Management Analyst 5 PO45 HQ

Description

Management Analyst 5

(Agency Project- DOC Internal Applicants Only)

Tumwater WA

Monthly Salary Range: $8253 to $11100

The Department of Corrections is seeking a highly motivated and qualified individual to fill an internal project position as Management Analyst 5. Internal DOC Headquarter only.

The Washington State Department of Corrections (DOC) mission is to improve public safety by positively changing lives with a vision of working together for safer communities. Our commitment is to operate a safe and humane corrections system and partner with others to transform lives for a better Washington.

The Health Services Division provides health care administration with a comprehensive complex health care delivery system. This includes oversight and complete responsibility in each institution for the medical dental and mental health facility intermittent and contract employees consisting of high-level clinical professionals and clinical support staff and providing consultant and advisory services to the Department of Corrections on health care matters. The division ensures patients receive their constitutional mandated right to health care while incarcerated and plans for the patients return to the community as seamlessly as possible. Those patients who will not return to the community will be provided a constitutional level of health care throughout their lives.

This Management Analyst 5 (Health Services Lead Analyst) reports to the Health Services Administrator who oversees the Gender Affirming and MOUD programs. and acts as a lead analyst in providing statewide development implementation design and sustainability of Population Health reporting specifically for the Gender Affirming and Addiction Medicine programs which are both currently under legally binding settlement agreements with high financial consequence should data and therefore compliance requirements not be met. Both Settlement Agreements span over multiple years requiring expansion of services that are currently being provided to encompass the entire incarcerated population. Additionally this position will also be responsible for development and management of Provider One claims reporting monthly Drug Allocation and Provider One Accruals leads death data analysis acts as lead analyst for Health Services Data Governance Committee oversight of health services purchasing of equipment and supports Health Services Management Analyst 4s in everyday tasks ad hoc requests and training.

Duties

Perform duties as a Lead Health Services Data and Analytics Analyst. Assists in development maintenance and training of consistent processes around responsive requests for internal and external stakeholders for Population Health reporting and equipment needs. Contribute to problem solving efforts as identified and prioritized by agency leadership and other process improvement efforts within Health Services.

Consult with managers clinical staff internal stakeholders external stakeholders and staff to evaluate the underlying factors that influence reports dashboards measures and further data integrity.

Independently designs develops prepares analysis and oversee the implementation of data reports addressing complex and sometimes unprecedented issues relating to business practices policies and data management for the Gender Affirming Addiction Medicine Pharmacy and other high-priority programs within Health Services Division.

Work with the Health Services Leadership team to formulate strategies to generate and integrate complex data into analysis of trends issues and outcomes as well as present findings and recommendations to executive staff and external consultants.

Respond to ad hoc requests to 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 to include front line staff Health Services administrators Health Services managers and vendors

Consult with DOC staff members and external customers regarding Population Health and other data needs/requirements

Using SQL SQL Server Reporting Services Health Service SQL database and Power BI design develop and implement Population Health data management and operational reports addressing complex issues related to business practices policies and data management

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 (i.e. federal and state agencies the Attorney Generals Office and higher education partners) and internal staff to determine what data needs to be collected when where how by whom to ensure the most efficient and effective deployment of resources and to achieve the desired results of the Department

Identify and implement data processing improvements including but not limited to efficient coding ensuring appropriate documentation data integrity and streamlining processes

May require understanding of SAS to implement conversion of reports from SAS to SQL

Gather requirements of reports by identifying data source(s) and counting rules

Provides data for data sharing agreements with CLS DRW DOH and other external stakeholders as needed

Maintain code: update as required and when policy or practices dictate

Completes statistical analysis

Respond to mandatory Health Services Division related ad hoc and recurring requests from internal and external stakeholders in a responsive accurate and timely manner. Independently develop prepare analyses and recommend data and business rules that support data needs summaries and reports. Requests include those from legislative staff the Governors Office Communication office WA Department of Health Health Care Authority and other high-profile customers.

Mandatory reports include: Quarterly Gender Affirming Care Report to DRW Biannual MOUD report to CLS Monthly Provider One Accrual Monthly Provider One Reconciliation Monthly Drug Allocation Yearly RAB CAFR report Yearly Equipment Requests/Ready Lists Washington Center for Bleeding Disorders reporting.

Responsibilities include:

• Isolate High-Need Populations: Query and analyze complex health datasets to isolate specific vulnerable or high-need patient populations within each facility across the State.
• Identify Gaps in Care: Proactively identify systemic or facility-specific issues where patients are missing necessary medical interventions.
• Facility Correction & Collaboration with Leadership: Engage in difficult but necessary consultations with HQ and facility leadership to address data errors operational bottlenecks and care deficiencies. Partner with them to implement corrective actions.
• Standards Alignment: Ensure that patient care aligns with national state and Department of Corrections (DOC) healthcare standards directly driving the improvement of overall facility metrics.
• Assist with or develop connections between different data sources to help with numerous taskforce/committees/workgroups to better ascertain comprehensive data (GA MOUD SRU Polypharmacy MIR QRR etc.) to enable visualization of the data as a whole. This is integral to high level decision making and ensures appropriate fiscally responsible resource deployment.

Specific Tasks include but are not limited to:

1. Identify requirements of the request
2. Identify appropriate data source(s)
3. Identify appropriate platform for presentation (i.e. Excel SQL Server Reporting Services Power BI etc.)
4. Plan approach for writing the appropriate code
5. Write code to fulfill requirements
6. Test code to ensure accuracy
7. Document code
8. Prepare request
9. Share completed request
10. Track work progress and completed product
11. Maintain code; updating as required or as changes in policy or practice dictate

Perform duties of a lead analyst for the Health Services Division. Assist in the development maintenance and training of consistent processes around responsive requests for internal and external stakeholders.

Provide assistance as needed to the Deputy Assistant Secretary Health Services Administrator and other Health Services Leaders such as assigning work to MA4 attending meetings preparing talking points and briefings for executive management and reviewing agency data publications. Work with the Health Services Leaders to develop strategies to improve and advance the divisions data analytics.

Supports the Health Services Administrator with Project Management for the MOUD and GA data analytics and reporting.

• Data Validation: Review and audit pre-existing datasets across various systems to ensure absolute accuracy and integrity before findings are utilized for operational decisions.
• Technical Execution: Directly utilize SQL Servers for complex data extraction and Power BI to build intuitive actionable dashboards for facility and executive monitoring.
• Cross-Functional Tracking: Oversee and analyze diverse operational data streams including:

1. Pharmacy Data: Statewide MOUD utilization Tracking medication compliance high-cost formulations and prescribing trends.
2. Billing and Claims: Analyzing operational costs utilization reviews and outside medical spending.
3. Health Status Reports (HSRs): Monitoring macro-level health trends across the state.

• Special Project Collaboration & Clinical Partnership
• MOUD Project Collaboration: Serve as a key operational and analytical collaborator on the MOUD expansion project providing the data validation population tracking and metrics necessary to support the projects rollout and success.
• Clinical Leadership Partnership: Collaborate directly with Deputy Chief Medical Officer and each facilitys Medical Director to align data insights with clinical realities helping them identify targeted patient populations and improve program delivery.
• Interdisciplinary Liaison: Bridge the gap between data-driven operational mandates and the clinical needs voiced by Program Directors to ensure smooth project implementation.
• Medical Equipment & Resource Capacity Analysis
• Asset Management Analysis: Oversee the data tracking and logistical modeling for medical equipment needs across all state facilities ensuring clinics are properly equipped to meet their specific populations acuity level.
• Budget & Dollar Impact: Evaluate the financial impact of equipment procurement pharmacy utilization and billing claims providing recommendations that safeguard high-dollar agency budgets and revenue.
• Stakeholder Consultation Process Improvement & Leadership
• Expert Consultation: Provide expert-level advice to executive management Clinical Program Directors facility superintendents and healthcare managers regarding highly complex unprecedented operational issues.
• Process Improvement: Lead multi-disciplinary teams to implement process improvement strategies working alongside IT and facility staff to determine future system requirements policies and staffing models.
• Executive Reporting: Produce and present complex high-level reports and findings to diverse stakeholders including department heads boards commissions and elected officials.

Specific Tasks include but are not limited to:

1. Assign ad hoc requests
2. Train and mentor staff on SAS/SQL (or equivalent) programming
3. Consult and mentor staff on approaches to data analysis and presentation
4. Provide recommendations on how to respond to and prevent data discrepancies within the Agency
5. Validate and conduct quality assurance checks on work products internal processes and publications
6. Establish and maintain consistent processes for responding to data requests
7. Attend meetings present findings/recommendations and facilitate interaction between diverse groups on behalf of the Health Services Informatics Manager
8. Create and maintain report documentation for HS Data Governance Committee presentations dashboards data extraction from outside agencies.

Seek solutions to continuously improve the information produced and distributed by the Health Services Division

• Identify and implement data processing improvements including but not limited to efficient coding ensuring appropriate documentation and streamlining processes
• Establish implement and adhere to branding formatting and data presentation and verification guidelines
• 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.

• May include such things as participation in interagency and cross state agency work groups special projects and back-up support of other positions. Working with other divisions within the agency to provide data upon request working with Emergency Operation Command to provide data upon request working with Communications to provide data upon request.

Qualifications

Required qualifications:

• 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.

Preferred/Desired Qualifications:

• Bachelors 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
• Leadership attributes:
  • 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 agencys goals and priorities
  • Able to convey how business rules relate to counting rules
• Customer focus:
  • 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
• Department of Corrections:
  • Knowledge of corrections or criminal justice practices and research
• Health Care:
  • Working knowledge of medical terminology and national medical coding standards

Supplemental Information

Mission : The mission of DOC is to improve public safety by positively changing lives.

Our Vision : Working together for safer communities.

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

Our Core Values :

• Cultivate an environment of integrity and trust: Corrections values partnership and trust. We foster openness and support courageous conversations. We are committed to doing what we say we are going to do by being accountable and taking personal ownership in our actions.
• Respectful and inclusive interactions: Corrections appreciates and values individuals by promoting an inclusive and diverse environment which encourages safety. We respect value and listen to the thoughts feelings and perspectives of our stakeholders and consider the impact on those we serve as well as each other.
• Peoples safety: Corrections believes in creating an environment that values physical mental and emotional security and well-being. We honor those who advance safety for all.
• Positivity in words and actions: At Corrections we assume positive intentions and believe there is a shared desire for the best outcome. We consistently demonstrate positive behavior and always put forth our best effort.
• Supporting peoples success: Corrections is committed to our community understanding individuals instilling hope embracing change and providing opportunities.

IMPORTANT NOTES:

• DOC complies with the employment eligibility verification requirements for 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. does not use E-Verify; therefore we are not eligible to extend STEM-Optional Practice Training (OPT). For information please visit .

• 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 non-related 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 alcohol-free work environment and our employees are expected to comply with all state and federal laws. A pre-employment 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 self-defense and/or de-escalation. 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.
• This position may be represented by a bargaining unit.

• Requires respirator medical evaluation questionnaire fit testing training and use of respiratory protection as required by the WA Industrial Safety & Act standards. Refer to WAC 296-842 to learn more.
• 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.
• 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 be selected to move forward in the hiring process.
• 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.
• Salary is based on experience and is determined at the time a final offer of employment is made.

We are committed to hiring individuals who possess core diversity competencies:

Foster a positive attitude and openness toward the ever changing social and cultural makeup of the workplace.

• Work effectively with people of different perspectives abilities disabilities races religions ages lifestyle preferences and social ethnic and cultural backgrounds.
• Respectfully acknowledge peoples differences and recognize these differences as important and valuable.
• Promote inclusiveness.
• Be culturally sensitive and appropriate.
• Respect and value diverse backgrounds and traditions.

What We Offer:

As an employee of the Department of Corrections your work-life 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:

• Up to 25 paid vacations days a year
• Remote/telework/flexible schedules (depending on position)
• 3 days of bereavement Leave
• 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!

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 the Department of Retirement Systems web site.

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.

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 7-1-1 or 1-.

Required Experience:

IC