Job description

Details Open Date 11/07/2025 Requisition Number PRN43536B Job Title Data Architects Working Title Data Architects Career Progression Track P00 Track Level P3 - Career, P2 - Developing, P1 - Entry Level Pro 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 Full-time, 40 hours per week. Monday – Friday from 8:00 am to 5:00 pm This position offers a flexible, mostly remote work schedule for candidates who reside in the state of Utah. While most duties can be performed remotely, the employee must reside in Utah and be able to attend essential meetings and events on campus as needed. This position may require occasional travel. 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 $61,599 to $112,068 Close Date 02/06/2026 Priority Review Date (Note - Posting may close at any time) 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. Type Benefited Staff Special Instructions Summary Additional Information The University of Utah values candidates who have experience working in settings with students from diverse backgrounds and possess a strong commitment to improving access to higher education for historically underrepresented students. Individuals from historically underrepresented groups, such as minorities, women, qualified persons with disabilities and protected veterans are 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 Director/ Title IX Coordinator Office of Equal Opportunity and Affirmative Action ( OEO /AA) 383 University Street, Level 1 OEO Suite Salt Lake City, UT 84112 801-581-8365 oeo@utah.edu Online reports may be submitted at oeo.utah.edu For more information: https://www.utah.edu/nondiscrimination/ To inquire about this posting, email: employment@utah.edu or call 801-581-2300. 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. 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.

Requirements