Software Developer - Analytics Engineering

Farmers Insurance Careers

1d•Hybrid

About The Position

This role is part of the Claims Solutions Engineering team, responsible for building custom solutions to enable the deployment of predictive models and other specialized use-cases. This position plays a crucial role in the data ecosystem by iteratively transforming raw data into structured, high-quality datasets ready for analysis in partnership with data/decision scientists. The role primarily focuses on moderately complex business problems while receiving limited coaching and guidance from data leadership. It combines the technical skills of a data engineer, the analytical mindset of a data analyst, and strong business acumen to ensure data is not only collected and stored efficiently but also made accessible and insightful for end users. In partnership with data/decision scientists, 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. This position requires a deep understanding of data engineering, business processes, and analytics principles, as well as a proactive approach to solving complex data challenges.

Requirements

3-5 years of related work experience required.
Experience with cloud-based data platforms (AWS, Azure, GCP).
High School Diploma or equivalent required.

Nice To Haves

Experience with C#, Python, JavaScript, Blazor, SQL, and Snowflake highly preferred.
Bachelors degree preferred in computer science, data science, engineering, or a related field.

Responsibilities

Architects and builds scalable data pipelines using modern ETL tools and frameworks such as dbt, Apache Airflow, or similar.
Automates data ingestion processes from various sources including databases, APIs, and third-party services.
Designs and implements data warehousing solutions using platforms like Snowflake, Redshift, or BigQuery.
Optimizes storage solutions for performance, cost efficiency, and scalability.
Develops and maintains logical and physical data models to support business analytics.
Creates and manages dimensional models, star/snowflake schemas, and other data structures.
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.
Conducts data validation and consistency checks to ensure the accuracy and reliability of data.
Implements data quality monitoring and alerting mechanisms.
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.
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.
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.
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.
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.
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 coaching, guidance, and feedback.
Performs other duties as assigned.