Senior Data Analyst - Hybrid

Worker's Compensation Insurance Rating Bureau

Oakland, CA

$111,000 to $130,000 Yearly
Full-Time

Job Description

The Workers' Compensation Insurance Rating Bureau of California (WCIRB) is California's trusted, objective provider of actuarially-based information and research, advisory pure premium rates, and educational services integral to a healthy workers' compensation system. The WCIRB is a California unincorporated, private, nonprofit association comprised of all companies licensed to transact workers' compensation insurance in California, and has over 400 member companies. No state money is used to fund its operations. The operations of the WCIRB are funded primarily by membership fees and assessments.

To accurately measure the cost of providing workers' compensation benefits, the WCIRB performs a number of functions, including collection of premium and loss data on every workers' compensation insurance policy, examination of policy documents, inspections of insured businesses, and test audits of insurer payroll audits and claims classification.

The WCIRB employs approximately 175 people. The home office is located in Oakland, California.

The Senior Data Analyst will work on various WCIRB datasets, such as medical and indemnity transaction data, Policy and Unit Statistical Report data, Hoovers data and inspection report data. The Analyst is also expected to explore and utilize external datasets to enhance analysis.

Essential Duties and Responsibilities

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.

Qualifications

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.

Physical Demands

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Job requires approximately 90% sitting, 10% standing/walking.
Significant time spent at keyboard and monitor.
Some telephone and copy machine use.

Work Environment

The work environment characteristics described in this section are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.