CCBHC Business Intelligence Analyst

Metropolitan Family Services • Merrionette Park, IL

18h • Onsite

About The Position

Metropolitan Family Services (MFS) is seeking a Business Intelligence Analyst to join their team at the Merrionette Park Office. MFS is an organization dedicated to empowering families to learn, earn, heal, and thrive, with a strong emphasis on community. Since 1857, MFS has been a driving force for change, helping families reach their full potential and positively impact their communities. This role offers an opportunity to make a significant impact beyond a company's bottom line.

Requirements

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

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.

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.
• 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
• Metropolitan Family Services contributions of $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