L&I Data Analyst

State of Washington•Thurston County – Tumwater, WA

7h•Remote

About The Position

This role focuses on designing, developing, and implementing reporting solutions to support L&I's strategic direction and business process improvements. The analyst will help build the foundation for tracking agency business processes and program metrics, promoting data-driven decision-making. The position primarily supports the Employer Services and Claims Administration programs within the Insurance Services division and works closely with agency executive management.

Requirements

A Bachelor's degree including college level coursework in Statistics and/or Mathematics AND Three years of experience working as a Data Consultant 3 or equivalent.
Graduate training in a related discipline may be substituted for up to two years of experience.
Equivalent education/experience.
The ability to take action to learn and grow.
The ability to take action to meet the needs of others.

Nice To Haves

Three years’ experience within the Employer Services program of Labor and Industries as an Industrial Insurance Underwriter or three years’ experience within the Claims Administration program as a Workers’ Compensation Adjudicator.
One years’ experience with Microsoft Office Suite, particularly Microsoft Excel.
Intermediate Hyperion Reporting Studio, SQL Server Management Studio (SSMS), SQL Server Reporting Services (SSRS), SAS (Statistical Analysis System), SharePoint and Excel skills.
Intermediate JavaScript skills.
Knowledge of Kimball Data Warehouse design.
Excellent written and verbal communication skills.

Responsibilities

Elicit, clarify and refine data and business reporting requirements from customers, interpreting customer needs to design data solutions and innovative approaches to solve analytic problems.
Develop models of final output, verifying the availability and validity of data required to produce the desired result.
Write code using tools such as Hyperion Studio, SAS, SSMS, SSRS, and languages including SQL and JavaScript.
Extract, analyze, manipulate, and format data from the agency’s data warehouse and integrate with other data sources.
Evaluate results to verify accuracy and usability of data to fulfill the intent of the request.
Determine appropriate methods to remove, amend, exclude data, or revise coding logic and implement as necessary.
Create and distribute highly complex statistical reports, which may include multi-paged Excel documents with datasets, charts, and graphs, Word documents, PowerPoint presentations, or web-based interactive reports (Business Intelligence Center).
Advise project teams so that accurate, intelligible data is available in easily interpreted forms to support decision making.