Business Intelligence Analyst

HEART OF OHIO FAMILY HEALTH CENTERS•Whitehall, OH

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

About The Position

The Business Intelligence Analyst provides appropriate and accurate data to the Executive team, management, and staff to improve business and clinical outcomes. The role assists in maintaining and using the organization’s data warehouse, maintaining reporting systems according to data standards, designing reports, and developing best practices and processes for business intelligence. The analyst collects historical and current data, analyzes it using statistical tools, and develops projections to inform business strategies. Data may include financial, operational, pharmacy, clinical, and grant-related information. The role also identifies organizational strengths, weaknesses, opportunities, and threats; finds opportunities to improve processes and strategies through technology; helps implement automated data and reporting solutions; and presents and interprets data for leadership, management, and staff. Other assigned duties may include backing up other departmental positions to support continuity. This is a full-time position of up to 40 hours per week during standard Monday-to-Friday business hours, subject to change due to business needs. The primary work area is in business offices at Heart of Ohio Family Health facilities in the Columbus, Ohio area. The dress requirement is business casual in accordance with the organization’s dress code.

Requirements

Strong healthcare financial reporting experience; experience in an FQHC-type organization is preferred.
Experience navigating Electronic Health Record systems.
Working understanding of SQL and database concepts.
At least 3 years of experience on business intelligence teams; healthcare experience is preferred.
Understanding of Microsoft tools, including PowerBI, PowerApps, PowerAutomate, VisualStudio, Microsoft Office, and VBA.
Strong analytical and problem-solving skills.
Highly organized and detail-oriented.
Ability to communicate professionally, orally and in writing.
Ability to work effectively independently and in a team setting.
Ability to maintain an established work schedule and ensure dependable, accurate work.
Strong visual design skills for 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 using Business Intelligence reporting tools.
Experience with Analysis Services and MS SQL Server Reporting Services (SSRS).
Strong knowledge of relational, SQL, and dimensional databases.
Strong analytical and communication skills.
MS Excel skills.
Flexibility and ability to work analytically in a problem-solving, results-oriented environment.
Ability to clearly communicate stakeholder reporting needs.
Willingness to work with and learn new technologies.
Action-oriented approach with excellent follow-through.
Accountability.

Nice To Haves

Experience in a healthcare organization on a business intelligence team.
Experience with Population Health Management tools.
Strong healthcare financial reporting experience in an FQHC-type organization.

Responsibilities

Assist in maintaining and exploiting the organization’s data warehouse to identify relevant statistics and facts about industry standing and organizational performance.
Maintain reporting systems in accordance with the organization’s data standards.
Design reports and develop best practices and processes to support business intelligence.
Collect past and present data and analyze it using statistical tools to project the outcomes of business strategies.
Analyze financial, operational, pharmacy, clinical, and grant-related data, among other data.
Format information to identify organizational strengths, weaknesses, opportunities, and threats.
Identify opportunities to improve processes and strategies through technology solutions.
Assist in developing and implementing automated solutions for data and reporting tasks.
Present and help interpret data to senior leadership, management, and other staff.
Perform other assigned non-essential duties, including backing up other departmental positions as needed to provide depth and continuity.