Data Engineer

Data Engineer The Opportunity: We are seeking a Data Engineer to build and maintain cloud-native data ingestion pipelines and analytics infrastructure on AWS. You will develop and support API-driven ingestion feeds, maintain Lambda and Glue-based ETL processes, model and query data in Redshift across landing, staging, core, and mart layers, and monitor production workloads for reliability and data quality. This role sits at the intersection of data engineering and cloud operations, and includes exposure to data visualization and dashboard delivery for business stakeholders. What You’ll Work On: Build and support ingestion pipelines that pull data from external APIs, normalize JSON and CSV payloads, and land data in Amazon S3. Develop and maintain AWS Lambda functions supporting ingestion and orchestration workflows. Create and maintain AWS Glue jobs, including Visual ETL workflows. Support large-volume data loads and batch processing, including ECS or Fargate. Write and maintain Redshift SQL organized into properly layered landing, staging, core, and mart structures, including tables and views. Develop efficient queries using joins, aggregations, and views against large datasets. Implement and maintain SQL-based data quality checks covering null values, duplicates, row counts, and schema change detection. Monitor, diagnose, and remediate pipeline and job failures using CloudWatch logs and job run histories. Work within supporting AWS services, including VPC, IAM, SSM Parameter Store, Secrets Manager, and KMS. Adhere to established AWS naming conventions and follow DEV/STAGE/PROD promotion patterns. Build and maintain dashboards and reporting assets in Amazon QuickSight, Tableau, or Power BI to support business stakeholders. Ingest and manipulate data in dashboards. Join us. The world can’t wait. You Have: 2+ years of experience with SQL, including joins, aggregations, views, and query optimization 2+ years of experience in ETL development or data cleaning and parsing 2+ years of experience with data visualization using Amazon QuickSight, Tableau, or Power BI Experience with ingestion pipelines consuming REST APIs and normalizing JSON or CSV data into S3 Experience maintaining AWS Lambda functions, creating AWS Glue jobs, executing visual ETL workflows, and implementing data quality validation in SQL, including nulls, duplicates, row counts, and schema drift Experience monitoring, diagnosing, and resolving job failures via CloudWatch logs and job run histories Experience supporting AWS services, including VPC, IAM, SSM Parameter Store, Secrets Manager, and KMS Ability to write and maintain layered Redshift SQL, including landing, staging, core, or mart, using tables and views Ability to follow AWS naming conventions and execute DEV/STAGE/PROD promotion patterns HS diploma or GED Nice If You Have: 1+ years of experience with cybersecurity Experience writing AWS Lambda functions in Python Experience with PySpark for ETL development within Glue Experience with ECS or Fargate for large data loads Experience with CI/CD practices, including GitHub version control and GitHub Actions, automated testing, and release management Experience with front-end or stack development in JavaScript, including with React, Vue, or Angular Experience with Python or JavaScript Experience with GitHub Bachelor's degree AWS Certified Cloud Practitioner or similar AWS Certification 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. Our recognition awards program acknowledges employees for exceptional performance and superior demonstration of our 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. Individuals that do not meet the threshold are only eligible for select offerings, not inclusive of health benefits. We encourage you to learn more about our total benefits by visiting the Resource page on our Careers site and reviewing Our Employee Benefits page. 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). The estimate displayed represents the typical salary range for this position and is just one component of Booz Allen’s total compensation package for employees. 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.