Meron Birhanu

About Meron Birhanu

BI Developer with 5+ years of experience building end-to-end BI solutions using MS SQL Server, SSIS, SSRS, SSAS, and Power BI across OLTP/OLAP systems. Skilled in ETL development, data modeling, dimensional modeling (Star/Snowflake), and creating data marts/cubes with SSAS. Strong expertise in advanced T-SQL, SQL optimization, performance tuning, and DataStage job sequencing. Proficient in developing dashboards and DAX-driven analytics in Power BI, deploying reports via SSAS Tabular, and managing data pipelines using SSIS transformations. Adept at troubleshooting, error handling, and ensuring high-performance BI environments.

Experience

1. Senior Business Intelligence Engineer

   Humana

   Jun 2024 — Present · US

   Used SSIS to create ETL packages to validate, extract, transform, and load data to data warehouse databases• Lead the design, development, and optimization of SSIS-based ETL pipelines to support enterprise data integration, ensuring high-performance, scalable, and reliable data movement across multiple systems.• Manage data extraction, transformation, and loading from diverse sources (SQL Server, Azure SQL, flat files, APIs, cloud storage) using SSIS, Bulk Insert, BCP, and other integration utilities.• Conduct deep SQL performance tuning using DMVs, Profiler, execution plans, indexing strategies, and query rewriting to optimize ETL and reporting operations.• Designed and developed dashboards and reports using Power BI and Tableau, collaborating with business users to gather, analyze, and document requirements.• Develop and enhance Power BI dashboards and reports with optimized DAX measures, data modeling best practices, and user-friendly visualizations.• Implemented Row-Level Security and authentication protocols to ensure data governance, access control, and compliance with enterprise standards.• Performed data profiling, gap analysis, and data mining using complex SQL queries, stored procedures, Common Table Expressions (CTEs), and temporary tables.• Adopt Agile methodologies to manage sprint cycles, deliverables, and continuous enhancements across multiple concurrent BI and ETL projects.• Implemented Azure DevOps CI/CD pipelines to automate deployment of Power BI datasets, reports, and semantic models across Dev, Test, and Production workspaces.• Coordinated with data engineering and business stakeholders to define DevOps-aligned workflows, approvals, and release gates for BI solutions.

Education

• Haramaya University

  Master's degree, Agricultural Economics

• HARAMAYA University

  Bachelor's degree, Economics