Business Intelligence Analyst

Job SummaryOpportunity to join a dynamic and growing team building an ambitious and trailblazing project!The Michigan Emergency Department Improvement Collaborative (MEDIC, http://www.medicqi.org/) is a statewide quality improvement effort funded by Blue Cross Blue Shield of Michigan/Blue Care Network with the Coordinating Center housed at the University of Michigan. MEDIC?s vision is to support emergency physicians working together to improve patient care. MEDIC is part of a family of projects called Collaborative Quality Initiatives (CQIs) within the Value Partnerships program (http://www.valuepartnerships.com/), making health care work better across the state of Michigan. MEDIC focuses on care decisions made in the emergency department for children and adults. Working collaboratively with a network of partner hospitals, we leverage the MEDIC data registry with shared knowledge and experience of participating sites to provide timely feedback on quality performance measures to improve the care of our patients through dissemination and implementation of best practices. There are currently over 60 hospitals in the Collaborative with plans to continue expansion annually supported by an infrastructure of the MEDIC clinical data registry hosted by a third-party vendor.We are seeking a Data Manager who uses their impeccable attention to detail, critical thinking skills, and data administration knowledge to help take MEDIC?s work to the next level. This individual will act as a liaison with our third-party registry vendor and participating hospitals to ensure essential data streams are reliable, accurate, and displayed in an easy-to-comprehend manner. Additionally, this individual will take a lead role in managing MEDIC?s data projects including meeting deliverable schedule planning and coordination. This is a primarily remote position that will require occasional travel to the MEDIC office in Ann Arbor as well as infrequent statewide travel. We are looking for a stellar team member who will embrace our positive and flexible work culture and help us dive into all things data related!Responsibilities*Lead project management of MEDIC's internal weekly data meetings including but not limited to:Collecting and preparing weekly meeting agenda itemsCoordinating project follow-up with internal and external investigators as neededTracking status of new, ongoing, and closed projects including documented data use, storage, and deletionTaking and disseminating meeting notesCo-chair and project manage MEDIC's Data and Publications Committee along with our physician data lead including but not limited toManaging committee membership roster, expectations, and relevant committee guidelinesPartner with committee physician lead to ensure committee policies are maintained and new proposals are appropriately routed through the committee process for review and approvalWork with MEDIC administrator to schedule and manage agenda items for quarterly committee meetingsProvide project management of MEDIC's data centric work and analysisTrack and support data needs for MEDIC-related analyses from inception to publication to responsible destruction of dataHelp manage quarterly release updates with registry vendor for clinical abstraction platform and reports, including new feature and content development, JIRA ticket creation, iterative content refinement, error testing, validation, and approvalResponsible for monthly data upload process for each of our 60+ sites, including data cleansing, troubleshooting, and interfacing with our registry vendorConduct an annual data auditCollaborate with new and existing sites; IT contacts to create and/or update electronic data filesResolve ad-hoc data issues and requestsAssist the MEDIC project team in measure development and improvement of data analysis policies and proceduresHelp design and edit clinical abstraction modules for existing and future quality improvement initiatives, with a focus on the input and output of dataAssist with technical design, testing, and validation of new and existing Tableau reports including documentation of issues and resolutionsManage access and permissions to a variety of internal and external user platforms (i.e., shared drives, Tableau, etc.)Responsible for documentation and maintenance of all data-related policies and proceduresOther duties as assignedRequired Qualifications*A bachelor's degree Critical thinking skills as demonstrated by the ability to identify data errors and patternsProven analytical skills that allow the individual to suggest plausible root causes and offer solutions for increasing accuracy of the dataAbility to handle confidential information with care and adhere to HIPAA guidelines for information disseminationProven skill and interest in acting as a project management lead for data projectsCreative and flexible approach to continuous improvementAbility to work independently while handling multiple assignments and deadlinesValues collaborative teamwork, can be flexible and successful working in a small, highly motivated teamStrong written and verbal communication skillsProficiency in Microsoft Office softwareSuccessful experience in collaboration with others in a team environmentStrong interpersonal skills and ability to successfully work with all levels of faculty and staffAbility to travel within the state of Michigan for collaborative-wide meetings 3 times per year (various locations such as Traverse City, Grand Rapids, Detroit, etc.)Senior - Minimum 5 Years Of Applicable Work ExperienceIntermediate - Minimum 3 years of applicable work experienceDesired Qualifications*Proficiency in T-SQL, ability to understand Python (data manipulation & automation) and Excel VBA, with the willingness and excitement to expand upon those skills to create their own code to solve questionsExperience with the following software: Microsoft SQL Server Management Studio, Tableau, JIRA, Zendesk, SharePoint, Microsoft Power PlatformExperience with ETL processes and tools for building and maintaining healthcare data pipelinesFamiliarity with healthcare data, including ICD-10 codes and CPT codesWork LocationsNote: This position is primarily remote, with occasional in-person work in Ann Arbor, MI required.Modes of WorkPositions that are eligible for hybrid or mobile/remote work mode are at the discretion of the hiring department. Work agreements are reviewed annually at a minimum and are subject to change at any time, and for any reason, throughout the course of employment. Learn more about the work modes.Underfill StatementThis position may be underfilled at a lower classification depending on the qualifications of the selected candidate.Background ScreeningMichigan Medicine conducts background screening and pre-employment drug testing on job candidates upon acceptance of a contingent job offer and may use a third party administrator to conduct background screenings. Background screenings are performed in compliance with the Fair Credit Report Act. Pre-employment drug testing applies to all selected candidates, including new or additional faculty and staff appointments, as well as transfers from other U-M campuses.Application DeadlineJob openings are posted for a minimum of seven calendar days. The review and selection process may begin as early as the eighth day after posting. This opening may be removed from posting boards and filled anytime after the minimum posting period has ended.U-M EEO StatementThe University of Michigan is an equal employment opportunity employer.