Business Intelligence & Reporting Coordinator

SCCMHA JOB VACANCY ANNOUNCEMENT

CLASSIFICATION: Business Intelligence & Reporting Coordinator

Pay Grade: $63,069.55 - $78,089.41 Annually

GENERAL STATEMENT OF DUTIES

This position works in a structured team environment and has responsibilities unique to the teams in which they belong. These teams have Primary, Secondary and Supporting members. It is required that the Primary and Secondary members of these Teams be aware of the status of all projects and major initiatives with enough knowledge to discuss with the Chief Information Officer and others at the time of the inquiry. All Primary and Secondary members of the Team must discuss, vet, and agree upon any changes to processes, procedures, standards, equipment, and infrastructure that relate to the responsibilities of the team. All changes must follow a change control process which includes scope and risk analysis, team and peer review, contingency and backup planning, pre-deployment testing and validation, implementation, testing and documentation in the change control log. Root cause analysis will be performed for all process, network and system failures or disruptions and corrective actions will be put in place. All members of the team will be proactive by constantly looking for innovative techniques and technologies that will improve the effectiveness, efficiency, longevity, and sustainability in all areas of responsibility. Primary members must act as the lead on all projects, tasks, and initiatives with the full involvement of the Secondary members. Primary members will act as mentors whose goal is to assist all Secondary members with becoming a SME (Subject Matter Expert) in all aspects within the team. Supporting members of the team will assist the Primary and Secondary members within their areas of expertise to fulfill the responsibilities of the team.

As a Staff Member within the Business Intelligence Department , this person 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 Primary Member of the BI Quality Team. This position will facilitate overall quality system functions, provide project management, data analytic technical support, and assistance with all quality and process improvement projects with a focus on business and operational projects.

As a Primary 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.

INCIDENTAL DUTIES AND RESPONSIBILITES:

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

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

• Attends mandated SCCMHA regulatory staff training.

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

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

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

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

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

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

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

• Perform other duties as assigned by the Chief Information Officer.

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

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

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

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

QUALIFICATIONS:

Education: Bachelor's degree in Business Administration, 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 Access, Visual Studio and other report generating and database products such as SQL Reporting Services and SQL Server with emphasis on Analytical, BI, and reporting tools.

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

Knowledge, Skills, and Abilities:

• Ability to lead and manage projects.

• Ability to quickly learn database programming code.

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

• Familiarity with data visualization related to process improvements.

• Excellent problem solving and critical thinking skills.

• Solid troubleshooting and communication skills.

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

• Ability to train and assist others.

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

• Knowledge of personal computers, client/server computer systems and Windows based software applications, including Microsoft Access, Word, and Excel. Publisher and Project desirable but not required.

• Ability to exercise mature judgment and maintain strict confidentiality.

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

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

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

• Ability to provide small group leadership or management.

• Professional level verbal and written communication skills.

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

• Good analytical, problem solving skills.

Physical/Mental Requirements:

• Ability to handle stress in meeting deadlines and dealing with large numbers of employees and/or consumers.

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

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

• Hearing acuity to converse in person and on telephone.

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

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

• Strong interpersonal skills to interact with leadership, employees, consumers, and the public.

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

The above is only a summary. For complete listing of all job responsibilities see the Job Description.