Data Analyst / Power BI Specialist

The Western Mutual Insurance Group has been providing excellent customer service to homeowners throughout the Southwestern United States for over 80 years. We are rated A (Excellent) by A.M. Best Company and have been named among the Top 50 Property Casualty Insurers in the country by Ward’s.

Our constant endeavor in employee relations is to maintain a well-trained, enthusiastic, and efficient group of employees who work together to make our business successful, thus enhancing the career goals of every employee.

We are seeking a motivated Data Analyst / Power BI Specialist to work onsite and who will work closely with management and departments to turn data into meaningful insights. You will build reports and dashboards using Power BI, support data collection / cleaning activities, and help drive data-informed decisions across the business.

Key Responsibilities

• Develop, maintain and enhance interactive dashboards and visualizations in Power BI to support key business functions : underwriting performance, claims and marketing trends, loss ratios, expense analysis, policy-holder reporting.
• Extract, transform, and load (ETL) data from multiple internal sources (policy system, claims system, marketing, ERP / finance) into analytical datasets.
• Write and optimize SQL queries (or equivalent) to support reporting and analytics.
• Ensure data quality, consistency and integrity : identify anomalies, collaborate with data / IT teams to remediate.
• Work with business stakeholders to understand reporting needs, translate them into technical requirements and deliver actionable insights that empower data driven decisions.
• Create / adapt KPI frameworks and metrics (e.g., combined ratio, claim frequency / severity, retention / renewal rates).
• Present findings in a clear and compelling way to non-technical audiences; support decision-making across departments.
• Ad hoc analyses : trend analysis, segmentation, benchmarking, scenario modelling.
• Document data definitions, metadata, and maintain documentation including user training materials on dashboards and analytics tools.

Required Qualifications

Preferred Qualifications

We offer a competitive salary and a full benefits package including, 401k Plan, Profit Sharing Plan and Bonus Plan.

Please see our Privacy Notice For Job Applicants here : careers / privacynoticeforjobapplicants