Python & SQL Data Engineer (Middle/Senior) ID32276

AgileEngine, LLC.; Metropolitana; A distancia; COP 226.559.000 - 388.387.000; Jornada completa

Ventajas ofrecidas por este puesto de trabajo

Flextime (remote work options)

USD-based compensation

Opportunity to work with Fortune 500-?

Descripción de la vacante

AgileEngine is seeking a data engineer to build and optimize data pipelines, design Snowflake tables, and enhance observability for reliable analytics. You will create dashboards and collaborate with stakeholders to deliver business insights.

With 3+ years in data modeling, SQL, Python, Airflow, and DBT, you’ll integrate APIs, work with S3, and deploy using GitLab CI/CD. Flexible flextime with remote work options and exposure to Fortune 500 clients.

Formación

• +3 years in data modeling principles/methods, especially Kimball
• Proficiency in SQL; Snowflake or similar cloud data warehouse
• Python for data processing and automation
• ETL pipelines using Airflow or similar tools
• DBT for data transformation, modeling, and testing
• Experience consuming APIs and integrating data with Snowflake
• Develop simple Tableau dashboards
• GitLab CI/CD workflows for CI/CD
• Familiarity with AWS S3 services
• Strong analytical and problem-solving skills
• Innovative and productivity-driven mindset – automate processes
• Adapt to business needs and stakeholder requirements
• Clear communication of work

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

SQL

Snowflake

Python

ETL

Airflow

DBT

APIs

Tableau

GitLab CI/CD

AWS S3

Data modeling

Communication

Herramientas

Docker

Tableau BI

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.