CCBHC Business Intelligence Analyst

Job Description

Job Description

If asked to describe the culture at Metropolitan Family Services, we could do that in one word. COMMUNITY ! Reflected in both our internal culture as well as through the services we provide, community is at the heart of all we do.

Metropolitan Family Services (MFS) empowers families to learn, to earn, to heal, to thrive. Part mentor, part motivator, part advocate, since 1857, Metropolitan Family Services has been the engine of change that empowers families to reach their greatest potential and positively impact their communities. Are you looking to have an impact on more than just a company’s bottom line? Then we’d love to hear from you!

We are currently looking to fill a Business Intelligence Analyst hybrid role located out of our Headquarters at 101 N. Wacker Dr. Chicago, IL 60606.

SALARY:

• The average starting salary for this position will fall in the range of $70,000 and $80,000 annually. Where candidates fall in this range will be based on skill and experience level.

$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).

ESSENTIAL JOB FUNCTIONS:

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

KNOWLEDGE, SKILLS, and ABILITIES:

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

QUALIFICATIONS:

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

ADDITIONAL REQUIREMENTS:

• Satisfactorily pass all relevant screening and criminal background checks.

TRANSPORTATION/TRAVEL REQUIREMENTS:

• Driving not required. No travel between sites.

PHYSICAL DEMANDS

• While performing the essential duties of this job, the employee is required to sit and stand for sustained periods of time, frequently talk, hear, use hands and fingers to feel, handle, and operate objects or controls, and occasionally stand, bend, stretch, stoop, kneel and crouch. The employee is required to have close visual acuity to perform an activity such as preparing and analyzing data and figures, transcribing, and viewing a computer terminal.

Metropolitan Family Services puts our people first with a top-of-the-line benefits package. Find out more by clicking here !

Some highlights include:

• Medical Coverage, Dental Coverage, and 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.

And so much more! Make sure you click here to see the full suite of benefits offered!

MORE ABOUT US:

Metropolitan is Illinois' first comprehensive human services agency and reaches more than 122,970 individuals and families in Chicago, Evanston/Skokie, the southwest suburbs, and DuPage County with services promoting education, economic stability, emotional wellness, and empowerment.