CCBHC Business Intelligence Analyst

Metropolitan Family ServicesMerrionette Park, IL
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).
© 2026 Teal Labs, Inc
Privacy PolicyTerms of Service