Sr Business Intel Developer, Advancement

As a community, the University of Rochester is defined by a deep commitment to Meliora - Ever Better. Embedded in that ideal are the values we share: equity, leadership, integrity, openness, respect, and accountability. Together, we will set the highest standards for how we treat each other to ensure our community is welcoming to all and is a place where all can thrive.

Job Location (Full Address):

300 East River Rd, Rochester, New York, United States of America, 14623

Opening:

Worker Subtype:

Regular

Time Type:

Full time

Scheduled Weekly Hours:

40

Department:

100006 Ofc Sr Vice Pres Advancement

Work Shift:

UR - Day (United States of America)

Range:

UR URG 113

Compensation Range:

$77,216.00 - $115,824.00

The referenced pay range represents the minimum and maximum compensation for this job. Individual annual salaries/hourly rates will be set within the job's compensation range, and will be determined by considering factors including, but not limited to, market data, education, experience, qualifications, expertise of the individual, and internal equity considerations.

Responsibilities:

GENERAL PURPOSE
The Sr Business Intel Developer, Advancement has primary oversight, responsibility, and leadership for the implementation and management of all reporting systems for University Advancement, with the overarching responsibility of overseeing information and business intelligence assets and delivery. The Sr Business Intel Developer functions include designing, developing, directing, testing, implementing, and maintaining policies and procedures in support of all Advancement reporting systems.

The Sr Business Intel Developer will collaborate with cross-functional teams, as well as the Advancement Salesforce ascend support team, to ensure the reporting systems are continuously optimized and serve as the best means to provide customers with accurate and timely data and reports. They will act as functional project manager and application administrator in the design, testing and implementation of new system functionality and enhancements. They will create and review data audits and quality processes for the validation of deliverables. Also, they will interact with university finance and business managers to assess needs and coordinate resources.

The Sr Business Intel Developer will maintain a keen awareness of the goals and activities of the University of Rochester and its peer institutions.

Together with the Senior Director of Advancement Information Services, the Sr Business Intel Developer will build upon the strategic vision of the Associate Vice President of Advancement Services to achieve business results. This position may mentor and/or train new or junior staff members.

ESSENTIAL FUNCTIONS

Business Intelligence and Application Administration

• Serves as the lead reporting and application administrator for Salesforce ascend reporting, including upgrades, patching, and configuration.
• Serves as a systems administrator for Salesforce ascend reporting infrastructure, supporting the business intelligence, applications, configuration, and troubleshooting of the database.
• Responsible for communicating problems and resolutions with the Senior Director.
• Discusses data integrity issues or concerns with Advancement IS team for resolution and helps to ensure data entry practices are aligned with documented policies and procedures.
• Responsible for development of data queries of Salesforce data tables to verify the data displayed on reports is accurate and conforms to business rules. 
• Ensure reports and dashboards conform to Advancement reporting standards and have been thoroughly tested.
• Outlines strategies for the development and maintenance of environments that support the Salesforce ascend report writing application.

Report Development and Optimization

• With considerable latitude for independent judgement, leads design, development, and testing sessions with cross-functional advancement staff and teams to capture requirements and data for report development.
• Develops/reviews report specifications and ensures requirements are met across all functional areas.
• Develops, writes, and maintains standard reports within the reporting system and provides guidance on the functionality of ad hoc reports developed by the Advancement reporting team.
• Translates business requirements into report objects with appropriate levels of security.
• Develops, reviews, and implements new/ongoing reporting functionality and solutions to support Advancement’s goals.
• Develops and enables reporting solutions to interact with cloud-based solutions.