Business Data Analyst

ACS, Analysis, Analyst, Database, Data Modeling, Development, Genetic, HTML, Inquire, Lifecycle, Management, Modeling, Oracle, PeopleSoft, Programmer, Programming, Project, Project Management, Research, Scripts, Supervision, TDD, Testing, Unix, Windows
Full Time, Full Time
Telecommuting not available Travel not required

Job Description


Open Date 02/02/2018

Requisition Number PRN16163B

Job Title Business Data Analyst

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

M-F, hours to be arranged. Some overtime and weekend work possible.

VP Area President

Department 00417 - UIT - ACS

Location Campus

City Salt Lake City, UT

Type of Recruitment Internal to the Department

Pay Rate Range 55,000 to 75,000/yr DOE

Close Date

Open Until Filled Yes

Job Summary

The Data Analyst manages portions of the university-wide logical data model and participates in all aspects of the information systems development lifecycle, including systems design analysis.


1.Leads project team in the identification of pertinent data issues, and prepares comprehensive project plans and timelines for data design, testing, conversion, and implementation.

2.Performs routine and complex data administration activities within department, including generating and reviewing table creation/alteration scripts, creating scripts for data alteration and cleanup, ensuring data integrity.

3.Coordinates with technical staff to ensure acceptable database performance; coordinates database outages, database copies, and other database activities.

4.Creates and maintains data dictionaries, Entity Relationship Diagram (ERD) models, and guidelines for database usage and availability.

5.Coordinates and reviews data initiatives during application upgrades; communicates effect of data changes to project team. Writes data conversion programs. Reviews and tests vendor and customer-supplied data conversion scripts to ensure accuracy and content.

6.Writes data conversion specifications and programs; reviews and tests vendor-and customer supplied data conversion scripts to ensure accuracy and content.

7.Reviews programmer, vendor and customerSQLand assists withSQLtuning.

8.Develops data test plans, validates data integrity and accuracy, diagnoses and corrects data discrepancies.

9.Gathers information from vendors on product features, support, and future development.

10.Actively participates and leads in the PeopleSoft fix/upgrade process.

11.75% of the time functioning as a DA and 25% as anSDE(Systems Design Engineer) doing work in creating technical specs for developers and troubleshooting and resolving functional production issues.


The incumbent works independently with minimal supervision, and has authority to make decisions related to project implementation.

Problem Solving

The incumbent is expected to solve technical and communication problems. An example of technical problem solving is modifying an existing software component to create desired results (e.g. a report) for a customer. An example of communication problem solving is extracting pertinent business or system information from a customer.

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.

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.

Broad knowledge of data design, specifically with Oracle databases and the implementation environment. Proficiency with data modeling tools, ad hoc database access tools, query/reporting software, andSQL. Demonstrated ability to work independently with minimal supervision and to lead small and mid-sized projects. Ability to accurately estimate effort to complete projects. Proficiency in the Windows environment and basic desktop application suites, including word processing, spreadsheet, and email. Demonstrated human relations and communications skills, and ability to work in a team environment. A strong commitment to excellence in service.

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


Three to five years progressively responsible experience that includes data or business analysis, large systems implementation, and project management experience; a degree in Computer Science, Business, or a related field may be used to offset experience.

Knowledge and experience in a large research university. Experience with PeopleSoft application software and implementation in a Unix/Oracle environment. Experience with PS Application Designer, PSQuery, andSQLDeveloper. PeopleSoft Finance experience, including functional and technical experience in Financial applications, grants, and the Application Upgrade Methodology. Ability to code in one or more programming or scripting languages, includingSQLandSQR. Experience with the PeopleSoft fix and upgrade process (i.e. Change Assistant).

Type Benefited Staff

Special Instructions Summary

Additional Information

The University of Utah is an Affirmative Action/Equal Opportunity employer and is committed to diversity in its workforce. In compliance with applicable federal and state laws, University of Utah policy of equal employment opportunity prohibits discrimination on the basis of race or ethnicity, religion, color, national origin, sex, age, sexual orientation, gender identity/expression, veteran’s status, status as a qualified person with a disability, or genetic information. Individuals from historically underrepresented groups, such as minorities, women, qualified persons with disabilities, and protected veterans are strongly encouraged to apply. Veterans’ preference is extended to qualified applicants, upon request and consistent with University policy and Utah state law.

To inquire about this posting, email: or call 801-581-2300. Reasonable accommodations in the application process will be provided to qualified individuals with disabilities. To request an accommodation or for further information about University AA/EO policies, please contact the Office of Equal Opportunity and Affirmative Action, 201 S. Presidents Cr., Rm 135, (801) 581-8365 (V/ TDD ), email: .

The University is a participating employer with Utah Retirement Systems (“URS”). To be eligible for retirement contributions, you must be hired into a benefit-eligible position. Certain new hires are automatically assigned to the URS retirement plan and other employees with prior URS service, may elect to enroll in the URS within 30 days of hire. Regardless of whether they are hired into a benefit-eligible position or not, individuals who previously retired and are receiving monthly retirement benefits from URS must notify the Benefits Department upon hire. Please contact Utah Retirement Systems at (801)366-7770 or (800)695-4877 or the University’s Benefits Department at (801)581-7447 for information.

This position may require the successful completion of a criminal background check and/or drug screen.
Dice Id : 10474576
Position Id : PRN16163B
Have a Job? Post it

Similar Positions

Data Analyst
  • Instructure
  • Salt Lake City, UT
Business Intelligence Analyst
  • Apremis
  • Salt Lake City, UT
Business Analyst - Reporting Systems
  • Zions Bancorporation
  • Salt Lake City, UT
Business Consultant
  • Domo, Inc
  • American Fork, UT
Business Analyst
  • Career Advancements, Inc.
  • Salt Lake City, UT
Junior Business Analyst
  • U.S. Tech Solutions Inc.
  • South Jordan, UT
Enterprise Data Engineer
  • Robert Half Technology
  • Salt Lake City, UT
Healthcare Business Analyst
  • emids
  • South Jordan, UT
Business Analyst
  • Kforce Inc.
  • Salt Lake City, UT
Deal Desk Analyst
  • Adobe Systems
  • Lehi, UT
Business Analyst - Content Management System CMS
  • Talent Logic, Inc.
  • Salt Lake City, UT