Python & SQL Data Engineer (Middle/Senior) ID32276

AgileEngine, LLC.; Sur; Híbrido; COP 291.290.000 - 388.387.000; Jornada completa

Ventajas ofrecidas por este puesto de trabajo

Flextime

Remote work options

Education budget

Team activities

Descripción de la vacante

AgileEngine is a fast-growing software partner delivering analytics-driven solutions. We are seeking a data engineer to build robust data pipelines, design Snowflake schemas, and enhance observability while delivering actionable dashboards for business stakeholders.

You will collaborate with cross-functional teams, leverage ETL tooling, and implement automated data quality checks. Flexible work options and USD-based compensation are offered.

Formación

• +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

Responsabilidades

• 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.

Conocimientos

Data modeling

SQL

Python

ETL

Airflow

DBT

APIs

Tableau

GitLab CI/CD

AWS S3

Analytical skills

Communication

Herramientas

Snowflake

Airflow

DBT

Tableau

GitLab CI/CD

Docker

Descripción del empleo

AgileEngine is one of the Inc. 5000 fastest-growing companies in the U and a top-3 ranked dev shop according to Clutch. We create award-winning custom software solutions that help companies across 15+ industries change the lives of millions

If you like a challenging environment where you’re working with the best and are encouraged to learn and experiment every day, there’s no better place - guaranteed!

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.