SQL Data Engineer

Booz Allen Hamilton • Bethesda, MD

9d • $77,600 - $176,000

About The Position

As a SQL developer and data engineer, you will design, develop, and optimize data solutions that support federal health programs, regulatory science, and other high-impact missions. You will use 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. The role calls for strong problem-solving skills, attention to detail, and the ability to communicate technical concepts to technical and non-technical audiences.

Applicants selected will be subject to a government investigation and may need to meet eligibility requirements of the U.S. government client; a Public Trust determination is required. The hiring process includes identity verification using biometrics and artificial intelligence, and candidates are expected to be on camera during interviews and assessments. Use of AI or other tools to assist with interview responses is prohibited unless explicitly permitted.

The projected annualized compensation range is $77,600 to $176,000. Salary is determined by factors including location, education, skills, experience, contract-specific affordability, and organizational requirements. The posting will close within 90 days from its posting date.

Requirements

• At least 5 years of experience developing, optimizing, and troubleshooting complex SQL solutions in Oracle SQL, PostgreSQL, and Databricks SQL.
• At least 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 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, and communicate potential risks and recommended actions to management early.
• Public Trust determination is required; selected applicants will be subject to a government investigation and may need to meet U.S. government client eligibility requirements.
• 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 ETL and ELT data transformation workflows 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 for federal health programs, regulatory science, and other high-impact missions.
• Build scalable data pipelines, data models, and analytics-ready datasets using SQL and Databricks.
• Integrate data from multiple sources and improve data quality.
• Deliver secure, high-performing data solutions.
• Collaborate with data engineers, analysts, software developers, data scientists, and client stakeholders.
• Communicate technical concepts to technical and non-technical audiences.
• Develop, optimize, and troubleshoot complex SQL solutions, including queries, stored procedures, views, functions, and data transformations.
• Develop data engineering solutions in Python and manage code through Git or comparable source-control tools.
• Implement automated testing, data validation, data reconciliation, and data-quality processes.
• Translate solutions across different SQL dialects and database environments.
• Work independently in an Agile, collaborative, client-focused environment; troubleshoot complex issues, raise questions proactively, and communicate potential risks and recommended actions to management early.

Benefits

• Health, life, and disability benefits.
• Financial and retirement benefits.
• Paid leave.
• Professional development.
• Tuition assistance.
• Work-life programs.
• Dependent care.
• Recognition awards for exceptional performance and demonstration of company values.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level