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

b1lRdmdrU2gvOUpKUDVUOUVRRnNHd3dtRVE9PQ==
  • 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 48 week of 2025

Job Tags

Full time, Work experience placement,

Similar Jobs

Staffmax Staffing & Recruiting

Warehouse Associate / Forklift Operator Job at Staffmax Staffing & Recruiting

 ...area Other duties as required Job Requirements: You must have previous experience in a shipping/receiving environment Forklift experience/ certification is an asset Pallet Jack experience is an asset No software use will be necessary- you will be assisting... 

A High-end Kindergarten

Montessori Kindergarten Teachers Needed in Chongqing City Job at A High-end Kindergarten

Montessori Kindergarten Teachers Needed in Chongqing CityWe are in new area of Chongqing city (the largest city in West China), a high-end international kindergarten, will open a Montessori class recently, and begin to operate in September 2013, now were looking for 1-... 

JLL

Experience Services Ambassador Job at JLL

Experience Services Ambassador Location Chicago, IL : JLL supports the Whole You, personally and professionally. Our people at JLL are shaping the future of real estate for a better world by combining world class services, advisory and technology to our clients. We are... 

tenavistaffing

LPN Job at tenavistaffing

 ...LPN Our Client is seeking a Licensed Professional Nurse (LPN) to provide telehealth services. This fully remote position works coordinates with clinical staff to provide patient education, monitor patient conditions, and ensure condition changes are reported to the... 

Hire Velocity

OTR CDL A Heavy Haul Truck Driver Job at Hire Velocity

 ...MRI USA is seeking experienced CDL A Heavy Haul Truck Drivers to join our elite team of professionals. If you're a reliable, skilled driver with oversized load experience, we offer you steady work, guaranteed weekly pay-even if you're not moving-and some of the best...