Senior Data Systems Engineer - AWS & Data Pipelines

Enroute; United States; Remote; USD 110,000 - 165,000; Full time

Job summary

Enroute is seeking a skilled Data Engineer to design and implement robust data models, mappings, and ETL/ELT pipelines on AWS. You will work with business stakeholders to translate needs into technical solutions and ensure data integrity across distributed systems.

The role requires strong SQL, Python, and data integration experience, plus hands-on AWS and modern data tooling. You will contribute to architecture design, documentation, and agile workflows within a collaborative team.

Qualifications

• Strong data engineering experience including data modeling, transformation, and integration.
• Hands-on with AWS and cloud-based data solutions.
• Strong knowledge of relational databases and SQL.
• Experience with Python for data processing, querying, validation, and automation.
• Hands-on with ETL/ELT processes and data pipelines.

Responsibilities

• Collaborate with stakeholders to translate business needs into technical requirements and solutions.
• Design, develop, and maintain data models, mappings, and transformation logic for source-to-target integration.
• Build, test, and maintain ETL/ELT processes and data pipelines on AWS with data accuracy and reliability.
• Develop and optimize SQL queries for data analysis, validation, and troubleshooting.
• Use Python to process, validate, query, and automate data workflows.
• Analyze architecture diagrams to identify data exchange points and gaps across microservices.
• Create and maintain documentation including data flows, mappings, user stories, and acceptance criteria.
• Participate in Agile development (Scrum/Kanban) and track work in Jira.
• Manage code and scripts in GitHub; enforce secure handling of sensitive data and PII.
• Support testing and UAT by defining test scenarios and validating data integrity.
• Communicate progress, risks, and updates to cross-functional teams and leadership.

Skills

Data engineering

AWS

SQL

Python

ETL/ELT

Data mapping

System architecture

SDLC & Agile

Documentation

Tools

GitHub

Jira

Job description

Enroute is seeking a skilled Data Engineer to design and implement robust data models, mappings, and ETL/ELT pipelines on AWS. You will work with business stakeholders to translate needs into technical solutions and ensure data integrity across distributed systems.

The role requires strong SQL, Python, and data integration experience, plus hands-on AWS and modern data tooling. You will contribute to architecture design, documentation, and agile workflows within a collaborative team.