Business Intelligence and Assessment Specialist

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

Benefits offered by this job

PTO up to 16 days first year

12% bonus potential

Insurance coverage (medical/vision/dac

HSA match up to $1000

401(k) with employer match

Professional development

Student loan forgiveness potential

Job summary

NorthKey Community Care is seeking a Business Intelligence & Assessment Specialist to lead analytics, evaluation, and BI efforts. The role focuses on SQL-based reporting, data visualization, and performance measurement to support grant programs and organizational decisions.

The position is on-site in Covington/Fort Wright, KY, with a hybrid option after six months. A master’s degree is preferred and relocation is not provided.

Qualifications

• Master’s degree preferred in a health analytics or related field.
• Bachelor’s degree in data analytics, health informatics, information systems, public health, statistics or BI required.
• Minimum of 5 years of progressive experience in healthcare analytics or related field.
• Experience with electronic health record datasets (clients, encounters, claims) preferred.

Responsibilities

• Develop, maintain, and optimize reports, dashboards, datasets, and BI solutions.
• Use SQL, Power Query, DAX to extract, transform, and analyze data from multiple sources.
• Design automated reporting solutions and executive dashboards for leadership and programs.
• Collaborate to coach analysts in SQL, Power BI, data validation, and dashboard design.

Skills

Data analytics

Healthcare analytics

Performance measurement

Education

Master’s degree preferred

Bachelor’s degree in data analytics/related field

Tools

Credible EHR

Power BI

SQL

Power Query

DAX

Job description

NorthKey Community Care is seeking a Business Intelligence & Assessment Specialist. The 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.

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 Measurementt

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