University of Utah
Data Warehouse Analyst
University of Utah, Salt Lake City, Utah, United States, 84193
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 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 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 rates14.2% retirement contributions that vest immediatelyGenerous paid leave time11 paid Holidays per year50% tuition reduction for employee, spouse, and dependent childrenFree transit on most UTA servicesEmployee discounts on a variety of products and services including cell phones & plans, entertainment, health and fitness, restaurants, retail, and travelProfessional development opportunities
Additional benefits information is available at
www.hr.utah.edu/benefits .ResponsibilitiesEssential FunctionsAs a BI Developer, your responsibilities will include:Building and Maintaining Reports (SSRS, Tableau, Power BI):
The BI Developer will be responsible for creating and managing reports using tools such as SSRS, Tableau, and Power BI. This involves designing visually appealing and informative reports that meet the specific needs of the business, ensuring data accuracy and consistency, and updating reports as necessary to reflect changes in business requirements or data structures.Writing Ad-Hoc Queries (T-SQL):
The role requires proficiency in writing T-SQL queries to retrieve and analyze data. This includes writing complex queries for ad-hoc data requests, optimizing query performance, and ensuring data integrity.Collecting Requirements and Documenting Processes:
A key part of the role is to liaise with business stakeholders to gather and understand their BI requirements. This includes documenting business processes, data needs, and report specifications, as well as communicating these requirements to the technical team for implementation.Developing and Maintaining Extract, Transform, Load (ETL) Processes (SSIS):
The BI Developer will design, develop, and maintain ETL processes using SSIS. This includes extracting data from various sources, transforming it according to business logic, and loading it into data warehouses or other storage solutions.Building and Maintaining Online Analytical Processing (OLAP) Tools (SSAS):
The role involves creating and managing OLAP cubes using SSAS, which includes designing data models, setting up measures and dimensions, and optimizing cube performance. The ability to build robust and scalable OLAP solutions that support complex data analysis is essential.Following Industry Standards and Best Practices:
The BI Developer is expected to stay abreast of the latest trends and best practices in business intelligence and data analytics. This includes adhering to industry standards for data security and privacy, ensuring high-quality and accurate reporting, and continuously seeking ways to improve BI processes and solutions.Minimum QualificationsRequires 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 2-4 years of experience in the field or in a related area. Familiar with a variety of the field’s concepts, practices, and procedures.Applicants must demonstrate the potential ability to perform the essential functions of the job as outlined in the position description.PreferencesProven experience as a BI DeveloperBackground in data warehouse designIn-depth understanding of database management systems, OLAP and ETL frameworksFamiliarity with core BI technologies (T-SQL, SSRS, SSIS, SSAS, Tableau, Power BI)Excellent analytical, problem-solving, and innovative thinking skillsStrong ability to explain advanced data concepts to fellow developers as well as non-technical end usersDemonstrated ability to meet deadlines, balance multiple priorities, and ensure quality standards based on an Agile Development process.Applicants will be screened according to preferences.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.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.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).Posting Specific Questions
Required fields are indicated with an asterisk (*).* Do you have a related Bachelor's degree or equivalency? (2 years related work experience may be substituted for 1 year of education)
YesNo
* Please indicate your level of experience/expertise in comprehensive data warehouse analysis and design:
NoneMinimalModerateExtensive
Required DocumentsResumeOptional DocumentsCover LetterAppropriate discharge document (such as a DD-214 – Member Copy 4) – Veteran Only – Call 801.581.2169Addendum to the University of Utah - Veteran Only - Call 801.581.2169 after submissionUniversity Human Resource Management250 East 200 South, Suite 125 Salt Lake City, UT 84111Contact us: (801) 581-2169 By Email: employment@utah.edu
#J-18808-Ljbffr
Additional benefits information is available at
www.hr.utah.edu/benefits .ResponsibilitiesEssential FunctionsAs a BI Developer, your responsibilities will include:Building and Maintaining Reports (SSRS, Tableau, Power BI):
The BI Developer will be responsible for creating and managing reports using tools such as SSRS, Tableau, and Power BI. This involves designing visually appealing and informative reports that meet the specific needs of the business, ensuring data accuracy and consistency, and updating reports as necessary to reflect changes in business requirements or data structures.Writing Ad-Hoc Queries (T-SQL):
The role requires proficiency in writing T-SQL queries to retrieve and analyze data. This includes writing complex queries for ad-hoc data requests, optimizing query performance, and ensuring data integrity.Collecting Requirements and Documenting Processes:
A key part of the role is to liaise with business stakeholders to gather and understand their BI requirements. This includes documenting business processes, data needs, and report specifications, as well as communicating these requirements to the technical team for implementation.Developing and Maintaining Extract, Transform, Load (ETL) Processes (SSIS):
The BI Developer will design, develop, and maintain ETL processes using SSIS. This includes extracting data from various sources, transforming it according to business logic, and loading it into data warehouses or other storage solutions.Building and Maintaining Online Analytical Processing (OLAP) Tools (SSAS):
The role involves creating and managing OLAP cubes using SSAS, which includes designing data models, setting up measures and dimensions, and optimizing cube performance. The ability to build robust and scalable OLAP solutions that support complex data analysis is essential.Following Industry Standards and Best Practices:
The BI Developer is expected to stay abreast of the latest trends and best practices in business intelligence and data analytics. This includes adhering to industry standards for data security and privacy, ensuring high-quality and accurate reporting, and continuously seeking ways to improve BI processes and solutions.Minimum QualificationsRequires 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 2-4 years of experience in the field or in a related area. Familiar with a variety of the field’s concepts, practices, and procedures.Applicants must demonstrate the potential ability to perform the essential functions of the job as outlined in the position description.PreferencesProven experience as a BI DeveloperBackground in data warehouse designIn-depth understanding of database management systems, OLAP and ETL frameworksFamiliarity with core BI technologies (T-SQL, SSRS, SSIS, SSAS, Tableau, Power BI)Excellent analytical, problem-solving, and innovative thinking skillsStrong ability to explain advanced data concepts to fellow developers as well as non-technical end usersDemonstrated ability to meet deadlines, balance multiple priorities, and ensure quality standards based on an Agile Development process.Applicants will be screened according to preferences.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.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.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).Posting Specific Questions
Required fields are indicated with an asterisk (*).* Do you have a related Bachelor's degree or equivalency? (2 years related work experience may be substituted for 1 year of education)
YesNo
* Please indicate your level of experience/expertise in comprehensive data warehouse analysis and design:
NoneMinimalModerateExtensive
Required DocumentsResumeOptional DocumentsCover LetterAppropriate discharge document (such as a DD-214 – Member Copy 4) – Veteran Only – Call 801.581.2169Addendum to the University of Utah - Veteran Only - Call 801.581.2169 after submissionUniversity Human Resource Management250 East 200 South, Suite 125 Salt Lake City, UT 84111Contact us: (801) 581-2169 By Email: employment@utah.edu
#J-18808-Ljbffr