SQL Data Engineer

Booz Allen Hamilton•Bethesda, MD

2h•$77,600 - $176,000•Hybrid

About The Position

As organizations collect increasing volumes of data from various sources, effective data engineering is essential to producing reliable insights and supporting mission-critical decisions. As a SQL developer and data engineer, you will help design, develop, and optimize data solutions that support federal health programs, regulatory science, and other high-impact missions. You will apply advanced SQL skills and hands-on Databricks experience to build scalable data pipelines, data models, and analytics-ready datasets. You will collaborate with data engineers, analysts, software developers, data scientists, and client stakeholders to integrate data, improve data quality, and deliver secure, high-performing solutions. This role requires strong problem-solving skills, attention to detail, and the ability to communicate technical concepts to both technical and non-technical audiences. Work with us to use data for good. Join us. The world can’t wait.

Requirements

5+ years of experience developing, optimizing, and troubleshooting complex SQL solutions, including queries, stored procedures, views, functions, and data transformations, in Oracle SQL, PostgreSQL, and Databricks SQL
2+ years of experience with Databricks, including Databricks Workspace, notebooks, jobs, workflows, Apache Spark, Delta Lake, and cluster configuration
Experience with relational databases, data modeling, dimensional modeling, data warehousing, and designing and implementing medallion architecture patterns
Experience integrating data from databases, cloud data platforms, APIs, JSON, XML, and flat files
Experience in developing data engineering solutions in Python and managing code through Git or comparable source-control tools
Experience implementing automated testing, data validation, data reconciliation, and data-quality processes
Ability to translate solutions across different SQL dialects and database environments
Ability to work independently in an Agile, collaborative, and client-focused environment, troubleshoot complex issues, raise questions proactively, communicate potential risks, and recommended actions to management early
Public Trust
Bachelor’s degree in Computer Science, Data Science, Engineering, Statistics, Biostatistics, or Mathematics

Nice To Haves

Experience with advanced Databricks capabilities, including Delta Live Tables, Workflows, and Unity Catalog
Experience developing and optimizing data transformation workflows, including ETL and ELT processes supporting reporting, analytics, or operational systems
Experience with Pentaho or equivalent data integration and ETL tools
Experience implementing CI/CD pipelines, automated deployments, and software development practices for data solutions
Experience applying AI-enabled tools or techniques to improve data engineering workflows, pipeline performance, or developer productivity
Experience with data governance, metadata management, data lineage, privacy, security, and access controls
Experience supporting federal health data systems, regulatory science, or other regulated data environments
Databricks, AWS Cloud, or Data Engineering technical Certification

Responsibilities

Design, develop, and optimize data solutions that support federal health programs, regulatory science, and other high-impact missions.
Apply advanced SQL skills and hands-on Databricks experience to build scalable data pipelines, data models, and analytics-ready datasets.
Collaborate with data engineers, analysts, software developers, data scientists, and client stakeholders to integrate data, improve data quality, and deliver secure, high-performing solutions.
Translate solutions across different SQL dialects and database environments.
Work independently in an Agile, collaborative, and client-focused environment, troubleshoot complex issues, raise questions proactively, communicate potential risks, and recommended actions to management early.