Data Engineer
Job Description
Matrix Systems and Technology is seeking a Data Engineer with approximately four to eight years of relevant experience to build and support data ingestion, transformation pipelines, and system integrations across cloud, relational, and NoSQL environments. This role is based in Washington, DC and requires onsite presence.
Role Overview
The position focuses on designing, developing, and maintaining end-to-end data pipelines, including ETL/ELT workflows and integrations across multiple data sources. You will also support troubleshooting and quality validation to ensure reliable processing and accurate outcomes.
Key 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.
Required Qualifications
- 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.
Technologies
AWS Glue, Informatica, MongoDB, Amazon Aurora, Amazon RDS, Oracle, SQL, ETL/ELT
Compensation and Location
- Location: Washington, DC (onsite)
- Salary: USD 70,000 - 95,000 per year
About MATRIX SYSTEMS & TECHNOLOGIES INC
Matrix Systems and Technology, Inc. (MSTi) was established in 1996 and provides IT and engineering services to federal, state, and local government and commercial clients.
Services include software testing and quality assurance, project management, requirements analysis, implementation support, and IT staff augmentation.