MTSI is looking to solve problems of global importance by providing high-demand technical expertise in areas like Digital Transformation, Modeling and Simulation, Rapid Capability Development, Test and Evaluation, Artificial Intelligence, Autonomy, Cybersecurity and Mission Assurance.
Requirements
- Advanced proficiency in SQL with extensive experience in cloud data warehousing.
- Deep knowledge of data modeling, schema design, and query optimization.
- Significant, hands-on experience with Google BigQuery (partitioning, clustering, BQ scripting, cost optimization) is essential.
- Deep expertise in Apache Airflow (designing, deploying, scaling, and managing complex DAGs).
- Proven ability to build and optimize robust, high-throughput batch and streaming data pipelines using Apache Beam.
- Solid foundation and practical experience with RDBMS architecture, management, and optimization, specifically with PostgreSQL.
- Fluency in Python (preferred) or Java for data pipeline development.
Responsibilities
- Advanced proficiency in SQL with extensive experience in cloud data warehousing.
- Deep knowledge of data modeling, schema design, and query optimization.
- Significant, hands-on experience with Google BigQuery (partitioning, clustering, BQ scripting, cost optimization) is essential.
- Demonstrable expertise in building, deploying, and scaling complex data pipelines using at least one of the following foundational technologies: Orchestration: Deep expertise in Apache Airflow (designing, deploying, scaling, and managing complex DAGs).
- Proven ability to build and optimize robust, high-throughput batch and streaming data pipelines using Apache Beam.
- Solid foundation and practical experience with RDBMS architecture, management, and optimization, specifically with PostgreSQL.
- Fluency in Python (preferred) or Java for data pipeline development.
Other
- 5-8 years of experience of hands-on experience in data engineering, demonstrating a clear progression in designing, building, and maintaining scalable data-intensive systems.
- Demonstrated ability to communicate complex data issues to both technical and non-technical stakeholders.
- Must have a Secret Clearance; US Citizenship required.
- Occasional travel to MTSI offices and events throughout country
- Bachelor’s or master’s degree in computer science, Data Science, or a related field.
