Senior Technical Systems Analyst (Data Engineering & AWS)

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

About Enroute:

We love technology, and we enjoy what we do. We are always looking for innovation. We have social awareness and try to improve it daily. We make things happen. You can trust us. Our Enrouters are always up for a challenge. We ask questions, and we love to learn.

We pride ourselves on having great benefits and compensations, a fantastic work environment, flexible schedules, and policies that positively impact the balance of work and life outside of it. We care about who you are in the office and who you are as an individual. We get involved, we like to know our people, we want every Enrouter to become part of a great community of highly driven, responsible, respectful, and above all, happy people. We want you to enjoy working with us.

Technical Skills:

• Strong Data Engineering experience, including data modeling, data transformation, and data integration.
• Strong hands-on experience 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 experience with ETL/ELT processes and data pipelines.
• Experience with data mapping and transformation logic.
• Understanding of system architecture, microservices, distributed systems, and data integration patterns.
• Ability to read and interpret system architecture diagrams and technical specifications.
• Experience with GitHub or other version control systems.
• Understanding of SDLC processes and Agile methodologies (Scrum/Kanban).
• Experience with project management tools such as Jira.
• Familiarity with secure data handling, particularly sensitive financial data and PII

Business & Communication Skills:

• Ability to work directly with business stakeholders to understand requirements and translate them into technical solutions.
• Strong communication skills and ability to collaborate with both technical and non-technical stakeholders.
• Experience gathering and documenting functional and non-functional requirements.
• Ability to create clear technical documentation, user stories, and acceptance criteria.

Responsibilities:

• Collaborate with business stakeholders to understand business needs and translate them into clear functional and non-functional requirements and technical solutions.
• Design, develop, and maintain data models, data mappings, and transformation logic to enable seamless integration between source and target systems.
• Build, test, and maintain ETL/ELT processes and data pipelines on AWS, ensuring data accuracy, reliability, and timely availability.
• Develop and optimize SQL queries for data analysis, validation, and troubleshooting across relational databases.
• Leverage Python to process, validate, query, and automate data workflows.
• Analyze system architecture diagrams and technical specifications to understand data exchanges across microservices and distributed systems, identifying integration points and potential gaps.
• Create and maintain comprehensive documentation, including data flows, mapping specifications, user stories, and acceptance criteria for technical and non-technical stakeholders.
• Participate in Agile (Scrum/Kanban) development processes, including sprint planning, backlog refinement, and sprint reviews, while tracking activities and deliverables in Jira.
• Manage and maintain code, scripts, and technical documentation using GitHub or other version control systems.
• Ensure the secure handling of sensitive financial data and personally identifiable information (PII), adhering to data governance, privacy, and compliance standards.
• Support testing and User Acceptance Testing (UAT) by defining test scenarios, validating data integrity, and collaborating with development teams to identify and resolve defects.
• Communicate project progress, technical risks, dependencies, and key updates effectively to cross-functional teams and leadership.