Senior SQL Data Engineer - Databricks Pipelines (Remote)

Booz Allen Hamilton; McLean (VA); On-site; USD 78,000 - 176,000; Full time

Benefits offered by this job

Health benefits

Life insurance

Disability insurance

Retirement benefits

Tuition assistance

Work-life programs

Dependent care

Job summary

Booz Allen Hamilton in McLean, VA is seeking a SQL Data Engineer to design, develop, and optimize data solutions for federal health programs and regulatory science. You will apply advanced SQL and Databricks to build scalable data pipelines, data models, and analytics-ready datasets, collaborating across data engineers, analysts, software developers, data scientists, and client stakeholders.

The role requires strong problem-solving, attention to detail, and the ability to communicate complex

Qualifications

• 5+ years of experience developing, optimizing, and troubleshooting complex SQL solutions across Oracle SQL, PostgreSQL, and Databricks SQL.
• 2+ years of experience with Databricks, including Workspace, notebooks, jobs, workflows, Spark, Delta Lake, and cluster configuration.
• Experience with relational databases, data modeling, dimensional modeling, data warehousing, and 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 via Git or similar 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, client-focused environment and communicate risks and actions.

Responsibilities

• Design, develop, and optimize data solutions for federal health programs, regulatory science, and high-impact missions.
• Build scalable data pipelines, data models, and analytics-ready datasets using SQL and Databricks.
• Collaborate with data engineers, analysts, software developers, data scientists, and client stakeholders to integrate data and improve quality.
• Communicate technical concepts clearly to both technical and non-technical audiences and ensure data security and performance.

Skills

SQL Development

Databricks

Databricks SQL

Relational Databases

Data Modeling

Dimensional Modeling

Data Warehousing

Medallion Architecture

Data Integration

Python

Git

Automated Testing

CI/CD

Communication

Public Trust

Education

Bachelor’s degree in Computer Science, Data Science, Engineering, Statistics, Biostatistics, or Mathematics

Tools

Databricks

Pentaho

Job description

Booz Allen Hamilton in McLean, VA is seeking a SQL Data Engineer to design, develop, and optimize data solutions for federal health programs and regulatory science. You will apply advanced SQL and Databricks to build scalable data pipelines, data models, and analytics-ready datasets, collaborating across data engineers, analysts, software developers, data scientists, and client stakeholders.

The role requires strong problem-solving, attention to detail, and the ability to communicate complex