MS Fabric Data Engineer

ovationhealthcare; United States; On-site; USD 120,000 - 160,000; Full time

Job summary

Ovation Healthcare seeks a Microsoft Fabric Data Engineer to design, build, and maintain scalable data pipelines, models, and analytics solutions using Fabric and Azure. You will work with Fabric Lakehouse/Warehouse environments and develop Fabric Notebooks for data transformation at scale, collaborating across analytics teams to deliver BI-ready data.

The role requires expertise in Fabric data modeling, PySpark, Spark SQL, and Python, plus experience with Power BI integration and data

Qualifications

• Expertise in Microsoft Fabric data modeling and engineering.
• Proficiency with PySpark, Spark SQL, and Python for large-scale data transformation.
• Experience with Lakehouse and Warehouse architectures and star-schema models.
• Knowledge of Delta Lake, medallion architecture, and Direct Lake/Import reporting.
• Ability to optimize Fabric Notebooks and data pipelines for performance.
• Strong SQL skills and experience with Power BI integrations.

Responsibilities

• Design, build, and maintain scalable data pipelines using Microsoft Fabric and Azure Data Services.
• Create data models within Fabric including Lakehouse/Warehouse architectures.
• Develop Fabric Notebooks for data transformation at scale.
• Collaborate with analysts, data scientists, and stakeholders to deliver insights.
• Implement secure, efficient ingestion, transformation, and integration workflows.
• Choose the right Fabric tool based on complexity and performance tradeoffs.
• Monitor and optimize pipelines, notebooks, and models for accuracy and uptime.
• Ensure compliance with governance and regulatory policies.
• Document models, architectures, and workflows for transparency.
• Stay current with Fabric and Azure updates and propose improvements.

Skills

Microsoft Fabric

Data modeling

Lakehouse/Warehouse

Delta Lake

Medallion architecture

Star-schema models

Direct Lake/Import mode

Fabric Notebooks

PySpark

Spark SQL

Python

Power BI integration

SQL

Azure Data Services

Education

Tools

Data Factory/Fabric Pipelines

Dataflows Gen2

Azure Synapse Analytics

Azure Data Lake

Job description

Welcome to Ovation Healthcare!

At Ovation Healthcare, we've been making local healthcare better for more than 40 years. Our mission is to strengthen independent community healthcare. We provide independent hospitals and health systems with the support, guidance and tech-enabled shared services needed to remain strong and viable. With a strong sense of purpose and commitment to operating excellence, we help rural healthcare providers fulfill their missions.

The Ovation Healthcare difference is the extraordinary combination of operations experience and consulting guidance that fulfills our mission of creating a sustainable future for healthcare organizations. Ovation Healthcare's vision is to be a dynamic, integrated professional services company delivering innovative and executable solutions through experience and thought leadership, while valuing trust, respect, and customer focused behavior.

We're looking for talented, motivated professionals with a desire to help independent hospitals thrive. Working with Ovation Healthcare you will have the opportunity to collaborate with highly skilled subject matter specialists and operations executives, in a collegial atmosphere of professionalism and teamwork.

Ovation Healthcare's corporate headquarters is located in Brentwood, TN. For more information, visit https://ovationhc.com.

Summary

As a Microsoft Fabric Data Engineer, you will design, build, and maintain scalable data pipelines, data models, and analytics solutions using Microsoft Fabric and Azure Data Services. You will work extensively within Fabric's Lakehouse and Warehouse environments - building well-structured data models and developing Fabric Notebooks (PySpark/Spark SQL) for data transformation at scale - and collaborate with cross-functional teams to deliver high-quality, secure, and efficient data solutions that drive business intelligence and advanced analytics initiatives.

Duties and Responsibilities

• Design, develop, and maintain scalable, reliable, and efficient data pipelines using Microsoft Fabric and Azure Data Services.
• Design and implement data models within Microsoft Fabric - including Lakehouse and Warehouse architectures, medallion (bronze/silver/gold) layering, and star-schema semantic models optimized for Direct Lake reporting.
• Build, maintain, and optimize Fabric Notebooks (PySpark, Spark SQL, and/or Python) to ingest, cleanse, and transform data at scale, applying performance best practices for Spark compute and Delta Lake tables.
• Collaborate with data analysts, data scientists, and business stakeholders to understand data requirements and deliver actionable insights.
• Implement data ingestion, transformation, and integration workflows (pipelines, Dataflows Gen2, and notebooks) following best practices for security and performance.
• Evaluate and choose the right Fabric tool for the job - pipelines, Dataflows Gen2, or notebooks - based on complexity, performance, and maintainability tradeoffs.
• Monitor, troubleshoot, and optimize data pipelines, notebooks, and data models to ensure high availability and accuracy.
• Ensure data solutions comply with organizational data governance policies and industry regulations.
• Document data models, architectures, processes, and workflows for operational transparency and knowledge sharing.
• Stay current with Microsoft Fabric and Azure ecosystem updates and recommend improvements or new technologies.
• Support the deployment and maintenance of business intelligence and reporting platforms, including Power BI semantic models built on Fabric data.

Knowledge, Skills, and Abilities

• Demonstrated expertise in Microsoft Fabric data modeling and engineering , including Lakehouse vs. Warehouse architecture, OneLake, Delta Lake tables, medallion architecture, and designing star-schema semantic models for Direct Lake or Import mode reporting.
• Hands-on proficiency writing and maintaining Fabric Notebooks using PySpark, Spark SQL, and/or Python for large-scale data transformation, including Spark performance tuning (partitioning, caching, cluster sizing).
• Proficiency with the broader Microsoft Fabric and Azure Data Services ecosystem (e.g., Data Factory/Fabric Pipelines, Dataflows Gen2, Azure Synapse Analytics, Azure Data Lake).
• Strong understanding of data engineering concepts including ETL/ELT processes, data pipeline architecture, and data integration.
• Experience with SQL and programming languages such as Python or Scala for data manipulation.
• Familiarity with cloud computing platforms and best practices for scalability and security.
• Knowledge of data governance, data quality, and compliance standards.
• Ability to work with business intelligence tools (e.g., Power BI) and understand analytics requirements, including how well-designed data models drive report performance.
• Strong problem-solving skills and the ability to optimize performance in large data environments.
• Excellent communication and collaboration skills for working with cross-functional teams.

Work Expe