Associate Analytics Engineer
Farmers Insurance
full-time
Posted on:
Location Type: Hybrid
Location: Hartford • Connecticut • 🇺🇸 United States
Visit company websiteSalary
💰 $79,360 - $141,250 per year
Job Level
JuniorMid-Level
Tech Stack
AirflowAmazon RedshiftApacheAWSBigQueryETLPySparkPythonSQL
About the role
- 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.
- Data Storage and Management - Designs and implements data warehousing solutions using platforms like Snowflake, Redshift, or BigQuery.
- Data Modeling - Develops and maintains logical and physical data models to support business analytics.
- Data Transformation - Transforms raw data into clean, organized, and analytics-ready datasets using SQL, Python, or other relevant languages.
- Conducts data validation and consistency checks to ensure the accuracy and reliability of data.
- Works closely with data analysts, data scientists, and business stakeholders.
Requirements
- 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
- High School Diploma or equivalent required.
- 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
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard skills
ETLdata pipeline designdata warehousingdata modelingdata transformationSQLPythondbtApache AirflowPySpark
Certifications
High School DiplomaBachelor's degree