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/Overview:

The Senior Data Engineer design, develops, tests, deploys and maintains database solutions supporting the analytic projects of the Quality Analytics team at University of Michigan Health.  In this role the candidate will engage in multiple projects to learn business processes, design, and construct the data structures, appropriate ETL, process automation to support Michigan Medicine reporting solutions. On an ongoing basis the candidate will contribute to improving solution stability, reliability, efficiency, and quality of all data processes. The Sr. Engineer will build cross functional relationships with analytic teams and business leaders to understand information needs, data flows, and data quality considerations for each project and will execute on these needs with minimal supervision. This role is part of the Quality Analytics team that integrates and manages multiple internal and external Healthcare datasets. 

About the Division: 

The Quality Analytics division is comprised of a diverse team of data management professionals, application developers, BI specialists, and both technical and clinical analysts focused on tackling tough questions with data and analytics. The Quality Analytics division efforts support Michigan Medicine in providing quality analytics and information that assists leaders at all levels in identifying, assessing, and monitoring key metrics to improve healthcare.  Members of the team work together collaboratively to tackle some of healthcare's biggest challenges in the areas of change management, population health, ambulatory and inpatient care delivery at one of the top Medical Centers in the country. 

This department employs a work remote first policy. Office and meeting space within the health system is available as needed. Remote work is supported and encouraged as appropriate.

Organizational Relationships:

• Directly responsible to the Team Lead and the Manager of the Quality Analytics Database Team.
• May mentor junior staff members and/or students.
• Maintain collaborative team-focused relationships with support, clinical and administrative staff within the UMHS and external agencies as appropriate.

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.

Michigan Medicine is one of the largest health care complexes in the world and has been the site of many groundbreaking medical and technological advancements since the opening of the U-M Medical School in 1850. Michigan Medicine is comprised of over 30,000 employees and our vision is to attract, inspire, and develop outstanding people in medicine, sciences, and healthcare to become one of the world’s most distinguished academic health systems.  In some way, great or small, every person here helps to advance this world-class institution. Work at Michigan Medicine and become a victor for the greater good.

What Benefits can you Look Forward to?

• Excellent medical, dental and vision coverage effective on your very first day
• 2:1 Match on retirement savings

70%

• Design, develop and test database objects utilizing PL/SQL and ETL tools to allow for efficient and effective analysis and reporting of data.
• Develop data models, data acquisition, and data loading plans.
• Design and build complex processes and structures to evaluate the integrity, accuracy, and completeness of a variety of data sources used in quality reporting.
• Work with clinical analysts and business analysts to ensure that database programming, design and processes meet the needs for reporting and analysis.
• Evaluate and incorporate appropriate technologies and tools to meet project requirements.

20%

• Define and conduct validation to ensure data quality, accuracy and integrity.
• Propose and contribute to process improvements in data model design and efficiency for the team.
• Create standard documentation related to database management activities.
• Coordinate with other team members to plan and execute tasks according to key milestones.

10% 

• Communicate status of work to project leadership, project managers, and team members.
• Communicate potential risks, issues, and mitigation strategy to team members. 
• Other duties as assigned.

• Bachelor's degree in computer science, or related field or equivalent education and experience. 
• 3 - 5 years of experience in information technology, database design or data management.
• Data engineering and data warehousing experience designing and building data warehouses, data marts, ETL packages, data monitoring, etc.
• Proven Healthcare Data Architecture experience, including data management, and integration of multiple data sources.
• Programming/SQL/PLSQL experience.
• Experience with ETL tools (e.g., Informatica/SSIS).
• Strong customer service skills.
• Excellent analytical and problem-solving ability.
• Strong aptitude for debugging problems independently and tracing root causes.
• Excellent organizational skills and diligence.
• Flexibility to adapt to a changing environment.
• Excellent collaboration, interpersonal, meeting facilitation, presentation, written, listening, and verbal communication skills.
• Ability to work effectively and collaboratively across internal functional areas, with external partners, and with staff at all levels of the organization
• Committed to data security and the protection of sensitive information. 
• Ability to reliably attend virtual meetings.

• Experience with EPIC Systems (Clarity Data Model, Caboodle Data Warehouse).
• Oracle, SQL Server, Azure SQL Server experience.
• Experience with third-party health system data (e.g., CMS/Claims/Registries).
• XML, SAS experience.
• Master's degree in computer science, or related field.

Positions 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.

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. 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.

Job 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.

The University of Michigan is an equal employment opportunity employer.