Business Intelligence and Assessment Specialist

NorthKey Community Care; Covington (KY); On-site; USD 55,000 - 80,000; Full time

Benefits offered by this job

Paid time off

Bonus potential

PTO days

Paid holidays

Insurance plans

HSA match

401(k) match

Professional development

Student loan forgiveness

Job summary

NorthKey Community Care is seeking a Business Intelligence Analyst & Evaluator to lead analytics, data visualization, and program evaluation across multiple health programs. The role emphasizes SQL-based reporting, data integrity, and performance measurement, with on-site duties in Covington, KY and potential hybrid scheduling after six months.

The candidate should have 5+ years in healthcare analytics, proficiency with EHR data, and a strong background in BI and evaluation.

Qualifications

• Master’s degree preferred.
• Bachelor’s degree in data analytics, health informatics, information systems, public health, statistics, BI, healthcare administration, or related field required.
• Minimum of 5 years of progressive experience in healthcare analytics, BI, program evaluation, quality improvement, or related field.
• Experience with electronic health record datasets strongly preferred.
• Experience supporting behavioral health or grant-funded programs preferred.

Responsibilities

• Develop, maintain, and optimize reports, dashboards, datasets, and BI solutions using Credible EHR and Power BI.
• Utilize SQL, Power Query, DAX and other tools to extract and analyze data from multiple sources.
• Design automated reporting, dashboards, scorecards, and visualizations.
• Create executive dashboards and performance reports for leadership and project teams.
• Collaborate with analysts and report developers on data validation and dashboard best practices.
• Lead evaluation for grants and initiatives and develop measurement frameworks.

Skills

Healthcare analytics

Program evaluation

Quality improvement

SQL reporting

Data visualization

Education

Bachelor's degree in data analytics

Master's degree preferred

Tools

Credible EHR

Power BI

SQL

Power Query

DAX

Job description

NorthKey Community Care is seeking a Business Intelligence Analyst & Evaluator. This individual serves as NorthKey Community Care’s lead analytics and evaluation professional, providing expertise in business intelligence, SQL-based reporting, data visualization, program evaluation, and performance measurement. Work Hours: Generally, Monday-Friday, 8:30 am-5:00 pm. This position is on-site in our Covington/Fort Wright, KY location, with opportunity for a hybrid schedule after six months. Candidates MUST reside within commuting distance of Covington, KY, or be willing to relocate to the area prior to their start date. Relocation assistance is not provided.

PERKS & PAY

• $55,000–$80,000 annually, depending on education and relevant experience.
• Potential for up to 12% annual contingency bonus
• Generous plan for paid time off (PTO) (Up to 16 days the first year)
• 10 Paid Holidays
• Individual and family insurance coverage: Various medical, vision, and dental plans to choose from
• HSA Employer match up to $1000, depending on plan
• 401(k) with employer match
• Professional Development
• Potential eligibility for student loan forgiveness through the Public Service Loan Forgiveness program

QUALIFICATIONS

• Master’s degree preferred.
• Bachelor’s degree in data Analytics, Health Informatics, Information Systems, Public Health, Statistics, Business Intelligence, Healthcare Administration, or related field required.
• Minimum of 5 years of progressive experience in healthcare analytics, business intelligence, program evaluation, quality improvement, or related field.
• Experience working with electronic health record datasets strongly preferred, including client population, encounter information, and medical claims/billing.
• Experience supporting behavioral health, CMHC, CCBHC, or grant-funded healthcare programs preferred.

JOB DUTIES

Business Intelligence, Reporting & Analytics

• Develop, maintain, and optimize reports, dashboards, datasets, and business intelligence solutions within Credible EHR, Power BI, and other organizational systems.
• Utilize SQL, Power Query, DAX, and other reporting tools to extract, transform, validate, reconcile, and analyze data from multiple sources.
• Design automated reporting solutions, dashboards, scorecards, and visualizations.
• Create executive-level dashboards and performance reports for leadership, project directors, and program teams.
• Conduct analyses to identify trends, opportunities, risks, and performance improvement initiatives.
• Collaborate with and provide technical guidance, coaching, and support to analysts and report developers in SQL, Power BI, data validation, dashboard design, and reporting best practices.

Data Integrity & Quality Management

• Validate data accuracy, completeness, and consistency across systems and reporting platforms.
• Investigate reporting discrepancies and collaborate with staff to resolve data quality issues.
• Partner with program management to establish reporting standards, data definitions, and quality assurance processes.

Evaluation & Performance Measuremen

• Serve as lead evaluator for assigned grants and initiatives, including SAMHSA-funded programs.
• In concert with Project Directors, develop evaluation plans, measurement frameworks, and performance monitoring strategies.
• Develop and maintain reporting processes and tools to collect, analyze, validate, and interpret program outcome data, and prepare data summaries and reports for leadership, program staff, funders, and other stakeholders.

Grant and Regulatory Reporting

• Support Project Directors and leadership in fulfilling grant reporting and performance measurement requirements.
• Partner with Project Directors to coordinate collection and submission of required performance measures, including SPARS and GPRA requirements when applicable.
• Prepare data and documentation for audits, site visits, and grant monitoring activities.

Consultation, Leadership & Training

• Serve as an internal consultant regarding analytics, reporting strategy, performance measurement, and business intelligence solutions.
• Partner with leadership and department managers to improve data-informed decision-making, including providing coaching, technical guidance, and consultation.
• Coordinate and collaborate with third-party data consulting firms to advance organizational reporting, analytics, data governance, and business intelligence initiatives.

NORTHKEY COMMUNITY CARE - COMPANY OVERVIEW

Since 1966, NorthKey Community Care (NorthKey) has provided quality, evidence-based mental health, substance use, and developmental disabilities services to the Northern Kentucky region with the commitment to providing the right service, at the right time, and in the right place. With multiple convenient locations throughout the Northern Kentucky region (Kenton, Boone, Campbell, Grant, Carroll, Gallatin, Pendleton, and Owen counties), NorthKey offers a wide array of mental health, substance use, and developmental disabilities services unparalleled in the region.

Join our team to help us fulfill our mission of Transforming Lives and Communities Through Excellence in Mental Health, Substance Use, and Developmental Disabilities Services!