Data Engineer

Matrix Systems & Technologies • Washington, DC

9d

About The Position

Matrix Systems and Technology, Inc. (MSTi) seeks a Data Engineer to develop and support data pipelines and integrations across cloud, relational, and NoSQL environments. The role involves building and maintaining ingestion, transformation, and ETL/ELT workflows; integrating data from multiple database sources; and supporting data mapping and validation. The engineer will also investigate processing failures, monitor pipeline reliability and performance, document operating procedures, and collaborate with application developers, analysts, and testing teams.

MSTi provides IT and engineering services to federal, state, local government, and commercial clients. Its work includes software testing and quality assurance, project management, requirements analysis, implementation support, and IT staff augmentation. The company has provided services since 1996 and is based in the Washington, DC metro area.

Requirements

• Approximately four to eight years of relevant data engineering experience.
• Experience with AWS Glue and Informatica.
• Experience working with MongoDB, Amazon Aurora/RDS, and Oracle.
• Strong SQL, data mapping, and integration skills.
• Experience building and troubleshooting ETL/ELT pipelines.
• Ability to collaborate with application developers, analysts, and testing teams.

Responsibilities

• Design, develop, and maintain data ingestion and transformation pipelines.
• Build and support ETL/ELT workflows using AWS Glue and Informatica.
• Integrate data from MongoDB, Amazon Aurora/RDS, Oracle, and other sources.
• Develop SQL queries and support source-to-target data mapping.
• Validate data accuracy and completeness and investigate processing failures.
• Monitor pipeline reliability and performance and document operating procedures.
• Collaborate with application developers, analysts, and testing teams.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: No Education Listed