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.
 

Who Are We

The HITS Enterprise Data & Information Services (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.

The Data Integration and Architecture (DIA) Team at Michigan Medicine is seeking a candidate to fulfill the role of Data Architect. The Data Integration and Architecture team designs, develops, and supports data pipelines to enterprise data stores.

Health Information Technology & Services (HITS) plays a role in the success of Michigan Medicine by providing clinicians, educators, researchers, students, and staff with technology-related information, products, and support. HITS also provides institutional expertise related to IT strategy, security, infrastructure, and resource management. 

Health Information Technology and Services (HITS) at the U-M Michigan Medicine has an exciting opportunity for a Data Architect Intermediate on its Enterprise Data and Information Services (EDIS), Data Integration and Architecture Team.  EDIS 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 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 APIs, Restful APIs, Cloud services.

• 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 DBAs on best practices for all of our solutions.

• Bachelor's degree in a related field and/or equivalent combination of education, certification and experience.
• 2-3 years of IT related experience.
• Experience working closely with, or as a member of, enterprise data warehousing teams.
• Excellent analytical and creative problem-solving skills.
• Solid and effective written, interpersonal, and verbal communication skills.
• Strong organizational skills with attention to detail.
• Able to work on multiple priorities in a deadline-driven environment.
• Strong SQL programming language skills.

• 2 or more years of demonstrated experience in a related role requiring confidentiality, timeliness, customer service, organization, prioritization, troubleshooting, and working independently.
• 2 or more years of experience with the full software lifecycle of system implementation including requirements analysis, design, implementation, quality assurance testing and documentation.
• Experience building new data models while ensuring consistency and integration with mature warehouse structure.
• Experience building data integration solutions that leverage restful APIs or message-based technology.
• Experience with scripting and/or object-oriented programming languages.
• Experience using ETL development platforms like Informatica or MS SSIS.
• Experience working with Azure SaaS or PaaS Cloud service offerings.
• Experience in one or more disciplines such as Health Care, Financial, Human Resources, Student Administration, and Sponsored Research.
• Familiarity with Enterprise Resource Planning (ERP) and Enterprise Medical Record (EMR) solutions.
• Ability to work effectively with management, team members, and colleagues from other departments and projects.
• Experience developing on Oracle and SQL Database platforms.
• Knowledge of data warehouse design concepts.
• Knowledge of systems development methodologies including waterfall and agile approaches.
• Demonstrated skills in data analysis and process modeling tools and techniques.

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.

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.

Benefits

We offer a benefits package that includes comprehensive training and career development opportunities, generous retirement savings plans, ample paid time off, and a wealth of family care support: https://careers.umich.edu/benefits

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.