CCBHC Business Intelligence Analyst

Metropolitan Family Services • Chicago, IL

18d • $70,000 - $80,000 • Hybrid

About The Position

Metropolitan Family Services (MFS) is seeking a Business Intelligence Analyst for a hybrid role based at their Headquarters in Chicago, IL. MFS is an established human services agency focused on empowering families to learn, earn, heal, and thrive. This role is crucial for providing data-driven insights to support the agency's mission and operations, particularly in areas like healthcare quality and regulatory reporting.

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

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 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 a 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