> Markdown version of [/jobs/ext/4800099-data-architect](https://www.wearedevelopers.com/jobs/ext/4800099-data-architect). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Data Architect - **Company:** University of Michigan - **Location:** Ann Arbor, MI, United States (Remote available) - **Experience:** Expert - **Contract:** Temporary contract - **Skills:** Data Analysis, Microsoft Azure, Hospital Information Systems, Information Systems, Databases, Data Architecture, Extract Transform Load (ETL), Data Mart, Data Security, Data Structures, Data Systems, Data Warehousing, Relational Databases, DevOps, Health Information Technology, Microsoft SQL Server, Oracle Databases, Enterprise Data Management, Git, Usage Tracking, Microsoft Fabric, Information Technology - **Published:** November 20, 2026 - **Apply:** https://careers.umich.edu/job_detail/apply/285772 ## About the Role * 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, * 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. ## Description 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., 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.