Lead Business Intelligence Analyst, Full Time - Days

Be a part of a world-class academic healthcare system at UChicago Medicine as aBusiness Intelligence - Value Based Care Analyst for the Finance Managed Care department. This position is a hybrid remote opportunity with occasional requirements to come in off at our Burr Ridge or Hyde Park locations. Healthcare experience strongly preferred.

The Business Intelligence - Value Based Care Analyst will be responsible for key financial performance and operational analyses to support development and implementation of new and current Value Based Care (VBC) health care delivery system models. Under general direction, is accountable for the accuracy, integrity of system-level data for the entirety of the reporting life-cycle. Develops Organization/System-wide reporting and presents work and guiding executive decision making as it relates to data quality and improvement efforts across the network. Will serve in the lead role to develop reporting for VBC arrangements and establish key metrics around quality, gaps in care, risk adjustment, utilization trends and leakage that can be made actionable for the clinical teams to identify performance improvement opportunities and key initiatives to manage the quality, outcomes and costs for selected populations and programs. Under the direction of the Director, Value Based Payment Models, the technical services may include: data modeling, ETL design and development, master data management, data quality and data governance. Develops and maintains stored procedures leveraging production-level data required for the sustainment of reporting. Collaborates with interdisciplinary teams across the care continuum and is a steward of data and data best practices. Has a full technical knowledge of the data sources and systems across the UCM network. Owns report and analytic development for the whole life cycle. Will present findings to senior level management. Must be highly skilled in Tableau development and automation.

Essential Job Functions:

• Works in collaboration with Report Sponsors to meet the needs and specifications of reporting requests. Create complex reporting suites that provide insight for the purpose of action and improvement and maintain dashboard generator to support wide use/distribution. Anticipates the potential future needs of the report in order to incorporate those in advance.
• Manipulate data from source systems in order to define rules for reporting. Must be able to combine data from many disparate sources to include spreadsheets, flat files, payer portals, Electronic Medical Records, and EDW/UDP databases. This includes cleansing of data and datasets necessary for the creation of data marts, tables, and Tableau data extracts.
• Develop and own the rules necessary in order to diagnose the health and stability of system-wide reports and measures, support and troubleshoot data hygiene, and work with partnering teams on identifying data hygiene issue resolution.
• Creation of measures for reporting purposes. This includes defining populations (inclusion and exclusion criteria), appropriate variance of performance, setting organization targets.
• Leading responsible work through to completion. Working with interdisciplinary teams to continue large scale projects and insure the timely completion of work. Ability to hold oneself and others accountable for responsibilities as assigned. Must be able to present work and findings, as well as make recommendations for the best course of action to those in leadership roles.
• Maintain an appropriate portfolio of work. Updating reports and queries to match the most appropriate specifications and versions of technology available. Use job scheduling and Tableau extract creation scheduling to automate reports as appropriate.

Required Qualifications:

• Bachelor's Degree required in Mathematics, IT, Computer Science, Industrial Engineering, business decision support/statistical analysis, healthcare administration or a clinically associated health care field with strong statistical analysis. Master’s Degree preferred

• Minimum 3-5 years (5-7 years preferred) directly applicable experience in data systems, analysis, programming and technical design in a healthcare setting, programming in one or more language (SQL minimum, others applicable), with background in payer claims and sourcing data EDWs and EMRs.

• Minimum 3-5 (5-7 years preferred) report-development experience, leveraging the most current BI tools (Tableau minimum, others applicable)

• Healthcare experience strongly preferred

• Experience with project management and demonstrate proven project management skills

• Demonstrated ability to identify areas for improvement, capable of making recommendations and implementing solution.

• Demonstrated ability to lead group discussions.

• Demonstrated skills in conflict resolution

• Must work well in a team environment and be able to partner with both business and technical team members and translate technical language to the non-technical need

• Demonstrated ability to self-direct, multi-task and partner with technical staff from different departments.

• Ability to work remotely as business needs require while remaining an engaged member of a team.

• Strong organizational and consensus building skills.

• Requires technical creativity and strong understanding of information technology in health care.

• Demonstrated ability for public speaking

• Knowledge and application of the principles of continuous improvement including methodologies, data collection and analysis, and reporting.

• Advanced skill in the most current BI tools - especially Tableau.

• Demonstrated advanced technical skill and knowledge of data systems and query languages.

• technical creativity and strong understanding of information technology in health care.

• knowledge of regulatory and accreditation standards such as CMS Conditions of Participation, IDPH, MACRA and others as needed.

Position Details:

• Job Type/FTE: Full Time (1.0FTE)
• Shift: Days Monday-Friday
• Location: Full Time- Remote- Location, Burr Ridge, IL or Hyde Park, IL when required to come onsite (as needed)
• Unit/Department: Finance, Managed Care
• CBA Code: Non-Union