Job Information

University of Utah Data Analyst in Salt Lake City, Utah

Details

Open Date 11/30/2022

Requisition Number PRN33112B

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

VP Area President

Department 00289 - Development

Location Campus

City Salt Lake City, UT

Type of Recruitment External Posting

Pay Rate Range $80,000 - $82,000

Close Date

Open Until Filled No

Job Summary

The Information Services (IS) department within University Advancement at the University of Utah is excited to bring on a new Data Analyst to our strong and capable team. The IS department is comprised of data and systems professionals and provides direct support to all departments within the University Advancement division. With significant growth in the broader University Advancement division, the IS department is growing its team to provide continued reliable and high-quality service to University Advancement end-users.

The Data Analyst position works within the Advancement Office, which oversees and coordinates fundraising and alumni relations efforts at the University of Utah. This position is responsible for writing programs and reports in order to support University development activities. Additionally, this position provides technical support for data analysis and visualization, report creation, and database loads and extracts. The position requires a broad range of technical knowledge and the ability to communicate and work with all levels of University development staff. This position will be a dual reporting position specifically supporting the advancement data needs of University of Utah Health.

The University Advancement division is a fast-paced and goal-oriented organization. A successful applicant to this position will enjoy the problem-solving process, answering complex business questions using SQL and other languages and take great pride in delivering high-quality results. Applicants for this role must be comfortable collaborating with end-users to better understand their business questions.

The projects of this position will be primarily focused on the reporting needs of University of Utah Health Advancement and will dual report to the Senior Director of Information Services – Main Campus and Director of Advancement Services – Health. This position will collaborate with various members of the larger Advancement Services team including System Administrators, other Data Analysts, Business Systems Analysts, and Trainers.

As a part of the University of Utah, the University Advancement division is deeply committed to fostering, cultivating, and preserving a culture of equity, diversity, and inclusion ( EDI ). We embrace this commitment to grow and maintain a diverse, safe, and inclusive workplace culture for all employees in University Advancement. With an increasingly diverse population of alumni and donors, we recognize that nationally the most successful advancement offices employ individuals who can connect with these diverse communities and understand approaches that mirror a broad perspective of cultures, values, and experiences. The long-term strength and viability of the University of Utah stem from the ongoing EDI practices, and we work intentionally to ensure these efforts are reflected in all aspects of our fundraising and advancement work. We highly encourage applications from historically underrepresented minority groups, persons with disabilities, persons who have served in the military, and others who would bring additional dimensions of education and experience to our team.

Benefits

The University of Utah provides a generous and well-rounded package of employee benefits, including:

  • 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)
  • Generous paid leave time
  • Tuition reduction for employee and family members (https://www.hr.utah.edu/benefits/tuition.php)
  • … and more: https://www.hr.utah.edu/benefits/

Responsibilities

  • Designs, documents, codes, tests, and debugs programs using PL/ SQL , SQL , and other necessary languages and tools.
  • Develops new reports and modifies existing reports for end-users from within Oracle databases and Salesforce CRM .
  • Performs continuous quality assurance prior to releasing deliverables to users.
  • Analyzes and reviews report/data requests for clarity and content, verifying and clarifying that the request criteria are understood and match user intent and expectations.
  • Verifies that report/data deliverables match the established request criteria. Provides deliverables in clear and logical formatting and organization. Educates end users, as necessary, to improve their understanding of the information provided.
  • Develops, tests, and documents scripts to support data integrity of department data systems.
  • Supports data interfaces between systems (e.g. Salesforce, VanillaSoft, and iModules) by writing scripts to review data, import/export data, and resolve data format and/or integrity issues.
  • Develops and maintains technical and functional specifications as well as documentation for all reports and interfaces.
  • Creates visualizations and dashboards in Tableau and Salesforce.
  • Supports and troubleshoots issues/questions posed by department leadership. Performs application and data analysis when needed to support the department’s decision making.
  • Complies with governmental and university regulations such as HIPAA , GRAMA , U Policy 4-001, and U Policy 4-004. Protects the privacy and security of the sensitive data in our systems at all times, including protected health information ( PHI ).
  • Possesses the professional flexibility, to adapt to new University data systems and the evolution of skills and duties required for the position.

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.

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

Preferences

Department Preferred Qualifications

  • High proficiency with SQL .
  • Experience working with Oracle databases.
  • Experience using Salesforce (Sales Cloud, Service Cloud, or EDA ).
  • Experience using Tableau.
  • Experience using UC Innovation ascend.
  • Experience with web programming, version control, and dashboard tools.
  • Experience in higher education or other non-profit software applications and environments.
  • Familiarity with fundraising concepts and terminology.
  • Demonstrated written communication skills, especially technical documentation.
  • Demonstrated strong self-guided problem solving and decision-making skills.
  • High level of professionalism working with others.

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

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.