Data Engineer

About the Role

We are seeking an experienced Data Engineer / Database Administrator with a strong background in the healthcare or laboratory industry to design, build, and maintain secure, compliant, and high-performance data systems. This role requires expertise in the Microsoft technology stack, including Azure, Synapse Analytics, and SQL Server, as well as a deep understanding of data governance and interoperability in healthcare environments.

You will play a key role in developing and optimizing data infrastructure that supports clinical operations, reporting, analytics, and regulatory compliance.

Key Responsibilities

Data Engineering

* Design, build, and maintain robust data pipelines using Azure Data Factory, Synapse Pipelines, and related services to ingest and transform large healthcare datasets.

* Develop scalable data warehouse and data lake solutions on Azure Synapse to support analytics, machine learning, and business intelligence initiatives.

* Create and maintain data models optimized for performance, reliability, and scalability.

* Collaborate with laboratory information systems (LIS), electronic health records (EHR), and other healthcare data sources to ensure seamless integration and interoperability.

* Implement data quality, validation, and auditing processes to ensure integrity across all data assets.

Database Administration

* Administer and optimize Microsoft SQL Server databases across on-premise and cloud environments.

* Design and tune indexes, stored procedures, and queries for optimal performance.

* Manage database security, roles, and access controls to maintain compliance with HIPAA, HITECH, and organizational standards.

* Oversee backup, recovery, and disaster recovery strategies for mission-critical healthcare systems.

* Monitor database performance and availability using tools like Azure Monitor, SQL Profiler, and Log Analytics.

Collaboration & Strategy

* Partner with data scientists, analysts, clinicians, and application developers to support reporting and analytics use cases.

* Define and enforce data architecture standards and documentation within the organization.

* Stay up to date with Microsoft's evolving data ecosystem, recommending tools and practices that enhance scalability, performance, and compliance.

Qualifications

* Bachelor's degree in Computer Science, Information Systems, or related field (Master's preferred).

* 5+ years of experience as a Data Engineer, Database Administrator, or similar role, preferably in a healthcare or laboratory environment.

* Strong proficiency in T-SQL, SSIS, and Azure Synapse Analytics.

* Proven experience with Azure Data Factory, Azure Data Lake Storage, Azure SQL Database, and Power BI.

* In-depth understanding of data modeling, ETL development, and data warehouse design within Microsoft ecosystems.

* Solid grasp of data security, encryption, and compliance standards in healthcare (HIPAA, PHI, HL7, FHIR).

* Experience with CI/CD for data solutions using tools such as Azure DevOps or GitHub Actions.

* Excellent problem-solving skills, attention to detail, and ability to communicate complex technical concepts to non-technical stakeholders.

Preferred Skills

* Experience integrating data from LIS, EHR, or LIMS platforms.

* Familiarity with Python or .NET for data automation and custom integrations.

* Knowledge of Power BI administration and data governance frameworks (Purview, Collibra, etc.).

* Exposure to machine learning pipelines in Azure ML or Databricks environments.

#LI-Remote