Senior Technical Systems Analyst, Data Engineering, AWS

This is a fully remote position, open to applicants in Mexico.

📋 Description

• Collaborate with business stakeholders to identify needs and convert them into functional and non-functional requirements along with technical solutions.

• Design, develop, and sustain data models, mappings, and transformation logic for integrating source-to-target systems.

• Construct, test, and uphold ETL/ELT processes and AWS data pipelines.

• Develop and refine SQL queries for data analysis, validation, and troubleshooting purposes.

• Utilize Python for processing, validating, querying, and automating data workflows.

• Analyze architecture diagrams and technical specifications across microservices and distributed systems.

• Create and maintain documentation, including data flows, mapping specifications, user stories, and acceptance criteria.

• Engage in Agile Scrum/Kanban methodologies, including sprint planning, backlog refinement, and sprint reviews.

• Monitor activities and deliverables in Jira.

• Maintain code, scripts, and documentation using GitHub or other version control systems.

• Ensure secure handling of financial data and personally identifiable information in compliance with governance, privacy, and standards.

• Assist in testing and UAT by defining test scenarios, validating data integrity, and addressing defects with development teams.

• Communicate project progress, risks, dependencies, and updates to cross-functional teams and leadership.

⛳️ Requirements

• Extensive Data Engineering experience, encompassing data modeling, transformation, and integration.

• Strong hands-on expertise with AWS and cloud-based data solutions.

• In-depth knowledge of relational databases and SQL.

• Proficiency in Python for data processing, querying, validation, and automation tasks.

• Practical experience with ETL/ELT processes and data pipeline management.

• Familiarity 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 using GitHub or similar version control systems.

• Knowledge of SDLC processes and Agile methodologies (Scrum/Kanban).

• Experience with project management tools like Jira.

• Awareness of secure data handling, especially regarding sensitive financial data and PII.

• Capability to work directly with business stakeholders to understand requirements and convert them into technical solutions.

• Excellent communication skills and ability to collaborate with both technical and non-technical stakeholders.

• Experience in gathering and documenting both functional and non-functional requirements.

• Ability to create technical documentation, user stories, and acceptance criteria.

🏝️ Benefits

• Competitive benefits and compensation.

• Excellent work environment.

• Flexible work schedules.

• Policies that promote work-life balance.

• Community-focused workplace culture.