Azure SQL Database Engineer

Job Title: Azure SQL Database Engineer

Experience: 4 to 5 years

Employment Type: Full-time

About the Role

We are looking for an Azure SQL Database Engineer to join our team and support a healthcare data platform engagement. You will be embedded with a client team, working across database design, pipeline support, and data infrastructure on Azure. You will be expected to take ownership of your work, operate independently, and bring both technical depth and sound judgment to day-to-day decisions.

This is a hands-on role. You will spend most of your time in the data layer, not in meetings.

What You Will Do

Design, build, and maintain Azure SQL databases and related infrastructure

Support data pipeline development and troubleshooting across Azure-native services including Azure Data Factory and Azure Synapse

Optimize query performance using Azure SQL Query Store and Execution Plan analysis to proactively identify and resolve slow queries before they become operational problems

Implement and maintain database security controls including Azure Entra ID authentication, Row-Level Security, and Dynamic Data Masking to meet HIPAA compliance requirements

Collaborate with data engineering and analytics teams to support schema design and data modeling

Assist with migration of legacy SQL-based reporting and ETL pipelines to modern Azure equivalents

Monitor database health, availability, and performance and resolve issues proactively

Write clean, well-documented SQL for data transformation, reporting, and operational queries

Support data quality and validation processes within the data platform

Contribute to documentation of data structures, data flows, and operational runbooks

What You Bring

4 to 5 years of hands-on experience with SQL Server and Azure SQL Database

Strong command of T-SQL including complex queries, stored procedures, views, and performance tuning

Experience with Azure data services including Azure Data Factory, Azure Synapse Analytics, or Azure Databricks

Familiarity with ELT pipeline design and working alongside tools like Matillion or similar

Experience with Power BI or equivalent reporting tools is a plus

Working knowledge of data modeling concepts including dimensional modeling, normalization, and schema design

Ability to work independently, manage your own priorities, and communicate clearly with both technical and non-technical stakeholders

Healthcare domain knowledge is a plus, specifically familiarity with healthcare data standards such as HL7, FHIR, ICD-10, or experience working with EHR data, claims data, or CMS-related submissions

Nice to Have

Experience with Snowflake alongside Azure SQL

Exposure to HIPAA compliance requirements and working with protected health information

Familiarity with Azure DevOps for version control and pipeline CI/CD

Experience in a consulting or client-facing engagement