University of Utah
Data Architect
University of Utah, Salt Lake City, Utah, United States, 84193
Details
Open Date 08/16/2024
Requisition Number PRN39582B
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
This position may have the option for a hybrid – partial onsite/partial telecommute – work schedule.
VP Area U of U Health - Academics
Department 00952 - Division of Epidemiology
Location Campus
City Salt Lake City, UT
Type of Recruitment External Posting
Pay Rate Range 60700 to 101649
Close Date
Open Until Filled Yes
Job Summary
Familiar with a variety of the field’s concepts, practices, and procedures. Relies on extensive experience and judgment to plan and accomplish goals. Performs a variety of tasks. Leads and directs the work of others. A wide degree of creativity and latitude is expected. Is expected to work independently, making decisions with considerable thought and appropriate justification in moving tasks forward. Typically reports to a manager or head of a unit/department.
This position is anticipated to start 10/01/2024.
Responsibilities
Designs and builds relational databases for data storage, processing, analytics, and visualization.
Develops, implements and optimizes tables, views, stored procedures, indexes, functions, dictionaries, and complex ad-hoc queries using T- SQL for SQL Server databases.
Develops, tests and deploys reports, dashboards, query tools, and apps to production environments.
Develops, tests and administers usability protocols/study for various health informatics data tools.
Designs, develops, tests, tunes, and implements ETL processes and/or pipelines using SSIS /Azure Synapse Analytics.
Creates and maintains documentation as it relates to ETL , database and report development standards, templates, and processes.
Ability to analyze, troubleshoot, and fix SSIS ETL packages, reports ( SSRS /PowerBI), and apps (PowerApps).
Monitor and support automated SQL Agent jobs or scheduled pipelines that ingest, process, & deliver data for consumption by customers/end users.
Works independently, but in collaborative team setting using source control best practices.
This job description 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.
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.
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
2-3 years’ working knowledge of Microsoft SQL Server.
1-2 years’ experience with Microsoft SQL Server Integration Services.
1-2 years’ working knowledge of Visual Studio\ SQL Server Data Tools.
1-2 years’ working experience with EHR data.
1-2 years’ experience with Team Foundation Server ( TFS ), GitHub, or DevOps.
1-2 years’ experience with Microsoft SQL Server Reporting Services and/or PowerBI.
1-2 years’ experience with SharePoint.
Strong troubleshooting and problem-solving skills.
Some experience with PowerApps, Power Automate, Azure Synapse Analytics.
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.
Open Date 08/16/2024
Requisition Number PRN39582B
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
This position may have the option for a hybrid – partial onsite/partial telecommute – work schedule.
VP Area U of U Health - Academics
Department 00952 - Division of Epidemiology
Location Campus
City Salt Lake City, UT
Type of Recruitment External Posting
Pay Rate Range 60700 to 101649
Close Date
Open Until Filled Yes
Job Summary
Familiar with a variety of the field’s concepts, practices, and procedures. Relies on extensive experience and judgment to plan and accomplish goals. Performs a variety of tasks. Leads and directs the work of others. A wide degree of creativity and latitude is expected. Is expected to work independently, making decisions with considerable thought and appropriate justification in moving tasks forward. Typically reports to a manager or head of a unit/department.
This position is anticipated to start 10/01/2024.
Responsibilities
Designs and builds relational databases for data storage, processing, analytics, and visualization.
Develops, implements and optimizes tables, views, stored procedures, indexes, functions, dictionaries, and complex ad-hoc queries using T- SQL for SQL Server databases.
Develops, tests and deploys reports, dashboards, query tools, and apps to production environments.
Develops, tests and administers usability protocols/study for various health informatics data tools.
Designs, develops, tests, tunes, and implements ETL processes and/or pipelines using SSIS /Azure Synapse Analytics.
Creates and maintains documentation as it relates to ETL , database and report development standards, templates, and processes.
Ability to analyze, troubleshoot, and fix SSIS ETL packages, reports ( SSRS /PowerBI), and apps (PowerApps).
Monitor and support automated SQL Agent jobs or scheduled pipelines that ingest, process, & deliver data for consumption by customers/end users.
Works independently, but in collaborative team setting using source control best practices.
This job description 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.
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.
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
2-3 years’ working knowledge of Microsoft SQL Server.
1-2 years’ experience with Microsoft SQL Server Integration Services.
1-2 years’ working knowledge of Visual Studio\ SQL Server Data Tools.
1-2 years’ working experience with EHR data.
1-2 years’ experience with Team Foundation Server ( TFS ), GitHub, or DevOps.
1-2 years’ experience with Microsoft SQL Server Reporting Services and/or PowerBI.
1-2 years’ experience with SharePoint.
Strong troubleshooting and problem-solving skills.
Some experience with PowerApps, Power Automate, Azure Synapse Analytics.
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.