Power Bi Data Engineer

ERMIAS BOGALE

SQL/ETL/POWER BI DEVELOPER

Microsoft Certified Fabric Data Engineer Data Analyst Azure Data Engineer Associate

346-***-**** *********@*****.*** Houston, TX LinkedIn: linkedin.com/in/ermias-b-a2001b22a

PROFESSIONAL SUMMARY

Experienced Senior BI Developer with over 9 years of success delivering end-to-end data solutions using SQL, SSIS, Power BI, and Azure technologies. Strong expertise in enterprise reporting, data modeling, ETL, DAX, and dashboard development. Proven ability to lead crossfunctional data initiatives, troubleshoot complex issues, and optimize performance for large- scale data systems across financial, insurance, and healthcare industries. U.S. Citizen and fully remoteready.

CORE COMPETENCIES

• ETL & Data Integration: SSIS, Azure Data Factory, Informatica, Data Cleansing, Data Merging, Scheduling

• BI & Analytics: Power BI (DAX, Paginated Reports, Power BI Service, RLS), Tableau, SSRS, Power BI Report Builder

• Cloud & Data Platforms: Azure Synapse Analytics, Azure Data Lake, Redshift, BigQuery, Snowflake

• Data Modeling: Star & Snowflake Schemas, Dimensional Modeling, Tabular Models, SSAS

• Programming: T-SQL, PL/SQL, Power Query, DAX, MDX, Python, VB.NET

• Reporting & Optimization: Performance Tuning, SQL Profiler, DAX Studio, Tabular Editor, Report Scheduling

• Tools & Processes: Git, JIRA, DevOps, Agile/Scrum, SDLC, Deployment Pipelines PROFESSIONAL EXPERIENCE

Spencer Gifts NJ

Senior Power BI / SQL Developer June 2021 – Present

• Built and maintained enterprise Power BI dashboards with advanced DAX and Power Query for finance and sales teams.

• Developed robust ETL pipelines in SSIS and Azure Data Factory, integrating data from SQL Server, DB2, Oracle, and flat files.

• Led the design of data models (Import, DirectQuery, Live), and implemented incremental refresh, row-level security, and Power BI deployment pipelines.

• Automated Excel-based reporting using Power BI and Power Automate; created paginated reports in Power BI Report Builder.

• Acted as Power BI Service admin—managed workspaces, apps, and scheduled refreshes while resolving performance issues.

ING North America Insurance PA

SQL BI / Power BI Developer Apr 2020 – Jun 2021

• Designed complex stored procedures and T-SQL scripts to support Power BI and SSRS reports.

• Migrated legacy SQL reports to Power BI and SSRS; created custom visuals and KPIs aligned with financial metrics.

• Built and managed Power BI dashboards using SSAS Tabular models and configured RLS.

• Contributed to data migration and QA testing for a SQL Server modernization project

(2008 to 2016).

Blue Cross Blue Shield MI

BI Developer / ETL Engineer Oct 2018 – Mar 2020

• Developed SSIS packages and SSRS reports; performed data transformation and integration from diverse sources.

• Collaborated in Agile teams to gather requirements and deliver business-ready dashboards and ad hoc reporting.

• Built Power BI dashboards with complex visuals, filters, and custom DAX measures supporting healthcare reporting.

• Administered Power BI Service for workspace governance, report versioning, and gateway setup.

GetaRoom TX

SQL/SSIS/SSRS Developer Jun 2014 – Sep 2018

• Developed and maintained ETL pipelines in SSIS for nightly batch jobs and on-demand data refreshes.

• Created complex stored procedures, SQL joins, views, and UDFs to support downstream reporting.

• Built SSRS and Power BI reports to replace Excel-based reporting processes, improving efficiency and accuracy.

• Supported Tableau visualizations and built custom dashboards for sales and customer service teams.

EDUCATION Bachelor’s Degree in Information Technology Addis Ababa University

CERTIFICATIONS

• Microsoft Certified: Fabric Data Engineer Associate

• Microsoft Certified: Data Analyst Associate (Power BI)

• Microsoft Certified: Azure Data Engineer Associate

• Microsoft Certified: Azure Data Fundamentals

• Databricks Lakehouse Fundamentals

• MS Power Platform Developer (in progress)

TECHNICAL TOOLS & ENVIRONMENTS

• Databases: SQL Server (2008–2019), Oracle, DB2, MySQL, Redshift, Teradata, BigQuery

• BI/Reporting: Power BI, SSRS, SSAS, Tableau, Domo, Crystal Reports

• ETL Tools: SSIS, Azure Data Factory, Informatica IDMC

• Languages: T-SQL, DAX, MDX, Python, VB.NET, PL/SQL

• Cloud Platforms: Azure Synapse, Azure Data Lake, Power BI Service

• Other Tools: Power BI Report Builder, Git, JIRA, DevOps, Performance Tuning Tools

(SQL Profiler, Tabular Editor)

Contact this candidate