Data Analyst/Business Intelligence Developer Job at Western Mutual Insurance Group, Irvine, CA

YVd5cU9sbXVuRFoyRWVZdnRxVGJTL1VtdUE9PQ==
  • Western Mutual Insurance Group
  • Irvine, CA

Job Description

Salary: $80,000 - 100,000 per year Requirements:

  • I hold a Bachelor’s degree in Data Science, Statistics, Computer Science, Business Analytics, or a related quantitative field (or possess equivalent work experience).
  • I have 2-5 years of experience in a data analysis or business intelligence role, preferably within the insurance or financial services sectors.
  • I am proficient in Power BI, including creating dashboards, data modeling, DAX, and managing data refresh schedules.
  • I possess strong SQL skills and have experience working with relational databases.
  • I demonstrate solid analytical and problem-solving abilities and am comfortable handling large and complex datasets.
  • I have a good understanding of business functions and can partner effectively with underwriting, claims, finance, and operations stakeholders.
  • I possess excellent communication and presentation skills, allowing me to translate technical findings into actionable business insights.
  • I am detail-oriented and capable of ensuring the accuracy and reliability of data.
Responsibilities:
  • I will develop, maintain, and enhance interactive dashboards and visualizations in Power BI to support key business functions, including underwriting performance, claims and marketing trends, loss ratios, expense analysis, and policyholder reporting.
  • I will extract, transform, and load (ETL) data from various internal sources, such as policy systems, claims systems, marketing, and ERP/finance, into analytical datasets.
  • I will write and optimize SQL queries (or equivalent) to support reporting and analytical tasks.
  • I will ensure data quality, consistency, and integrity by identifying anomalies and collaborating with data and IT teams to resolve issues.
  • I will engage with business stakeholders to understand their reporting needs, translate these needs into technical requirements, and provide actionable insights that foster data-driven decision-making.
  • I will create and adapt KPI frameworks and metrics, such as combined ratio, claim frequency/severity, and retention/renewal rates.
  • I will present my findings clearly and compellingly to non-technical audiences to support decision-making activities across departments.
  • I will conduct ad hoc analyses, including trend analysis, segmentation, benchmarking, and scenario modeling.
  • I will document data definitions, metadata, and maintain documentation that includes training materials for users on dashboards and analytics tools.
Technologies:
  • Business Intelligence
  • ETL
  • ERP
  • Support
  • Marketing
  • Power BI
  • SQL
  • AWS
  • Azure
  • Cloud
  • Python

More:

At the Western Mutual Insurance Group, we have been dedicated to delivering outstanding customer service to homeowners throughout the Southwestern United States for over 80 years. We proudly carry an A (Excellent) rating from A.M. Best Company and have been recognized among the Top 50 Property Casualty Insurers in the nation by Ward’s.

Our focus on employee relations drives us to cultivate a well-trained, motivated, and efficient workforce that collaborates to elevate our business, ultimately enhancing the professional aspirations of every team member.

We are offering a full-time position with a competitive salary ranging from $80,000.00 to $100,000.00 per year and a comprehensive benefits package that includes a 401k Plan, Profit Sharing Plan, and Bonus Plan.

last updated 46 week of 2025

Job Tags

Full time, Work experience placement,

Similar Jobs

Encoded Therapeutics

Director, IT Operations & Security Job at Encoded Therapeutics

 ...addressable with current approaches. For more information, please visit . Position details Encoded is seeking a Director, IT Operations & Security that will serve to provide Information Technology support for early-stage gene therapy candidates. Reporting to the... 

Airtm

Senior Front-End Developer (React) Job at Airtm

 ...locations will not be considered). This is a fully remote role , reporting to our Tech Lead. About us:...  ...countries. Who Do We Want? Airtm is seeking a Sr Front End Developer to continue enhancing our Web application by adding amazing new features while maintaining... 

Simera

Junior Web Developer - Build Fast, Accessible Web Apps Job at Simera

 ...A leading tech company in California is looking for a skilled Web Developer. The ideal candidate will develop and deploy responsive websites, collaborate with cross-functional teams, and optimize for speed and SEO. Required qualifications include strong proficiency in... 

Rising Hope Counseling, LLC

Licensed Social Worker/Counselor Job at Rising Hope Counseling, LLC

 ...own semi-private practice! Join Rising Hope Counseling, LLC! Work in YOUR area! We are seeking to expand in Minnesota! Have you...  ...Hope Counseling, LLC is a group practice seeking a Counselor or Social Worker to provide individual and family therapy to clients in a... 

NOW Courier

NOW Courier: Delivery Driver (Routed) Job at NOW Courier

Seize the Freedom of the Open Road! Are you a dependable go-getter with a passion for customer service and the thrill of being your own boss? NOW Courier, a recognized leader in logistics, is looking for enthusiastic and professional Contract Delivery Drivers to join...