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

VDdTQWF0QXpDTENlbFE3Wk5zd2xaUTgvamc9PQ==
  • 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 1 week of 2026

Job Tags

Full time, Work experience placement,

Similar Jobs

jobgether

Remote Web Designer Job at jobgether

 ...behalf of a partner company. We are currently looking for a UI/UX Designer - REMOTE. This role is pivotal in defining the visual identity...  ..., preferably in startup environments. ~ Background delivering web-based SaaS projects (preferably related to media). ~ Strong proficiency... 

Butler County- Sheriff's Office

Dispatcher/Jailer Job at Butler County- Sheriff's Office

 ...department. A jailer isa law enforcement professional responsible for the custody, supervision, and security of inmates in jails, prisons, and other correctional facilities.Their duties include enforcing facility rules, maintaining order, preventing disturbances, and... 

Anko Products, Inc.

Assembly Operator Job at Anko Products, Inc.

 ...Local Manufacturing Company is search of reliable assembly/machine operators for full time, long term employment. 4 day work week Mon - Thurs 1st shift 6:30am - 5:00pm Company offers: Medical, dental, vision plans; 401K, paid holidays, vacation pay, attendance bonus... 

Compass Group

Admin. Asst. - CACTI Park Job at Compass Group

 ...frequency varies. Message and data rates may apply. Text STOP to opt out or HELP for help. Terms and conditions: Diversityof...  ...relationships with co-workers, school personnel, administrators, student's parents and Supervisor. Complete and maintain accurate and... 

Oorah

Web Designer Job at Oorah

 ...Web Designer Kars4Kids is looking for. Your passion for performance optimization and responsive, mobile-first design smarts. If you are a skilled Web Designer with excellent collaboration skills and an eye for design, come join our high-level online marketing...