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.

Summary

Enterprise Data & Information Systems

The HITS Enterprise Data & Information Systems (EDIS) 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. EDIS 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, and Enterprise Data Solutions.

Health Information Technology and Services (HITS) at the U-M Michigan Medicine has an exciting opportunity for a Senior Data Architect on its Enterprise Data and Information Services (EDIS), Data Foundations Team. Data Foundations is responsible for supporting and building Michigan Medicine’s Enterprise Data Warehouse environment and application integration activities. Michigan Medicine’s Enterprise Data Warehouse serves as a vital conduit of information to leaders across the institution.

A candidate for this position should possess extensive experience in database design and development. That experience should include extracting, transforming, and loading (ETL) data between systems. The preferred candidate will have experience integrating data using a variety of approaches, that may include flat-file extracts, Enterprise Service Buses (ESB), ODBC API’s, Restful API’s.

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.

Why Join Michigan Medicine?

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

Michigan Medicine’s benefit package includes:

Excellent medical, dental, and vision coverage
Generous PTO and extended sick
2:1 retirement contribution
Tuition assistance

Responsibilities*

Gather requirements for the design and development of data structures and data extracts to support comprehensive data collection, loading, and extraction for complex analyses.
Model information in a way that customers can easily consume it.
Work with business analysts to develop key measures that drive University metrics.
Work with data experts to ensure that data is stored accurately.
Write SQL queries that validate the data is accurate and meets business requirements.
Design, build, and support ETL applications that meet our customer’s data needs.
Research and share discoveries about new technologies, frameworks, and architectural approaches to data integration and warehousing.
Actively monitor and respond to production support issues.
Proactively recommend application and architecture modifications that will improve the reliability, relevance, timeliness, completeness, and accuracy of the data we support.
Collaborate effectively with a team of business analysts, data architects, ETL developers, and DBA’s on best practices for all of our solutions.

Required Qualifications*

Senior Level:

Bachelor’s degree, or equivalent combination of education and experience
3-5 Years Professional Experience

Intermediate Level:

Bachelor’s degree, or equivalent combination of education and experience
1-3 Years Professional Experience

Desired Qualifications*

Minimum of 3-5 years of demonstrated experience in a related role requiring confidentiality, timeliness, customer service, organization, prioritization, troubleshooting, and working independently.
Minimum of 3-5 years of experience with the full software lifecycle of system implementation including requirements analysis, design, implementation, quality assurance testing and documentation.
Experience working closely with, or as a member of, enterprise data warehousing teams.
Excellent analytical and problem-solving skills.
Strong SQL programming language skills.
Able to work on multiple priorities in a deadline-driven environment.
Experience collaborating with data architects, ETL developers, report developers, database administrators, systems analysts, application software developers, vendors, and tech support personnel on the other.
Experience developing on Oracle and SQL Database platforms.
Knowledge of data warehouse design concepts.
Demonstrated skills in data analysis and process modeling tools and techniques
Experience in one or more disciplines such as Health Care, Financial, Human Resources, Student Administration, and Sponsored Research.
Familiarity with ERP and EMR solutions.
Experience building data integration solutions that leverage restful API’s or message-based technology.
Experience with scripting and/or object-oriented programming languages.
Experience working with SaaS or PaaS Cloud service offerings.
Experience using ETL development platforms like Informatica or MS SSIS.

Work Locations

This position is being made available with the ability for you to negotiate alternative work schedules and remote/on-site options to suit your work-life balance.

Non-Michigan residents should inquire about potential employment while working remotely in a state other than Michigan. Apply to be part of a strong team that partners with our institution, community, and each other.

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

Application Deadline

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.

Vaccine Requirements

COVID-19 vaccinations are required for all students, faculty and staff working in the following areas: Michigan Medicine including the Medical School, Dental School, University Health Service or the Mary A. Rackham Institute. This includes those working remotely and temporary workers. More information on this new policy is available on the U-M Health Response.

U-M EEO/AA Statement

The University of Michigan is an equal opportunity/affirmative action employer.

Job Opening ID

225310

Working Title

Data Architect Senior

Job Title

Data Architect Senior

Work Location

Michigan Medicine - Ann Arbor

Ann Arbor, MI

Full/Part Time

Full-Time

Regular/Temporary

Regular

FLSA Status

Exempt

Organizational Group

Exec Vp Med Affairs

Department

MM HITS EDIS Data Warehousing

Posting Begin/End Date

3/10/2023 - 3/24/2023

Career Interest

Information Technology

Suggested Searches