Title: Senior Power BI/Fabric Data Engineer
Location:O Fallon, MO(Hybrid)
Must have Skills/Attributes Banking/Financial, Data Engineer, Data Modeling, PowerBI, SQL
Job Description:
We are seeking an experienced Senior Power BI/Fabric Data Engineer to support the implementation of our Microsoft Fabric and Power BI reporting environment. This role will focus on designing and implementing scalable data models, semantic models, notebook-based data transformations, and Power BI reporting solutions. The ideal candidate will be assessing existing datasets, developing advanced DAX calculations, contribute to data modeling, reporting, and analytics solution delivery.
Required Qualifications/Skills/Experience
5+ years of Power BI development experience.
Advanced DAX expertise with demonstrated experience solving complex business requirements.
Strong dimensional modeling experience including:
o Star Schema Design
o Snowflake Schema Design
o Fact & Dimension Modeling
o Complex Dimensions
o Semantic Model Design
o Performance Optimization
Experience with Microsoft Fabric implementation and development.
Experience developing notebooks using Python and SQL.
Experience designing enterprise reporting and analytics solutions.
Strong understanding of data integration and transformation patterns.
Experience working with complex and highly related data structures.
Ability to quickly understand existing data environments and contribute with minimal ramp-up time.
Intermediate Level - Power BI development, including report creation, semantic models, workspace management, and publishing practices
Intermediate Level - DAX and data modeling, including measures, calculated columns, dimensional modeling, and troubleshooting report performance
Intermediate Level - Dashboard design and business requirements gathering, including translating stakeholder needs into intuitive reports and actionable visualizations
Preferred Qualifications/Skills/Experience
Experience migrating reporting assets to Power BI/Fabric.
Databricks experience a plus.
Experience with Report Builder and Paginated Reports.
Experience implementing row-level security and security group-based access controls.
Experience with Power BI Report Server environments.
Key Responsibilities:
Data Modeling & Semantic Models-
- Design and implement scalable dimensional models and semantic models within Power BI and Microsoft Fabric.
- Structure complex datasets using fact and dimension modeling techniques using star and snowflake schema solutions.
- Analyze existing data structures and implement improvements for scalability, performance, and usability.
- Optimize model relationships and reporting performance.
Microsoft Fabric & Data Engineering-
- Build and maintain Fabric-based data solutions including dataflows, pipelines, lakehouses, warehouses, and semantic models.
- Develop notebooks using Python and SQL for data preparation and transformation.
- Integrate data from multiple source systems and prepare data for reporting and analytics consumption.
- Support data engineering activities required to enable Power BI reporting and analytics initiatives.
DAX & Reporting-
- Develop advanced DAX measures, calculations, and performance optimization strategies.
- Troubleshoot complex reporting and analytical requirements.
- Build and enhance executive and operational dashboards using Power BI.
- Support paginated reporting and Report Builder solutions where appropriate.
Security & Distribution-
- Implement row-level security and security group-based access controls.
- Support reporting distribution, user access, and data extraction requirements.
- Assist in establishing reporting access models within Power BI and Fabric.
