Data Engineer, Senior

Booz Allen Hamilton is hiring a Senior Data Engineer to support mission-critical applications and analytics. In this onsite role in McLean, VA, you will design, develop, and maintain scalable, cloud-based data pipelines and automated data workflows, working with teams to deliver reliable data solutions for enterprise environments.

This position offers a projected annual compensation range of $77,600 to $176,000, along with benefits including health, life, disability, financial, and retirement benefits, paid leave, professional development, tuition assistance, and work-life and dependent care programs.

What you’ll do

• Design, develop, test, and maintain scalable data pipelines and data processing workflows.
• Build data solutions using Databricks, including data transformation, processing, and orchestration.
• Create automated workflows that improve reliability, efficiency, and repeatability of data processing.
• Integrate data from multiple sources and formats into enterprise data platforms.
• Develop and optimize data transformations using SQL and Python.
• Troubleshoot data pipeline issues and identify opportunities for performance and reliability improvements.
• Collaborate with software developers, data engineers, architects, and stakeholders to understand requirements and deliver technical solutions.
• Apply Agile practices, version control, testing, and CI/CD across the software development lifecycle.

What you need

• 5+ years of experience in data engineering, database development, or data warehousing.
• Experience with SQL, including complex queries with joins and aggregations, CTEs, window functions, query optimization, and performance tuning, plus relational database development, troubleshooting, and tuning.
• Experience developing and maintaining data pipelines using Python and Apache Spark or PySpark for processing and transforming large datasets, including performance optimization and troubleshooting.
• Experience with Databricks for data engineering.
• Experience with AWS and AWS data services such as S3, EMR, Glue, Lambda, or NoSQL databases.
• Experience with CI/CD pipelines, including platforms such as GitHub Actions, for automated builds, testing, deployment, and promotion across environments.
• Knowledge of database design and data warehousing concepts, including ETL/ELT, fact and dimension tables, star and snowflake schemas, slowly changing dimensions, data integration, and incremental data processing.
• Ability to independently troubleshoot data pipeline failures, data issues, performance problems, and production incidents, including identifying root causes and corrective actions.
• Public Trust and U.S. citizenship are required.
• Bachelor’s degree in CS.

Nice to have

• Experience with data lake or Lakehouse architectures.
• Experience with DevSecOps practices.
• Experience working in federal or other highly regulated environments.
• Knowledge of data modeling, including conceptual, logical, and physical data models, dimensional modeling, and analytics and reporting-oriented model design.
• Ability to contribute to technical design and architecture discussions and develop scalable, maintainable, reliable data engineering solutions.
• Ability to use AI-assisted development tools for productivity, code generation and review, troubleshooting, SQL and Spark optimization, documentation, and learning while following organizational security and data-protection standards.

Benefits

• Health, life, disability, financial, and retirement benefits
• Paid leave
• Professional development
• Tuition assistance
• Work-life programs
• Dependent care
• Recognition awards program

Vetting and identity requirements

• Selected applicants will be subject to a government investigation and may need to meet eligibility requirements of the U.S. government client; Public Trust determination is required.
• During the hiring process, you will complete an identity verification process that uses 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 may take your picture to verify identity and prevent fraud.

Candidate AI usage policy: use of artificial intelligence (AI) or other tools to assist with responses during interviews (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 collaborate directly with colleagues and customers as required by the role.

Technologies: Databricks, AWS, SQL, Python, Apache Spark, PySpark, S3, EMR, Glue, Lambda, GitHub Actions, NoSQL databases.