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 extensive experience in data engineering and cloud technologies. Responsibilities include designing data pipelines, implementing DBT models, developing Python solutions, managing Snowflake databases, and orchestrating workflows with Airflow. Collaboration with BI teams and experience with machine learning model training are essential. The ideal candidate possesses advanced skills in SQL, AWS, DBT, and Python.

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