Data Warehouse Analyst Sr
University of Utah
Salt Lake City, UT
Full-time
Information Services / Technology (IT)
Posted on April 12, 2024
Announcement
Details
Open Date
01/11/2024
Requisition Number
PRN37406B
Job Title
Data Warehouse Analyst Sr
Working Title
Sr. Business Intelligence Developer
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
Monday – Friday, 8:00am – 5:00pm
VP Area
U of U Health - Academics
Department
00848 - Pediatric Administration
Location
Campus
City
Salt Lake City, UT
Type of Recruitment
External Posting
Pay Rate Range
$60,700 to $109,649
Close Date
Open Until Filled
Yes
Job Summary
Job Summary
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:
Responsibilities
Essential Functions
As a Sr. BI Developer, your responsibilities will include:
1. 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.
2. 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.
3. 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.
4. 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.
5. 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.
6. 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.
Disclaimer
This job description has been designed to indicate the general nature and level of work performed by employees within this classification. It 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.
Comments
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. A wide degree of creativity and latitude is expected. Typically reports to a manager or head of a unit/department.
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 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.
Preferences
Preferences
- Extensive Experience as a BI Developer: Demonstrated senior-level expertise in BI development, with a proven track record of managing complex BI projects and delivering insightful analytical solutions.
- Expertise in Data Warehouse Architecture and Design: Advanced knowledge in designing and optimizing data warehouse architecture, with a focus on scalability and efficiency in handling large datasets.
- Advanced Understanding of Database Systems and ETL Processes: Deep knowledge of database management systems, with a specialized focus on advanced OLAP functionalities and ETL frameworks. Demonstrated ability to design and optimize complex ETL processes.
- Proficiency in Core BI Technologies: Advanced skills in core BI technologies such as T- SQL, SSRS, SSIS, SSAS, Tableau, and Power BI, with the ability to leverage these tools to create high-performance BI solutions.
- Exceptional Analytical and Problem-Solving Abilities: Outstanding analytical skills with a knack for problem-solving and innovative thinking, capable of tackling complex data challenges and delivering actionable insights.
- Leadership in Technical Communication: Strong capability to articulate complex data concepts and strategies to a diverse range of stakeholders, including fellow developers and non-technical users, facilitating effective knowledge transfer and collaboration.
- Project Management and Agile Methodology Expertise: Proven ability to lead projects, meeting stringent deadlines and managing multiple priorities in a dynamic environment. Expertise in Agile Development methodologies, with a focus on continuous improvement and quality standards in BI processes.
Applicants will be screened according to preferences.
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.
Posting Specific Questions
Required fields are indicated with an asterisk (*).
Required Documents
Details
Open Date
01/11/2024
Requisition Number
PRN37406B
Job Title
Data Warehouse Analyst Sr
Working Title
Sr. Business Intelligence Developer
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
Monday – Friday, 8:00am – 5:00pm
VP Area
U of U Health - Academics
Department
00848 - Pediatric Administration
Location
Campus
City
Salt Lake City, UT
Type of Recruitment
External Posting
Pay Rate Range
$60,700 to $109,649
Close Date
Open Until Filled
Yes
Job Summary
Job Summary
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
Responsibilities
Essential Functions
As a Sr. BI Developer, your responsibilities will include:
1. 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.
2. 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.
3. 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.
4. 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.
5. 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.
6. 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.
Disclaimer
This job description has been designed to indicate the general nature and level of work performed by employees within this classification. It 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.
Comments
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. A wide degree of creativity and latitude is expected. Typically reports to a manager or head of a unit/department.
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 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.
Preferences
Preferences
- Extensive Experience as a BI Developer: Demonstrated senior-level expertise in BI development, with a proven track record of managing complex BI projects and delivering insightful analytical solutions.
- Expertise in Data Warehouse Architecture and Design: Advanced knowledge in designing and optimizing data warehouse architecture, with a focus on scalability and efficiency in handling large datasets.
- Advanced Understanding of Database Systems and ETL Processes: Deep knowledge of database management systems, with a specialized focus on advanced OLAP functionalities and ETL frameworks. Demonstrated ability to design and optimize complex ETL processes.
- Proficiency in Core BI Technologies: Advanced skills in core BI technologies such as T- SQL, SSRS, SSIS, SSAS, Tableau, and Power BI, with the ability to leverage these tools to create high-performance BI solutions.
- Exceptional Analytical and Problem-Solving Abilities: Outstanding analytical skills with a knack for problem-solving and innovative thinking, capable of tackling complex data challenges and delivering actionable insights.
- Leadership in Technical Communication: Strong capability to articulate complex data concepts and strategies to a diverse range of stakeholders, including fellow developers and non-technical users, facilitating effective knowledge transfer and collaboration.
- Project Management and Agile Methodology Expertise: Proven ability to lead projects, meeting stringent deadlines and managing multiple priorities in a dynamic environment. Expertise in Agile Development methodologies, with a focus on continuous improvement and quality standards in BI processes.
Applicants will be screened according to preferences.
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.
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)
- Yes
- No
- * How many years experience do you have working with Business Intelligence?
- Less than 1 year
- 1-5 years
- 5+ years
- * Please indicate your level of experience/expertise in comprehensive data warehouse analysis and design:
- None
- Minimal
- Moderate
- Extensive
Required Documents
- Resume
- Cover Letter
- Appropriate discharge document (such as a DD-214 – Member Copy 4) – Veteran Only – Call 801.581.2169
- Addendum to the University of Utah - Veteran Only - Call 801.581.2169 after submission
