SQL Developer / Database Engineer

Remote SQL Developer / Database Engineer role focused on designing and optimizing SQL databases, data pipelines, and reusable enterprise data products for ATLAS.

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, and database objects 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 with 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 using 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 to technical and non-technical stakeholders.
• Document database structures, data mappings, pipelines, operational procedures, and technical decisions.
• Participate in Agile/Scrum ceremonies and support continuous improvement of ATLAS data services.

Requirements

• Minimum five (5) years of experience in database development, administration, and maintenance.
• Strong experience with Microsoft SQL Server, including complex SQL, 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.
• Excellent written and verbal communication skills, including the ability to communicate technical details to non-technical users and stakeholders.
• Ability to obtain and maintain a Public Trust or Suitability/Fitness determination based on client requirements.

Technologies

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

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.

Location: Remote

Experience level: 5+ years