Data Warehouse Analyst Sr

The University of Utah • Salt Lake, UT

1d

About The Position

The Data Coordinating Center ( DCC ), housed within the Division of Pediatric Critical Care at the University of Utah School of Medicine has an immediate opening for a Senior Business Intelligence (BI) Developer position. This position provides qualified candidates with an opportunity to be a part of a high-functioning, cutting-edge academic research operation ( ARO ) that is working to accelerate the translation of research to the bedside. The Sr. BI Developer will assist in the strategic design and maintenance of streamlined and performance-optimized BI solutions for the entire DCC organization. In doing such, this position will have the opportunity to work on a diverse range of projects and acquire new skills while working alongside some of the most innovative individuals within the industry. Positions are designed to provide growth and professional development opportunities, including promotions within a defined career ladder. 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 per year 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

Requirements

• Requires a bachelor’s degree in area of specialty or equivalency (one year of education can be substituted for two years of related work experience) and 4-6 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.

Responsibilities

• Advanced Report Creation and Management ( SSRS , Tableau, Power BI): Lead in the development of complex reports using tools like SSRS , Tableau, and Power BI. Responsibilities include architecting detailed, insightful reports, ensuring data accuracy, and updating reports in line with evolving business requirements and data structures.
• Expertise in Complex T- SQL Queries: Exhibit exceptional skills in formulating and optimizing intricate T- SQL queries for detailed data analysis and ad-hoc requests, with a focus on peak query performance and data integrity.
• Strategic Requirements Gathering and Process Documentation: Proactively engage with business stakeholders to capture and understand their BI needs. This includes thorough documentation of business processes, data requirements, and report specifications, and effectively communicating these requirements to the technical team for implementation.
• Leading ETL Process Development ( SSIS ): Take charge of designing, developing, and maintaining sophisticated ETL processes using SSIS , encompassing data extraction from various sources, transformation as per complex business logic, and loading into data warehouses or other storage solutions.
• Acting as a Business Partner to Customers: With a strong focus on customer management, act as a business partner to clients, representing their business requirements and translating them into functional and then technical specifications. This role requires a deep understanding of customer needs, outstanding communication skills, and the ability to bridge the gap between business objectives and technical solutions.
• Setting Industry Standards and Upholding Best Practices: Maintain a leading edge in business intelligence and data analytics trends. This entails adhering to data security and privacy standards, ensuring the highest standards in reporting accuracy, and continuously innovating BI processes and solutions.

Benefits

• Excellent health care coverage at affordable rates
• 14.2% retirement contributions that vest immediately
• Generous paid leave time
• 11 paid Holidays per year
• 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

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Number of Employees: 5,001-10,000 employees