Business Intelligence Analyst

HEART OF OHIO FAMILY HEALTH CENTERS•Whitehall, OH

2d•$60,216 - $81,000•Onsite

About The Position

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. This role involves maintaining and exploiting the company's data warehouse to extract important statistics and facts that can help in rendering a true picture of an organization’s industry standing and performance. The analyst will be responsible for designing reports, developing best practices and processes to aid business intelligence, and collecting and analyzing past and present data to establish the fashion of an organization’s operation. Data analyzed includes financial, operations, pharmacy, clinical data, and grant-related data. The role also involves identifying opportunities to improve processes and strategies with technology solutions and developing and implementing automated solutions for data and reporting related tasks. The analyst will present and help interpret data to senior leadership, management, and other staff members.

Requirements

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.
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.

Nice To Haves

Experience with Population Health Management tools is preferred.

Responsibilities

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.
Collects past and present data to establish the fashion of an organization’s operation.
Collects 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.
Formats information that is used in discovering an organization’s weaknesses, strengths as well as the opportunities and threats surrounding the business.
Identifies 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.