University of Utah Database Report Writer in Salt Lake City, Utah

Details

Open Date 10/25/2018

Requisition Number PRN18746B

Job Title Database Report Writer

Working Title Database Report Writer

Job Grade E

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 through Friday, 8 am to 5 pm

VP Area President

Department 00289 - Development

Location Campus

City Salt Lake City, UT

Type of Recruitment External Posting

Pay Rate Range $45,000 to $60,000

Close Date

Open Until Filled Yes

Job Summary

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, 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.

Responsibilities

•Designs, documents, codes, tests, and debugs programs using PL/SQL,SQL,HTML, JavaScript, and other necessary languages and tools. Develops new reports or modifies existing reports for end-users from within the Ellucian Advance database or other supporting systems.

•Perform continuous quality assurance prior to releasing deliverables to users. Analyzes and reviews report/data requests for clarity and content. Verifies and clarifies that understood request criteria is what the user is intending and expecting. 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. Advance, SmartCall, 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 for all reports and interfaces.

•Customizes user interface of Ellucian AdvanceCRMsystem, using both Ellucian’s configuration tool and PL/SQLto make modifications.

•Creates visualizations and dashboards in Tableau.

•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 asHIPAA,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.

•Possesses professional flexibility as university data systems change and required skills and duties for this position evolve.

Minimum Qualifications

Requires a bachelor’s degree in area of specialty or 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

High proficiency withSQL. Experience working with Oracle databases. Experience doing Salesforce customization and configuration. Experience creating visualizations in Tableau. Experience with web programming, version control, and dashboard tools. Experience in higher education or other non-profit software applications and environments. Experience in advancement or specifically nonprofit fundraising. Specific knowledge of advancement concepts such as gift processing and relationship management. 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 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: employment@utah.edu 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: oeo@umail.utah.edu .

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.