Senior Technical Systems Analyst (Data Engineering & AWS)

Enroute

About The Position

Enroute is seeking a Senior Technical Systems Analyst focused on data engineering and AWS. The role works with business stakeholders and technical teams to translate business needs into requirements and technical solutions, and to build and maintain data integrations, models, transformation logic, and AWS-based ETL/ELT pipelines. It also supports data validation, testing and UAT, technical documentation, and Agile delivery. The position requires careful handling of sensitive financial data and personally identifiable information in accordance with applicable governance, privacy, and compliance standards. Enroute describes itself as an innovative, technology-focused company that values learning, social awareness, trust, collaboration, and making things happen. It highlights its benefits and compensation, work environment, flexible schedules, work-life balance policies, and community of highly driven, responsible, and respectful people.

Requirements

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 using 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, including Scrum or Kanban.
Experience with project management tools such as Jira.
Familiarity with secure data handling, particularly sensitive financial data and PII.
Ability to work directly with business stakeholders to understand requirements and translate them into technical solutions.
Strong communication and collaboration skills with 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 functional and non-functional requirements and technical solutions.
Design, develop, and maintain data models, data mappings, and transformation logic for integrating source and target systems.
Build, test, and maintain AWS ETL/ELT processes and data pipelines, ensuring data accuracy, reliability, and timely availability.
Develop and optimize SQL queries for analysis, validation, and troubleshooting across relational databases.
Use Python to process, validate, and query data and automate workflows.
Analyze system architecture diagrams and technical specifications to understand data exchanges across microservices and distributed systems, and identify integration points and potential gaps.
Create and maintain documentation such as data flows, mapping specifications, user stories, and acceptance criteria.
Participate in Agile Scrum or Kanban processes, including sprint planning, backlog refinement, and sprint reviews, and track activities and deliverables in Jira.
Manage code, scripts, and technical documentation using GitHub or another version control system.
Handle sensitive financial data and PII securely and follow data governance, privacy, and compliance standards.
Support testing and UAT by defining test scenarios, validating data integrity, and working with development teams to identify and resolve defects.
Communicate project progress, technical risks, dependencies, and updates to cross-functional teams and leadership.