Data Analyst

The Municipal Information Systems Association of California; La Palma (CA); On-site; USD 90,000 - 130,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 Office, the data analyst's responsibilities will include: Minimum of three years of experience with SQL, Python, and R for data manipulation and analysis. Proficiency in Power BI and Excel.

Qualifications

• Minimum of three years of experience as a data analyst or related role.
• Proficient in SQL, Python, and R for data manipulation and analysis.
• Experience with dashboards and BI tools like Power BI and Excel.

Responsibilities

• Clean, normalize, and prepare data from multiple sources.
• Develop dashboards and analytical solutions for stakeholders.
• Establish and govern KPIs and data quality standards.
• Collaborate with Risk Managers, Program Managers, and vendors.
• Collaborate with data engineers to optimize data pipelines.

Skills

SQL

Python

R

Power BI

Excel

Education

Bachelor’s degree in data 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.