About the Role:

We are seeking a skilled and motivated AWS ETL Engineer to join our growing Data Engineering team. In this role, you will be responsible for designing, developing, implementing, and maintaining efficient and scalable ETL pipelines using AWS cloud services. You will play a key role in ensuring the smooth and reliable flow of data from various sources into our data warehouse and data lake, enabling data-driven decision-making across the organization. Given the small size of our current engineering team, this role will have the opportunity to be deeply involved in AdTech projects and publishing strategies.

Responsibilities:

● Design and develop ETL pipelines: Create and maintain robust ETL processes using AWS services such as AWS Glue, Lambda, AWS Pandas SDK, S3,Redshift, and Kinesis.

● Data extraction and integration: Extract data from diverse sources, including databases, APIs, flat files, email and streaming platforms, and integrate it into the target data stores.

● Data transformation and cleansing: Implement data quality rules, perform data cleansing, and transform data into the required formats for analysis and reporting.

● Performance optimization: Optimize ETL jobs for performance, scalability, and cost-effectiveness.

● Monitoring and troubleshooting: Monitor ETL pipelines, identify and resolve issues, and ensure data quality and integrity.

● Collaboration: Work closely with data analysts, data scientists, and other stakeholders to understand data requirements and deliver data solutions.

● Documentation: Maintain clear and comprehensive documentation of ETL processes and data flows.

● Stay current: Keep up-to-date with the latest AWS services and best practices in ETL development.

Qualifications and Experience:

● CS Degree or equivalent experience

● 3+ Years AWS Expertise: Strong understanding and hands-on experience with AWS services relevant to ETL, including AWS Glue, Pandas SDK, Lambda, S3, Redshift, and Kinesis.

● 5+ Years ETL Development: Proven experience in designing, developing, and implementing ETL pipelines using scripting languages like Python or Scala and tools like Apache Spark.

● 5+ Years Data Modeling: Knowledge of data warehousing concepts and data modeling techniques.

● SQL Proficiency: Strong SQL skills for data manipulation and querying.

● Problem-Solving: Excellent analytical and problem-solving abilities.

● Communication: Strong written and verbal communication skills.

Bonus Points:

● AI/ML integration experience to prepare and transform data for machine learning tasks.

● AdTech or MarTech specific experience

● Experience with data governance and data quality tools.

● Familiarity with DevOps practices and CI/CD pipelines.

● AWS certifications (e.g., AWS Certified Data Analytics - Specialty, AWS Certified Machine Learning - Specialty).

You must be based in LATAM, but we are unable to hire in Mexico for this position.
You must have a good understanding of English (spoken and written)

Contract