Sr. Data Analyst - Hybrid

Are you eager to make a real difference through data and innovation?

At the WCIRB, the Sr. Data Analyst plays a vital role in supporting a healthy California workers’ compensation system through data-driven insights, innovation, and collaboration. We take pride in producing work that is consistent, accurate, and impactful. Our culture values curiosity, empowerment and safe space, where every question is encouraged and every new idea has the potential to shape the future of our projects.

We also believe that great work thrives in balance. Our hybrid work model promotes flexibility and well-being, empowering our team to do their best work while maintaining a healthy work-life balance.

We work on a variety of workers’ compensation projects, from medical cost trend analysis and classification research that support advisory pure premium rate changes (see: Regulatory and Pure Premium Rating Filings), to innovative studies uncovering emerging drivers of system costs. Our research dives into timely and relevant topics, such as employee tenure, long COVID, and the effectiveness of experience rating in workplace safety.

We also push boundaries by exploring how climate change and AI may influence the workers’ compensation landscape in the years ahead.

Assist with the design and implementation of medical and classification analytics projects through:

• Reviewing published data, information and studies on various research topics and contributing to study design.
• Independently developing well-documented and reproducible scripts in SQL, R or Python for pulling and wrangling data for the Analyst’s own work and for the use of research staff in studies or to address ad-hoc requests.
• Performing accuracy and reasonableness checks to assure quality of the working dataset is appropriate to each study.
• Communicating clearly to research staff the rules employed to prepare the working datasets for study.
• With limited directions, independently conducting exploratory analyses and statistical analyses (e.g., hypothesis testing, regression analysis, predictive modeling) to answer key research questions.
• Applying judgement and discretion in the analyses and in the production of reports and presentations.
• Exploring external data sources for specific research purposes and performing integration of diverse internal and external data sources, such as external code sets or policy data, to enhance analyses.
• Preparing well-formatted tables and figures to present analysis results in reports and presentations.
• Assuring analysis results are accurate following the Data Analytics team review protocol.
• Providing technical and peer review of other analysts’ work.
• Communicating results via written and oral presentations at internal and external meetings.
• Lead the development of automating routine analysis data and reporting tasks, including quarterly medical benchmarking reports.
• Provide training to data analysts and members of other actuarial and research teams on research protocols and team processes (if applicable).
• Participate in discussions with external agencies, working groups and research groups on medical and classification research.

• Bachelor’s Degree or above in a quantitative field such as statistics, economics, data science, computer science or other related field.
• A minimum of four years of SQL, R or Python programming experience in a Data Analyst or equivalent role, or through coursework.
• A minimum of two years of professional experience with rating organizations, data analytic companies, property/casualty insurers, health insurers, managed care companies, consulting, and/or hospital systems.
• Strong proficiency in data wrangling, building functions and producing data visualization in R or Python.
• Track record of completed analytical projects in R or Python.
• Proficiency in statistical modeling (e.g., regression analysis), text analytics, geospatial data, or predictive modelling.
• Strong proficiency in working with relational databases, large data sets and multiple data sources.
• Ability to communicate both effectively and professionally, both…