Senior Data Engineer Microsoft Fabric & Power BI

Job Title:Senior Data Engineer Microsoft Fabric & Power BI

Location O'Fallon, MO

Type: W2 Contract

***Only qualified Senior Data Engineer Microsoft Fabric & Power BI candidates located near O'Fallon, MO to be considered due to the position requiring an onsite presence. ***

Industry: Payments, FinTech Be competitive on rate based on candidates' skills & experience! Your company must hold the candidates vias, no layered candidates accepted.

Role Microsoft Fabric & Power BI Modernization

Migration of operational reporting assets and datasets to Microsoft Fabric and Power BI.

Implement Fabric architectures including Lakehouses, Warehouses, Semantic Models, Data Pipelines, and OneLake strategies.

Build reusable engineering patterns that accelerate dashboard migration and reduce delivery effort.

Develop enterprise-scale Power BI datasets supporting operational, executive, and strategic reporting.

Optimize Fabric capacity utilization, storage strategy, performance, and cost management.

Data Engineering

Build and maintain scalable data ingestion and transformation pipelines from enterprise platforms and operational systems.

Design and implement medallion architecture patterns (Bronze, Silver, Gold) within Fabric.

Develop data integration solutions utilizing Fabric Data Factory, notebooks, Spark, SQL, APIs, and related technologies.

Ensure data quality, reliability, availability, and observability throughout the data lifecycle.

Support modernization of existing ETL and reporting solutions into cloud-native architectures.

Analytics Enablement

Partner with Power BI developers, business analysts, and product stakeholders to define analytical requirements.

Design scalable semantic models that support both operational reporting and advanced analytics use cases.

Improve performance, usability, and adoption of enterprise reporting assets.

Participate in architecture reviews and provide technical leadership for reporting modernization initiatives.

All About You Bachelor's degree in Computer Science, Information Systems, Engineering, or related discipline.

5+ years of experience in data engineering, analytics engineering, or business intelligence development.

3+ years of experience with Microsoft Power BI including semantic modeling, DAX, data modeling, and report optimization.

Experience designing and operating enterprise data platforms in Microsoft Fabric, Azure, or comparable cloud ecosystems.

Strong SQL development and data modeling expertise.

Experience building ETL/ELT pipelines and integrating data from multiple enterprise systems.

Knowledge of data governance, metadata management, and data quality frameworks.

Strong communication and stakeholder management skills

Hands-on Experience With Microsoft Fabric Components Including

• OneLake
• Data Factory
• Lakehouse
• Data Warehouse
• Spark Notebooks
• Real-Time Intelligence
• Data Agents

Experience migrating reporting platforms from Domo, Tableau, or similar BI tools to Power BI.

Experience with Power Platform technologies including Power Apps and Power Automate.

Knowledge of AI/ML enablement within Fabric.

Microsoft Azure or Microsoft Fabric certifications.