Quality Projects and Reporting Coordinator

SCCMHA JOB VACANCY ANNOUNCEMENT

CLASSIFICATION: Quality Projects and Reporting Coordinator

PAY GRADE: $63,069.55 - $78,089.41 Annually

POSITION SUMMARY:

Under the general supervision of the Quality & Medical Records Supervisor, this position will have the primary responsibility for developing, tracking, analyzing, and reporting quality metrics to ensure compliance, drive performance improvement, and support strategic decision making. This position requires proven experience in quality measurement, quality improvement, or data analytics as well as a strong understanding of quality frameworks. The tasks of this position have monthly reporting requirements, act as a subject matter expert on quality measurement methodologies and best practices and maintain dashboards and scorecards. This position works in a structured team environment and has responsibilities unique to the teams in which they belong.

This position will seek to become knowledgeable in all areas within the Department by observing and allowing Senior members of the team to mentor them. As a member of the BI Quality Team., this position will facilitate overall quality system functions, provide project management, data analytic technical support, and assist with all quality and process improvement projects with a focus on clinical projects. As a member of the BI Reporting Team, this position will prepare reports in financial, graphical and dashboard formats for presentation to groups and report submissions. Prepare data for reports and submission files to various external agencies, partners, and regulatory authorities. Assess internal agency reporting needs for administrative and clinical areas.

This position will be knowledgeable about and actively support culturally competent recovery-based practices; person centered planning as a shared decision-making process with the individual, who defines his/her life goals and is assisted in developing a unique path toward those goals; and a trauma informed culture of safety to aid persons served in the recovery process.

ESSENTIAL DUTIES AND RESPONSIBLITIES:

As a Member within the Business Intelligence Department: Applies and maintains identity and role-based security in all SCCMHA's Information Systems including business applications, databases, online services, hosted environments, external applications, and all other information technologies in which the position is either partially or fully responsible for the administration of the security. Develops policies and procedures that ensure the integrity, availability, and confidentiality of information. Establishes standards, policies, and procedures for granting access, evaluating current controls, and implementing new access controls as appropriate.

Primary Member of the BI Quality Team: Acts as Project Manager for Quality Improvement Projects. Assists the Quality Project Team leader and the team in articulating an intervention designed to impact a desired change. Assists with the development of the Annual Quality Report and Plan. Assists with the PPG Annual Submission and Community Needs Assessment. Collects data and generates ad-hoc reports and presentations for supervisory use to address specific issues or for special projects as assigned. Coordinates and manages all Critical Incident Reporting functions. Coordinates and oversees all customer satisfaction activities including final approval of survey instruments, distribution plans, data aggregation, and reporting. Coordinates the completion of customer satisfaction surveys, aggregates data, generates reports and graphic representations of data for supervisory review on at least an annual basis. Critical Incident Reporting to MHSN (Mid-State Health Network) and MDHHS (Michigan Department of Health and Human Services). Consults and assists in selection and definition of performance indicator, summaries of findings, and ongoing performance indicator reports. Performs routine data entry with attention to completeness and accuracy and monitors all data for integrity. Develops forms, databases, reports, spreadsheets, and pivot tables as necessary to complete assigned tasks using software including but not limited to PowerPoint, Word, Excel, Access, SQL.

Primary Member of the BI Reporting Team: Acts as backup for BH-TEDS record reporting including Sentri Batch creation & management, return file management, REMI Batch Submissions, error resolution, data model, and pivot table maintenance. Continuous efforts to improve the data integrity and quality of the BH-TEDS datasets. As a backup, provide grant support including data needs, reports, and dashboard development. Creates and defines a Power Bi Dashboard and Reporting standard presentation and delivery platform. Develops Power Bi Dashboards and reports to meet the reporting and analysis needs of the agency. Identifies gaps, needs within the agency, and creates robust reporting solutions to meet them. Lead for the creation and maintenance of a report (Report Dictionary) inventory system to include all SSRS, Metric, Power BI and Pivot Table Reports that are created and maintained within the BI department and thoroughly document and properly inventory all reports within the BI inventory system. Ensure continued compliance with all security and privacy requirements of SCCMHA, State and Federal regulations. Lead for the creation, formatting, maintenance, management, and support of all Metric Reports. MMBPIS (Michigan's Mission Based Performance Indicator System) Reporting and Submissions. MSHN Delegated Functions Audits and HSAG Audits. Prepares demographic, financial, clinical or Network reports and data for submission to departmental managers, commercial insurers, governmental units, or other outside constituencies of the agency. Prepares educational materials, alerts, and other forms of provider information regarding client demographic and event data collection and reporting. Provides data analysis as requested by SCCMHA's staff, leadership, and Network providers. Reports End-User Training through Pivot Tables, Data Warehouse, Power BI Dashboards, and Excel. Routinely meets with department supervisors or Directors to assess reporting needs.

Backup Duties: Applies category type coding to incident reports and assists in monitoring incident report data. Coordinates administrative tasks for the attainment of the NCQA (National Committee for Quality Assurance) accreditation. Coordinates and is responsible for the NCI (National Core Indicators) Adult In-Person Survey. Creates, maintains, and reviews annually all Workgroup Charters. Facilitates the CIRC (Critical Incident Reporting Committee) meeting preparation and follow-up. Manages the SCCMHA website including the design and posting of quality measures and performance indicators in a “Dashboard” format. Provides initial and periodic Home Manager training for incident reporting and follows-up with communication when re-training becomes a need.

INCIDENTAL DUTIES AND RESPONSIBILITES:

1. Works very closely with the Quality & Medical Records Supervisor with all reporting functions.

2. Assists the Chief Information Officer with policy and procedure writing.

3. At the discretion of the CIO, may be an indirect report to other agency directors for specific tasks as assigned.

4. Attends mandated SCCMHA regulatory staff training.

5. Attends meetings both in-person and remotely; presents to groups, facilitates meetings, creates agendas, maintains minutes, and performs needed project management tasks.

6. Attends meetings, seminars, workshops, and community events related to the public mental health mission and training sessions to maintain or upgrade current knowledge and skills required by this position and to maintain professional proficiency.

7. Communicates project or work status to the Chief Information Officer and other department leaders regularly as appropriate.

8. May be required to commute to other SCCMHA facilities and business partners and vendor locations, when necessary, to investigate and resolve problems, implement new systems, train staff, etc.

9. May represent SCCMHA on state or regional committees and workgroups.

10. May serve as a member of various community committees, which promote the general goals of SCCMHA.

11. Must react productively and positively to change and handle other essential tasks as assigned.

12. Perform other duties as assigned by the Chief Information Officer and Quality & Medical Records Supervisor.

13. Reads journals, periodicals, and research subjects on the Internet to increase job related knowledge and further professional and talent advancement.

14. Serves in a team setting approach by backing up other department personnel in their duties when needed.

15. Works closely with and coordinates efforts with all other agency staff and leadership as needed.

16. Works closely with and coordinates efforts with all Quality, Compliance, Business Intelligence, and Information Technology staff.

(The above statements are intended to describe the general nature and level of work being performed by people assigned to this classification. They are not intended to be construed as an exhaustive list of all duties and responsibilities required of personnel so classified.)

REPORTING RELATIONSHIPS:

Reports to: Quality & Medical Records Supervisor

Supervises: None

WORKING CONDITIONS/ENVIRONMENT:

1. Daily exposure in all other department areas while working with staff at their workstation locations.

2. It is not unusual to work varied and extra hours to complete assignments to meet deadlines.

3. Occasional exposure to persons served with potential for disruptive, aggressive behavior and communicable diseases.

4. Occasionally drives personal automobile on agency business to offsite facilities or meetings, sometimes in bad weather.

5. Works at workstation using keyboard and viewing computer screen for long periods.

6. Works in typical professional office environment with pressures of time constraints, multiple projects, priorities, and numerous interruptions from telephone calls and walk-ins.

QUALIFICATIONS:

Education: Bachelor's degree in Business Administration, Healthcare Administration, or Health Information Technology preferred. Other considerations include Bachelor’s degree in Applied Science, Computer Science, Computer Information Systems, Database Administration, Database Analysis, Networking Administration, or another closely related field A combination of skills, education, and experience, which meets organizational needs, may be considered.

Experience: Five (5) years’ experience in most of the Primary Member essential duties and responsibilities listed above preferred. One (1) year professional experience in project management, business analysis, software applications, data/statistical compilation, and project experience. Experience and demonstrated competency in use of Microsoft Office 365.

Licenses and Credentials: Valid Michigan Driver’s license with good driving record.

Knowledge, Skills, and Abilities:

1. Ability to lead and manage projects.

2. Ability to quickly learn database programming code.

3. Experience and demonstrated competency in use of Microsoft Office (Access, Excel, etc.) and other report generating and database products such as SQL.

4. Familiarity with data visualization related to process improvements.

5. Excellent problem solving and critical thinking skills.

6. Solid troubleshooting and communication skills.

7. Ability to demonstrate exceptional customer service skills in working with other staff, contractors, and vendors.

8. Ability to train and assist others.

9. Knowledge of mental health services is desirable but not required.

10. Ability to exercise mature judgment and maintain strict confidentiality.

11. Ability to maintain favorable interpersonal working relationships and positive public relations.

12. Ability to plan and organize work, perform tasks consistently and adhere to priorities.

13. Ability to produce accurate and comprehensive work products with minimal direction.

14. Ability to provide small group leadership or management.

15. Professional level verbal and written communication skills.

16. Knowledge of software applications for behavioral health provider management and managed care preferred but not required.

17. Good analytical, problem solving skills.

Physical/Mental Requirements:

1. Ability to handle stress in meeting deadlines and dealing with large numbers of employees and/or persons served.

2. Ability to lift boxes and equipment weighing up to 30 pounds; carry climb, stoop, bend, walk, stand, and sit for extended periods of time.

3. Ability to plan short and long range and to manage and schedule time.

4. Hearing acuity to converse in person and on telephone.

5. Manual to write and to operate standard office equipment (PC, Keyboard, Copy Machine, Fax Machine, etc.)

6. Mental capacity to think independently, follow instruction and use judgment.

7. Strong interpersonal skills to interact with leadership, employees, persons served, and the public.

8. Visual Acuity to read and proofread documents.

(Listed qualifications are for guidance in filling this position. Any combination of education and experience that provides the necessary knowledge, skills, and abilities will be considered; however, mandatory licensing or certification requirements cannot be waived. Physical/mental requirements cannot be waived unless specifically indicated.)

(Listed qualifications are for guidance in filling this position. Any combination of education and experience that provides the necessary knowledge, skills, and abilities will be considered; however, mandatory licensing or certification requirements cannot be waived. Physical/mental requirements cannot be waived unless specifically indicated.)