Data Engineer, Senior

Booz Allen Hamilton; Washington (District of Columbia); On-site; USD 99,000 - 225,000; Full time

Benefits offered by this job

Health benefits

Tuition assistance

Work-life programs

Paid leave

Job summary

Booz Allen Hamilton is seeking a Senior Data Engineer to design, build, and maintain robust data pipelines for multiple clients. You will optimize ETL processes, model data, and ensure security and compliance while collaborating with a multidisciplinary team in a fast-paced setting.

The role emphasizes hands-on data engineering with PySpark, Python, and SQL across AWS services to deliver scalable analytics, insights, and trusted data assets for decision-making.

Qualifications

• 7+ years of experience designing and developing ETL processes and data pipelines.
• Experience with AWS services including Glue, S3, and RDS.

Responsibilities

• Design, build, and maintain end-to-end data pipelines and ETL processes.
• Collaborate with cross-functional teams to enable analytics across the business.
• Improve performance, scalability, and data security/compliance of data platforms.

Skills

ETL design

Data pipeline optimization

Python

PySpark

SQL (PostgreSQL)

Data modeling

Public Trust

Education

Bachelor's degree in CS/CE/Information Systems/Technology

Tools

AWS Glue

Amazon S3

Amazon RDS

PostgreSQL

AWS Glue Data Catalog

Collibra / metadata tooling

Job description

The Opportunity

As a Senior Data Engineer, you will be responsible for designing, building, and maintaining robust data pipelines. Your key tasks will include creating and optimizing end-to-end data flows, handling ETL processes including extract, transform, and load, designing data models, ensuring data security and compliance, collaborating with cross-functional teams, and continuously improving performance and scalability. Your expertise will bridge the gap between raw data and actionable insights, enabling efficient data processing and analytics across the business. Here, you’ll work with and guide a multi-disciplinary team of analysts, data engineers, developers, and data consumers in a fast-paced, agile environment. You’ll use your experience in analytical exploration and data examination while you manage the assessment, design, building, and maintenance of scalable platforms for your clients. Work with us to use data for good. Join us. The world can’t wait.

You Have:

• 7+ years of experience in designing and developing ETL processes and managing data pipelines
• Experience using various AWS services, including AWS Glue, Amazon S3, and Amazon RDS
• Knowledge of performance optimization techniques for ETL jobs, such as partitioning, bucketing, and caching
• Ability to troubleshoot and improve query performance
• Ability to develop and deploy ETL processes with limited visibility, utilizing comprehensive logging and robust error handling mechanisms to troubleshoot and resolve issues
• Ability to proficiently write Python and PySpark code for ETL scripts and custom transformations
• Ability to proficiently write SQL queries on a PostgreSQL database
• Ability to design and implement data models, define schemas, and optimize data structures for efficient querying and analytics
• Public Trust
• Bachelor’s degree in Computer science, Computer engineering, Information systems, or technology

Nice If You Have:

• Experience with cloud-native data services such as AWS Lambda or Google Cloud Functions and leveraging serverless architectures for data processing
• Experience ensuring data quality, privacy, and security
• Knowledge of data governance practices, data lineage, and compliance requirements such as GDPR and CCPA
• Knowledge of tools like Apache Atlas, AWS Glue Data Catalog, or Collibra for managing metadata, data lineage, and cataloging data assets

Compensation

At Booz Allen, we celebrate your contributions, provide you with opportunities and choices, and support your total well-being. Our offerings include health, life, disability, financial, and retirement benefits, as well as paid leave, professional development, tuition assistance, work-life programs, and dependent care.

• 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. Individuals that do not meet the threshold are only eligible for select offerings, not inclusive of health benefits.
• Salary at Booz Allen is determined by various factors, including but not limited to location, the individual’s particular combination of education, knowledge, skills, competencies, and experience, as well as contract-specific affordability and organizational requirements.
• The projected compensation range for this position is $99,000.00 to $225,000.00 (annualized USD).
• This posting will close within 90 days from the Posting Date.

Identity Statement

As part of the hiring process, we will ask you to complete 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. We reserve the right to take your picture to verify your identity and prevent fraud.

Candidate AI Usage Policy

AI is a part of our daily work at Booz Allen, and we are committed to the responsible and ethical use of AI tools. However, we want to ensure a fair candidate process based on your own skills and knowledge. As part of this commitment, 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

Our people-first culture prioritizes the benefits of collaboration, whether it occurs in person or virtually. To support engagement and effective communication, employees working virtually are generally expected to have their cameras on during meetings.

• Remote: If this position is listed as remote, there may still be occasions when you are required to work in person at a Booz Allen or customer facility.
• Hybrid: If this position is listed as hybrid, you will be expected to work from a Booz Allen facility frequently, in alignment with leadership expectations and the needs of the role. You may also be required to work from or visit a customer facility.
• Onsite: If this position is listed as onsite, work will primarily be performed at a Booz Allen office or customer facility, where employees will collaborate directly with colleagues and customers as required by the role.

Commitment to Non-Discrimination

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.

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.

About Booz Allen

Booz Allen is an advanced technology company. We build commercial-grade products and solutions for America’s most critical defense, civil, and national security priorities.

Know Your Rights Poster Accommodations

Applicants who need a reasonable accommodation for any part of the application, hiring, or employment process because of a disability, a sincerely held religious belief, practice, or observance, or as otherwise required by applicable law should contact the Booz Allen Help Desk by calling 1-877-927-8278 or sending an email to [e-mail]. We will review requests on an individualized basis and provide reasonable accommodations consistent with applicable law.

Data Privacy

For more information on how Booz Allen uses your information, please see our Careers Privacy Policy.