Data Analyst

Job TitleMake a difference in L&I's Data Analysis by performing the design, development, and implementation of reporting solutions that promote the agency's strategic and tactical direction and business process improvements.This opportunity is open to current L&I employees only.Job DescriptionIn this role, you'll participate in building the foundation for tracking agency business processes and program metrics and encourage the use of data for making decisions. You'll work closely with agency executive management and primarily support the Employer Services and Claims Administration programs of the Insurance Services division.DutiesSome of what you'll do: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 problemsDevelop model of final output, verifying availability and validity of data required to produce the desired resultWrite 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.QualificationsRequired: A Bachelor's degree including college level coursework in Statistics and/or Mathematics AND 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. OR Equivalent education/experience.Required Equity Competencies:The ability to take action to learn and grow.The ability to take action to meet the needs of othersDesired: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 skillsIntermediate JavaScript skillsKnowledge of Kimball Data Warehouse designExcellent written and verbal communication skillsSupplemental InformationTo help you maintain a proper work-life balance, teleworking is one of the work schedule options for this position. L&I also offers flexible custom work schedules.State employees who meet the qualifications will become eligible for a generous retirement package at the end of the employee's career. Click on the "Benefits" tab to learn more.At L&I, your voice matters. In addition, L&I is a diverse state agency dedicated to the safety and health and security of Washington's 3.3 million workers. Take a look at this brief video and learn more about why L&I is an employer of choice.For this position, telework is permitted full time. The assigned duty station for this position is Tumwater, Washington. For positions where in-office work is necessary, the frequency of telework will be discussed with the supervisor of the position at the time of offer.To receive more information on opportunities at L&I sign up for GovDelivery and select L&I job alerts.Application processWe will contact the top candidates directly to interview for this position. Because we base the selection on information provided by you, it is in your best interest to identify the knowledge, skills, and abilities that address the required and desirable qualifications described in the announcement.Please include the following documents with your application:A cover letter describing specific qualifications.A current resume detailing applicable experience and education.A list of at least three professional references with current telephone numbers.Please do not attach or place any medical information (vaccination status included) within the application, resume, or cover letter. If you do, we will have to reject your application to safeguard others from receiving your confidential information. You will have to remove the confidential information before you can apply again.To learn more about our hiring process timeline at L&I please visit our L&I recruiting page at Hiring Process at L&I. If you would like to read our website in a language other than English, scroll up to the top of the page to select your language of choice from the banner.Background Check NoticePrior to a placement in this position, a background check, including criminal history record will be conducted. Information from your background check will not necessarily preclude employment but will be considered in determining your eligibility to perform the requirements of the position.Other informationFor positions requiring travel, you must have a valid unrestricted driver's license and have insurance if driving a privately owned vehicle on state business.This position is represented by the Washington Federation of State Employees (WFSE).Candidates who are offered a job with L&I must possess work authorization that does not require sponsorship by the employer for a visa now or in the future.The Department of Labor & Industries complies with the employment eligibility verification requirements of the federal employment eligibility verification form, I-9. The selected candidate must be able to provide proof of identity and eligibility to work in the United States consistent with the requirements of that form on the first day of employment.Please note: L&I may use this announcement to fill multiple permanent and/or non-permanent positions.Did You Know?Washington is America's Top State to live, play, and work, according to U.S. News (2021). Join the L&I team and enjoy all the Evergreen State has to offer.In addition to offering a positive balance between life and work, L&I provides one of the most competitive benefits packages in the nation. We also believe your voice matters. We value our employees and their work-life balance by encouraging flexible schedules. L&I is a diverse state agency dedicated to the safety and health and security of Washington's 3 million workers.Veterans PreferenceApplicants wishing to claim Veterans Preference should attach to their application a copy of their DD-214 (Member 4 copy), NGB 22, or signed verification of service letter from the United States Department of Veterans Affairs. Please blackout any personally identifiable data such as Social Security numbers. For further information, contact L&I's View email address on click.appcast.io, Equity, and Inclusion EmployerL&I employees come from all walks of life. We strive to hire great people from a wide variety of backgrounds. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, gender identity or expression, sexual orientation, national origin, genetics, disability, age, or veteran status.We believe in the importance of recognizing the value each of us contribute to the success of the agency mission. Having a diverse workforce is this agency's greatest resource of strength and knowledge. It is through the combination of talents and abilities that we can pursue finding effective measures to provide the best customer service. We are committed to building a diverse and inclusive workplace for everyone and we strongly mean everyone.The State of Washington is an equal opportunity employer. Persons with a disability who need accommodation in the application process or testing process, or those needing this announcement in an alternative format, may call View phone number on click.appcast.io. TTY users should first call 711 to access the Washington Relay Service.You are welcome to include the name and pronoun you would like to be referred to in your materials and we will honor this as you interact with our award-winning diverse and inclusive organization.For more InformationIf you have any questions regarding this job posting, program,