FBS (Mexico) - Analytics Engineer (USFITFV)

Farmers Insurance Careers Mexico

Estado de México

On-site

MXN 700,000 - 1,000,000

Full time

3 days ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Benefits offered by this job

Competitive compensation
Bonuses
Training and development resources
Work-life balance

Job summary

Farmers Insurance is seeking a highly skilled Data Engineer to join Analytics Engineering. You will design, build, and maintain scalable data pipelines supporting Advanced Analytics, BI, and Data Science efforts.

You’ll contribute to a semantic data layer and data products with AI-driven solutions to boost business growth and customer experience. Join a results-driven team focused on data quality, governance, and modern cloud platforms.

Qualifications

  • 3+ years as Analytics Engineer or equivalent.
  • Strong SQL, Python, Snowflake and DBT proficiency.
  • Experience with Git and Airflow for data workflows.
  • Proven ability to design scalable data pipelines.

Responsibilities

  • Lead design and deployment of scalable data pipelines across systems.
  • Establish data engineering best practices and governance.
  • Perform code reviews and contribute to engineering standards.
  • Develop ETL/ELT pipelines and reusable data frameworks.
  • Implement CI/CD for analytics pipelines and deployments.
  • Collaborate with data scientists, analysts, and product teams.
  • Communicate complex data concepts to non-technical stakeholders.
  • Deliver data products in agile cloud environments.

Skills

SQL
Python
Snowflake
DBT
Git
Airflow
Data pipelines
ETL/ELT

Tools

Snowflake
DBT
Git
Airflow
SQL Server

Job description

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 us and 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.

Ready to make your mark? Discover Farmers’ vibrant culture and explore career opportunities at www.Farmers.com/careers/corporate.

Job Summary

Seeking a highly skilled and motivated data engineer to join Analytics Engineering team within the Service Analytics and AI organization. This role is pivotal in designing, building, and maintaining scalable data pipelines and analytics solutions that empower Advanced Analytics, Business Intelligence, and Data Science initiatives. You will play a crucial role in building a semantic data layer, defining and implementing cutting-edge data products, and delivering innovative AI-driven solutions that fuel business growth and enhance customer experience.

Essential Job Functions
  • Data Pipeline Development: Lead the design, development, and deployment of scalable and robust data pipelines, ensuring seamless data integration and processing across diverse systems.
  • Analytics Engineering Best Practices: Establish and uphold best practices for data engineering, including coding standards, data governance, performance optimization, and automation strategies.
  • Code Quality and Review: Participate in code reviews, provide constructive feedback, and contribute to the team's continuous improvement in coding practices and methodologies.
  • ETL/ELT Development: Design, build, and maintain robust ETL/ELT pipelines, reusable frameworks, and libraries to process and transform data from diverse sources, ensuring accuracy, quality, and consistency.
  • Automation and CI/CD: Implement CI/CD pipelines to streamline the deployment, testing, and maintenance of analytics engineering processes.
  • Cross-functional Collaboration: Partner with data scientists, engineers, analysts, product managers, and business stakeholders to understand requirements
  • Stakeholder Communication: Articulate complex technical concepts to non-technical stakeholders, fostering alignment and ensuring a shared understanding of data initiatives across teams.
  • SQL & Data Engineering: Advanced SQL development, query optimization, complex transformations, and large-scale data processing.
  • Hands-on experience designing and developing enterprise-scale data solutions using Snowflake including performance tuning, data sharing, tasks, streams, and modern platform capabilities.
  • Experience building scalable transformation frameworks, reusable business logic, testing, documentation, and deployment pipelines using dbt.
  • Star schemas, conformed dimensions, historical tracking, KPI frameworks, and analytical data models.
  • Data quality, lineage, metadata management, testing, observability, and model lifecycle management.
  • Experience delivering data products within Agile product teams and modern cloud environments.
Experience Requirements
  • 3+ years of experience working as an Analytics Engineer or equivalent
  • Hands-on experience with SQL, SQL Server, Python, SnowFlake and DBT.
  • Experience in version control systems such as Git, and workflow management tools such as Airflow
  • Proven experience in designing and building scalable data pipelines.
  • Expertise in ETL/ELT processes, data modeling, and integration of data from multiple sources into a data warehouse.
  • Experience with CI/CD workflows and tools for data engineering.
  • Strong problem-solving and analytical skills, with the ability to work effectively in a collaborative environment.
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 permitted to engage in parallel employment, professional activities, or paid work for other entities. Any ownership, partnership, directorship, and participation in other businesses or companies must be fully disclosed and formally reviewed in accordance with FBS internal conflict-of-interest and 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.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

FBS (Mexico) - Associate Analytics Engineer (USFITFU)
FBS (Mexico) - Associate Analytics Engineer (USFITFU)

Farmers Insurance Careers Mexico • Estado de México

On-site
MXN 600,000 - 900,000
Competitive salary opportunities
Performance-based bonuses
Comprehensive benefits
+1
FBS (Mexico) - Senior Analytics Engineer
FBS (Mexico) - Senior Analytics Engineer

Farmers Insurance Careers Mexico • Estado de México

On-site
MXN 800,000 - 1,000,000
Competitive salary
Performance bonuses
Training opportunities
FBS Sr Data Engineer (SQL, Informatica)
FBS Sr Data Engineer (SQL, Informatica)

Farmers Group Inc. • Mexico

On-site
MXN 1,591,000 - 2,060,000
Bonuses
Training & development
Benefits package
FBS Data Engineer (Insurance)
FBS Data Engineer (Insurance)

Farmers Group Inc. • Mexico

Hybrid
MXN 420,000 - 720,000
FBS (Mexico) Director Principal Data & Analyticser (USFITFB)
FBS (Mexico) Director Principal Data & Analyticser (USFITFB)

Farmers Insurance Careers Mexico • Estado de México

On-site
MXN 900,000 - 1,500,000
FBS SAP Analytics Engineer (Datasphere)
FBS SAP Analytics Engineer (Datasphere)

Farmers Group Inc. • Mexico

On-site
MXN 600,000 - 900,000
FBS (Mexico) - Senior Decision Scientist
FBS (Mexico) - Senior Decision Scientist

Farmers Insurance Careers Mexico • Estado de México

On-site
MXN 900,000 - 1,500,000
FBS (Mexico) - Data Governance Advisor
FBS (Mexico) - Data Governance Advisor

Farmers Insurance Careers Mexico • Estado de México

On-site
MXN 600,000 - 1,200,000
FBS (Mexico) - Application Security Engineer
FBS (Mexico) - Application Security Engineer

Farmers Insurance Careers Mexico • Ciudad de México

On-site
MXN 700,000 - 950,000
Competitive pay
Bonuses
Benefits package
+1
FBS (Mexico) - Business Analyst
FBS (Mexico) - Business Analyst

Farmers Group Inc. • Mexico

On-site
MXN 300,000 - 540,000