Apply now »

Principal Business Analyst - Caledonia, MI (Hybrid)

29415

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 ) 

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.

Job Summary

The Specialty Business Information Delivery (BID) team is seeking a data-driven professional to support regulatory reporting and data solutions across Foremost business units.  

 

The intenral position title will be Business Solutions Analyst. 

What You'll Do

Analyze and deliver data solutions:

  • Extract, transform, and analyze data from relational databases using SQL (DB2 and Snowflake).
  • Develop and maintain Power BI dashboards using DAX, Power Query, and M to support business reporting needs.
  • Apply business intelligence techniques to identify trends, anomalies, and actionable insights.
  • Build efficient semantic models and visualizations tailored to regulatory and operational reporting.
  • Leverage Excel for advanced data manipulation and reporting tasks.
  • Ensure data accuracy, consistency, and integrity across reporting deliverables.

 

Support regulatory reporting and business operations:

  • Collaborate with business units to understand reporting requirements and deliver timely, accurate outputs.
  • Interpret regulatory guidelines and translate them into data requirements and reporting logic.
  • Document data processes and reporting logic to ensure transparency and repeatability.
  • Contribute to the development and maintenance of documentation and training materials.

 

Communicate insights and influence decisions:

  • Create impactful PowerPoint presentations to communicate complex data findings to technical and non-technical audiences.
  • Translate analytical results into clear business implications and recommendations.
  • Present findings to stakeholders, including leadership, with clarity and confidence.

 

Foster collaboration and knowledge sharing:

  • Mentor and upskill peers in areas of expertise, including Power BI, SQL, and data modeling.
  • Promote a culture of continuous learning and cross-functional collaboration.
  • Share best practices and contribute to team standards and templates.

 

Demonstrate business acumen and adaptability:

  • Understand P&C insurance concepts and how they relate to data and reporting.
  • Adapt quickly to evolving business needs and regulatory changes.
  • Prioritize tasks effectively to meet deadlines in a fast-paced environment.

What You'll Bring

  • 3-5 years of related experience required.
  • Strong analytical capabilities, deep technical expertise in data tools and platforms, and the ability to communicate insights effectively to diverse audiences, preferred.
  • Possess a solid understanding of Property & Casualty (P&C) insurance, preferred.
  • Demonstrate proficiency in SQL (DB2 and Snowflake), Power BI, and Excel, preferred.
  • Passionate about fostering a collaborative, knowledge-sharing environment, preferred. 

Education You'll Need

  • High School Diploma or equivalent required.
  • Bachelors degree preferred.

Additional Qualifications

  • Demonstrated analytical skills.
  • Demonstrated problem solving skills.
  • Proficient in English written and verbal communication skills.
  • Possesses strong technical aptitude. Intermediate experience with: SQL (preferably using Snowflake), Power BI semantic modeling, and BI visualizations.
  • Effective interpersonal skills.
  • Ability to influence internal and/or external constituents.

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: $106,560 - $169,950
    o CO Only: $99,920 - $146,520 
    o HI/IL/MN/VT Only: $99,920 - $156,750
    o MA Only: $99,920 - $156,750 
  • o MD Only: $99,920 - $156,750
    o NY/DC/NJ Only: $99,920 - $169,950 
             o Albany County: $106,560 - $146,520 
    o WA Only:  $99,920 - $178,125 
  • 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 - MI - Caledonia, US - MI - Grand Rapids

 

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


Nearest Major Market: Grand Rapids

Apply now »