How to Apply
A cover letter is required for consideration for this position and should be attached as the first page of your resume. The cover letter should address your specific interests in the position and outline skills and experience that directly relate to this position.
Develops, tests and executes complex database queries to mine and analyze potential professional liability claims, patient complaints and grievances, clinical safety reports, phone calls and all incidents reported to Patient Relations & Clinical Risk (PCRC) for the purpose of system improvement and sharing of lessons learned. Ensures data integrity, reliability and quality. Develops and maintains relevant documentation, including metadata. Successfully identifies and resolves gaps between end users’ data requests and data output. Utilizes ODBC to access and query data from multiple sources. Integrates and analyzes data from disparate clinical and administrative sources. Provides data analysis support to leadership and key customers in the health system. Creates reports and executive summaries for top leadership on aggregate trends and opportunities for improvement. Creates dashboard reports using Tableau. Designs, implements and maintains data dashboards on secure website. Investigates, recommends and implements new technology to best meet departmental and institutional objectives.
Conduct educational training to medical, nursing and support staff on clinical safety reporting and review workflow.
Database development and web design, including implementation and maintenance for both. Create and maintain databases as needed to support departmental interests and projects. Provide technological expertise and support for PCRC projects. Other duties as assigned.
Bachelor’s or Associate degree in computer science, information systems, or similar discipline. A minimum of 3 years’ experience in a healthcare-related field. Two or more years of experience in using SQL to query MS SQL and Oracle databases. Two or more years of experience utilizing ODBC to access and query data from multiple sources. Two or more years of experience with a business intelligence tool, such as Business Objects. Two or more years of experience in designing, developing, and delivering reports for end users using Tableau and Crystal Reports. Experience with gathering, elucidating and validating data and information requirements. Proficiency in data manipulation and extraction techniques. Proficiency in using Microsoft Office, including MS Access and Excel. Experience with Java, HTML, XML and Visual Basic. Experience and skills in the development and management of relational databases and websites.
Candidate must have the ability to communicate skillfully and concisely, both verbally and in writing with both technical and non-technical audiences. Problem-solving, critical thinking and strong organizational skills are also required. Ability to manage multiple competing priorities with competing data needs. Knowledge of process improvement/the PDCA cycle and/or Lean principles.
Experience with data warehouse, analytics, reporting, and business intelligence initiatives. Applied experience developing for multiple desktop and mobile browsers. Experience with and knowledge of security issues related to web applications. Experience with and knowledge of accessibility requirements for web applications. Experience with best practices in web development, technical programming, and database development. Training and experience in statistical methods and computing, including predictive modeling. Experience with statistical packages (such as SAS, SPSS) and advanced Excel. Experience with data visualization and reporting tools such as RL Solutions, Tableau, Business Objects, Crystal Reports. Knowledge of Qualtrics.
Enthusiasm and self-initiative for making a difference in the level of quality care the University of Michigan Health System delivers.
Michigan 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.
Job openings are posted for a minimum of seven calendar days. This job may be removed from posting boards and filled anytime after the minimum posting period has ended.
U-M EEO/AA Statement
The University of Michigan is an equal opportunity/affirmative action employer.