Python & SQL Data Engineer (Middle/Senior) ID32276

AgileEngine, LLC.; Bogotá ciudad; Hybrid; COP 258,925,000 - 388,387,000; Full time

Benefits offered by this job

Mentorship

Tech Talks

Growth roadmap

USD compensation

Education budget

Fitness budget

Team activities

Flextime

Remote work options

Job summary

AgileEngine, LLC is hiring a data engineer in Usaquen, Colombia to build and optimize data pipelines, design Snowflake models, and enhance observability. You will create dashboards and collaborate with stakeholders to deliver insights.

The role requires 3+ years in data modeling, SQL, Python, Airflow, and DBT, with experience in API data integration and AWS S3. The position offers hybrid work options, USD-based compensation, and opportunities for growth, mentorship, and hands-on projects with

Qualifications

• 3+ years in data modeling, Kimball methods.
• Strong SQL; Snowflake or similar cloud warehouses.
• Python for data processing and automation.
• ETL pipelines with Airflow or similar tools.
• DBT for data transformation and testing.
• APIs integration with Snowflake data.
• Develop simple Tableau dashboards.
• GitLab CI/CD workflows for CI/CD.
• AWS services, especially S3.
• Strong analytical and problem-solving skills.
• Innovative mindset with automation focus.
• Adapt to changing business needs and clear communication.

Responsibilities

• Build and optimize data pipelines for reliable integration and transformation.
• Design and maintain Snowflake tables and data models for analytics.
• Enhance data observability to proactively resolve issues.
• Create dashboards and workflows to deliver business insights.
• Collaborate with stakeholders to ensure project transparency and success.

Skills

Data modeling

Analytical thinking

Problem solving

Communication

Tools

SQL

Snowflake

Python

Airflow

DBT

API integration

Tableau

GitLab CI/CD

AWS S3

Job description

Usaquen, Colombia | Posted on 03/11/2025

What you will do

• Build and optimize data pipelines to ensure reliable integration and transformation;
• Design and maintain Snowflake tables and data models for analytics and reporting;
• Enhance data observability to proactively identify and resolve issues;
• Create dashboards and workflows to deliver business insights;
• Collaborate with stakeholders to ensure project transparency and success.

Must haves

• +3 years of experience in data modeling principles/methods, especially Kimball ;
• Strong proficiency in SQL and experience working with Snowflake or similar cloud-based data warehouses;
• Strong proficiency in Python for data processing and automation;
• Hands-on experience building ETL pipelines using Apache Airflow or similar orchestration tools;
• Hands-on experience using DBT for data transformation, modeling, and testing;
• Strong experience consuming APIs and integrating data with Snowflake;
• Ability to develop simple Tableau dashboards;
• Proficiency in GitLab CI/CD workflows for continuous integration and deployment;
• Familiarity with AWS services, especially S3 ;
• Strong analytical and problem-solving skills;
• Innovative and productivity-driven mindset - willingness to improve and automate processes;
• Ability to adapt to business needs and stakeholder requirements;
• Ability to communicate work clearly;

Nice to haves

• Basic knowledge of local development using Docker;
• Tableau or any BI development experience.

The benefits of joining us

Professional growth

Accelerate your professional journey with mentorship, TechTalks, and personalized growth roadmaps.

Competitive compensation

We match your ever-growing skills, talent, and contributions with competitive USD-based compensation and budgets for education, fitness, and team activities.

A selection of exciting projects

Join projects with modern solutions development and top-tier clients that include Fortune 500 enterprises and leading product brands.

Flextime

Tailor your schedule for an optimal work-life balance, by having the options of working from home and going to the office - whatever makes you the happiest and most productive.