Associate Analytics Engineer - Hartford, CT (Hybrid)

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.

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

Skills

• 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
• 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 Overview

Company H1B Sponsorship