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: Business Intelligence Manager
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, on\-site position, in Columbus, OH, 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
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
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