Eyerusalem Asfaw

About Eyerusalem Asfaw

Senior BI Engineer and Azure Data Engineer with over 12 years of experience designing and delivering enterprise-scale analytics, governed self-service BI, and cloud data platforms across aviation and healthcare. Proven expertise in translating complex operational, financial, and regulatory requirements into reliable, high-performing data products that support executive decision-making.Currently serving as a BI POD Lead at Frontier Airlines, I lead the end-to-end delivery of analytics solutions supporting operations, finance, revenue management, maintenance, crew scheduling, HR, safety, and customer experience. I architect and maintain enterprise data warehouse and lakehouse solutions, integrating high-volume source systems into curated analytical datasets aligned to business priorities.My technical expertise includes Power BI architecture and governance (semantic models, DAX, Row-Level Security, certified datasets, and Premium capacity), Azure Data Factory, Databricks, Apache Spark, Azure Synapse Analytics, SQL Server, and modern dimensional modeling practices. I specialize in building scalable ingestion pipelines, optimized data models, and reusable semantic layers that improve data quality, refresh performance, and reporting consistency.In addition to hands-on technical leadership, I drive Agile analytics delivery by establishing standards, CI/CD practices, and governance frameworks that enable secure, trusted self-service BI. I partner closely with stakeholders to define KPIs, validate outputs, and ensure analytics solutions meet operational, financial, and compliance requirements.Earlier in my career, I delivered healthcare analytics solutions supporting Medicaid, Medicare, and behavioral health programs, building ETL pipelines, enterprise data models, and regulatory reporting while maintaining HIPAA-aligned data controls.I am committed to building analytics platforms that are scalable, well-governed, and aligned with business strategy—enabling organizations to make informed, data-driven decisions with confidence.

Experience

1. Power Bi Architect Bi Pod Lead

   Frontier Airlines

   Oct 2015 — Present

   Own the end-to-end delivery of Frontier’s BI “pod” portfolio supporting airline operations, finance, revenue management, maintenance, crew scheduling, and customer experience; align roadmap with leadership priorities and convert ambiguous requests into governed data products and reporting deliverables.Architect, enhance, and operationalize the Enterprise Data Warehouse and lakehouse layers by integrating high-volume airline systems (OPS, PSS/reservations, crew scheduling, maintenance, HR/payroll, safety) into curated analytical datasets used across multiple business units for planning and daily execution.Build and tune modern ingestion and transformation pipelines using ADF, SSIS, and Databricks/Spark—implementing incremental loads, partitioning strategies, retry patterns, audit tables, and data validation checkpoints to improve reliability and reduce refresh failures in production.Design dimensional models and Power BI semantic layers (star/snowflake, conformed dimensions, shared measures) for enterprise KPIs including OTP, delay codes, load factor, route profitability, RASM/CASM, yield, IRROPS impact, crew utilization, and customer satisfaction metrics.Lead enterprise Power BI standardization by implementing certified datasets, report templates, naming conventions, workspace structure, and deployment practices; enforce governance for reusable semantic models to accelerate delivery and reduce duplicated logic across teams.I have hands-on experience implementing Medallion architecture (Bronze, Silver, and Gold layers) to build scalable and reliable data platforms. The Bronze layer is used for raw data ingestion, Silver for data cleansing, validation, and standardization, and Gold for curated, business-ready datasets optimized for analytics and reporting. This approach improves data quality, governance, and performance across analytics workflows.

Education

• Debre berhan University

  Bachelor of Science, Computational Science