FBS Senior Data Engineer (SnowFlake)

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

Benefits offered by this job

Competitive compensation

Performance-based bonuses

Training and development resources

Healthcare options

Job summary

Farmers Insurance in Mexico is seeking an experienced Data Engineer to design, build, and monitor scalable data pipelines and data warehousing solutions. You will work with DBT, Snowflake, and Python/SQL to enable analytics and business insights.

The role requires 4+ years in data engineering, strong communication, and experience with data governance and data quality processes. Join a high-performance team delivering impactful models and decisions.

Qualifications

• 4+ years working with Python and SQL.
• Data Transformation and Data Quality Assurance experience.
• Pipeline Design and Development experience.
• Technical Communication with stakeholders.
• Experience with DBT and Snowflake.
• Experience with Data Governance.

Responsibilities

• Pipeline Design and Development; Architect and build scalable data pipelines using modern ETL tools such as DBT or similar.
• Automates data ingestion from databases, APIs, and third-party services.
• Data Storage and Management; design data warehousing solutions using Snowflake, Redshift, or BigQuery.
• Optimize storage solutions for performance and cost.
• Data Modeling and transformation to analytics-ready datasets; SQL, Python, or similar.
• Implement data quality monitoring and governance practices.
• Collaborate with data analysts, data scientists, and business stakeholders to translate requirements into technical specs.

Skills

Python

SQL

Data Transformation

Data Quality Assurance

Pipeline Design

Technical Communication

DBT

Snowflake

Data Governance

Education

Bachelor's degree preferred in Computer Science / Data Science / Engineering

Tools

DBT

Snowflake

Databricks

Job description

Select how often (in days) to receive an alert:

36317

Farmers– where ambition meets opportunity.

Farmers is known for more than its unforgettable jingle – it’s a team with a passion for purpose and making a real difference in people’s lives. Farmers employees deliver peace of mind when it matters most. The organization’s results-driven, high-performance culture thrives on creativity, accountability and bold solutions. Here, growth isn’t just a goal – it’s a way of life for both the organization and every individual on the team. Farmers employees tackle challenges head‑on, learn from every experience and measure their impact on the customers who trust them.

Join usand help power the success of Farmers. As a team member, you’ll collaborate with Farmers’ award-winning workforce, benefit from a culture of innovation and support and contribute to their mission of delivering protection and peace of mind to millions of U.S. customers.

The Direct modeling team is focused on creating models to guide enterprise marketing decision that will help to promote brand awareness as well as boost sales through direct channel. This role will help the team to design, set up, and monitor the data ecosystem that's needed to support the modeling needs. Tasks include, but not limited to, setting up data pipelines and design efficient data storage solutions.

Essential Job Functions

• Pipeline Design and Development; Architects and builds scalable data pipelines using modern ETL (Extract, Load, Transform) tools and frameworks such as DBT (Data Build Tool), or similar.
• Automates data ingestion processes from various sources including databases, APIs, and third party services.
• Data Storage and Management - Designs and implements data warehousing solutions using platforms like Snowflake, Redshift, or BigQuery.
• Optimizes storage solutions for performance, cost efficiency, and scalability.

Data modeling and transformation:

• Data Modeling - Develops and maintains logical and physical data models to support business analytics.
• Creates and manages dimensional models, star/snowflake schemas, and other data structures.
• Data Transformation - Transforms raw data into clean, organized, and analytics-ready datasets using SQL, Python, or other relevant languages.
• Implements data transformation workflows to handle data cleansing, normalization, and enrichment.
• Data Quality Assurance - Conducts data validation and consistency checks to ensure the accuracy and reliability of data. Implements data quality monitoring and alerting mechanisms.

Collaboration and stakeholder management:

• Cross-Functional Collaboration - Works closely with data analysts, data scientists, and business stakeholders to gather requirements and understand their data needs.
• Acts as a liaison between technical teams and business units to translate business requirements into technical specifications.

Data governance and security knowledge:

• Governance Policies Implements and enforces data governance policies to ensure data privacy, security, and compliance with relevant regulations.
• Defines and manages data access, controls, permissions, and audit trails.
• Security Measures - Monitors and enforces data security measures to protect sensitive information from unauthorized access and breaches.
• Ensures compliance with industry standards and regulations such as GDPR, CCPA, or HIPAA and others as applicable.

Physical Actions

Physical Environment

Education Requirements

High School Diploma or equivalent required. Bachelors degree preferred in computer science, data science, engineering, or a related field.

Experience Requirements

• 4+ years working with Python and SQL
• Data Transformation
• Data Quality Assurance
• Pipeline Design and Development
• Technical Communication
• Experience working with DBT and SnowFlake
• Experience working with Data Governance

Special Skill Requirement

Additional Qualification

• Experience working with Databricks

Benefits
This position offers a competitive compensation and benefits package designed to support your wellbeing, growth, and work–life balance. While specific benefits may vary by country and employee level, offerings generally include competitive salary opportunities, performance-based bonuses, comprehensive benefits, and ongoing training and development resources.

Important Hiring Conditions and Disclosures

By applying for this position, candidates acknowledge and agree that:

Personal Data Processing:The personal data provided during the recruitment and selection process will be collected, processed, and retained for legitimate recruitment and compliance purposes,in accordance with applicable data protection and privacy laws and FBS internal policies.

Legal Authorization to Work:Employment with FBS is conditional upon the candidate having valid, local legal authorization to work in the country where the role is based at the time of hire.FBS does not sponsor or obtain work authorization unless explicitly stated.

Exclusivity of Employment and Conflict of Interest:Upon acceptance of an offer and during employment with FBS, employees will not be permittedto engage in parallel employment, professional activities, or paid work for other entities. Any ownership, partnership, directorship, or participation in other businesses or companies must be fully disclosed and formally reviewed in accordance with FBS internal conflict‑of‑interestand external engagement policies prior to the start date or as soon as such circumstances arise.

Failure to comply with these conditions may impact the hiring decision or employment continuation.

About Farmers Insurance
"Farmers Insurance®" and "Farmers®" are tradenames for a group of insurers providing insurance for automobiles, homes and small businesses and a wide range of other insurance and financial services products. Farmers Insurance Exchange, the largest of the three primary insurers that make up Farmers Insurance, is recognized as one of the largest U.S. companies on the 2025 Fortune 500 list. For more information about Farmers Insurance, visit Farmers.com.