SQL Data Engineer

As a SQL Data Engineer at Booz Allen Hamilton, you will help design, develop, and optimize secure data solutions and pipelines for federal health programs and other mission-critical initiatives. The work centers on building analytics-ready datasets that perform reliably at scale, with a focus on strong SQL foundations and practical Databricks experience.

Based in Bethesda, MD (onsite), this role supports data integration and delivery across teams and stakeholders, including engineers, analysts, developers, data scientists, and client partners. You will apply advanced SQL and modern data engineering practices to improve data quality, troubleshoot complex issues, and communicate technical findings to both technical and non-technical audiences.

Key Responsibilities

• Design, develop, and optimize data solutions supporting federal health programs, regulatory science, and other high-impact missions.
• Use advanced SQL 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.
• Communicate technical concepts to both technical and non-technical audiences.
• Work independently in an Agile, collaborative, client-focused environment by troubleshooting complex issues, raising questions proactively, and identifying potential risks and recommended actions to management early.

Required Qualifications

• 5+ years developing, optimizing, and troubleshooting complex SQL solutions, including queries, stored procedures, views, functions, and data transformations using Oracle SQL, PostgreSQL, and Databricks SQL.
• 2+ years 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.
• Public Trust
• Bachelor’s degree in Computer Science, Data Science, Engineering, Statistics, Biostatistics, or Mathematics.

Technologies

• SQL, Oracle SQL, PostgreSQL
• Databricks SQL, Databricks Workspace
• Notebooks, jobs, workflows
• Apache Spark, Delta Lake, cluster configuration
• Python, Git

Compensation

USD 77,600 - 176,000 per yearly

Benefits

• Health, life, disability, financial, and retirement benefits
• Paid leave
• Professional development
• Tuition assistance
• Work-life programs
• Dependent care
• Recognition awards program acknowledging employees for exceptional performance and superior demonstration of values
• Full-time and part-time employees working at least 20 hours a week on a regular basis are eligible to participate in Booz Allen’s benefit programs

Additional “Nice If You Have”

• 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.

Identity and Background Requirements

• Selected applicants 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.
• Completing an identity verification process that leverages advanced biometrics and artificial intelligence to ensure authenticity and protect against identity fraud.
• You are expected to be on camera during interviews and assessments.
• Booz Allen reserves the right to take your picture to verify your identity and prevent fraud.

Candidate AI Usage Policy

• The use of artificial intelligence (AI) or other tools to assist with responses during interviews (whether in-person or virtual) is prohibited unless permission is explicitly provided.

Work Model

• Onsite: Work will primarily be performed full-time at a customer facility, where employees will collaborate directly with colleagues and customers as required by the role.
• Employees working virtually are generally expected to have their cameras on during meetings.

Non-Discrimination Commitment

All qualified applicants will receive consideration for employment without regard to disability, status as a protected veteran, or any other status protected by applicable federal, state, local, or international law.