Senior Data Engineering Systems Analyst - AWS & ETL
Posted Updated
Description
Enroute is seeking a Data Engineer to design, build and maintain data models, mappings, and ETL/ELT pipelines on AWS. You will work with business stakeholders to translate requirements into robust data solutions and ensure data quality and security across distributed systems.
The ideal candidate has strong SQL, Python and cloud data experience, plus a solid understanding of SDLC and Agile methodologies. Collaboration with cross-functional teams and thorough documentation are essential.
Collaborate with business stakeholders to translate needs into technical requirements and solutions. Design, develop and maintain data models, data mappings and transformation logic for source-to-target integration. Build, test, and maintain ETL/ELT processes and data pipelines on AWS. Develop and optimize SQL queries for data analysis, validation and troubleshooting. Use Python to process, validate, query and automate data workflows. Analyze system architecture diagrams to identify data exchange points between microservices and distributed systems. Create and maintain documentation including data flows, mappings, user stories and acceptance criteria. Participate in Agile processes (Scrum/Kanban) and manage tasks in Jira. Manage and maintain code and documentation using GitHub or other VCS. Experience with data modeling, transformation and integration. Hands-on AWS/cloud-based data solutions experience. Strong knowledge of relational databases and SQL. Proficiency in Python for data processing, querying and automation. Hands-on ETL/ELT processes and data pipelines. Experience with data mapping and transformation logic. Understanding of SDLC and Agile methodologies. Familiarity with secure data handling of financial data and PII.Skills
Sign in to read and join the discussion.