Data Analyst

Sacbar; La Palma, Northern (CA, KY); Hybrid; USD 85,000 - 115,000; Full time

Job summary

The California Joint Powers Insurance Authority seeks a skilled Data Analyst to interpret and analyze complex datasets to provide insights for data-driven decision making. You will gather, normalize, and clean data from multiple sources, and develop dashboards and semantic models to support operations.

With three years of relevant experience and a Bachelor’s degree in a data-related field, you will collaborate with Risk, Program, and IT teams to govern data, establish KPIs, and enable enterprise

Qualifications

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

Responsibilities

• Complete the gathering, normalization, and cleaning processes for data from various sources, ensuring data integrity and quality.
• Interpret results using a variety of techniques, ranging from simple data aggregation to more complex statistical analysis.
• Develop and maintain trusted datasets, semantic models, dashboards, and analytical solutions that support operational and strategic decision making.
• Standardize member, claims/loss, underwriting, payroll, training, CRM, and operational data into governed Lakehouse and semantic-model assets.
• Analyze data to identify trends, risks, opportunities, and actionable insights using statistical and business intelligence techniques.
• Establish and govern KPIs, business metrics, data definitions, metadata, and data quality standards.
• Collaborate with business and technology teams to optimize data architecture, data lake initiatives, and enterprise reporting capabilities.
• Enable AI and Copilot readiness through effective data governance, cataloging, lineage, security, and information management practices.
• Use statistical methods and techniques to identify patterns, trends, correlations, anomalies, and extract meaningful insights.
• Develops and maintains dashboards, reports, and visualizations to communicate data findings effectively.
• Identifies KPIs and develops metrics to track and measure business performance.
• Collaborates with data engineers and IT professionals to optimize data collection, storage, normalization, and retrieval processes.
• Work with a variety of stakeholders to include Risk Managers, Program Managers, and vendors.
• Manage the collection, integration, normalization, governance, and quality of enterprise data across CJPIA business systems.

Skills

SQL

Python

R

Data analysis

Education

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

Tools

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 Office, the data analyst's responsibilities will include:

• Complete the gathering, normalization, and cleaning processes for data from various sources, ensuring data integrity and quality.
• Interpret results using a variety of techniques, ranging from simple data aggregation to more complex statistical analysis.
• Develop and maintain trusted datasets, semantic models, dashboards, and analytical solutions that support operational and strategic decision making.
• Standardize member, claims/loss, underwriting, payroll, training, CRM, and operational data into governed Lakehouse and semantic-model assets.
• Analyze data to identify trends, risks, opportunities, and actionable insights using statistical and business intelligence techniques.
• Establish and govern KPIs, business metrics, data definitions, metadata, and data quality standards.
• Collaborate with business and technology teams to optimize data architecture, data lake initiatives, and enterprise reporting capabilities.
• Enable AI and Copilot readiness through effective data governance, cataloging, lineage, security, and information management practices.
• Use statistical methods and techniques to identify patterns, trends, correlations, anomalies, and extract meaningful insights.
• Develops and maintains dashboards, reports, and visualizations to communicate data findings effectively.
• Identifies KPIs and develops metrics to track and measure business performance.
• Collaborates with data engineers and IT professionals to optimize data collection, storage, normalization, and retrieval processes.
• Work with a variety of stakeholders to include Risk Managers, Program Managers, and vendors.
• Manage the collection, integration, normalization, governance, and quality of enterprise data across CJPIA business systems.

If you are ready to apply your skills and experience to an organization committed to excellence, we encourage you to seize this exciting opportunity with the California Joint Powers Insurance Authority

Experience

Minimum of three years of increasingly responsible experience as a data analyst, data scientist, BI analyst, or related profession. Proven project experience with programming languages such as SQL, Python, and R for data manipulation and analysis. Proven project experience with data analysis and visualization tools such as Power BI and Excel.

Education

Bachelor’s degree from an accredited college or university in data science, statistics, mathematics, information science, or a related field.