Job Description

Job Summary
Data Architects
This position is in the Utah Data Coordinating Center. Join the Utah DCC where we harness the power of collaboration, to advance science, move society, and benefit humanity. We offer opportunities to work with high functioning, cutting-edge teams that study, understand, and improve multi-site research. Bring your strong background in regulatory affairs to the Utah DCC. Autonomy, creativity, and critical thinking skills are strongly encouraged.

Join the Utah Data Coordinating Center (DCC) as a Data Architect, where your work will directly enable innovative clinical research at the University of Utah and across national partners. You’ll lead the design of scalable data systems, define and enforce architecture standards, and work alongside software developers, data analysts, and research teams to ensure our platforms evolve with the needs of scientific discovery. This is a growth-focused role ideal for someone who thrives in a collaborative, mission-driven environment. The Utah DCC supports large-scale health data infrastructure that underpins national emergency response, clinical registries, and federal research initiatives.

Establish project teams and provide overall direction for technical projects from initiation through to delivery. Perform project requirements, estimation, and budget management. Formulate project scope and delivery strategies and establish milestones/schedules. Maintain and report project status and monitor progress of all team members. Gather required data from end-users to evaluate objectives, goals, and scope to create technical specifications. Serve as liaison between technical and non-technical departments in order to ensure that all targets and requirements are met. Keep leadership informed of key issues that may impact project completion, budget, or other results.

The Utah DCC offers a career ladder for Data Architects and provides growth and professional development opportunities.

To learn more about the Utah DCC visit http://uofuhealth.org/UtahDCC

Work Environment and Level of Frequency
Often: Office environment
Seldom: Outdoor environment, extreme cold, extreme heat, noise (there is sufficient noise to cause you to shout in order to be heard above the noise level), atmospheric conditions (conditions that affect the respiratory system, such as fumes, odors, dusts, mists, gases, or poor ventilation) and close quarters

Physical Requirements and Level of Frequency that may be required
Nearly continuously: Repetitive hand motion (such as typing), hearing, listening, talking, walking
Often: Sitting, bending, twisting
Seldom: Repetitive foot motion, climbing, kneeling, squatting, crawling, balancing, reaching overhead, pulling, pushing

The University of Utah offers a comprehensive benefits package including:

Excellent health care coverage at affordable rates
14.2% retirement contributions that vest immediately
Generous paid leave time
11 paid Holidays
50% tuition reduction for employee, spouse, and dependent children
Flex spending accounts
Free transit on most UTA services
Employee discounts on a variety of products and services including cell phones & plans, entertainment, health and fitness, restaurants, retail, and travel
Professional development opportunities

Learn more about the great benefits of working for University of Utah: benefits.utah.edu

This is posted as open-rank and may be filled at any of the listed job levels.

Responsibilities
Design, deploy, and manage the organization’s data architecture. Collaborate with technology and management teams to understand structural requirements and define standards for how data will be stored, consumed, integrated, and managed across the organization and translate into a usable blueprint. Build an inventory of data needed to implement architecture and create a vision for how data will flow through the organization. Design and build complex data models, approve modifications, and implement systems. Implement measures to ensure data accuracy and accessibility, constantly monitoring and refining the performance of data management systems. Produce and enforce database development standards. Possess strong understanding of data modeling tools and standards, ETL tools, and big data technologies (e.g., Hadoop, Spark, Pig, NoSQL).

Essential Functions:
As a Data Architect, your responsibilities will include:
Design, develop, and orchestrate reliable, scalable, and secure data pipelines from initial data extraction to final delivery. This includes data pipeline development and orchestration as well as data modeling.
Developing and Maintaining ETL processes (SSIS): The role involves designing, developing, and maintaining ETL processes. This includes extracting data from various sources, transforming it according to business logic, and loading it into data warehouses or other storage solutions.
Writing Ad-Hoc Queries and Stored Procedures (T-SQL): The role requires proficiency in writing T-SQL queries to retrieve and analyze data and stored procedures. This includes writing complex queries for ad-hoc data requests, optimizing query and stored procedure performance, and ensuring data integrity.
Work with our operations team to help establish and enforce data security measures to ensure data meets compliance and regulatory standards and protects sensitive information.
Troubleshooting and Performance Optimization: The Data Architect will monitor and optimize the performance of ETL processes, resolving any problems that arise during data processing pipelines
Collecting Requirements and Documenting Processes: A key part of the role is liaising with business stakeholders to gather and understand their data storage requirements. This includes documenting business processes, data needs, and data pipeline specifications and communicating these requirements to other relevant team members for implementation.
The department may choose to hire at any of the below job levels and associated pay rates based on their business need and budget.

Data Architect, I
Requires basic skill set and proficiency. Conduct work assignments as directed. Closely supervised with little latitude for independent judgment.

This is an Entry-Level position in the General Professional track.
Expected Pay Range: $61,599 to $84,197

Data Architect, II
Requires moderate skill set and proficiency in discipline. Conduct work assignments of increasing complexity, under moderate supervision with some latitude for independent judgment.

This is a Developing-Level position in the General Professional track.
Expected Pay Range: $74,535 to $101,879

Data Architect, III
Considered highly skilled and proficient in discipline. Conduct complex, important work under minimal supervision and with wide latitude for independent judgment.

This is a Career-Level position in the General Professional track.
Expected Pay Range: $81,983 to $112,068
Minimum Qualifications
EQUIVALENCY STATEMENT: 1 year of higher education can be substituted for 1 year of directly related work experience (Example: bachelor’s degree = 4 years of directly related work experience).

Department may hire employee at one of the following job levels:

Data Architect, I: Requires a bachelor’s (or equivalency) + 2 years of directly related work experience or a master’s (or equivalency) degree.

Data Architect, II: Requires a bachelor’s (or equivalency) + 4 years or a master’s (or equivalency) + 2 years of directly related work experience.

Data Architect, III: Requires a bachelor’s (or equivalency) + 6 years or a master’s (or equivalency) + 4 years of directly related work experience.



Preferences
Familiarity with AWS (Glue, S3, EC2)
Experience with different versions of Microsoft SQL Server (T-SQL)
Development experience with Python (Pandas, Boto3, PySpark)
Experience with version control systems (Git)
Ability to read/understand Java is a plus
Experience using Jenkins
Experience with data visualization tools (Tableau, SSRS, Power BI)
Background in data warehouse design (Star/Snowflake Schema)
In-depth understanding of database management systems, OLAP and ETL frameworks
Excellent analytical, problem-solving, and innovative thinking skills
Strong ability to explain advanced data concepts to fellow developers as well as non- technical end users
Demonstrated ability to meet deadlines, balance multiple priorities, and ensure quality standards based on an Agile development process.
Applicants will be screened according to preferences.