Senior Data Engineer – Snowflake Pipelines & Modeling

Farmers Group Inc.; México; Remote; MXN 900,000 - 1,400,000; Full time

Benefits offered by this job

Competitive compensation package

Performance-based bonuses

Training & development resources

Job summary

Farmers Insurance is seeking a data-focused engineer to join the Direct modeling team in Mexico. The role involves designing, setting up, and monitoring the data ecosystem to support marketing analytics and direct channels.

You will build scalable data pipelines, automate ingestion, and design data warehouses using Snowflake, Redshift, or BigQuery. You will develop and maintain data models and transformations, collaborating with data analysts, scientists, and business stakeholders to translate

Qualifications

• 4+ years of Python and SQL experience.
• Experience with data transformation and data quality assurance.
• Pipeline design and development across ETL processes.
• Technical communication and collaboration with stakeholders.
• Experience with DBT and Snowflake.
• Knowledge of data governance principles.

Responsibilities

• Design and develop scalable data pipelines using modern ETL tools such as DBT.
• Automate data ingestion from databases, APIs and third-party services.
• Design data warehousing using Snowflake, Redshift, or BigQuery.
• Model and transform data to analytics-ready formats.
• Collaborate with analysts and business stakeholders to gather requirements.
• Define and enforce data governance policies and security controls.

Skills

Python

SQL

Data Transformation

Data Quality Assurance

Pipeline Design

Technical Communication

DBT

Snowflake

Data Governance

Databricks

Education

High School Diploma

Bachelors degree in CS/Data Science/Engineering

Tools

Databricks

Job description

Farmers Insurance is seeking a data-focused engineer to join the Direct modeling team in Mexico. The role involves designing, setting up, and monitoring the data ecosystem to support marketing analytics and direct channels.

You will build scalable data pipelines, automate ingestion, and design data warehouses using Snowflake, Redshift, or BigQuery. You will develop and maintain data models and transformations, collaborating with data analysts, scientists, and business stakeholders to translate