Senior AWS, Snowflake Engineer

Summary

Join Encora as a Senior AWS, Snowflake Engineer and lead the design, development, and maintenance of scalable data solutions. You will drive data architecture, pipeline automation, and AI integration using AWS, DBT, Snowflake, Airflow, and Copilot AI. This remote role, based in Peru, Colombia, Costa Rica, or Bolivia, requires expertise in data pipelines, data transformation, and database management. You will collaborate with BI teams and leverage your advanced skills in SQL, AWS, DBT, Python, and experience with Snowflake and Airflow. The ideal candidate possesses a Bachelor’s degree in a related field and 5+ years of experience as a Data Engineer.

Requirements

• Bachelor’s degree in computer science, software engineering, or a related field
• Professional/ Advanced English skills
• +5 years of experience as Data Engineer
• Advanced SQL: strong skills in complex queries, optimization, and data modeling
• Advanced AWS: hands-on experience with services like S3, Redshift, Lambda, Glue, etc
• DBT (Data Build Tool): proven and mandatory experience
• Advanced Python: scripting, automation, and data processing
• Experience with Snowflake and Airflow
• Familiarity with BI tools (Power BI, Tableau, Looker, etc.)
• Experience in machine learning model training
• Familiarity with Apache technologies (e.g., Spark, Kafka)
• Experience with Terraform for Infrastructure as Code (IaC)

Responsibilities

• Design and maintain robust, scalable, and efficient data pipelines on AWS
• Implement and optimize data transformation models using DBT
• Develop data integration and processing solutions in Python
• Manage and optimize databases in Snowflake and other relational environments
• Orchestrate data workflows using Apache Airflow
• Collaborate with BI teams to ensure data availability and quality for dashboards and reporting
• Integrate AI tools such as Copilot to enhance productivity and task automation

Preferred Qualifications

• Certifications in AWS, DBT, or Snowflake
• Experience in Agile environments (Scrum, Kanban)
• Knowledge of DevOps and CI/CD practices

Benefits

Work Mode: Remote