Management Analyst 5 Research Data Analytics

Management Analyst 5

Full Time Permanent

Location: Tumwater WA

Salary Range: $87808 $117960 Annually

This position is represented by the Teamsters 117 Bargaining Unit.

The Washington State Department of Corrections is seeking a data guru with a knack for complex analysis a passion for high quality standards of work and experience in leadership roles to join their team as a Senior Data Analyst (Management Analyst 5! The goal of the Senior Data Analyst is to assume the lead analyst role providing departmentwide development implementation design and sustainability of health services reporting.

Working in a dynamic environment the ideal candidate will be creative in defining and solving problems flexible adaptable and able to take initiatives by providing timely access to data and information required for policies actions and decisionmaking. The Senior Data Analyst is expected to be a reliable resource for data and information sharing best practices and have a positive attitude to meet the needs and desires of our stakeholders. You will work with the Health Service Informatics Manager to analyze trends issues and outcomes as well as present findings and recommendations to executive staff and external stakeholders.

The Senior Data Analyst will assist in development maintenance and training for standard processes as it relates to responses to health services reporting needs for internal and external stakeholders as well as contribute to problemsolving efforts as identified and prioritized by agency leadership and other process improvement efforts within Health Services.

A completed application packet will include:

• A detailed resume
• A cover letter regarding your interest for this position with our agency
• Three professional references

We are looking for teammates who share our vision of public service committed to an equitable and inclusive culture that fosters and inspires excellence while promoting innovation engagement and safety leading to better outcomes for our incarcerated population our agency and our community.

As a Management Analyst 5 some of your duties will include:

• Independently design develop and prepare analyses and oversee the implementation of data reports addressing complex issues relating to business practices policies and data management which could look like:
  • Consulting with managers clinical staff internal stakeholders external stakeholders and staff to evaluate the underlying factors that influence data integrity
  • Responding to ad hoc requests by internal and external stakeholders
  • Gathering requirements for reports including identifying data source(s) and counting rules
  • Using SQL SQL Server Reporting Services Health Service SQL database and PowerBI to design develop and implement Health Services management and operational reports addressing complex issues related to business practices and policies
  • Formulating strategies to generalize and integrate complex data for analysis of trends data issues and outcomes
• Responding to mandatory Health Services related ad hoc and recurring requests from internal and external stakeholders in a responsive accurate and timely manner including:
  • Independently developing preparing analyses and recommending data and business rules that support data needs summaries and reports
  • Collaborating with legislative staff the Governors Office Communications office WA Department of Health Health Care Authority and other highprofile customers regarding the requested data
• Performing duties of a lead analyst for RDA/Health Services Informatics to include:
  • Assisting in the development maintenance and training of consistent processes around responsive requests for internal and external stakeholders
  • Providing assistance as needed to the Health Services Informatics Manager such as assigning work attending meetings preparing talking points and briefings for executive management and reviewing agency data publications
  • Work with the Health Services Informatics Manager to develop strategies to improve and advance the divisions data analytics.
• Seeking solutions to continuously improve the information produced and distributed by the RDA/Health Services Informatics team
• Performing other duties as assigned or required

What we need (required qualifications):

AND

OR

AND

OR

In addition to:

• Five 5 or more years of experience with structured query language (SQL or equivalent) and/or SAS (or equivalent software) to include the use of complex joins using multiple data sources and developing stored procedures tables and views;
• Three 3 or more years of experience with SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS);
• Two 2 or more years of experience with PowerBI and/or Tableau.
• Excellent oral and written communication skills and the ability to summarize complex information in a clear and concise manner to different audience.

What will make your application stand out (preferred qualifications):

• Experience using SQL Server Integration Services (SSIS)/ Extract Transform Load (ETL) to support maintenance of multiple databased
• SQL Server database design programming and maintenance experience 2 or more years of professional experience)
• Team Foundation Server and Visual Studio experience
• Lead worker experience
• Previous work experience in health informatic
• Working knowledge of medical terminology and national medical coding standards

Vision: Working together for safer communities.

Mission: Improving public safety by positively changing lives.

Our Commitment: To operate a safe and humane corrections system and partner with others to transform lives for a better Washington.

DOC is an equal opportunity employer and does not discriminate on the basis of race creed color national origin sex marital status sexual orientation gender identity gender expression age honorably discharged veteran veteran status genetic information or the presence of any sensory mental or physical disability or the use of a trained guide dog or service animal by a person with a disability.

IMPORTANT NOTES:

• This recruitment may be utilized to fill more than one position.
• Please include a minimum of three 3 professional references with your application. A professional reference is defined as an individual who has been paid to supervise your work and can attest to your work performance technical skills and job competencies. If you do not have any or sufficient professional references please include nonrelated professionals such as educators or other professional associates.
  **Please note: Phone number AND email address are required for all professional references.
• A background check including criminal record history will be conducted prior to a new hire. Information from the background check will not necessarily preclude employment but will be considered in determining the applicants suitability and competence to perform in the position.
• Employees may work directly with or near incarcerated individuals in a potentially hazardous setting. Please consider this when deciding whether to apply.
• We are committed to maintaining a drug and alcoholfree work environment and our employees are expected to comply with all state and federal laws. A preemployment drug test may be administered as part of the selection process and applicants who test positive for any controlled substances will be disqualified from consideration.
• Oleoresin Capsicum (OC) is an aerosol pepper spray made available as a means of selfdefense and/or deescalation. Applicants with sensitivities or allergies are encouraged to ask about the level of exposure they could expect in this position.
• Animal care projects are a common component of most Washington State prisons including dog and cat programs. Applicants with animal sensitivities or allergies are encouraged to ask about the level of exposure they could expect in this position.
• Tuberculosis (TB) is a priority health issue for DOC employees. The successful candidate may be required to provide valid proof of a baseline TB skin test within 60 days from the date of hire. When positive tests result further information testing and treatment will also be required. Employment is not contingent upon test results.
• Foreign equivalent degrees awarded outside the United States must have a credential evaluation report attached to your application. You may request the required evaluation/documentation from and. Until this documentation is provided you will not beselected to move forward in the hiring process.
• DOC complies with the employment eligibility verification requirements for the federal employment eligibility verification form I9. 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. does not use EVerify; therefore we are not eligible to extend STEMOptional Practice Training (OPT). For information please .

Telework Details

This position may be allocated for telework. Work may be performed from your home or another offsite location within the state of Washington using a reliable internet or cellular hotspot service at that time. Employees are expected to perform assigned duties in a safe manner to take proper care all stateissued equipment and maintain confidentiality of all information in possession while working offsite. Employees will be required to commute to a Department of Corrections facility or field office as business requires to potentially include components of the onboarding process. Some offices will have a drop in area available however a dedicated workspace within a DOC facility will not be provided.

What We Offer:

As an employee of the Department of Corrections your worklife integration is a priority. Washington State employees are offered one of the most inclusive and competitive benefits packages in the nation. Besides comprehensive family insurance for medical dental and vision these perks also may include:

• Remote/telework/flexible schedules (depending on position)
• Up to 25 paid vacations days a year
• 8 hours of paid sick leave per month
• 12 paid holidays a year
• Generous retirement plan
• Flex Spending Accounts
• Dependent Care Assistance
• Deferred Compensation and so much more!

PERS: State Employees are members of the Washington Public Employees Retirement System (PERS). New employees have the option of two employer contributed retirement programs. For additional information check out theDepartment of Retirement Systems web site.

For questions about this recruitment or to request reasonable accommodation in the application process please email or call us at. For TTY service please call the Washington Relay Service at 711 or.