Consulting Data Engineer

POSITION SUMMARY: We are seeking a highly skilled Azure Fabric Data Engineer to design, build, and optimize data pipelines and analytical solutions within the Microsoft Fabric ecosystem. This role is pivotal in enabling scalable, secure, and AI-ready data infrastructure that supports business intelligence, machine learning, and operational reporting.

ESSENTIAL FUNCTIONS: 

• Design and implement data pipelines using Azure Data Factory, Synapse Pipelines, Fabric Notebooks, and dbt (data build tools)

• Develop and manage Fabric Warehouses and Lakehouses, ensuring schema compatibility, performance, and compliance

• Integrate data across cloud and on-prem sources, including SQL Server, Azure Blob, REST APIs, and third-party systems

• Configure linked services and authentication using service principals, managed identities, and secure credential stores (e.g., Azure Key Vault)

• Enable AI-readiness by preparing semantic models, marking artifacts as "Ready for AI," and supporting Copilot integration

• Optimize data storage and compute using Fabric capacities, partitioning strategies, and workload management

• Implement governance and security controls, including Purview integration, sensitivity labels, and RBAC

• Collaborate with data scientists, BI developers, and compliance teams to deliver reproducible, scalable solutions

• Monitor and troubleshoot pipelines, warehouse performance, and workspace configurations using Fabric Admin Portal and telemetry tools

KNOWLEDGE, SKILLS & ABILITIES: 

Education: 

• Bachelor's or Master's degree in Computer Science, Data Engineering, or related field or experience deemed relevant

Experience: 

• 3+ years of experience in cloud data engineering, preferably in Azure

• Healthcare experience not required but a solid nice to have

Certifications: 

• Microsoft certifications (e.g., DP-203, Fabric Data Analyst Associate) are a plus 

Skills and Abilities:

• Strong proficiency in T-SQL, Python, and Spark

• Hands-on experience with Microsoft Fabric, Azure Synapse, Azure Data Factory, and dbt (Data build tools)

• Deep understanding of data modeling, ETL/ELT, and semantic layer design

• Familiarity with Copilot, AI model integration, and vector search

• Experience with Azure Key Vault, Entra ID, and service principal authentication

• Knowledge of data governance frameworks (e.g., Purview, GDPR, HIPAA)

• Ability to work in cross-functional teams and communicate technical concepts clearly

Bonus Skills

• Experience with Microsoft Fabric REST APIs

• Familiarity with LangChain, Semantic Kernel, or ML.NET

• Knowledge of CMS compliance standards and healthcare data workflows

PHYSICAL AND MENTAL DEMANDS:

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodation may be made to enable individuals with disabilities to perform the essential job responsibilities. 

While performing the duties of this job, the employee is occasionally required to stand; walk; sit for extended periods of time; use hands to finger, handle, feel objects, tools or controls; reach with hands and arms; climb stairs; balance; stoop, kneel, bend, crouch or crawl; talk or hear; taste or smell.  The employee must occasionally lift and/or move up to 20 pounds.  Repetitive motion of upper body is required for extended use of computers. Required specific vision abilities include close vision, distance vision, color vision, peripheral vision, depth perception, and the ability to adjust focus. 

WORK ENVIRONMENT AND TRAVEL REQUIREMENTS: 

The work environmental characteristics described here are representative of those that an employee may encounter while performing the essential functions of this job. Reasonable accommodation may be made to enable individuals with disabilities to perform the essential job responsibilities.

•  Remote based

For those working on-site, they will have a well-lit, ventilated and climate-controlled office environment with routine office equipment; some equipment has moving mechanical parts.  Noise level in the work environment is typical for an office and/or hospital environment

In hospital environment, the individual may be exposed to hazards and unusual elements, which may include but are not limited to bloodborne pathogens and / or contagious illnesses, toxic chemicals, and biohazardous materials which may require extensive safety precautions and the use of protective equipment.

This position can expect overnight travel by land and/or air according to the requirements below: 

• Less than 25%

Normal business hours are: 8 a.m. - 5 p.m., Monday-Friday.  However, schedules may vary by business necessity.   Remote workers are expected to be available during normal business hours, unless otherwise approved by the department leader(s).

Lifepoint Health is a leader in community-based care and driven by a mission of Making Communities Healthier. Our diversified healthcare delivery network spans 29 states and includes 63 community hospital campuses, 32 rehabilitation and behavioral health hospitals, and more than 170 additional sites of care across the healthcare continuum, such as acute rehabilitation units, outpatient centers and post-acute care facilities. We believe that success is achieved through talented people. We want to create places where employees want to work, with opportunities to pursue meaningful and satisfying careers that truly make a difference in communities across the country.