The Actuarial Research Analyst is responsible for (1) preparing complex data sets, including extraction from internal systems and acquisition from external sources and merging data; (2) auditing data for analysis, including both basic accuracy and reasonableness; (3) providing statistical programming expertise in SQL, R or Python to access, analyze and report data descriptives and analysis results and (4) performing various actuarial and research analyses under moderate supervision.
The Analyst will work on various WCIRB datasets, such as medical and indemnity transaction data, Policy and Unit Statistical Report data, Hoovers data, aggregate financial data and inspection report and test audit data. The Analyst is also expected to utilize external datasets to enhance analysis.
The Actuarial Research Analyst works independently or collaboratively with other members of the Actuarial Research team or other WCIRB research teams and under general supervision where work is checked for conformity to broad specifications.
The Actuarial Research Analyst reports to the Vice President, Actuarial Research.
Essential Duties and Responsibilities
Prepares complex data sets for research projects. Acquires data from internal and external sources for analysis in spreadsheets or statistical software. Audits data for accuracy and reasonableness.
Conducts preliminary analysis of data, analysis of variance, and regression diagnostics with minimal or no supervision.
Performs complex analyses, such as multivariate or logistic regressions, that may involve special treatments (for example, transformation of variables or principal components extraction) for problems such as heteroscedasticity or multicollinearity.
Competently operates statistical, mathematical, actuarial or other specialized software for more complex analyses under guidance of the Vice President, Actuarial Research.
Performs more complex research, statistical and other analyses under guidance of Vice President, Actuarial Research.
Providing technical and peer review of other analysts work
Independently learns to operate new software to conduct assigned analyses.
Develop and maintain automation of regular analysis datasets, such as the LTLDS, the wage cube, Hoovers, and economic datasets.
Interact and communicate with representatives of other units of the WCIRB on various analytics-related and operational projects and issues.
Education, Experience, and Skill Qualifications
Bachelor of Science degree, preferably in mathematics, statistics, actuarial science, data science or a related field.
Minimum of two years’ demonstrated proficiency as an Associate Actuarial Research Analyst or equivalent actuarial position or coursework.
A minimum of two years of SQL, R or Python programming experience in a Data Analyst or equivalent role, or through coursework.
Completion of at least two Casualty Actuarial Society examinations.
Proficiency in at least two of the following three areas: applied statistics, economics and finance (beyond a college sophomore level), or programming (in a language such as R, Python or C++). Proficiency may be demonstrated by passage of the appropriate Casualty Actuarial Society examinations, college credit or satisfactory demonstration to the Vice President, Actuarial Research.
Strong proficiency in MS Excel, R, and SQL preferred. Ability to learn statistical packages demonstrated through proficiency in another package such as Stata, Python, or SPSS may qualify.
Ability to clearly communicate findings, issues, and recommendations to co-workers. Must be able to communicate both verbally and in writing in a professional manner.
Ability to work collaboratively on projects.
Experience in working with relational databases, large data sets and multiple data sources
Ability to work independently or with minimal supervision.
To perform this job successfully, the individual must be able to execute the tasks discussed in this job description. The requirements listed below are representative of the knowledge, skills and/or ability required. Reasonable accommodations, as required by ADA, may be made to enable individuals with disabilities to perform the essential functions.
The physical demands described in this section are to be representative of those that must be met by an employee to perform successfully the essential functions of this job. Reasonable accommodations, as required by ADA, may be made to enable individuals with disabilities to perform the essential functions.
Job requires both sitting at a workstation (90%) and moving about the office (10%).
Majority of time spent at a PC using keyboard and/or mouse.
The work environment characteristics described here 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.
Requires a cooperative and collaborative inclination.
Work requires attention to detail, follow-through and analysis of collected information.
Extended hours may be required during major project deadlines.
Management may assign or reassign duties and responsibilities to this position at any time. As such, the job description may be revised depending on the WCIRB’s needs. Further, this job description is a general summary of responsibilities and requirements and is not intended to be all-inclusive of the responsibilities and requirements of this position.
About WCIRB - Workers' Compensation Insurance Rating Bureau of California
The 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.
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 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.
The WCIRB employs approximately 200 people, and the office is located in Oakland, California.