Data Analyst: Insightful Metrics & AI-Ready Dashboards

California Joint Powers Insurance Authority (CJPIA); La Palma (CA); On-site; USD 85,000 - 125,000; Full time

Job summary

The California Joint Powers Insurance Authority is seeking a skilled Data Analyst to join our dynamic team. The Data Analyst will interpret and analyze complex datasets to provide insights and support data-driven decision-making.

Under the direction of the Chief Operations Officer, the analyst will gather, clean, and standardize data from multiple sources, develop semantic models, dashboards, and governance standards.

Qualifications

• Minimum of three years of experience as a data analyst or related profession.
• Experience with data manipulation and analysis using SQL, Python, and R.
• Proficiency in data visualization with Power BI and Excel.

Responsibilities

• Complete gathering, normalization, and cleaning of data from multiple sources to ensure quality.
• Interpret results using statistical techniques and data aggregation for insights.
• Develop and maintain datasets, semantic models, dashboards, and analytic solutions for operational/strategic decisions.
• Standardize data into governed Lakehouse and semantic-model assets across members, claims/loss, underwriting, payroll, CRM, and operations.
• Identify trends, risks, opportunities, and actionable insights using BI and statistical methods.
• Establish and govern KPIs, metrics, data definitions, metadata, and data quality standards.
• Collaborate with business and technology teams to optimize data architecture, data lake initiatives, and enterprise reporting.
• Enable AI readiness through data governance, cataloging, lineage, security, and information management practices.
• Develop dashboards, reports, and visualizations to communicate findings effectively.
• Collaborate with risk managers, program managers, and vendors to align data initiatives.
• Manage data collection, integration, normalization, governance, and quality across CJPIA systems.

Skills

Data analytics

Data visualization

Education

Bachelor’s degree in data science, statistics, mathematics, information science, or related field

Tools

SQL

Python

R

Power BI

Excel

Job description

The California Joint Powers Insurance Authority is seeking a skilled Data Analyst to join our dynamic team. The Data Analyst will interpret and analyze complex datasets to provide insights and support data-driven decision-making.

Under the direction of the Chief Operations Officer, the analyst will gather, clean, and standardize data from multiple sources, develop semantic models, dashboards, and governance standards.