What are the responsibilities and job description for the Lead Business Intelligence Analyst, Full Time - Days position at University of Chicago Medicine?
Job Description
Be a part of a world-class academic healthcare system at UChicago Medicine as a Business 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.
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 prefered) 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 prefered) report-development experience, leveraging the most current BI tools (Tableau minimum, others applicable)
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: Burr Ridge, IL or Hyde Park, IL when requred to come onsite (as needed)
- Unit/Department: Finance, Managed Care
- CBA Code: Non-Union
Why Join Us
We’ve been at the forefront of medicine since 1899. We provide superior healthcare with compassion, always mindful that each patient is a person, an individual. To accomplish this, we need employees with passion, talent and commitment… with patients and with each other. We’re in this together: working to advance medical innovation, serve the health needs of the community, and move our collective knowledge forward. If you’d like to add enriching human life to your profile, UChicago Medicine is for you. Here at the forefront, we’re doing work that really matters. Join us. Bring your passion.
UChicago Medicine is growing; discover how you can be a part of this pursuit of excellence at: UChicago Medicine Career Opportunities.
UChicago Medicine is an equal opportunity employer. We evaluate qualified applicants without regard to race, color, ethnicity, ancestry, sex, sexual orientation, gender identity, marital status, civil union status, parental status, religion, national origin, age, disability, veteran status and other legally protected characteristics.
Must comply with UChicago Medicine’s COVID-19 Vaccination requirement as a condition of employment. If you have already received the vaccination, you must provide proof as part of the pre-employment process. This is in addition to your compliance with the Flu Vaccination requirement as well. Medical and religious exemptions will be considered consistent with applicable law. Lastly, a pre-employment physical, drug screening, and background check are also required for all employees prior to hire.
Compensation & Benefits Overview
UChicago Medicine is committed to transparency in compensation and benefits. The pay range provided reflects the anticipated wage or salary reasonably expected to be offered for the position.
The pay range is based on a full-time equivalent (1.0 FTE) and is reflective of current market data, reviewed on an annual basis. Compensation offered at the time of hire will vary based on candidate qualifications and experience and organizational considerations, such as internal equity. Pay ranges for employees subject to Collective Bargaining Agreements are negotiated by the medical center and their respective union.
Review the full complement of benefit options for eligible roles at Benefits - UChicago Medicine.
Salary : $116,100 - $154,800
