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.
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
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
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
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.
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.
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.
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.
The University of Michigan is an equal opportunity/affirmative action employer.
A great university is made so by its faculty and staff, and Michigan is recognized as one of the best universities to work for in the country. The Michigan culture is known for engaging faculty and staff in all facets of the university to create a workplace that is vibrant and stimulating.For two consecutive years, the Chronicle of Higher Education has placed U-M in its "Great Colleges to Work For..." survey. In particular, the university earns high marks for strong relations between faculty and administrators, a collaborative system of governance, strong pay and benefits, and a healthy work/life balance.