Apply now »

Associate Analytics Engineer - Hartford, CT (Hybrid)

31908

We are Farmers!

We are… more than just your favorite commercials.  At Farmers, we strive to deliver peace of mind to our customers by providing protection and comprehensive advice and delivering in the moments of truth. That means having people who can help us meet changing customer and business needs. Farmers high-performance culture is focused on results and the people who achieve them. We hold ourselves and others accountable for sustainably growing the business and each other. We seek solutions, own our actions, and grow through discomfort. We see setbacks as opportunities while continuously asking ourselves how we impact our customers. 

 

Farmers is an award winning, equal opportunity employer, committed to the strength of an inclusive workforce. We are dedicated to supporting the well-being of our people through our extensive suite of benefits, as well as the well-being of the communities we serve through employee volunteer programs and nonprofit partnerships. Helping others in their time of need isn’t just our business – it’s our culture!  To learn more about our high-performance culture and open opportunities, check out www.Farmers.com/careers/corporate and be sure to follow us on Instagram, LinkedIn, and TikTok. 

 

Workplace: Hybrid ( #LI-Hybrid ), Remote ( #LI-Remote )

Farmers believes in a culture of collaboration, creativity, and innovation, which thrives when we have the ability to work flexibly in a virtual setting as well as the opportunity to be together in person. Our hybrid work environment combines the best of both worlds with at least three (3) days in office and up to two (2) days virtual for employees who live within fifty (50) miles of a Farmers corporate office. Applicants beyond fifty (50) miles may still be considered.

Job Summary

This position plays a role in the data ecosystem by assisting in transforming raw data into structured, high-quality datasets that are ready for analysis. The role primarily focuses on low to moderately complex business problems while receiving coaching and guidance from data leadership. The role combines the technical skills of a data engineer, the analytical mindset of a data analyst, and working business acumen to ensure data is not only collected and stored efficiently but also accessible and insightful for end users. With some coaching and guidance from more experienced engineers, the position is responsible for end-to-end data workflow including data ingestion, transformation, modeling, and validation to enable data-driven decision-making across the organization. The position requires understanding of data engineering, business processes, and analytics principles as well as a proactive approach to solving complex data challenges.

What You'll Do

  • 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 langua ges. 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.

Additional Qualifications

  • 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. Acts as translation layer for and conduit to technology for all aspects of the work 

What You'll Bring

  • 1-2 years of related work experience required.
  • 1-2 years of experience with Python, SQL
  • 1-2 years of experience with Data Engineering
  • Good to have experience with AWS, DBT or PySpark

Education Requirements

  • High School Diploma or equivalent required.
  • Bachelors degree preferred in computer science, data science, engineering, or a related field.

Physical Actions

Job is performed in-person at a Farmers office or virtually at an approved alternative work location. The physical work environment is indoors and climate-controlled with adequate lighting and ventilation. Normal and customary distractions include background noise produced by office equipment and chatter among people, as well as interruptions. Frequently sits for prolonged periods of time, up to a full shift. Occasionally moves about the workplace including, navigating stairs, ramps, and level or uneven surfaces. Occasionally moves, pushes, pulls, lifts, carries, and/or places objects or materials weighing up to 25 pounds without assistance. Frequently uses shoulders, arms, hands, and fingers to manipulate equipment, tools, and objects necessary to perform job duties. Frequently performs fine motor tasks such as typing, mousing, or writing, up to a full shift. Rarely performs movements such as bending, stooping, crouching, kneeling, twisting, and reaching overhead or below the knees. Possesses clear vision, with or without correction, to visually read and verify information. Relies on depth perception and peripheral vision to navigate the work environment visually by identifying barriers, changes in terrain and locating objects. Possesses adequate hearing, with or without correction, to communicate with co-workers, respond promptly to auditory signals or alarms, and discern sounds essential for maintaining safety and productivity in the workplace. Jobs in this category require rare, if any, travel.

Benefits

  • Farmers offers a competitive salary commensurate with experience, qualifications and location.
    o CA Only: $84,640 - $134,530
    o CO Only: $79,360 - $116,380 
    o HI/IL/MN/VT Only: $79,360 - $124,300
    o MA Only: $79,360 - $124,300 
  • o MD Only: $79,360 - $124,300
    o DC/NJ/NY/OH Only: $79,360 - $134,530 
             o Albany County, NY/Cleveland, OH: $84,640 - $116,380 
    o WA Only:  $79,360 - $141,250 
  • 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
  • For more information, review “What we offer” on https://www.farmers.com/careers/corporate/#offer

 

Job Location(s): US - CT - Hartford, US - CT - West Hartford

 

Anticipated application deadline: At Farmers, the recruitment process is designed to ensure that we find the best talent to join our team. As part of this process, we typically close open positions within 8 to 21 days after posting. If you are interested in any of our open positions, we encourage you to submit your application promptly.

 

Farmers will consider for employment all qualified applicants, including those with criminal histories, in accordance with the Los Angeles Fair Chance Initiative for Hiring Ordinance or other applicable law.  Pursuant to 18 U.S.C. Section 1033, Farmers is prohibited from employing any individual who has been convicted of any criminal felony involving dishonesty or a breach of trust without prior written consent from the state Department of Insurance.

 

It is unlawful in Massachusetts to require or administer a lie detector test as a condition of employment or continued employment. An employer who violates this law shall be subject to criminal penalties and civil liability.

 

Farmers is an Equal Opportunity Employer and does not discriminate in any employer/employee relations based on race, color, religion, gender, sexual orientation, gender expression, genetic information, national origin, age, disability, marital status, military and veteran's status, or any other basis protected by applicable discrimination laws. 

 

Want to learn more about our culture & opportunities? Check out www.Farmers.com/careers/corporate and be sure to follow us on Instagram, LinkedIn, and TikTok.

 

Spokane, WA only:  Residents who prefer not to provide their address click here to submit your resume via email: careers@farmers.com

Apply now »