L&I Data Analyst

Summary

The Washington State Department of Labor & Industries promotes workplace safety, health, and security for Washington workers. The L&I Data Analyst designs, develops, and implements reporting solutions, analyzes data from the agency warehouse and other sources, creates complex statistical reports, and advises project teams to support business improvement and decision-making.

Responsibilities

• Elicit, clarify and refine data and business reporting requirements from customers, including interpreting customer needs or situation to design data solutions and innovative and effective approaches to solve analytic problems
• Develop model of final output, verifying availability and validity of data required to produce the desired result
• Write code using tools such as Hyperion Studio, SAS (Statistical Analysis System), SSMS (SQL Server Management Studio), SSRS (SQL Server Reporting System), and languages including SQL (Structured Query Language) 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 method to remove, amend, exclude data, or revise coding logic and implement as necessary
• Create and distribute highly complex statistical reports, which may be a multi-paged Excel document, including datasets, charts and graphs, a Word document, Power Point presentation, or a web based interactive report (Business Intelligence Center)
• Advises project teams so that accurate, intelligible data is available in easily interpreted forms to support decision making

Skills

• A Bachelor's degree including college level coursework in Statistics and/or Mathematics
• Three years of year experience working as a Data Consultant 3 or equivalent. Graduate training in 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
• * 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

Qualifications

Must Haves

• A Bachelor's degree including college level coursework in Statistics and/or Mathematics
• Three years of year experience working as a Data Consultant 3 or equivalent. Graduate training in 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

Benefits

• Teleworking is one of the work schedule options for this position.
• L&I also offers flexible custom work schedules.
• For this position, telework is permitted full time.
• Medical, vision, dental and basic life insurance coverage for employees and their families.
• Medical flexible spending account.
• Long-term disability insurance, with the option to purchase additional coverage amounts.
• Washington Wellness workplace wellness programs.
• Dependent care assistance allowing employees to save pre-tax dollars for child or elder care expenses.
• Auto, boat, home, and renter insurance available through payroll deduction.
• Washington State Employee Assistance Program.
• Membership in the Washington Public Employees' Retirement System (PERS).
• Two employer-contributed retirement programs for new employees.
• Deferred Compensation Program with pre-tax salary deferral and multiple investment options.
• Coverage under the federal Social Security and Medicare systems, with the state and employee paying equal amounts.
• Eligible employees may receive student loan forgiveness under the Public Service Loan Forgiveness Program.
• Paid holidays and one paid personal holiday per calendar year for full-time and part-time employees.
• Full-time employees earn eight hours of sick leave per month.
• Vacation leave accrual for full-time employees.
• Washington State supports members of the armed forces with 21 days of paid military leave per year.
• Most employees whose family member or household member dies, or for loss of pregnancy, are entitled to five (5) days of paid bereavement leave.
• Leave sharing.
• Parental leave.
• Family and Medical Leave Act (FMLA) leave.