Job Location: Salt Lake City, UT
Announcement
Details
Open Date
10/05/2022
Requisition Number
PRN32567B
Job Title
Data Warehouse Analyst
Working Title
Data Warehouse Analyst
Job Grade
F
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
VP Area
U of U Health – Academics
Department
00193 – Office of SR VP Health Sci
Location
Campus
City
Salt Lake City, UT
Type of Recruitment
External Posting
Pay Rate Range
$69,000 – $79,699
Close Date
Open Until Filled
Yes
Job Summary
Determines business information needs and identifies system requirements. Analyzes business intelligence data and provides reports. Acts as liaison between U of U Health Finance Team and other business units. Ensures data accuracy. Responsible for creating ad hoc and recurring reports and analysis that combine financial, operational, and organizational data. The incumbent must develop mastery of data sources in our enterprise data warehouse, which is accessed through SQL, VBA, SAP EPM, and Tableau. Successful performance is demonstrated by accuracy, thoughtfulness, presentation of work deliverables, adhering to timelines, working effectively as a member of the U of U Health Finance Team, and dependability.
Responsibilities
Disclaimer
The incumbent must be able to advance concurrent projects and work deliverables as prioritized by the U of U Health Finance Team. The following is a sample (not an exhaustive overview) of the responsibilities and qualifications of employees assigned to the job.
Essential Functions
- Collects and coordinates business requirements for analytics, reporting, and business process refinement.
- Utilizes technical tools to build system-level business solutions.
- Exercises expertise in BI tool architecture, functions, features, and customizes BI tools to meet needs.
- Determines statistical methods used to analyze data.
- Provides information related to planning, policy development, work methods and procedures, manpower utilization, organizational structure, distribution of assignments, and information management.
- Provides program and operations research and analysis.
- Conducts studies, productivity analyses, and surveys to improve systems.
- Analyzes new program plans, goals, and objectives.
- Assists in the preparation and evaluation of special projects.
- Designs forms tables, graphs, and charts to for summarizing information.
- Prepares technical documents and presentations that clearly and effectively communicate the Supports the annual budget process, including the personnel preparing budgets and the budget application.
- Engages and interacts with leadership throughout University of Utah Health.
- May be assigned special projects requiring a knowledge of governmental and business accounting practices
Knowledge / Skills / Abilities
- Expertise using data warehouse or analytical tools for business purposes.
- Ability to translate business requirements into technical requirements.
- Experience working and effectively communicating with technical colleagues.
- Proven ability to work and effectively communicate with administrators and physician leaders.
- Functional experience with BI tool architectures, functions, and features.
- Functional experience using SQL and relational and multidimensional database designs.
- Advanced Excel skills and strong functional experience using VBA, to create business solutions.
- Problem Solving
- Representative challenges of this position include providing key decision makers an objective view regarding products or services and values, and applying theoretical concepts to practical applications.
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 Finance, Accounting, Business, IT or Healthcare Administration and equivalency 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.
Preferences
A successful candidate will also have;
- A Master’s degree in a related field.
- Experience with Oracle, VBA, Tableau, R and R Studio is desired.
- Can work cooperatively and effectively in the context of a large, highly complex academic medical center.
- Effective communication skills, creativity, analytical acumen, technical aptitude, dependability, and a strong work ethic are needed.
- Work independently and as part of a small team.
- Must be able to transition effectively as projects are reprioritized.
- Needs to be able thrive in situations that demand high performance under short deadlines.
- Advanced experience in Excel is required.
- Applied knowledge of SQL, VBA, and BI tools.
Type
Benefited Staff
Special Instructions Summary
Additional Information
The University of Utah values candidates who have experience working in settings with students from diverse 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:
Director/ Title IX Coordinator
Office of Equal Opportunity and Affirmative Action (OEO/AA)
135 Park Building
Salt Lake City, UT 84112
801-581-8365
oeo@utah.edu
Online reports may be submitted at oeo.utah.edu
To inquire about this posting, email: employment@utah.edu or call 801-581-2300.
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.
Submit CV To All Data Science Job Consultants Across United States For Free
🔍 Explore All Related ITSM Jobs Below! 🚀
✅ Select your preferred "Job Category" in the Job Category Filter 🎯
🔎 Hit "Search" to find matching jobs 🔥
➕ Click the "+" icon that appears just before the company name to see the Job Detail & Apply Link 📝💼
