IT Business Analyst

North Country Community Mental Health is a public behavioral health organization committed to improving the quality of life for people with mental illness and/or developmental disabilities in our communities.

$27.00/hr - $28.00/hr

Starting wage range: $26.61 - $27.94 per hour or per year

JOB TITLE: IT Business Analyst

LOCATION: Petoskey, MI 49770

REPORTS TO: Chief Information Officer

STATUS: Full-Time, Non-Union, Non-Exempt

HYBRID ELIGIBLE: Yes

• No cost health, dental and vision insurance option
• 14.2% employer paid retirement plan contribution
• Vacation, sick and personal time
• Employer paid disability and life insurance
• Tuition reimbursement programs

Education: Bachelor’s degree in quality management, business administration, public or health administration, computer science, or related field.

Experience: Two to three years’ experience in data analysis and reporting, process improvement, and/or statistical analysis to support business/clinical operations. Exceptional computer skills with Microsoft Office products, including Word, Excel and Access. Experience with SQL Report Writer and Power BI.

Other: Lived experiences with behavioral health issues are valued.

The Information Technology Business Analyst (ITBA) acts as a liaison between Information Systems Department and various stakeholders to gather business requirements, design, develop and support applications, provide reporting solutions for the data needs of finance, back-office, and QI departments, and meet the data reporting obligations of various contracts.

• Technical acuity, accuracy
• Quality improvement tools including process mapping, rapid cycle PDSA, Lean, Six-Sigma
• Requires acute attention to detail
• Accurately and effectively uses visualization including charts, graphs, trend lines, and other tools to convey key messages
• Knowledge of Microsoft SQL Server
• Experience in software development, statistical and/or visualization platforms
• Ability to support and facilitate a cross‑functional team
• Ability to transform data into meaningful, actionable information
• Ability to track, monitor and report on progress towards identified benchmarks
• Understanding of relational databases

• Confer with various stakeholders to analyze current operational procedures, identify problems, and propose solutions.
• Work closely with data team to maintain data warehouse.
• Plan, design, and oversee the development of data gathering, storing and retrieval, to assure data integrity.
• Develop and/or maintain documentation.
• Adhere to software development standards.
• Conduct internal testing of user interfaces and decision-support tools (e.g., data apps, decision‑making frameworks, etc.).
• Safeguard data to ensure it is secured and only shared with intended users.
• Oversee all Health Information Exchange activities.
• Analyze user requirements, procedures, and problems to automate processing and/or to improve existing processes or software system.
• Find efficiencies in processes, reducing unnecessary steps, organizing data tracking, and simplify processes to report data.
• Develop tools for committees or teams using Microsoft products, i.e., Access, Excel, SQL Server tools (T‑SQL, SSMS/SSRS), and Power BI.
• Responsible for reporting data to PIHP, MDHHS and other payers, as mandated by contracts.
• Assist teams in development of key performance indicators/outcome metrics to evaluate program and organizational effectiveness.
• Knowledge of statistics for use in the production of key performance indicators.
• Work with Finance, Billing, Reimbursement and QI departments to support the reporting needs of those departments.
• Provide executive summaries based on data, e.g., incident report work groups and annual risk management summary.
• Conducts all phases of survey research, including development, testing, administration, and utilizing statistical methods to analyze data.
• Monitor and analyze data trends, including but not limited to quality assurance measures, and make recommendations for continuous quality improvement.
• Maintain and upgrade professional knowledge, skills…