Business Intelligence Analyst

Posted 21 Hours Ago
43224, Columbus, OH, USA
In-Office
60K-81K Annually
Mid level
Professional Services • Social Impact • Pharmaceutical
The Role
Develops and maintains business intelligence reporting systems, data warehouses, dashboards, and automated reporting solutions. Analyzes financial, operational, pharmacy, clinical, and grant data to identify trends, support projections, improve processes, and inform business and clinical strategies. Presents findings and interprets data for executive leadership, management, and staff. Requires healthcare reporting expertise, SQL and database knowledge, BI tools experience, and strong stakeholder communication skills.
Summary Generated by Built In

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 Officer 

Supervises:  N/A

Dress Requirement: Business casual in accordance with Heart of Ohio Family Health      dress code policy

Work 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 necessity

Exempt  þ                                        Non-Exempt   

Job 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 standards
  • Responsible 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 tasks 
  • Presents 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 continuity

Equipment Operated:

Telephone

Computer

Printer

Mail Machine

Copier

Scanner/Fax

Facility 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 temperature
  • sanitized daily
  • maintains standard office environment furniture with adjustable chairs
  • maintains standard office equipment; ie, computer, copier, fax 

Physical Demands and Requirements: these may be modified to accurately perform the essential functions of the position:

  • Mobility = ability to easily move without assistance
  • Bending = occasional bending from the waist and knees
  • Reaching = occasional reaching no higher than normal arm stretch
  • Lifting/Carry = ability to lift and carry a normal stack of documents and/or files
  • Pushing/Pulling = ability to push or pull a normal office environment
  • Dexterity = ability to handle and/or grasp, use a keyboard, calculator, and other office equipment accurately and quickly
  • Hearing = ability to accurately hear and react to the normal tone of a person’s voice 
  • Visual = ability to safely and accurately see and react to factors and objects in a normal setting
  • Speaking = ability to pronounce words clearly to be understood by another individual
Qualifications

Job Qualifications: (Experience, Knowledge, Skills and Abilities)

  • Strong healthcare financial reporting, preferably in an FQHC-type organization.
  • Experience navigating in Electronic Health Record systems
  • Working understanding of SQL and database concepts
  • 3+ years of experience on business intelligence teams, preferable in a healthcare organization.
  • Experience with Population Health Management tools is preferred
  • Understanding of Microsoft tools; PowerBI, PowerApps, PowerAutomate, VisualStudio, Microsoft Office VBA
  • Strong analytical and problem-solving skills
  • Highly organized and detail-oriented
  • Ability to communicate (orally and in written) in a professional manner
  • Ability to effectively work both independently and in a team setting
  • Ability to maintain an established work schedule to ensure dependability, accuracy of work quality, and a harmonious, consistent work environment
  • Strong visual design skills used in creating information dense, easy to understand reports and dashboards
  • Experience working with stakeholders and end-users to define, test, elicit and deliver technical and functional BI requirements by making use of Business Intelligence reporting tools
  • Experience with Analysis Services and MS SQL Server Reporting Services (SSRS)
  • Strong knowledge of relational, SQL and dimensional databases
  • Analytical and communication skills
  • MS Excel skills
  • Must be flexible and work analytically in a problem-solving, results oriented environment
  • Able to clearly communicate stakeholder reporting needs is a must
  • Must be willing to work with and learn new technologies
  • Must be action-oriented with excellent follow through
  • Must be accountable

Skills Required

  • Strong healthcare financial reporting experience, preferably in an FQHC-type organization
  • Experience navigating Electronic Health Record systems
  • Working understanding of SQL and database concepts
  • 3+ years of experience on business intelligence teams
  • Experience with Population Health Management tools
  • Understanding of Power BI, PowerApps, Power Automate, Visual Studio, and Microsoft Office VBA
  • Strong analytical and problem-solving skills
  • Strong visual design skills for creating information-dense reports and dashboards
  • Experience gathering, testing, and delivering technical and functional BI requirements with stakeholders and end users
  • Experience with Analysis Services and Microsoft SQL Server Reporting Services (SSRS)
  • Strong knowledge of relational, SQL, and dimensional databases
  • Microsoft Excel skills
  • Professional oral and written communication skills
  • Ability to work independently and as part of a team
  • Ability to maintain an established work schedule
  • Willingness to learn new technologies
  • Action-oriented approach with excellent follow-through and accountability
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
288 Employees

What We Do

Heart of Ohio Family Health is a non-profit organization that operates Federally Qualified Health Centers in Franklin County, Ohio. Its mission is to provide high-quality, holistic, and compassionate care to meet the healthcare needs of everyone in its diverse community, one heart at a time. The organization provides healthcare services regardless of ability to pay, offering a sliding fee scale based on income and number of dependents.

Similar Jobs

BECU Logo BECU

Business Intelligence Analyst

Fintech • Financial Services
Remote or Hybrid
3 Locations
3000 Employees

Nationwide Children's Hospital Logo Nationwide Children's Hospital

Business Intelligence Analyst

Healthtech • Kids + Family • Social Impact
In-Office
Columbus, OH, USA
Hybrid
Dublin, OH, USA
603 Employees
102K-140K Annually
Hybrid
Van Wert, OH, USA
603 Employees
102K-140K Annually

Similar Companies Hiring

Playground (tryplayground.com) Thumbnail
Kids + Family • Payments • Social Impact • Software
New York City, New York
80 Employees
Cravath, Swaine & Moore LLP Thumbnail
Legal Tech • Other • Professional Services
New York, NY
1200 Employees
VCA Animal Hospitals Thumbnail
Pet • Professional Services
Los Angeles, CA
35000 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account