Apply now »

Sr Analytics Engineer - Automated Underwriting and Business Insurance

29838

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 a diverse 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 crucial role in the data ecosystem by iteratively transforming raw data into structured, high-quality datasets that are ready for analysis in partnership with data/decision scientists. The role primarily focuses on moderately complex to complex business problems while receiving limited coaching and guidance from data leadership. It may assist less experienced analytics engineers in solving moderately complex business problems. The role 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 deep understanding of data engineering, business processes, and analytics principles as well as a proactive approach to solving complex data challenges.

Essential Job Functions

Professional data infrastructure development with limited coaching while providing some 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. Professional data modeling and transformation with limited coaching while providing some 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*Professional collaboration and stakeholder management with limited coaching while providing some 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. Professional data governance and security knowledge with limited coaching while providing some 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, as applicable. Professional tool and technology utilization with limited coaching while providing some 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 little to no coaching. Performs other duties as assigned.

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.

Education Requirements

High School Diploma or equivalent required. Bachelors degree Bachelor’s or Master’s degree preferred in computer science, data science, engineering, or a related field. Certification in analytics or data engineering preferred.

Experience Requirements

5-7 years of related work experience required. Experience with cloud-based data platforms (AWS, Azure, GCP). Experience in Commercial/Business Insurance required. 

Benefits

  • Farmers offers a competitive salary commensurate with experience, qualifications and location.
    o CA Only: $119,920 - $191,290
    o CO Only: $112,720 - $164,890 
    o HI/IL/MN/VT Only: $112,720 - $176,550
    o MA Only: $112,720 - $176,550 
  • o MD Only: $112,720 - $176,550
    o NY/DC/NJ Only: $112,720 - $191,290 
             o Albany County: $119,920 - $164,890 
    o WA Only:  $112,720 - $200,625 
  • 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): R_US - United States

 

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.

 

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 »