Role Overview

Mactores is a trusted leader in providing modern data platform solutions, enabling businesses to accelerate value through automation. We are seeking a seasoned AWS Data Engineer (Senior) to join our dynamic team. This role involves developing and maintaining robust data pipelines and models, leveraging cutting-edge AWS technologies to drive digital transformation.

Responsibilities

• Develop and maintain efficient data pipelines using Amazon EMR or Amazon Glue.
• Design and implement data models and facilitate end-user querying with Amazon Redshift, Snowflake, Amazon Athena, and Presto.
• Build and maintain data pipeline orchestration using Airflow.
• Collaborate with cross-functional teams to understand and address data needs, designing effective solutions.
• Troubleshoot and optimize existing data pipelines and models for performance and reliability.
• Write and maintain PySpark and SQL scripts for data extraction, transformation, and loading.
• Document and effectively communicate technical solutions to both technical and non-technical stakeholders.
• Stay informed on the latest AWS data technologies and assess their potential impact on current systems.

Required Skills

• Bachelor's degree in Computer Science, Engineering, or a related field.
• Minimum of 3 years of experience with PySpark and SQL.
• At least 2 years of experience in building and maintaining data pipelines using Amazon EMR or Amazon Glue.
• Experience with data modeling and querying using Amazon Redshift, Snowflake, Amazon Athena, and Presto for over 2 years.
• Proven experience (1+ years) in orchestrating data pipelines with Airflow.
• Strong problem-solving and troubleshooting capabilities.
• Excellent communication and collaboration skills.
• Ability to work both independently and as part of a team.

Nice to Have

• AWS Data Analytics Specialty Certification.
• Familiarity with Agile development methodologies.