University of Utah Health Research · 3 weeks ago
Data / Reporting Analysts
Salt Lake City, UT
Full-time
Onsite
Mid, Senior Level
$60K/yr - $80K/yr
4+ years expUniversity of Utah Health Research is seeking Data / Reporting Analysts to conduct data analysis in support of various analytic solutions. The role involves capturing and documenting data definitions, creating reports and dashboards, and ensuring compliance with reporting requirements through quality audits and analysis.
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
Company
University of Utah Health Research
At University of Utah Health, our world-class researchers work together to tackle some of the toughest problems in health and medicine.
5001-10000 employees
H1B Sponsorship
University of Utah Health Research 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
2020 (1)
Funding
Current Stage
Late StageCompany data provided by crunchbase