MetroStar is a company dedicated to building exceptional teams and providing outstanding technology services. As a Sr. Data Engineer III, you will be responsible for designing and maintaining the data layer for C2SET integrations, ensuring data integrity and performance across distributed environments.
Responsibilities:
- Design, maintain, and validate data schemas supporting federation and integration between C2SET and external systems
- Build and support SQL and Python based ETL pipelines for operational, simulation, and analytics data
- Ensure data integrity, correctness, and performance across distributed and multi tier data sources
- Troubleshoot data mismatches, malformed messages, schema drift, and integration issues
- Partner with modeling and simulation engineers to analyze simulation outputs and support tuning of behaviors and decision logic
- Design and execute data driven experiments to evaluate model changes and operational impacts
- Develop datasets, scripts, and tooling to support repeatable validation and performance analysis
- Support Government analysts and integrators by delivering timely, reliable data refreshes and analysis
- Perform database performance tuning and optimization for operational workloads
- Maintain data documentation, metadata repositories, and data governance artifacts
- Act as a functional lead for data engineering and analytics activities within the integrations team
Requirements:
- An active U.S. Government issued Secret security clearance
- Bachelor's degree in Computer Science, Data Engineering, Information Systems, Mathematics, or a related technical field, or equivalent experience
- More than ten years of experience in data engineering, database engineering, database administration, or applied analytics
- Strong hands on experience with SQL and Python, including building and maintaining ETL pipelines
- Proven experience designing, implementing, and maintaining complex data schemas and data models
- Experience working with structured and semi structured data formats such as JSON and XML
- Ability to design, validate, and troubleshoot data exchanges across distributed or federated systems
- Experience with database performance tuning, indexing strategies, and query optimization
- Experience analyzing large or complex data sets and translating results into actionable technical recommendations
- Ability to collaborate effectively with software engineers, modeling and simulation engineers, and Government stakeholders