Management Analyst 5 -PO45 - HQ

State of Washington•Thurston County – Tumwater, WA

2d•Onsite

About The Position

The Department of Corrections (DOC) is seeking a highly motivated and qualified individual to fill an internal project position as Management Analyst 5. This role is specifically for internal DOC Headquarter employees. The Health Services Division is responsible for health care administration, managing a complex health care delivery system that includes oversight of medical, dental, and mental health facilities, as well as managing intermittent and contract employees. This position reports to the Health Services Administrator and acts as a lead analyst for Population Health reporting, focusing on Gender Affirming and Addiction Medicine programs, which are under legally binding settlement agreements with significant financial consequences for non-compliance. The role also involves managing Provider One claims reporting, monthly Drug Allocation and Provider One Accruals, leading death data analysis, serving as the lead analyst for the Health Services Data Governance Committee, overseeing health services purchasing of equipment, and supporting other Health Services Management Analysts.

Requirements

At least five (5) years of experience in managing complex datasets and responding to research and/or policy-related inquiries.
College/university level education from an accredited institution whose accreditation is recognized by the U.S. Department of Education or the Council for Higher Education Accreditation may substitute year for year.
Demonstrates advanced degree of skill with SAS (or equivalent software) and/or structured query language (SQL or equivalent), to include the use of complex joins, using multiple data sources, and developing stored procedures, tables and views.
At least two (2) years of experience in High-Cost Medical Equipment Purchasing.
Demonstrates intermediate degree of skill with SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS).
Demonstrates intermediate degree of skill with Power BI and/or Tableau.
Ability to explain complex or technical information using plain language, ask clarifying questions, and clearly and concisely emphasize key points.
Advanced proficiency in Microsoft Excel with at least three (5) years of experience to include: complex formulas, PivotTables, charts/graphs, linking workbooks, exporting and importing data, analyzing data, and troubleshooting formula errors.
Intermediate proficiency in all other Microsoft Office Suite platforms: Word, PowerPoint, and Access.
Must be able to work in spaces, climb stairs, walk long distances, and frequently lift up to 30 pounds.
Under rare circumstances this position may be required to lift or carry up to 50 pounds and push up to 100 pounds.
Candidates who are offered a job with the Department of Corrections must possess work authorization that does not require sponsorship by the employer for a visa now or in the future.
Requires respirator medical evaluation questionnaire, fit testing, training, and use of respiratory protection as required by the WA Industrial Safety & Act standards.

Nice To Haves

Bachelor's degree in public administration, health care, sociology, criminal justice, social work, social sciences, analytics, or a relevant field from an accredited institution whose accreditation is recognized by the U.S. Department of Education or the Council for Higher Education Accreditation.
Demonstrates beginner degree of skill with SQL Server Integration Services.
Previously worked with Population Health data.
Previously worked in health care informatics.
Previous experience supervising staff.
Able to lead a diverse group of employees towards a common goal.
Comfortable interacting with staff members at all levels of the agency.
High level of workload management including organization and prioritization of tasks.
Oral and written communication skills: Able to explain complex or technical information using plain talk principles.
Actively listens to others, paraphrases and asks clarifying questions and is able to clearly and concisely emphasize key messages.
Strong analytical skills: Demonstrates ability to identify opportunities for improving and streamlining work processes beyond specific assignment, focuses on outcomes, takes calculated risks.
Able to embrace challenges in new and creative ways.
Comprehends and can explain the purpose(s) of a particular project and how it relates to the agency's goals and priorities.
Able to convey how business rules relate to counting rules.
Builds and maintains internal and external customer satisfaction with the services offered by the Health Services Business Unit.
Anticipates customers' needs and understands customers' organization to be able to work through solutions readily.
Knowledge of corrections or criminal justice practices and research.
Working knowledge of medical terminology and national medical coding standards.

Responsibilities

Perform duties as a Lead Health Services Data and Analytics Analyst.
Assist in the development, maintenance, and training of consistent processes for responsive requests for internal and external stakeholders for Population Health reporting and equipment needs.
Contribute to problem-solving efforts and process improvement initiatives within Health Services.
Consult with managers, clinical staff, internal and external stakeholders to evaluate factors influencing reports, dashboards, measures, and data integrity.
Independently design, develop, prepare analysis, and oversee the implementation of data reports addressing complex issues related to business practices, policies, and data management for key programs within Health Services.
Work with the Health Services Leadership team to formulate strategies for data integration and analysis of trends, issues, and outcomes, and present findings to executive staff.
Respond to ad hoc requests from internal and external stakeholders.
Participate in and/or lead problem-solving and process improvement workgroups for Population Health reporting.
Coordinate and communicate on high-cost medical equipment purchases with internal and external stakeholders.
Consult with DOC staff and external customers regarding Population Health and other data needs.
Using SQL, SQL Server Reporting Services, Health Service SQL database, and Power BI, design, develop, and implement Population Health data management and operational reports.
Formulate strategies to generalize and integrate complex data for analysis of trends, data issues, and outcomes.
Provide complex analysis, planning, solutions, and advice for internal and external customers.
Work with external consultants and internal staff to determine data collection needs and ensure efficient resource deployment.
Identify and implement data processing improvements, including efficient coding, documentation, data integrity, and process streamlining.
Gather requirements of reports by identifying data source(s) and counting rules.
Provide data for data sharing agreements with CLS, DRW, DOH, and other external stakeholders.
Maintain and update code as required by policy or practice changes.
Complete statistical analysis.
Respond to mandatory Health Services Division related ad hoc and recurring requests in a responsive, accurate, and timely manner.
Independently develop, prepare analyses, and recommend data and business rules that support data needs, summaries, and reports.
Isolate High-Need Populations by querying and analyzing complex health datasets.
Identify Gaps in Care by proactively identifying systemic or facility-specific issues.
Engage in consultations with HQ and facility leadership to address data errors, operational bottlenecks, and care deficiencies, and partner to implement corrective actions.
Ensure patient care aligns with national, state, and Department of Corrections (DOC) healthcare standards.
Assist with or develop connections between different data sources for taskforces/committees/workgroups to enable visualization of data.
Assign ad hoc requests.
Train and mentor staff on SAS/SQL (or equivalent) programming.
Consult and mentor staff on approaches to data analysis and presentation.
Provide recommendations on how to respond to and prevent data discrepancies within the Agency.
Validate and conduct quality assurance checks on work products, internal processes, and publications.
Establish and maintain consistent processes for responding to data requests.
Attend meetings, present findings/recommendations, and facilitate interaction between diverse groups on behalf of the Health Services Informatics Manager.
Create and maintain report documentation for HS Data Governance Committee, presentations, dashboards, and data extraction from outside agencies.
Seek solutions to continuously improve the information produced and distributed by the Health Services Division.
Determine appropriate product and dissemination methods based on customer needs.
Conduct ongoing assessments of data quality and provide methods to improve data integrity.
Perform other duties as assigned or required, including participation in interagency work groups, special projects, and back-up support.
Work with other divisions within the agency to provide data upon request.
Work with Emergency Operation Command to provide data upon request.
Work with Communications to provide data upon request.
Review and audit pre-existing datasets across various systems to ensure accuracy and integrity.
Directly utilize SQL Servers for complex data extraction and Power BI to build dashboards.
Oversee and analyze diverse operational data streams, including Pharmacy Data, Billing and Claims, and Health Status Reports (HSRs).
Serve as a key operational and analytical collaborator on the MOUD expansion project.
Collaborate directly with Deputy Chief Medical Officer and facility Medical Directors to align data insights with clinical realities.
Bridge the gap between data-driven operational mandates and clinical needs voiced by Program Directors.
Oversee the data tracking and logistical modeling for medical equipment needs across all state facilities.
Evaluate the financial impact of equipment procurement, pharmacy utilization, and billing claims.
Provide expert-level advice to executive management, Clinical Program Directors, facility superintendents, and healthcare managers.
Lead multi-disciplinary teams to implement process improvement strategies.
Produce and present complex, high-level reports and findings to diverse stakeholders.