Department Summary:
Join our Enterprise Data Warehouse team as we prepare for a major evolution in technology and process roll-out across MITRE. This is an exciting time to join the Enterprise Data Warehouse team as the use and gold source for our data evolves and grows exponentially. Your opportunity to make an impact is great as you help our team evolve to cloud-based hybrid data and real time data access. We are looking for a highly collaborative, team-oriented person to join us! A “can-do” and growth-focused attitude as well as the ability to work across more than one simultaneous project are musts!
Roles & Responsibilities:
· Design, develop, and implement robust ETL solutions using Python and PySpark to extract, transform, and load data from various sources into AWS data services.
· Optimize ETL processes for performance and scalability utilizing AWS Glue, EMR, Step Functions, and Lambda to ensure efficient data processing and timely delivery.
· Ensure data integrity and quality throughout the ETL process by implementing thorough data validation checks and error handling mechanisms.
· Manage AWS services such as Glue, EMR, Step Functions, and Lambda, including configuration, monitoring, and troubleshooting to maintain operational excellence.
· Collaborate with cross-functional teams including data engineers, data scientists, and business stakeholders to understand data requirements and deliver tailored ETL solutions.
· Troubleshoot complex technical issues and provide advanced operational support to internal MITRE customers in AWS
Basic Qualifications:
· Bachelor’s degree with eight years’ related experience, or a master’s degree with six years’ related experience, preferably with a technical major such as engineering, computer science, etc.
· Demonstrated experience in developing ETL pipelines using Python and PySpark, with a strong understanding of data processing techniques.
· Expertise in SQL for data manipulation, querying, and optimization to work with various database platforms including Postgres, DynamoDB, Oracle, and Redshift.
· Hands-on experience with AWS Glue, EMR, Step Functions, and Lambda for building and orchestrating ETL workflows in a cloud environment.
· Experience implementing Continuous Integration/Continuous Deployment (CI/CD) pipelines using AWS CDK or similar tools for automating deployment and testing of ETL solutions.
· This position requires a minimum of 60% hybrid on-site.
Preferred Qualifications:
· Previous experience leading or mentoring a team of developers/engineers in a collaborative environment.
· AWS certifications such as AWS Certified Developer or AWS Certified Solutions Architect, demonstrating proficiency in AWS services and best practices.
· Familiarity with big data technologies such as Apache Spark, Hadoop, or Kafka for processing large-scale datasets.
· Experience in data modeling and schema design for optimizing database performance and scalability.
· Experience working in Agile development methodologies, such as Scrum or Kanban, for iterative and collaborative project delivery.
· Self-motivated, curious, and collaborative, with a passion to learn new technologies and develop new skills
· Proven ability to collaborate effectively and actively participate in cross-training and team knowledge transfer.
This requisition requires the candidate to have a minimum of the following clearance(s):
NoneThis requisition requires the hired candidate to have or obtain, within one year from the date of hire, the following clearance(s):
NoneSalary compensation range and midpoint:
$144,800 - $181,000 - $217,200 AnnualWork Location Type:
HybridCommitment 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.
MITRE intends to maintain a website that is fully accessible to all individuals. If you are unable to search or apply for jobs and would like to request a reasonable accommodation for any part of MITRE’s employment process, please email recruitinghelp@mitre.org for general support and collegerecruiting@mitre.org for intern positions. This service is for individuals requiring reasonable accommodation requests. Please note that vendor solicitations will not receive a reply.
Benefits information may be found here.
Copyright © 1997-2026, The MITRE Corporation. All rights reserved. MITRE is a registered trademark of The MITRE Corporation. Material on this site may be copied and distributed with permission only.