Senior Data Analyst

2 months ago

Oakland, United States Worker's Compensation Insurance Rating Bureau Full time
Job DescriptionJob DescriptionThe 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.


You will join a dynamic and high-performing team to research the cost drivers of the California workers' compensation system from medical, economic and classification perspectives. This role provides an opportunity to apply your data science and research skills, such as data wrangling, statistical modeling and econometrics, to uncover actionable insights for the industry.

Some research studies the Data Analytics team published include:

  • The impact of tenure on claim frequency
  • Dose experience rating help keep workers safe?
  • “Long COVID” in the California workers’ compensation system – 2023 update
  • The Food and Beverage Study
  • Telehealth services in California workers' compensation system


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.


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. Our perks include:

  • Hybrid work environment (40% onsite 60% remote)
  • Medical, dental and vision benefits
  • Competitive PTO Program
  • 401K and pension plan
  • Annual incentive plan
  • Social activities
  • Community volunteer involvement


Please note that the WCIRB has enacted a mandatory COVID-19 vaccine requirement for all employees. Proof of full vaccination or an approved exemption or deferral is required of all employees, including new hires.

  • Senior Data Analyst

    2 months ago

    Oakland, United States Workers' Compensation Insurance Rating Bureau of California Full time

    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...

  • Senior Financial Analyst

    1 day ago

    Oakland, California, United States University of California , Riverside Full time

    Senior Financial & Administrative Services AnalystWe invite you to become a part of our dedicated team at the University of California, Riverside, within the Student Affairs & Interdepartmental Programs Admin Unit. As a Senior Financial & Administrative Services Analyst, you will play a crucial role in our financial operations.Key Responsibilities:Deliver...

  • Senior Systems Analyst

    6 days ago

    Oakland, California, United States Abacus Service Corporation. Full time

    Job Title: Senior Business AnalystDuration: 16 Months ContractLocation: RemoteDescription:This role is designed for a Senior Business Analyst who will serve as a key business authority, acting as a bridge between the IT development team and various business units. The primary focus will be on the development, enhancement, and implementation of both new and...

  • Senior Systems Analyst

    7 days ago

    Oakland, California, United States Abacus Service Corporation. Full time

    Position Title: Senior Business AnalystContract Duration: 16 MonthsWork Arrangement: Remote with occasional onsite presenceOverview:The Senior Business Analyst serves as a pivotal link between the IT development team and various business units, ensuring effective communication and collaboration for the development, enhancement, and deployment of both new and...

  • Operations Data Analyst, Principal

    1 week ago

    OAKLAND, United States PG&E Corporation Full time

    Requisition ID # 158309 Job Category: Business Operations / Strategy Job Level: Manager/PrincipalBusiness Unit: Electric OperationsWork Type: HybridJob Location: Oakland  Position SummaryExtracts operations data for analysis, leadership support and responses to ad hoc data requests. Maintains operations tools & databases to ensure that it is kept...

  • Senior Systems Analyst

    7 days ago

    Oakland, California, United States Abacus Service Corporation. Full time

    Job Title: Senior Business Systems AnalystDuration: 16 Months ContractLocation: RemoteDescription:This role requires a hybrid work model, with occasional onsite presence as necessary.Position Overview:The Senior Business Systems Analyst serves as a critical business authority, acting as a bridge between the IT development team and various business units....

  • Senior Systems Analyst

    6 days ago

    Oakland, California, United States Abacus Service Corporation. Full time

    Job Title: Senior Business AnalystDuration: 16 Months ContractLocation: RemoteDescription:This position requires a hybrid work model, with occasional onsite presence as necessary.Position Overview:The Senior Business Analyst serves as the primary business authority, acting as a bridge between the IT development team and various business units. This role is...

  • Senior Financial Data Analyst

    2 days ago

    Oakland, California, United States Dolls Kill Full time

    About Dolls Kill:Dolls Kill is a leading global fashion brand that champions individuality and self-expression. With a robust following of over 10 million on social media, we engage with influential figures across music, art, pop culture, and fashion.Our company is supported by dedicated consumer-focused investors who align with our vision of creating one of...

  • IT Data Analyst, Consultant

    7 days ago

    Oakland, United States Blue Shield Of California Full time

    Your Role The Data Analyst team is responsible for performing detailed data analysis, source to target designs, data profiling, and metadata management in support of new development, implementation or enhancement of existing data assets. The Data Analyst, Consultant will report to the Manager of Data Solutions and Asset Management. In this role you will...

  • Actuarial Analyst, Senior

    4 weeks ago

    Oakland, United States Blue Shield of California Full time

    Your Role   The Large Group Pricing team is responsible for setting accurate rates and forecasting future performance for fully insured employer groups. The Actuarial Analyst, Senior will report to the Director or Manager of Large Group Pricing. In this role you will be responsible developing our rating factors, including continually monitoring and...

  • Senior Operations Data Analyst

    3 weeks ago

    OAKLAND, United States PG&E Corporation Full time

    Requisition ID # 159683 Job Category: Business Operations / Strategy Job Level: Individual ContributorBusiness Unit: Operations - OtherWork Type: HybridJob Location: Oakland  Department OverviewOperations Support is dedicated to creating cross-commodity consistency and standards in Operations. The team provides support services guided by best practices...

  • Actuarial Analyst, Senior

    2 months ago

    Oakland, United States Blue Shield of California Full time

    Your Role   The Large Group Pricing team is responsible for setting accurate rates and forecasting future performance for fully insured employer groups. The Actuarial Analyst, Senior will report to the Director or Manager of Large Group Pricing. In this role you will be responsible developing our rating factors, including continually monitoring and...

  • Actuarial Analyst, Senior

    2 months ago

    Oakland, United States Blue Shield of California Full time

    Your Role   The Large Group Pricing team is responsible for setting accurate rates and forecasting future performance for fully insured employer groups. The Actuarial Analyst, Senior will report to the Director or Manager of Large Group Pricing. In this role you will be responsible developing our rating factors, including continually monitoring and...

  • Actuarial Analyst, Senior

    1 month ago

    Oakland, United States Blue Shield of California Full time

    Your Role   The Large Group Pricing team is responsible for setting accurate rates and forecasting future performance for fully insured employer groups. The Actuarial Analyst, Senior will report to the Director or Manager of Large Group Pricing. In this role you will be responsible developing our rating factors, including continually monitoring and...

  • Data Engineer, Senior

    2 weeks ago

    Oakland, United States Blue Shield of California Full time

    Your Role The Data Engineering Development team is responsible for design, development, test and deployment of large enterprise data warehouse/BI data solutions using both on-prem and cloud technologies. The Data Engineer, Senior will report to the Manager, Data Engineering Development. In this role you will be responsible for design, development, and...

  • Senior Data Analyst, Cash App Compliance

    4 weeks ago

    Oakland, United States Cash App Full time

    Job DescriptionJob DescriptionCompany DescriptionIt all started with an idea at Block in 2013. Initially built to take the pain out of peer-to-peer payments, Cash App has gone from a simple product with a single purpose to a dynamic ecosystem, developing unique financial products, including Afterpay/Clearpay, to provide a better way to send, spend, invest,...

  • Senior Data Analyst, Cash App Compliance

    1 month ago

    Oakland, United States Cash App Full time

    Job DescriptionJob DescriptionCompany DescriptionIt all started with an idea at Block in 2013. Initially built to take the pain out of peer-to-peer payments, Cash App has gone from a simple product with a single purpose to a dynamic ecosystem, developing unique financial products, including Afterpay/Clearpay, to provide a better way to send, spend, invest,...

  • Senior Portfolio Management Analyst

    2 weeks ago

    Oakland, United States Pacific Gas & Electric CO Full time

    The Senior Analyst position will perform portfolio analysis associated with managing PG&Es commercial activities involving RA, energy, CRR, GHG, and LCFS procurement and support various compliance reporting obligations to the CPUC, CEC, CARB, and CA Portfolio, Management, Software Engineer, Senior Analyst, Analyst, Energy, Technology

  • Expert Operations Data Analyst

    4 weeks ago

    Oakland, United States Pacific Gas and Electric Company Full time

    Position SummaryThe Operations Data Analyst extracts operations data for analysis, leadership support and responses to ad hoc data requests. The incumbent maintains operations tools & databases ensuring that it is kept up-to-date using data from various PG&E systems. They develop, maintain, and enhances operational metric database tools for the broader...

  • Strategic Data Analyst

    6 days ago

    Oakland, California, United States Axelon Services Corporation Full time

    Axelon Services Corporation is seeking a highly motivated and analytical Decision Support Analyst to join our growing team. In this role, you will play a vital part in providing critical insights and data-driven recommendations to key stakeholders and hospital leadership. As a Decision Support Analyst, you will be responsible for analyzing operational...