Business Intelligence Analyst

Heart of Ohio Family Health Centers

Ohio

On-site

USD 85,000 - 110,000

Full time

5 days ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Heart of Ohio Family Health Centers in Ohio seeks a Business Intelligence Analyst to collect, analyze, and present data to executives, management, and staff to improve clinical and business outcomes.

The role involves maintaining the data warehouse, designing reports, automating data tasks, and collaborating with stakeholders to translate requirements into actionable dashboards using Power BI and SQL within our healthcare environment.

Qualifications

  • Strong healthcare financial reporting experience.
  • Experience navigating Electronic Health Record systems.
  • 3+ years on business intelligence teams, preferably in healthcare.
  • Familiarity with Population Health Management tools preferred.
  • Proficiency with PowerBI, PowerApps, PowerAutomate, Visual Studio and MS Office VBA.

Responsibilities

  • Maintain and exploit the data warehouse to extract key statistics.
  • Design reports and establish best practices for BI processes.
  • Collect data from various domains and build projections for strategies.
  • Create analyses using statistical tools to inform business decisions.
  • Develop automated data and reporting solutions.
  • Present insights to senior leadership and staff for decision making.

Skills

Healthcare finance reporting
SQL concepts
BI analytics
Communication skills
Data visualization
Analytical thinking

Tools

PowerBI
PowerApps
PowerAutomate
SQL Server
Visual Studio
Excel

Job description

Summary: The Business Intelligence Analyst role in the organization is to get appropriate and accurate data to the Executive team, management, and staff to improve business and clinical outcomes.Reports to: Chief Quality and Strategy OfficerSupervises: N/ADress Requirement: Business casual in accordance with Heart of Ohio Family Health dress code policyWork Schedule: This is a full-time position consisting of up to 40 hours per week during the standard business hours of Monday to Friday. Times are subject to change due to business necessityExempt þ Non-ExemptJob Duties: These are considered essential to the successful performance of this position:The person assists in maintaining and exploiting the data warehouse of the company to dig for important statistics and facts that may help in rendering a true picture of an organization’s industry standing and performance.Maintains reporting system as directed by organization’s data standardsResponsible for designing reports and developing best practices and processes to aid the business intelligence of an organization.Responsibilities include collecting past and present data to establish the fashion of an organization’s operation.Collect data in a manner that is analyzed and put into use with statistical tools for the development of projections on the outcome of engaging certain business strategies.Data analyzed includes but is not limited to financial, operations, pharmacy, clinical data, and grant related data.Formatting information that is used in discovering an organization’s weaknesses, strengths as well as the opportunities and threats surrounding the business.Identifying opportunities to improve processes and strategies with technology solutions.Assists with developing and implementing automated solutions for data and reporting related tasksPresents and helps with interpreting data to senior leadership, management, and other staff members.Other duties as assigned (non-essential) including backing up other departmental positions as necessary to provide depth and continuityEquipment Operated:TelephoneComputerPrinterMail MachineCopierScanner/FaxFacility Environment:Heart of Ohio Family Health operates in multiple sites in the Columbus, OH area. All facilities are a medical office environment with front-desk reception area, separate patient examination rooms, pharmacy stock room, business offices, hallways and private toilet facilities. All facilities are ADA compliant.This position’s primary work area is business offices.This work area is:kept at a normal working temperaturesanitized dailymaintains standard office environment furniture with adjustable chairsmaintains standard office equipment; ie, computer, copier, faxPhysical Demands and Requirements: these may be modified to accurately perform the essential functions of the position:Mobility = ability to easily move without assistanceBending = occasional bending from the waist and kneesReaching = occasional reaching no higher than normal arm stretchLifting/Carry = ability to lift and carry a normal stack of documents and/or filesPushing/Pulling = ability to push or pull a normal office environmentDexterity = ability to handle and/or grasp, use a keyboard, calculator, and other office equipment accurately and quicklyHearing = ability to accurately hear and react to the normal tone of a person’s voiceVisual = ability to safely and accurately see and react to factors and objects in a normal settingSpeaking = ability to pronounce words clearly to be understood by another individualJob Qualifications: (Experience, Knowledge, Skills and Abilities)Strong healthcare financial reporting, preferably in an FQHC-type organization.Experience navigating in Electronic Health Record systemsWorking understanding of SQL and database concepts3+ years of experience on business intelligence teams, preferable in a healthcare organization.Experience with Population Health Management tools is preferredUnderstanding of Microsoft tools; PowerBI, PowerApps, PowerAutomate, VisualStudio, Microsoft Office VBAStrong analytical and problem-solving skillsHighly organized and detail-orientedAbility to communicate (orally and in written) in a professional mannerAbility to effectively work both independently and in a team settingAbility to maintain an established work schedule to ensure dependability, accuracy of work quality, and a harmonious, consistent work environmentStrong visual design skills used in creating information dense, easy to understand reports and dashboardsExperience working with stakeholders and end-users to define, test, elicit and deliver technical and functional BI requirements by making use of Business Intelligence reporting toolsExperience with Analysis Services and MS SQL Server Reporting Services (SSRS)Strong knowledge of relational, SQL and dimensional databasesAnalytical and communication skillsMS Excel skillsMust be flexible and work analytically in a problem-solving, results oriented environmentAble to clearly communicate stakeholder reporting needs is a mustMust be willing to work with and learn new technologiesMust be action-oriented with excellent follow throughMust be accountable
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

IS Business Intelligence Analyst I
IS Business Intelligence Analyst I

Nationwide Children's Hospital Inc • Columbus (OH)

Remote
USD 55,000 - 75,000
Healthcare BI Analyst - Data Insights Leader
Healthcare BI Analyst - Data Insights Leader

Heart of Ohio Family Health Centers • Ohio

On-site
USD 85,000 - 110,000
IS Business Intelligence Analyst I Nationwidechildrens ·
IS Business Intelligence Analyst I Nationwidechildrens ·

Dreamwork • Ohio

Remote
USD 65,000 - 90,000
IS Business Intelligence Analyst I
IS Business Intelligence Analyst I

10 Nationwide Children's Hospital • United States

Remote
USD 60,000 - 85,000
Project Manager
Project Manager

Heart of Ohio Family Health Centers • Columbus (OH)

On-site
USD 70,000 - 90,000
Business Intelligence Analyst
Business Intelligence Analyst

DRH Health • Duncan (OK)

On-site
USD 60,000 - 85,000
Business Intelligence Developer (3120)
Business Intelligence Developer (3120)

Heartland Orthopedic Specialists, PA • Alexandria (MN)

Remote
USD 73,000 - 102,000
Health, Dental, and Vision Insurance
Employee Health Clinic (health+)
401(k) plan with 6% match
Senior Business Intelligence Analyst
Senior Business Intelligence Analyst

GoHealth Urgent Care • Atlanta (GA)

On-site
USD 84,000 - 115,000
Data Scientist, Revenue Cycle
Data Scientist, Revenue Cycle

Orthopedic One • Westerville (OH)

Hybrid
USD 65,000 - 90,000
Senior Business Intelligence Analyst
Senior Business Intelligence Analyst

GoHealth Urgent Care • United States

Remote
USD 84,000 - 115,000