University of Utah · 3 weeks ago
Data / Reporting Analysts
Salt Lake City, UT
Full-time
Onsite
Mid, Senior Level
$60K/yr - $80K/yr
4+ years expThe University of Utah is seeking Data / Reporting Analysts to conduct data analysis in support of various analytic solutions. This role involves capturing and documenting data definitions, creating reports and dashboards, and providing insights to stakeholders.
Higher Education
Responsibilities
Review, evaluate, design, implement, and maintain company databases to support business operations and data integrity
Identify data sources and develop data decomposition diagrams, data flow diagrams, ERDs, and comprehensive process documentation
Develop scripts for data extraction, transformation, and modification, and optimize databases for improved performance and scalability
Write advanced scripts using DDL/DML & Window functions to query, process, and analyze large-scale datasets across multiple platforms, such as Microsoft SQL Server and PostgreSQL
Design and structure scalable, efficient data warehouses aligned with organizational analytic and reporting needs
Develop, automate, and maintain recurring data processes using Python, SQL, and R with a high level of proficiency
Detect, troubleshoot, and resolve issues including CPU, memory, I/O, disk space, and other resource constraints
Conduct data profiling, quality assessments, and validation to support analytical initiatives and production operations
Keep track of data changes and develop deep expertise in data dictionaries, metadata, and domain knowledge of organizational databases
Follow established project management guidelines and workflows using JIRA and GitHub for task tracking, documentation, and version control
Collaborate effectively with cross-functional teams, technical partners, and key business stakeholders
Present findings, reports, and recommendations clearly to technical and non-technical audiences, including leadership and external stakeholders
Qualification
Required
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)
Data / Reporting Analyst, II: Requires a bachelor's (or equivalency) + 4 years or a master's (or equivalency) + 2 years of directly related work experience
Data / Reporting Analyst, III: Requires a bachelor's (or equivalency) + 6 years or a master's (or equivalency) + 4 years of directly related work experience
Strong experience in MS SQL Server Database and PostgreSQL Administration with demonstrated ability to optimize performance and maintain system reliability
Advanced proficiency in DDL, DML, and Window functions for script development, including writing complex queries and stored procedures
Experience with data profiling tools, methodologies, and best practices
Demonstrated expertise in database programming with Microsoft SQL Server, PostgreSQL, and related ETL technologies
Proven ability to work with large-scale datasets, both structured and unstructured
Preferred
Experience as a Database Analyst, Data Analyst, ETL Engineer, or in a related technical field
Enterprise-level experience developing PostgreSQL-based solutions
At least 2 years of experience with dimensional modeling concepts for data warehousing
Benefits
The University of Utah values candidates who have experience working in settings with students from all 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.
This position may require the successful completion of a criminal background check and/or drug screen.
Company
University of Utah
The University of Utah, located in Salt Lake City in the foothills of the Wasatch Mountains, is the flagship institution of higher learning in Utah.
10001+ employees
H1B Sponsorship
University of Utah has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (216)
2024 (189)
2023 (201)
2022 (175)
2021 (156)
2020 (174)
Funding
Current Stage
Late StageLeadership Team
Allison Nicholson
Special Assistant to CFO
Bruce Hunter
Interim Chief Innovation and Economic Engagement Officer
Recent News
National Institutes of Health (NIH)
2023-06-27
Company data provided by crunchbase