Sr Business Intel Developer, Advancement

Location: River Road Complex Advancement, United States of America

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,600.00 - $116,400.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

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
• 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.
• Analyzes and synthesizes broad and complex information gathered from Advancement staff and leadership to develop new reports and reporting systems as needed.
• Designs, develops, and implements complex dashboard reports and visualizations.
• Data Integrity and Security Oversight
• Organizes, documents, and streamlines the various reporting methods utilized by Advancement Services. Writes detailed functional specifications and prepares appropriate testing scripts for new system functionality and enhancements.
• Directs testing of system modifications and solicits customer approvals.
• Investigates reporting application/system concerns by monitoring logs to ensure proper functionality. Communicates issues with University IT as appropriate and conducts repairs accordingly. Tests reports for accuracy and data integrity.
• Leads activities supporting the development and maintenance of security architecture and workflow automation within the reporting application.
• Ensures conformance to Advancement/university standards and procedures by reviewing and preparing necessary paperwork and documentation.
• Prepare and maintain data models and reporting policies when necessary. Review standards and documentation to ensure reports, dashboards, etc. conform to those standards.