Business Intelligence Analyst

We are seeking a Business Intelligence Analyst!

Franklin County. OH

Join our team!

Integrated Services for Behavioral Health (ISBH) is a community-minded, forward-thinking behavioral health organization helping people along the road to health and well-being. We meet people in their homes and communities and help connect them to the resources they need. We serve Southeastern and Central Ohio with a comprehensive array of behavioral health and other services, working with local partners to promote healthy people and strong communities. All of our services are intended to be collaborative and personalized for the individual.

This position will be responsible for gathering, cleaning, organizing, and reporting on data across multiple sources, locations, and departments within the organization in order to create reports, identify trends, and help drive business analytics. This position will also assist in the organization and management of our PowerBI environment to include all existing reports, workspaces, and access levels, and will help to satisfy the organization's reporting needs with changes to existing reports as well as ad-hoc reports as needed.

The pay range for this position is $60,126.00 - $77,720.36 annually based on experience.

Essential Functions

• Maintain and optimize existing data systems, ensuring high availability and data quality.

• Assists in the identification, planning, and execution of data migration between and amongst different systems on an as-needed basis.

• Routinely reviews and tests data feeds, data transformation routines, and data validity, and responds accordingly to ensure ongoing integrity.

• Troubleshoots production issues and develops proactive solutions for data quality and system performance issues.

• Act as a liaison between departments, facilitating communication and ensuring alignment on data-driven goals.

• Support and enhance ETL (Extract, Transform, Load) processes for seamless data integration.

• Provide ongoing training and guidance to individuals and teams on using data, tools, dashboards, and reports.

• Design, refine, and implement interactive reports and dashboards using Power BI to support data-driven decision-making.

• Identifies and integrates data from multiple sources and builds dashboards and reports within Power BI environment that produces interactive and effective data analytics.

• Ensure reports and dashboards meet business needs and adhere to data quality standards.

• Maintains a detailed inventory of new and existing reports, dashboards, data feeds, and transformation routines.

• Analyze clinical and business data to identify trends, patterns, and actionable insights.

• Collaborate with management and stakeholders to address analytical needs and propose solutions and/or improvements.

• Leads the development of business intelligence solutions based on the requirements and strategic initiatives of business leadership.

• Takes part in ad hoc reporting projects as needed, including supporting users in determining reporting options within available applications.

· Other duties as assigned.

Minimum Requirements

• A bachelor’s degree in Data Science, Computer Science, Mathematics, Statistics, Business Intelligence, or a related field is required.

• 3-4 years of experience with an Electronic Health Record (EHR) system to include report building or extracting data from the system for reporting purposes.

• Basic knowledge of SQL and Python; familiarity with cloud platforms (Azure or AWS); experience with Microsoft Power Platform and tools.