Senior Data Engineer Microsoft Fabric & Power BI

Kastech Software Solutions Group; O’Fallon (MO); On-site; USD 120,000 - 190,000; Full time

Job summary

Kastech Software Solutions Group is seeking a Senior Data Engineer with deep expertise in Microsoft Fabric and Power BI to lead modernization of enterprise reporting. You will design, build, and govern modern data platforms that enable trusted operational insights and AI readiness across the organization.

The ideal candidate has hands-on experience with Fabric components (OneLake, Data Factory, Lakehouse, Data Warehouse) and strong SQL, data modeling, and ETL/ELT design skills.

Qualifications

• 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, 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.

Responsibilities

• 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.
• Build and maintain scalable data ingestion and transformation pipelines from enterprise platforms and operational systems.
• Design and implement medallion architecture patterns 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.
• 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.

Skills

Power BI

SQL development

ETL/ELT pipelines

Data governance

Stakeholder management

Data platforms

Communication

Fabric knowledge

AI/ML enablement

Tools

OneLake

Data Factory

Lakehouse

Data Warehouse

Spark Notebooks

Data Agents

Job description

Job Title: Senior Data Engineer Microsoft Fabric & Power BI

Preferred W2

Required Skills, Experience, & Abilities:

• Date engineering Principals
• 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
• 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.

Desired Certifications:

• Microsoft Azure or Microsoft Fabric certifications

Role:

The Senior Data Engineer will play a critical role in the transformation of enterprise reporting and analytics through Microsoft Power BI and Microsoft Fabric. This position is responsible for designing, building, and governing modern data platforms that enable trusted operational insights, analytics, AI readiness, and enterprise-scale reporting.

The ideal candidate combines deep data engineering expertise with hands-on experience in Microsoft Fabric, Power BI semantic modeling, data architecture, and enterprise governance. This role will lead migration efforts from legacy reporting platforms, establish scalable Fabric design patterns, and partner with business and technology stakeholders to deliver certified, governed, and high-performing analytical solutions.

Responsibilities:

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.
• 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.