Data Architect Staff Specialist

Apply Now

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 Michigan Data Collaborative (MDC) Data Architect designs and constructs relational databases and data warehouses, develops and maintains data models, and manages data acquisition, access design, and strategies for data archiving, recovery, and loading. The architect ensures the integration and consistency of new data sources with existing warehouse structures, reviews business data needs, and research opportunities for improved data quality, feeds, and system performance. In addition, they support continuous improvement initiatives to enhance performance, scalability, and functionality of MDC's data systems and reporting services. With more than eight years of professional experience, the Data Architect applies comprehensive technical expertise and well-developed leadership skills to plan, conduct, and supervise complex or concurrent projects. Operating with considerable independence and decision-making authority, the individual plays a critical role in shaping MDC's data architecture, advancing analytical capabilities, and enabling data-driven insights that significantly impact organizational operations. The Data Architect will work under the supervision of the team manager. Under FLSA, this is the exempt job classification for this title. Incumbents in this position must meet the full criteria for exempt status: salary level, salary basis, and duties tests.

Supervision Received

This position will report to the Michigan Data Collaborative Tech Team Manager within the Enterprise Data and Information Services (EDIS) Division of Health Information Technology & Services (HITS).  
 

Responsibilities*

  • Design and construct relational databases and data warehouses for the Michigan Data Collaborative (MDC).
  • Develop and maintain data models; manage data acquisition, access analysis and design, as well as archiving, recovery, and load strategies and implementation.
  • Coordinate new data development to ensure consistency, quality, and integration with existing warehouse structures and reporting environments.
  • Review business requests for data and data usage; research and evaluate data sources to identify opportunities for improved data quality, new data feeds, and enhanced performance.
  • Drive continuous improvement efforts to enhance data system scalability, functionality, and overall reporting capabilities.
  • Apply advanced technical expertise and leadership to plan, conduct, and supervise complex or concurrent data architecture projects.
  • Exercise substantial independence and decision-making authority in shaping MDC's data architecture and enabling data-driven insights that support organizational goals.
     

Required Qualifications*

  • Bachelor's Degree in Computer Science, Information Systems or related field.
  • 8 years of professional experience in one or more of the following:
    • Designing, developing, and building data structures for databases, data warehouses, and/or data marts.
    • Collecting and loading data into data structures.
    • Defining and assessing input data formats and layouts.
  • Experience with data modeling, and design methodologies.
  • Maintaining and refreshing data loaded into data structures.
  • Performing data quality analysis and edit checking to ensure data is fit for use.
  • Experience working with and strong technical skills in Oracle database environments or other large RDBMS (i.e., MS SQL).
  • Experience working with Informatica or other enterprise level ETL technology.
  • Proven track record of delivering projects on time, in line with requirements, and with a high degree of accuracy.
  • Solid and effective written and oral communication skills and excellent analytic and problem-solving ability.
  • Ability to work effectively and collaboratively in a team environment while also being comfortable with independent tasks and projects; ability to dynamically shift priorities and approaches given emerging customers and team needs.
  • Experience with Microsoft Fabric, Data Factory, and Azure
     

Desired Qualifications*

  • Background in solution architecture and development in Microsoft Fabric leveraging Git and understanding DevOps cycle.
  • Experience working with healthcare data, including claims and clinical information, and familiarity with clinical coding systems such as ICD-10, HCPCS, CPT-4.
  • Familiarity with Collaborative Quality Initiatives (CQI) organizations, knowledge of population health concepts, and clinical, quality, utilization reporting methodologies.
  • Familiarity of data security concepts, especially around Protected Health Information (PHI) and HIPAA regulated data.
  • Ability to work with analysts, end users, clinicians, researchers, and others to identify and understand deliverable requirements; ability to present technical information to disparate audiences.
     

Modes of Work

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.

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 any time after the minimum posting period has ended.

U-M EEO Statement

The University of Michigan is an Equal Opportunity Employer. We are committed to providing an environment of mutual respect where equal employment opportunities are available to all applicants, including protected veterans and individuals with disabilities.