Business Data Analyst

Role Details

Details

Open Date 03/24/2023

Requisition Number PRN34323B

Job Title Business Data Analyst

Working Title Business Data 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

Monday – Friday 8 am to 5 pm

VP Area President

Department 00417 - UIT Univ Support Services

Location Campus

City Salt Lake City, UT

Type of Recruitment External Posting

Pay Rate Range $75,000/yr. - $83,000/yr.

Close Date

Open Until Filled Yes

Job Summary

This position is focused on supporting the University Data Warehouse and associated tools/analytical applications across our Student, Finance, Human Resources, and Facilities/Ancillary Services environments. This position will be a primary contact for end user support, trouble shooting as well as requirements gather for enhancements and modification to the data warehouse. This position will assist in gathering functional specifications to fulfill the data requirements for delivering comprehensive business intelligence solutions and working with data engineers to build those solutions. Strong SQL skills and knowledge of analytics/business intelligence applications is required.

Responsibilities

• Participates in all phases of data warehouse implementation. Identifies pertinent issues and prepares comprehensive design specifications for database design, testing, conversion, and implementation

• Translates and documents the results of requirements gathering into a standard format to be used to create the appropriate Business Intelligence (BI) solution

• Analyzes user data to determine business rules and creates data models

• Develops and delivers BI solutions

• Works with end user to gather reporting requirements

• Implements and supports Business Objects/Tableau and other reporting applications

• Develops strategies and updates the data warehouse in response to changes in reporting requirements

• Applies industry standards to the technical architecture of a Business Intelligence solution (Stars, Cubes, Extract Transform and Load ( ETL )) to solve business problems or increase business efficiency

• Identifies and recommends methods to normalize and maintain data from disparate systems. Works with other internal UIT teams and external systems support staff to understand the source systems used for the warehouse

• Troubleshoots data warehouse software. Develops and maintains tools to optimize data quality and access

• Collaborates with users and negotiates to identify and develop additional data sources for the data warehouse consistent with business rules and customer needs

• Coordinates with Data Warehouse Architects to create and support Business Intelligence environment. Identifies and works with appropriate staff to resolve technical issues

• Conducts and attends team meetings, and communicates (verbally and in writing) team and project issues to appropriate staff and customers. Presents findings, recommendations, and specifications both verbally and in writing.

• Participates as a team member in data warehouse projects

Primarily supporting: Student & Finance reporting tools such as Tableau and SAP Web Intelligence

This job description 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.

Our team is temporarily operating under a hybrid work-from-home model. We currently are operating in office 2 days a week. This position is not open for 100% remote work.

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 related area (2 years related work experience may be substituted for 1 year of education). Two to four years of experience in the field or in a related area. Familiar with standard concepts, practices, and procedures within a particular field.

Department-Specific Requirements:

• Advanced knowledge of SQL , preferably Oracle

• Experienced in Analytic/Business Intelligence applications ( SAP , Tableau, PowerBI, etc)

Applicants must demonstrate the potential ability to perform the essential functions of the job as outlined in the position description.

Preferences

• Knowledge of the University’s data requirements

• Knowledge of relational database and advanced query concepts including Performance Tuning.

• Ability to analyze and develop business requirements and communicate those to developers

• Ability to multitask and meet negotiated timelines

• Skill in explaining data to technical and non-technical users

• Experience with Oracle database development, SQL and relational database design

• Higher Education experience in one or more functional lines of business

• Experience with Tableau, SAP Business Objects or other business intelligence software solution

Type Benefited Staff

Special Instructions Summary

Additional Information

About UIT :University Information Technology ( UIT ) (https://it.utah.edu/) , the central IT service provider for the University of Utah, reports to the U’sChief Information Officer (https://it.utah.edu/cio/) and is responsible for many of the U’s shared IT services including the wired and wireless network; Campus Information Services ( CIS ) portal; UMail, telephone, and online collaboration; high performance and research computing; information security; software licensing; and a host of other IT systems and services.

UIT is committed to creating a workplace culture that values equity, diversity, and inclusion ( EDI ), and we believe that everyone plays a role in fostering EDI , every day. EDI isn’t just the right thing for our employees and the university community; it’s also the smart thing. It empowers us to provide the best IT services for our students and their families, staff, faculty, clinicians, and patients and their families.

About the University of Utah : Located in Salt Lake City, the U is the flagship institution of the State of Utah’s system of higher education, home toarts and museum venues (https://www.utah.edu/arts/) and a member of thePac-12 Conference (https://utahutes.com/) .Skiing and snowboarding opportunities (https://www.utah.com/destinations/ski-resorts/) are a short distance from campus, and opportunities to pursue activities frombiking to hiking to fishing abound (https://www.visitsaltlake.com/things-to-do/outdoor-recreation/) . Salt Lake City is home to theUtah Symphony and Opera (https://usuo.org/) ,Ballet West (https://balletwest.org/) ,professional sports teams (https://www.visitsaltlake.com/things-to-do/sports/professional-sports/) , and a wide range of other cultural and recreational activities.

University of Utah Benefits

· Health, dental, and wellness coverage (https://www.hr.utah.edu/benefits/health\_wellness.php) · Automatic and immediately vested14.2% employer contribution (https://www.hr.utah.edu/benefits/retire\_401aPlan.php) to personal retirement account (401a)

· Freepublic transportation pass (https://commuterservices.utah.edu/uta/) (Utah Transit Authority)

· Paid leave time (https://www.hr.utah.edu/benefits/paidLeave.php) · Reduced tuition benefits for employee and family members (https://www.hr.utah.edu/benefits/tuition.php) · More information: https://www.hr.utah.edu/benefits/

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)

383 University Street, Level 1 OEO Suite

Salt Lake City, UT 84112

801-581-8365

oeo@utah.edu

Online reports may be submitted at oeo.utah.edu

For more information: https://www.utah.edu/nondiscrimination/

To inquire about this posting, email: employment@utah.edu (%20employment@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.

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.

University of Utah provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.