Apply now »

Sr. Analytics Engineer Manager

33678

We are Farmers – where ambition meets opportunity.

 

At Farmers, we’re not just known for unforgettable jingle – we’re a team with a passion for purpose and making a real difference in people’s lives. We deliver peace of mind when it matters most. Our results-driven, high-performance culture thrives on creativity, accountability and bold solutions. Here, growth isn’t just a goal – it’s a way of life for both the organization and every individual on our team. We tackle challenges head-on, learn from every experience and measure our impact on the customers who trust us.

 

Join an award-winning,  equal opportunity employer, where you’ll find more than a job – you’ll find a supportive community. Enjoy competitive benefits, take part in meaningful volunteer projects, and help shape the future alongside talented colleagues across all backgrounds. At Farmers, helping others is at the heart of what we do.

 

Ready to make your mark? Discover our vibrant culture and explore career opportunities at www.Farmers.com/careers/corporate. Connect with us on InstagramLinkedIn and TikTok, and let’s build something incredible together!

 

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 science and information delivery teams. The role primarily focuses on complex business problems while working independently. It mentors, coaches, and trains less experienced team members and supervises direct reports who are people leaders or individual contributors. The role combines the technical skills of a data engineer, the analytical mindset of a data analyst, and advanced business acumen to ensure data is not only collected and stored efficiently but also made accessible and insightful for end users. In partnership with analytic teams, 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

  • Expert data infrastructure development working independently while providing regular 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.
  • Expert data modeling and transformation working independently while providing regular 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. Expert collaboration and stakeholder management working independently while providing regular 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.
  • Expert data governance and security knowledge working independently while providing regular 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.
  • Expert tool and technology utilization working Independently while providing regular 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 while assisting lower levels as needed. Performs other duties as assigned.
  • Expert people leadership working independently while providing coaching, guidance and supervision to less experienced people leaders or individual contributors: Supervises, guides, coaches, and manages the performance of direct reports. Delivers regular feedback and supports professional development. Fosters a high-performance culture where excellence is standard and innovation is actively encouraged.

Experience Requirements

  • 7-10 years of related work experience required.
  • Experience with cloud-based data platforms (Snowflake, AWS, Azure, GCP).
  • Experience in a people leader or management role preferred.

Education Requirements

  • Bachelors degree required.
  • Certification in analytics or data engineering preferred. 

Additional Qualifications

  • Strong verbal communication and listening skills.
  • Demonstrated written communication skills.
  • Demonstrated analytical skills.
  • Demonstrated problem solving skills.
  • Effective interpersonal skills.
  • Effectively coaches and delivers constructive feedback.
  • Ability to influence internal and/or external constituents.
  • Seeks to acquire knowledge in area of specialty.
  • Possesses strong technical aptitude.
  • Proficiency with SQL or similar, dimensional modeling, pipeline orchestration, building data pipelines to transform data, and BI visualizations.
  • Knowledge of data visualization tools (example Tableau, Power BI).
  • Acts as translation layer for and conduit to technology for all aspects of the work.
  • Understanding of machine learning concepts and tools.

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: $129,075 - $219,780
    o CO Only: $121,350 - $189,310 
    o HI/IL/MN/VT Only: $121,350 - $202,730
    o MA Only: $121,350 - $202,730 
  • o MD Only: $121,350 - $202,730
    o DC/NJ/NY/OH Only: $121,350 - $219,780 
             o Albany County, NY/Cleveland, OH: $129,075 - $189,310 
    o WA Only:  $121,350 - $230,375 
  • 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.

 

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 InstagramLinkedIn, 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 »