Management Analyst 5 -PO45 - HQ

Description --------------- Management Analyst 5 (Agency Project\- DOC Internal Applicants Only) Tumwater, WA Monthly Salary Range: $8,253 to $11,100 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 General’s 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 Governor's 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: Identify requirements of the request Identify appropriate data source(s) Identify appropriate platform for presentation (i.e. Excel, SQL Server Reporting Services, Power BI, etc.) Plan approach for writing the appropriate code Write code to fulfill requirements Test code to ensure accuracy Document code Prepare request Share completed request Track work progress and completed product 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 division's 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: Pharmacy Data: Statewide MOUD utilization, Tracking medication compliance, high\-cost formulations, and prescribing trends. Billing and Claims: Analyzing operational costs, utilization reviews, and outside medical spending. 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 project's rollout and success. Clinical Leadership Partnership: Collaborate directly with Deputy Chief Medical Officer and each facility’s 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 population's 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: 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, 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: 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 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 agency's 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. People's 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 people's 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. https://www.uscis.gov/i\-9\-central/form\-i\-9\-acceptable\-documents DOC does not use E\-Verify; therefore, we are not eligible to extend STEM\-Optional Practice Training (OPT). For information, please visit www.uscis.gov. 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 applicant’s 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 ofhire. 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 www.wes.org and www.aice\-eval.org. 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 people's 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 kathey.waggoner@doc1\.wa.gov or call us at 509\-907\-7808 For TTY service, please call the Washington Relay Service at 7\-1\-1 or 1\-800\-833\-6388\. More than Just a Paycheck! Employee benefits are not just about the kind of services you get, they are also about how much you may have to pay out of pocket. Washington State offers one of the most competitive benefits packages in the nation. We understand that your life revolves around more than just your career. Like everyone, your first priority is ensuring that you and your family will maintain health and financial security. That's why choice is a key component of our benefits package. We have a selection of health and retirement plans, paid leave, staff training and other compensation benefits that you can mix and match to meet your current and future needs. Read about our benefits: The following information describes typical benefits available for full\-time employees who are expected to work more than six months. Actual benefits may vary by appointment type or be prorated for other than full\-time work (e.g. part\-time); view the job posting for benefits details for job types other than full\-time. Note: If the position offers benefits which differ from the following, the job posting should include the specific benefits. Insurance Benefits Employees and their families are covered by medical (including vision), dental and basic life insurance. There are multiple medical plans with affordable monthly premiums that offer coverage throughout the state. Staff are eligible to enroll each year in a medical flexible spending account which enables them to use tax\-deferred dollars toward their health care expenses. Employees are also covered by basic life and long\-term disability insurance, with the option to purchase additional coverage amounts. To view premium rates, coverage choice in your area and how to enroll, please visit the Public Employees Benefits Board (PEBB) website. The Washington Wellness program from the Health Care Authority works with PEBB to support our workplace wellness programs. Dependent care assistance allows the employee to save pre\-tax dollars for a child or elder care expenses. Other insurance coverage for auto, boat, home, and renter insurance is available through payroll deduction. The Washington State Employee Assistance Program promotes the health and well\-being of employees. Retirement and Deferred Compensation 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. Employees also have the ability to participate in the Deferred Compensation Program (DCP). This is a supplemental retirement savings program (similar to an IRA) that allows you control over the amount of pre\-tax salary dollars you defer as well as the flexibility to choose between multiple investment options. Social Security All state employees are covered by the federal Social Security and Medicare systems. The state and the employee pay an equal amount into the system. Public Service Loan Forgiveness If you are employed by a government or not\-for\-profit organization, and meet the qualifying criteria, you may be eligible to receive student loan forgiveness under the Public Service Loan Forgiveness Program. Holidays Full\-time and part\-time employees are entitled to paid holidays and one paid personal holiday per calendar year. Note: Employees who are members of certain Unions may be entitled to additional personal leave day(s), please refer to position specific Collective Bargaining Agreements for more information. Full\-time employees who work full monthly schedules qualify for holiday compensation if they are employed before the holiday and are in pay status for at least 80 nonovertime hours during the month of the holiday; or for the entire work shift preceding the holiday. Part\-time employees who are in pay status during the month of the holiday qualify for the holiday on a pro\-rata basis. Compensation for holidays (including personal holiday) will be proportionate to the number of hours in pay status in the month to that required for full\-time employment, excluding all holiday hours. Pay status includes hours worked and time on paid leave. Sick Leave Full\-time employees earn eight hours of sick leave per month. Overtime eligible employees who are in pay status for less than 80 hours per month, earn a monthly proportionate to the number of hours in pay status, in the month to that required for full\-time employment. Overtime exempt employees who are in pay status for less than 80 hours per month do not earn a monthly accrual of sick leave. Sick leave accruals for part\-time employees will be proportionate to the number of hours in pay status, in the month to that required for full\-time employment. Pay status includes hours worked, time on paid leave and paid holiday. Vacation (Annual Leave) Full\-time employees accrue vacation leave at the rates specified in WAC 357\-31\-165(1\) or the applicable collective bargaining agreement (CBA). Full\-time employees who are in pay status for less than 80 nonovertime hours in a month do not earn a monthly accrual of vacation leave. Part\-time employees accrue vacation leave hours in accordance with WAC 357\-31\-165(1\) or the applicable collective bargaining agreement (CBA) on a pro rata basis. Vacation leave accrual will be proportionate to the number of hours in pay status, in the month to that required for full\-time employment. Pay status includes hours worked, time on paid leave and paid holiday. As provided in WAC 357\-58\-175, an employer may authorize a lump\-sum accrual of vacation leave or accelerate the vacation leave accrual rate to support the recruitment and/or retention of a candidate or employee for a Washington Management Service position. Vacation leave accrual rates may only be accelerated using the rates established WAC 357\-31\-165\. Note: Most agencies follow the civil service rules covering leave and holidays for exempt employees even though there is no requirement for them to do so. However, agencies are required to adhere to the applicable RCWs pertaining holidays and leave. Military Leave Washington State supports members of the armed forces with 21 days paid military leave per year. Bereavement Leave Most employees whose family member or household member dies, or for loss of pregnancy, are entitled to five (5\) days of paid bereavement leave. In addition, the employer may approve other available leave types for the purpose of bereavement leave. Additional Leave Leave Sharing Parental Leave Family and Medical Leave Act (FMLA) Leave Without Pay Please visit the State HR Website for more detailed information regarding benefits. Updated 01\-07\-2026