Python & SQL Data Engineer (Middle/Senior) ID32276

AgileEngine, LLC.; Campinas; Hybrid; BRL 452,000 - 652,000; Full time

Benefits offered by this job

Mentorship program

TechTalks

Education budget

Flexible schedule

Job summary

AgileEngine, LLC is seeking a data engineering professional to build and optimize data pipelines, design Snowflake data models, and deliver analytics-ready dashboards. You will collaborate with stakeholders to ensure transparency and project success while enhancing data observability and automation.

The role requires 3+ years in data modeling, strong SQL/Python skills, and hands-on experience with ETL tools like Airflow and DBT.

Qualifications

• 3+ years of experience in data modeling principles/methods, especially Kimball.
• Strong proficiency in SQL and experience 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.

Responsibilities

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

Skills

+3 years of experience in data...

Data modeling

SQL

Python

ETL pipelines

Airflow

DBT

APIs

Tableau

GitLab CI/CD

AWS (S3)

Analytical skills

Communication

Problem solving

Adaptability

Docker

Tools

Snowflake

Apache Airflow

DBT

GitLab

Job description

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.