F

Farmers Insurance

Multiline insurer of auto and home

Senior Analytics Engineer

Data EngineeringConfirmed live in the last 24 hours
Full-timeRemote in Mexico

About the Job

Requirements

  • At least 5 years of experience working as an Analytics Engineer or equivalent.
  • Hands-on experience with SQL, SQL Server, Python, dbt, and Snowflake.
  • Experience with version control systems such as Git and workflow management tools such as Airflow.
  • Experience designing and building scalable data pipelines and architectures.
  • A strong understanding of data governance, quality assurance, and performance optimization in a data engineering context.
  • Expertise in ETL/ELT processes, data modeling, and integrating data from multiple sources into a data warehouse.
  • Experience with CI/CD workflows and tools for data engineering.
  • Strong problem-solving and analytical skills, and the ability to work effectively in a collaborative environment.

Responsibilities

  • Lead the design, development, and deployment of scalable, robust data pipelines, ensuring seamless data integration and processing across diverse systems.
  • Establish and uphold data engineering best practices, including coding standards, data governance, performance optimization, and automation strategies.
  • Participate in code reviews, provide constructive feedback, and contribute to continuous improvement in the team's coding practices and methodologies.
  • 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.
  • Proactively monitor and troubleshoot data pipelines to ensure high availability, reliability, and performance across data engineering workflows.
  • Implement CI/CD pipelines to streamline the deployment, testing, and maintenance of analytics engineering processes.
  • Partner with data scientists, engineers, analysts, product managers, and business stakeholders to understand requirements, translate them into actionable technical specifications, and deliver data solutions.
  • Explain complex technical concepts to non-technical stakeholders, fostering alignment and shared understanding of data initiatives across teams.
  • Develop advanced SQL, optimize queries, perform complex transformations, and process data at large scale.
  • Design and develop enterprise-scale data solutions using Snowflake, including performance tuning, data sharing, tasks, streams, and modern platform capabilities.
  • Build scalable transformation frameworks, reusable business logic, testing, documentation, and deployment pipelines using dbt.
  • Develop star schemas, conformed dimensions, historical tracking, KPI frameworks, and analytical data models.
  • Support data quality, lineage, metadata management, testing, observability, and model lifecycle management.
  • Deliver data products within Agile product teams and modern cloud environments.

About the Company

Farmers Insurance

Multiline insurer of auto and home

Farmers Insurance Group offers auto, home, life, and business insurance plus related financial services across all 50 states. Policies are underwritten and supported by risk management and claims handling, with sales through a mix of exclusive and independent agents who focus on long-term relationships. It stands out by combining nationwide coverage with a multiline product lineup and an emphasis on ongoing service and cross-selling rather than one-off transactions. Its goal is to protect customers’ assets and finances with reliable coverage while growing its business through lasting relationships.

Company size
10,001+
Company stage
Debt Financing
Total funding
$300M
Headquarters
Los Angeles, CA
Founded
1928

Recently Posted Jobs

Explore more opportunities at Farmers Insurance

See more jobs