Apply Now Clicking "Apply Now" opens the link in a new window.

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 interest in the position and outline skills and experience that directly relate to this position.

Job Summary

Be part of the exciting and challenging Cost Analytics and Decision Intelligence project team at Michigan Medicine and have a direct impact on the tripartite missions of education, research and patient care! The HITS Data Reporting and Analytics department is seeking a qualified candidate who is excited to execute on our data management strategy ensuring rapid delivery of projects including developing and maintaining  ETL (Extract, Transform and Load) processes,  and delivery of analytical data sets. The qualified candidate would:

  • Assist with the design and delivery of data models which power Business Intelligence and Analytics initiatives, dashboards, scorecards and reporting for Michigan Medicine.
  • Design, develop, modify, test, document, and implement data warehouse data sets, reports, and queries. 
  • Design, develop, modify, test, document and implement data integration needs for applications and products.
  • Develop and follow established ETL(Extract, Transform and Load) development standards, methodologies, and best practices.
  • Become proficient in various ETL tools used to provide solutions. Work with others to continually refine a roadmap for ETL tools and processes based on changes in the marketplace.
  • Provide training, guidance, and assistance to staff to successfully accomplish objectives.  Provide content information for training and performance support.  Lead and participate in process improvement initiatives.
  • Collaborate with others to identify solutions that meet the needs of the customer and the organization.  Participate in planning; recommend priorities.  
  • Develop in-depth knowledge of business and administrative processes. 
  • Seek out learning opportunities relative to the position. Effectively communicate with management, co-workers, teams, business offices, and subject matter experts.
  • Participate on the investigation into emerging database technologies and infrastructure including big data handling, cloud environments, NoSQL databases and more.
  • Partner with or act as a consultant for other information services teams including software development, database services and delivery support.
  • Use APIs as data integration and data delivery methods

Required Qualifications*

  • Information Management, Computer Science, Engineering or related field Bachelor’s degree
  • 5 to 7 years of systems analysis/programming in a business environment experience
  • Minimum 2 years of experience in Epic Clarity
  • Minimum 2 years of experience in data management
  • Minimum 2 years of experience with streaming ETL tools such as Pentaho or Informatica Powercenter
  • Experience with data modeling tools such as ER/Studio
  • Understand dimensional and normalized data structure
  • Experience with analytics, reporting and business intelligence initiatives
  • Experience with relational database systems such as Oracle or Microsoft Sql Server
  • Experience in metadata management
  • Experience with determining project objectives and requirements, anticipating and solving problems, and developing standards and guidelines for diverse activities
  • Excellent organizational, research, analytical and independent problem-solving skills
  • Team player with excellent written and verbal communication skills and the ability to collaborate with cross-functional teams
  • Demonstrated ability to learn quickly, and to understand technical information and communicate it to others using clear, concise and user-friendly language
  • Demonstrated ability to approach information management efforts from both technical and business perspectives

Desired Qualifications*

  • Information Management, Computer Science, Engineering or related field Master's degree
  • Experience with agile development or other project management methodologies
  • Experience with other database technologies such as MongoDB, RDF, NoSQL and multi-dimensional cubes
  • Experience with development processes and tools, such as Eclipse, version control systems, test-driven development and build tools
  • Experience with facilitating group discussions and other collaborative efforts
  • Experience in the healthcare or pharma industry
  • Experience with Epic Clarity data architecture

Work Schedule

  • Punctual, regular, and consistent attendance is required.
  • Requires on-call availability on team rotation outside of normal working hours.
  • Requires working during non-business hours and on weekends.
  • Requires maintaining own high-speed residential internet connectivity service.

Work Locations

The primary location is the NCRC and Michigan House buildings of Ann Arbor, Michigan.

May require commuting to various locations on and off campus.

Background Screening

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.

Mission Statement

Michigan Medicine improves the health of patients, populations and communities through excellence in education, patient care, community service, research and technology development, and through leadership activities in Michigan, nationally and internationally.  Our mission is guided by our Strategic Principles and has three critical components; patient care, education and research that together enhance our contribution to society.

Application Deadline

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.