Apply on Employer Site

Farmers Insurance · 3 hours ago

Associate Analytics Engineer - Hartford, CT (Hybrid)

West Hartford, CT

Full-time

Hybrid

Entry Level

$85K/yr - $135K/yr

1+ years exp

Farmers Insurance is dedicated to delivering peace of mind to customers through protection and comprehensive advice. The Associate Analytics Engineer will assist in transforming raw data into structured datasets, focusing on data ingestion, transformation, and modeling to enable data-driven decision-making across the organization.

Auto InsuranceFinancial ServicesInsuranceLife Insurance

H1B Sponsor Likely

Responsibilities

Emerging data infrastructure development with coaching and guidance: 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), Apache Airflow, 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

Emerging data modeling and transformation with coaching and guidance: 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

Emerging collaboration and stakeholder management with coaching and guidance: 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. Technical Communication - Clearly communicates complex technical concepts and data insights to non-technical stakeholders. Provides training and support to team members on data tools, best practices, and methodologies

Emerging data governance and security knowledge with coaching and guidance: 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

Emerging tool and technology utilization with coaching and guidance: Technology Stack - Utilizes modern data tools and technologies such as SQL, Python, dbt, Airflow, and cloud platforms like AWS, Azure, or GCP. Evaluates and integrates new tools and technologies to improve data infrastructure and processes. Continuous Learning - Stays updated with the latest trends, best practices, and advancements in data engineering and analytics. Participates in professional development opportunities to enhance technical and analytical skills. Provides code as requirements for hardening and operationalization by technology with significant coaching, guidance, and feedback. Performs other duties as assigned

Qualification

Data EngineeringSQLPythonETL ToolsData ModelingCloud PlatformsAnalytical SkillsProblem SolvingCommunication SkillsInterpersonal Skills

Required

1-2 years of related work experience required

1-2 years of experience with Python, SQL

1-2 years of experience with Data Engineering

High School Diploma or equivalent required

Strong verbal communication and listening skills

Demonstrated written communication skills

Demonstrated analytical skills

Demonstrated problem solving skills

Effective interpersonal skills

Ability to influence internal and/or external constituents

Seeks to acquire knowledge in area of specialty

Possesses strong technical aptitude

Basic experience with SQL or similar, dimensional modeling, pipeline orchestration, building data pipelines to transform data, and BI visualizations

Preferred

Good to have experience with AWS, DBT or PySpark

Bachelors degree preferred in computer science, data science, engineering, or a related field

Benefits

Bonus Opportunity (based on Company and Individual Performance)

401(k)

Medical

Dental

Vision

Health Savings and Flexible Spending Accounts

Life Insurance

Paid Time Off

Paid Parental Leave

Tuition Assistance

Company

Farmers Insurance

Glassdoor3.2

The companies comprising the Farmers Insurance Group of Companies® currently make up one of the country's largest insurers of vehicles, homes and small businesses, and provide a wide range of other specialty insurance and financial services products.

Founded in 1928

Los Angeles, California, USA

10001+ employees

https://www.farmers.com

H1B Sponsorship

Farmers Insurance has a track record of offering H1B sponsorships. Please note that this does not guarantee sponsorship for this specific role. Below presents additional info for your reference. (Data Powered by US Department of Labor)

Distribution of Different Job Fields Receiving Sponsorship

Represents job field similar to this job

Trends of Total Sponsorships

2025 (105)

2024 (76)

2023 (86)

2022 (129)

2021 (106)

2020 (90)