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

The HITS Data, Reporting & Analytics (DRA) division collaborates with partners throughout Michigan Medicine, the U-M, and the state of Michigan, to create data resources which can be used across the enterprises.  Their work enables enterprise analytics which supports strategic, data-driven decisions by leaders, researchers, clinicians, educators, and administrators.  DRA provides services across the clinical, education, research, and administrative mission domains and is organized around the following core capabilities:  Data Foundations, Analytics, Health Information Exchange, Enterprise Data Solutions, and the Michigan Data Collaborative.

 

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! HITS Data Reporting and Analytics 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:

  • Be responsible for configuring, troubleshooting and maintaining vendor ETL and Data Warehouse tools
  • Be responsible for configuring, maintaining, and enhancing data source feeds to and from vendor data warehouse
  • 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
  • Create and follow ETL development standards, methodologies, and best practices
  • Become proficient in various ETL tools used to provide solutions
  • 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
  • Partner with, or act as, a consultant for other information services teams including software development, database services, and delivery support

    Required Qualifications*

    Requirements for Senior Position:

    • Information Management, Computer Science, Engineering or related field Bachelor’s or Master’s degree
    • Minimum 5-7 years of experience in data management
    • Experience with ETL tools
    • Experience with data modeling
    • Familiarity with healthcare and/or financial data
    • Familiarity with dimensional and normalized data structures
    • 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

    Requirements for Intermediate Position:

    • Information Management, Computer Science, Engineering or related field Bachelor’s or Master’s degree
    • Minimum 3-5 years of experience in data management
    • Experience with ETL tools
    • Experience with data modeling
    • Familiarity with healthcare and/or financial data
    • Familiarity with dimensional and normalized data structures
    • 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*

    • Experience with Epic Clarity data model
    • Experience with data modeling tools such as ER/Studio
    • Experience with Informatica
    • 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, version control systems, test?driven development
    • Experience with facilitating group discussions and other collaborative efforts
    • Experience in the healthcare industry
    • Experience in the finance 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.

    Underfill Statement

    This position may be underfilled at a lower classification depending on the qualifications of the selected candidate.

    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.