Principal Business Analyst - Caledonia, MI (Hybrid)
Principal Business Analyst - Caledonia, MI (Hybrid)
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
$ 99920 - 178125
1 Vacancy
Job Description
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 isnt just our business its our culture! To learn more about our high-performance culture and open opportunities check out 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 Youll 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 Youll 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 Youll 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
Benefits
- Farmers offers a competitive salary commensurate with experience qualifications and location.
o CA Only: $106560 - $169950
o CO Only: $99920 - $146520
o HI/IL/MN/VT Only:$99920 - $156750
o MA Only:$99920 - $156750 - o MD Only: $99920 - $156750
o NY/DC/NJ Only:$99920 - $169950
o Albany County:$106560 - $146520
o WA Only: $99920 - $178125 - 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 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 veterans status or any other basis protected by applicable discrimination laws.
Want to learn more about our culture & opportunitiesCheck out be sure to follow us onInstagramLinkedIn andTikTok.
Spokane WA only: Residents who prefer not to provide their address click here to submit your resume via email:
Required Experience:
Staff IC
Employment Type
Full Time
