Key skills
Azure Synapse AnalyticsT-SQLAzure Data FactoryData modelingData securityCI/CD for data solutionsPower BIProblem-solvingAttention to detailCommunication skillsPythonSQL.NETMachine LearningMLETLData LakeAnalyticsBIBusiness IntelligenceDatabricksAzureGitHub ActionsAzure DevOpsAzure SQLAzure MonitorSQL ServerGitHubCI/CD
About this role
Certified Group is seeking an experienced Data Engineer / Database Administrator with a strong background in the healthcare or laboratory industry. The role involves designing, building, and maintaining secure and high-performance data systems to support clinical operations, reporting, analytics, and regulatory compliance.
Responsibilities:
- 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
- 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
- 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
Requirements:
- 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
- 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