Senior Data Analyst - Hybrid
Worker'S Compensation Insurance Rating BureauThe WCIRB performs a number of functions to accurately measure the cost of providing workers' compensation benefits and ensure a healthy workers’ compensation system. To learn more about our company, please visit About Us | WCIRB California. The WCIRB employs approximately 175 people with the average tenure of over 10 years. We are committed to fostering a healthy, safe and diverse work environment leading to a dedicated, collaborative and innovative workforce This is a hybrid position where approximately 40% of the work time is spent at the home office in downtown San Francisco.
About the Position
We work on a variety of workers’ compensation projects, including medical cost trend analysis and classification research to support advisory pure premium rate changes (see: Regulatory and Pure Premium Rating Filings | WCIRB California). Our research also explores emerging drivers of workers’ compensation costs through medical and economic research, examining topics such as employee tenure, long COVID, and the effectiveness of experience rating in promoting workplace safety.
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.
Education, Experience, and Skill 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.
- Ability to communicate both effectively and professionally, both verbally and in writing.
- Strong listening and interpersonal skills.
- Strong proficiency in Microsoft Office suite.
Perks & Benefits
Our employees enjoy a state of the art, energy-efficient, open work environment that nurtures collaboration and creativity. At the WCIRB, we go the extra mile to keep our employees happy and healthy.
Proud to be recognized as a Plan Sponsor of the Year finalist for our commitment to retirement readiness through strong 401k and pension offerings.
Some of our perks include:
- Hybrid work environment (40% onsite 60% remote)
- Medical, dental and vision benefits
- Competitive PTO Program
- Wellness benefits
- 401K and pension plan
- Social activities
- Community volunteer involvement
WCIRB is an equal opportunity employer committed to an inclusive workplace that fosters belonging. All qualified applicants will receive consideration for employment without regards to race, color, religion, sex, sexual orientation, gender identity, national origin, disability status, protected veteran status, age, genetic information, or any other basis prohibited by law. We also consider qualified applicants with criminal histories consistent with applicable federal, state and local law.
The successful candidate will reside in California and will work from our headquarters in San Francisco at least 40% of the time. We are NOT able to pay for relocation costs for candidates or to sponsor or take over sponsorship of an employment Visa at this time. Thank you for your interest in the WCIRB!