Job Details

Data Architect

Position Number: 6403225
Location: Salt Lake City, UT
Position Type: Computing - Database Administration

Data Architect

Job Summary

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.

The Data Architect will play a key role in designing and maintaining secure, scalable, and high-performance data infrastructure that supports the full range of research and operational activities at the Utah DCC. This includes developing and orchestrating modern data pipelines, integrating systems across research domains, and ensuring alignment with performance, security, and compliance standards. The Data Architect will lead the modernization of legacy data workflows to cloud-native architecture and evaluate emerging tools and frameworks to support future-state infrastructure. This role offers the opportunity to work on diverse, high-impact projects in collaboration with software engineers, research faculty, and external partners. It is a growth-oriented position within a defined technical career ladder, with opportunities to expand architectural leadership over time.

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

Additional benefits information is available at www.hr.utah.edu/benefits

Work Environment and Level of Frequency typically required
Nearly Continuously: Office environment.
Physical Requirements and Level of Frequency that may be required
Nearly Continuously: Sitting, hearing, listening, talking.
Often: Repetitive hand motion (such as typing), walking.
Seldom: Bending, reaching overhead.

Responsibilities
As a Data Architect, your responsibilities will include:

Data Architecture: The Data Architect will 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.
Data Security: 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.

This job description has been designed to indicate the general nature and level of work performed by employees within this classification. It is not designed to contain or be interpreted as a comprehensive inventory of all duties, responsibilities and qualifications required of employees assigned to the job.

Minimum Qualifications
Requires a bachelor's degree or equivalency (one year of education can be substituted for two years of related work experience) in a related area and 2-4 years of experience in the field or in a related area.

Applicants must demonstrate the potential ability to perform the essential functions of the job as outlined in the position description.

Preferences
We will give preference to candidates with the following qualifications:

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.

Special Instructions

Requisition Number: PRN42622B
Full Time or Part Time? Full Time
Work Schedule Summary: Monday-Friday; 8:30am - 5:30 pm
Department: 02228 - Data Coordinating Center
Location: Campus
Pay Rate Range: 60700 to 109649
Close Date: 10/22/2025
Open Until Filled:

To apply, visit https://utah.peopleadmin.com/postings/186063