F

Farmers Insurance

Multiline insurer of auto and home

Analytics Engineer

Data EngineeringPosted on Nov 14
Full-timeRemote in MexicoRemote

About the Job

Requirements

  • At least 3 years of experience working as an Analytics Engineer or equivalent.
  • Hands-on experience with SQL, SQL Server, Python, Snowflake, and dbt.
  • Experience with version control systems such as Git and workflow management tools such as Airflow.
  • Proven experience designing and building scalable data pipelines.
  • 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, with 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 coding practices and methodologies.
  • Design, build, and maintain robust ETL/ELT pipelines, reusable frameworks, and libraries to process and transform data from diverse sources while ensuring accuracy, quality, and consistency.
  • Implement CI/CD pipelines to streamline deployment, testing, and maintenance of analytics engineering processes.
  • Partner with data scientists, engineers, analysts, product managers, and business stakeholders to understand requirements.
  • Explain complex technical concepts to non-technical stakeholders to foster alignment and shared understanding of data initiatives across teams.
  • Develop advanced SQL, optimize queries, implement 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