SQL Developer / Database Engineer

i4DM

United States

Remote

USD 120,000 - 180,000

Full time

14 days+

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

i4DM seeks an experienced SQL Developer / Database Engineer to support the VA’s ATLAS platform across multi-cloud environments. Design, build, and optimize SQL data structures, ETL/ELT pipelines, and data products for secure, reusable analytics.

You will work with SQL Server, Azure Data Factory, Synapse Pipelines, Databricks, and Azure Data Lake Service to ensure data reliability and performance, collaborate with engineers, analysts, and product teams, and enable Azure ML/Power BI workflows.

Qualifications

  • Minimum five (5) years of database development, administration, and maintenance.
  • Strong experience with Microsoft SQL Server, including complex queries, stored procedures, indexing, and performance tuning.
  • Experience developing and troubleshooting data integrations, ETL/ELT processes, and SSIS packages.
  • Hands-on experience with Azure Data Factory and Synapse Pipelines.
  • Experience with Databricks, Starburst, Azure Data Lake Service, and large-scale datasets.
  • Experience with Collibra for data cataloging, metadata management, or data governance.
  • Experience supporting Azure ML/AI services and validating data for analytics.
  • Experience supporting Pyramid Analytics and Power BI visualization solutions.

Responsibilities

  • Design, install, configure, maintain, and optimize SQL database systems and related data structures.
  • Develop, monitor, and troubleshoot ETL/ELT workflows and data pipelines using Azure Data Factory and Synapse Pipelines.
  • Integrate structured and unstructured data into Azure Data Lake Service from various sources.
  • Create and optimize complex SQL queries, stored procedures, and data transformation logic.
  • Use Databricks and Starburst to query and integrate distributed data across lakehouse and enterprise sources.
  • Investigate data discrepancies, pipeline failures, and performance issues; perform root-cause analysis and fixes.
  • Apply data-quality controls and support metadata management and data cataloging using Collibra.
  • Monitor performance, perform tuning, backup, recovery, and reliability improvements.
  • Ensure secure, compliant access to enterprise data and support Azure ML/AI and BI services.
  • Collaborate with data engineers, analysts, data scientists, and product teams to deliver consumable data products.

Skills

SQL development
Data integration
Troubleshooting
Communication

Tools

Microsoft SQL Server
SSIS
Azure Data Factory
Synapse Pipelines
Databricks
Starburst
Azure Data Lake Service
Collibra
Azure ML/AI
Pyramid Analytics
Power BI

Job description

Description About the Role

We are seeking an experienced SQL Developer / Database Engineer to support ATLAS, the VA’s open-architected, multi-cloud enterprise data management and analytics platform. In this role, you will design, maintain, integrate, and optimize SQL database structures, transformation logic, and data pipelines that ingest, condition, curate, and deliver multi-source data as secure, reusable enterprise data products. You will use SQL Server, Azure Data Factory, Synapse Pipelines, Databricks, Starburst, and Azure Data Lake Service to improve data reliability, performance, and interoperability across ATLAS and connected source platforms. You will troubleshoot discrepancies and ETL/ELT failures, translate business requirements into technical solutions, and help provide consistent access to trusted data that supports analytics, evidence-based decisions, and better outcomes for Veterans and their families.

Key Responsibilities
  • Design, install, configure, maintain, and optimize SQL database systems and related data structures supporting ATLAS.
  • Develop, maintain, monitor, and troubleshoot ETL/ELT workflows and data pipelines using Azure Data Factory and Synapse Pipelines.
  • Integrate structured and unstructured data from databases, APIs, cloud platforms, and other enterprise sources into Azure Data Lake Service.
  • Create and optimize complex SQL queries, stored procedures, database objects, and transformation logic for data conditioning and curation.
  • Use Databricks and Starburst to query, transform, and integrate distributed data across lakehouse and enterprise data sources.
  • Investigate data discrepancies, pipeline failures, and performance issues; perform root-cause analysis and implement durable fixes.
  • Apply data-quality controls and support metadata management and data cataloging using Collibra.
  • Monitor database and pipeline performance; perform query tuning, indexing, backup, recovery, patching, and reliability improvements.
  • Support secure, consistent, and compliant access to enterprise data through appropriate identity, authorization, and data-protection controls.
  • Collaborate with data engineers, analysts, data scientists, and product teams to create consumable data products and enable Azure ML/AI services.
  • Support reporting and visualization needs using Pyramid Analytics and Power BI, including validation of underlying data structures and accuracy.
  • Translate business requirements into technical specifications and communicate solutions clearly to technical and non-technical stakeholders.
  • Document database structures, data mappings, pipelines, operational procedures, and technical decisions.
  • Participate actively in Agile/Scrum ceremonies and support continuous improvement of ATLAS data services.

TAG: #LI-I4DM TAG: INDMJC

Requirements Minimum Qualifications
  • Minimum five (5) years of experience in database development, administration, and maintenance.
  • Strong experience with Microsoft SQL Server, including complex SQL queries, stored procedures, database design, indexing, optimization, and performance tuning.
  • Experience developing and troubleshooting data integrations, ETL/ELT processes, and SSIS packages.
  • Hands-on experience creating, updating, monitoring, and troubleshooting Azure Data Factory and Synapse Pipelines.
  • Experience with Databricks, Starburst, Azure Data Lake Service, and distributed or large-scale datasets.
  • Experience with Collibra for data cataloging, metadata management, or data governance.
  • Experience supporting Azure ML/AI services and preparing reliable data for analytics or machine-learning use cases.
  • Experience supporting Pyramid Analytics and Power BI visualization solutions and validating source data.
  • Excellent troubleshooting and root-cause analysis skills.
  • Ability to understand business requirements and translate them into technical specifications.
  • Ability to communicate technical details to non-technical users and stakeholders, with excellent written and verbal communication skills.
  • Ability to obtain and maintain a Public Trust or Suitability/Fitness determination based on client requirements.
Preferred Qualifications
  • Experience supporting federal agencies, the Department of Veterans Affairs, or other regulated environments.
  • Experience with enterprise data lakes, lakehouses, Delta Lake, Parquet, and multi-cloud data integration.
  • Experience working independently and collaboratively within Agile data-product teams.
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

SQL Developer / Database Engineer
SQL Developer / Database Engineer

i4DM • Millersville (MD)

On-site
USD 120,000 - 160,000
Azure Data Integration Engineer
Azure Data Integration Engineer

i4DM • United States

Remote
USD 140,000 - 190,000
Health insurance
HSA Plan
Life insurance
+2
Azure Data Integration Engineer
Azure Data Integration Engineer

i4DM • Millersville (MD)

On-site
USD 120,000 - 160,000
Healthcare coverage
HSA Plan
Life and Disability Insurance
+1
Data Quality Engineer
Data Quality Engineer

i4DM • United States

Remote
USD 100,000 - 150,000
Healthcare coverage
HSA Plan
Life and Disability Insurance
+1
DevSecOps / Cloud Platform Engineer
DevSecOps / Cloud Platform Engineer

i4DM • Millersville (MD)

On-site
USD 140,000 - 180,000
Comprehensive healthcare coverage
HSA Plan
Life and Disability Insurance
+1
DevSecOps / Cloud Platform Engineer
DevSecOps / Cloud Platform Engineer

i4DM • United States

Remote
USD 140,000 - 180,000
Comprehensive healthcare coverage
HSA Plan
Life and Disability Insurance
+1
Data Quality Engineer
Data Quality Engineer

i4DM • Millersville (MD)

On-site
USD 90,000 - 140,000
Healthcare coverage
HSA Plan
Life and Disability Insurance
+1
Azure SQL DB SME
Azure SQL DB SME

i4DM • Millersville (MD)

On-site
USD 140,000 - 180,000
Azure SQL DB SME
Azure SQL DB SME

i4DM • United States

Remote
USD 150,000 - 190,000
Senior Data Architect & Engineer - Enterprise Pipelines
Senior Data Architect & Engineer - Enterprise Pipelines

Ares Enterprise • Washington

Hybrid
USD 120,000 - 180,000