Analytics Engineer: ELT, DBT & Snowflake Expert

Capgemini; Mexico; On-site; PHP 3,685,503 - 5,528,255; Full time

Benefits offered by this job

Private Health and Dental Insurance

Pension Plan

Meals tickets

Life Insurance

Career development and training

Job summary

FBS - Farmer Business Services, part of Farmers operations, partners with Capgemini as Employer of Record to identify and hire top talent. We are building innovative data pipelines and semantic models to enable analytics-driven decisions.

The role focuses on pipeline design, data modeling, and collaboration with analysts and stakeholders to deliver scalable data solutions and insights.

Qualifications

• 5+ years of experience as Analytics Engineer or in a similar role.
• Proficient in SQL and Python.
• Advanced knowledge of PowerBI (Power Query and DAX).
• 4+ years of experience with pipeline automation tools (Fivetran a plus).
• Strong knowledge of DBT or other ELT frameworks/tools (Apache Airflow).
• Strong English communication skills.

Responsibilities

• Design and develop scalable data pipelines using ELT tools and frameworks (DBT or similar).
• Automate data ingestion from databases, APIs, and third-party services.
• Design data warehousing solutions (Snowflake or similar) and optimize storage for performance and cost.
• Develop and maintain logical/physical data models; create star/snowflake schemas.
• Transform raw data into analytics-ready datasets using SQL, Python, or similar languages.

Skills

SQL

Python

PowerBI

English

Tools

DBT

Apache Airflow

Fivetran

Job description

FBS - Farmer Business Services, part of Farmers operations, partners with Capgemini as Employer of Record to identify and hire top talent. We are building innovative data pipelines and semantic models to enable analytics-driven decisions.

The role focuses on pipeline design, data modeling, and collaboration with analysts and stakeholders to deliver scalable data solutions and insights.