CCBHC Business Intelligence Analyst

Metropolitan Family Services • Merrionette Park, IL

2d • Onsite

About The Position

Metropolitan Family Services (MFS) is seeking a Business Intelligence Analyst for its Merrionette Park Office. MFS is Illinois' first comprehensive human services agency, dedicated to empowering families to learn, earn, heal, and thrive. The role involves understanding unique reporting needs, communicating effectively with stakeholders, providing guidance on reporting solutions, and ensuring data quality. The analyst will work with large, complex datasets, translate business requirements into reporting solutions, and support the development of reporting pipelines for healthcare quality and regulatory reporting, such as CCBHC and state reporting. Collaboration with data warehouse and IT teams is essential for data integration. The position also involves documenting data sources and logic, serving as a team lead on projects, and evaluating reporting tools and processes. The company culture emphasizes COMMUNITY, acting as an engine of change to help families reach their greatest potential and positively impact their communities.

Requirements

• Bachelor’s degree in computer science/information systems/business administration or related field, required.
• Experience working with relational databases and SQL, required.
• 3+ years of experience as Business Intelligence Analyst or in a similar role, required.
• Understanding of relational data structures and basic data modeling concepts, required.
• Satisfactorily pass all relevant screening and criminal background checks.

Nice To Haves

• Experience developing reports or dashboards using BI tools (e.g., Tableau, Power BI, or similar), preferred.
• Understanding of relational data structures and basic data modeling concepts, preferred.
• Experience working with healthcare or behavioral health data strongly, preferred.
• Ability to get up to speed on domain knowledge quickly and to understand data limitations under which Data Warehouse team operates.
• Ability to translate requirements from the Data Warehouse team; there is often an iterative back-and-forth between data consumers and Business Intelligence Analyst.
• Ability to partner with key stakeholders to perform root cause data analyses and remediation efforts.
• Ability to communicate effectively with report requestors, report writers, and data analysts in delivering reporting solutions.
• Ability to provide guidance on new report requests, as well as migration of existing reports.
• Ability to handle multiple tasks and assignments.
• Experience creating specification documents, use cases, and other request-related documentation.
• Highly motivated, proactive and a self-starter; strong sense of ownership & ability to create and execute plans without daily oversight.
• Ability to work across multiple teams and to manage multiple priorities.
• Highly organized; able to effectively prioritize and balance multiple efforts in a fast-paced, regulatory driven environment; detail oriented.
• Ability to decompose complex issues and drive timely decisions, knowing when to engage others for additional input, and when to act independently.
• Excellent verbal and written communication skills; ability to simplify and summarize complex topics.

Responsibilities

• Understand unique reporting needs of requestors and provide expert knowledge, understanding, and assistance with data deliverables.
• Communicate effectively with end users, program and quality leadership, and domain experts in order to deliver reporting solutions.
• Provide guidance on new report requests, as well as migration of existing reports.
• Understanding of data quality concepts, including data validation, completeness, and reconciliation.
• Ability to work with large, complex datasets from multiple sources (e.g., EHR, data warehouse).
• Ability to translate business and clinical requirements into reporting and data visualization solutions.
• Create, maintain, and expand growing body of technical domain knowledge related to reporting infrastructure.
• Conduct analysis of business and user needs, documentation of requirements, and translation into functional system requirements.
• Provide second level support to end-users, including troubleshooting data discrepancies and reporting issues.
• Supports end users in resolving data needs on a timely basis.
• Partner with analytics, CQI, and program teams to ensure reporting solutions align with clinical workflows, quality measures, and operational needs.
• Support development and maintenance of reporting pipelines for healthcare quality and regulatory reporting (e.g., CCBHC, state reporting).
• Ensure accuracy, completeness, and timeliness of data within reporting environments through validation and troubleshooting.
• Collaborate with data warehouse and IT teams to support data integration across systems (e.g., EHR, external data sources).
• Document data sources, transformations, and report logic to support transparency and consistency.
• Serve as team lead on small to medium size cross-functional projects.
• Lead workgroups and conducts meetings.
• Evaluate, research and recommend reporting tools, data models, and processes to improve data accessibility and decision-making, with a focus on the Agency’s systems, technology strategies and standards.
• Other duties as assigned.

Benefits

• Medical Coverage
• Dental Coverage
• Vision Coverage
• $2,000 to individual, and $4,000 to family, HSA accounts, pro-rated to your benefits start date.
• FREE General Medicine and Behavioral Health Teladoc services provided to all team members.
• Ascensus 401K plan services with a 4% employer match, vested at 100% on day one of eligibility.
• $2,500 Sign-on Bonus for first-time employees with MFS! ($1,250 on the first paycheck and $1,250 after 6 months of employment).

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Number of Employees: 251-500 employees