Data Engineer

About the role

The Data Engineer will build scalable, trusted, and secure data models and pipelines that support analytics, reporting, and operations across our healthcare organization. The role involves end-to-end ownership of data workflows, including ingestion, transformation, modeling, and delivery.

Responsibilities

• Build and maintain robust data pipelines that ingest, transform, validate, and deliver data from multiple internal and external sources.
• Design data models that align with business use cases and support high-performance reporting and analytics.
• Implement data validation logic to ensure quality, trust, and accuracy in all downstream outputs.
• Automate workflows using Logic Apps and Data Factory to support real-time and batch use cases.
• Ensure pipeline observability, logging, and monitoring for proactive issue detection and resolution.
• Collaborate with data analysts, BI developers, and business stakeholders to translate requirements into engineering solutions.
• Provide secure, governed access to data through role-based access controls and RLS configurations.
• Maintain documentation, data dictionaries, and flow diagrams to ensure transparency and maintainability.
• Publish curated, validated datasets to Power BI workspaces and Fabric Lakehouses, supporting enterprise-wide reporting.

Qualifications

• Bachelor’s degree in computer science, Information Systems, Engineering, or a related technical field, preferred.
• Three (3) – five (5) years of experience.
• Strong proficiency in SQL for large-scale data transformation, query optimization, and schema development.
• Advanced Python skills for scripting ETL/ELT logic, validation routines, automation, and integration.
• Demonstrated ability to design and implement scalable, maintainable data pipelines using Azure Data Factory, Synapse Pipelines, and Logic Apps.
• Expertise in data modeling, including normalized and dimensional models (star/snowflake), surrogate keys, SCD handling, and business-friendly schema design.
• Experience implementing robust data validation and quality frameworks, including completeness, accuracy, integrity, and anomaly detection.
• Proficient with Azure Synapse Analytics (dedicated and serverless pools), Azure Data Lake Storage, and Logic Apps for managing ingestion, transformation, and orchestration.
• Working knowledge of data security practices and compliance (HIPAA, PHI), including RBAC, RLS, and secure data delivery.
• Familiarity with CI/CD pipelines and infrastructure-as-code using Azure DevOps or GitHub Actions.
• Experience supporting Power BI development by preparing validated semantic models, implementing row-level security, and enabling performance-optimized report layers — always backed by solid pipeline foundations.

Skills

• Knowledge of healthcare interoperability standards such as FHIR or HL7, or experience working with clinical data models or claims data.
• Exposure to Microsoft Purview or other data cataloging tools for metadata management, lineage tracking, and automated governance.
• Experience building or supporting machine learning pipelines in Azure using Synapse ML, Azure ML, or Databricks.
• Experience with Delta Lake or lakehouse optimization strategies, including schema evolution, time travel, and ACID transactions on big data.
• Proficiency in performance tuning for large-scale BI environments, including query optimization, caching strategies, and dataset partitioning.
• Ability to lead data architecture discussions, contribute to platform design decisions, or mentor junior engineers on engineering best practices.
• Understanding of data privacy engineering, such as implementing differential privacy, data anonymization, or secure multi-party computation in analytics workflows.
• Hands-on experience with cross-cloud or hybrid-cloud architectures, especially integrating Azure with AWS or on-premise systems.

Benefits

N/A

Pay

N/A

Schedule

N/A

Additional Duties and Responsibilities

• Patient Centered Medical Home (PCMH) and Integrated Care Team (ICT)
• Adherence to Compliance and Code of Conduct
• Physical Demands and Work Environment