FBS Sr Data Engineer (SQL, Informatica)

Farmers Group Inc.; México; On-site; MXN 1,591,000 - 2,060,000; Full time

Benefits offered by this job

Bonuses

Training & development

Benefits package

Job summary

Farmers Group Inc. is seeking a data engineer to acquire, curate, and publish data for analytical and operational use both on prem and in the cloud.

You will design data products, build scalable data pipelines, and partner with business users, data scientists, and engineers to deliver trusted data across the organization. Responsibilities include creating data models, governance practices, and API integrations while coaching junior associates as needed.

Qualifications

• 5–7 years of related experience.
• Bachelor's degree preferred.
• High School Diploma or equivalent is required.

Responsibilities

• Lead design, development and implementation of data products.
• Develop advanced data blocks, models and data flows for client requests.
• Create access methods for structured and unstructured data.
• Build scalable data pipelines for streaming and batch workloads.
• Coordinate with stakeholders to translate business analytics into technical tasks.

Skills

Data modeling

Data pipelines

API integrations

Data governance

Data analysis

Agile

Education

Bachelor's degree preferred

High School Diploma or equivalent

Tools

Cloud environments

Relational databases

Non-relational databases

APIs

Job description

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

36371

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.

Responsible for acquiring, curating, and publishing data both on prem and in the cloud for analytical or operational uses for moderate scenarios. Ensures the data is in a ready‑to‑use form that creates a single version of the truth across all data consumers, including business/technology users, reporting and visualization specialists and data scientists. Utilizes skills to translate business analytic requests/requirements into design, development, testing, deployment, and production maintenance tasks. Works independently with various technologies from big data, relational and non-relational databases, cloud environments, different programming languages and various reporting tools. Is beginning to provide coaching to junior associates.

Essential Job Functions

Consults on data projects of varying complexity, with minimal coaching and guidance, to understand design requirement and existing business processes to lead in the design, development, and implementation of data products. Practices code management and integration with current architectural and data governance guidelines with minimal oversight. Produces advanced data building blocks, data models, and data flows for varying client requests such as dimensional data, standard and ad hoc reporting, data feeds, dashboard reporting, and data science research <(>&<)> exploration independently. Creates business user access methods to structured and unstructured data. Utilizes techniques such as mapping data to a common data model, natural language processing, transforming data as necessary to satisfy business rules, AI, statistical computations, and validation of data content. Translates business data stories into a technical story breakdown structure and work estimate for a schedule or planned agile sprint. Projects are advanced with interaction across multiple dependencies. Coaching and assistance required on an as needed basis. Develops and maintains advanced to complex scalable data pipelines for both streaming and batch requirements and builds out new API integrations to support increased demands of data volume and complexity. Preps/cleanses data to optimize for downstream reporting via Farmers standard visualization or AI/ML tools with coaching and assistance as requested. Applies extensive knowledge of data governance concepts and applies them across multiple scenarios. Delivers on complex projects with some vague timelines. Develops data project plans and executes independently. Performs other duties as assigned.

Physical Actions

This role, whether performed virtually or in an office setting, will include normal and customary distractions, noise, and interruptions. Sits or stands for extended periods of time, up to a full work shift. Occasionally reaches overhead and below the knees, including bending, twisting, pulling, and stooping. Occasionally moves, lifts, carries, and places objects and supplies weighing 0-10 pounds without assistance. Listens to, interprets, and differentiates auditory information (example others speaking) at normal speaking levels with or without correction. Visually verifies and reads information. Visually locates material, resources and other objects. Ability to continuously operate a computer for extended periods of time, up to a full work shift. Physical dexterity sufficient to use hands, arms, and shoulders repetitively to operate keyboard and other office equipment up to a full work shift.

Education Requirements

High School Diploma or equivalent required. Bachelor's degree preferred.

Experience Requirements

5-7 years of related experience required.

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

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