"Alerted.org

Details

**Open Date** 07/22/2025

**Requisition Number** PRN42622B

**Job Title** Data Architect

**Working Title** Data Architect

**Job Grade** G

**FLSA Code** Computer Employee

**Patient Sensitive Job Code?** No

**Standard Hours per Week** 40

**Full Time or Part Time?** Full Time

**Shift** Day

Work Schedule Summary

Monday-Friday; 8:30am – 5:30 pm

**VP Area** U of U Health - Academics

**Department** 02228 - Data Coordinating Center

**Location** Campus

**City** Salt Lake City, UT

**Type of Recruitment** External Posting

**Pay Rate Range** 60700 to 109649

**Close Date** 10/22/2025

Priority Review Date (Note - Posting may close at any time)

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:

1. 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.

2. 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.

3. 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.

4. 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.

5. 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

6. 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._

**Type** Benefited Staff

Special Instructions Summary

Additional Information

The University is a participating employer with Utah Retirement Systems (“URS”). Eligible new hires with prior URS service, may elect to enroll in URS if they make the election before they become eligible for retirement (usually the first day of work). Contact Human Resources at (801) 581-7447 for information. Individuals who previously retired and are receiving monthly retirement benefits from URS are subject to URS’ post-retirement rules and restrictions. Please contact Utah Retirement Systems at (801) 366-7770 or (800) 695-4877 or University Human Resource Management at (801) 581-7447 if you have questions regarding the post-retirement rules.

This position may require the successful completion of a criminal background check and/or drug screen.

The University of Utah values candidates who have experience working in settings with students and patients from all backgrounds and possess a strong commitment to improving access to higher education and quality healthcare for historically underrepresented students and patients.

All qualified individuals are strongly encouraged to apply. Veterans’ preference is extended to qualified applicants, upon request and consistent with University policy and Utah state law. Upon request, reasonable accommodations in the application process will be provided to individuals with disabilities.

The University of Utah is an Affirmative Action/Equal Opportunity employer and does not discriminate based upon race, ethnicity, color, religion, national origin, age, disability, sex, sexual orientation, gender, gender identity, gender expression, pregnancy, pregnancy-related conditions, genetic information, or protected veteran’s status. The University does not discriminate on the basis of sex in the education program or activity that it operates, as required by Title IX and 34 CFR part 106. The requirement not to discriminate in education programs or activities extends to admission and employment. Inquiries about the application of Title IX and its regulations may be referred to the Title IX Coordinator, to the Department of Education, Office for Civil Rights, or both.

To request a reasonable accommodation for a disability or if you or someone you know has experienced discrimination or sexual misconduct including sexual harassment, you may contact the Director/Title IX Coordinator in the Office of Equal Opportunity and Affirmative Action ( OEO /AA). More information, including the Director/Title IX Coordinator’s office address, electronic mail address, and telephone number can be located at: https://www.utah.edu/nondiscrimination/

Online reports may be submitted at oeo.utah.edu

https://safety.utah.edu/safetyreport This report includes statistics about criminal offenses, hate crimes, arrests and referrals for disciplinary action, and Violence Against Women Act offenses. They also provide information about safety and security-related services offered by the University of Utah. A paper copy can be obtained by request at the Department of Public Safety located at 1658 East 500 South.