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

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.

Customer Service

• Works with Advancement Learning & Development to ensure new processes, enhancements, and other modifications to the reporting application are properly documented and disseminated to customers.
• Responsible for conducting meetings with customers to ensure their reports are developed to meet their needs.
• Develops solutions to address Advancement’s reporting needs such as additional training, preferred report types, documentation, reporting structure, etc.
• Makes recommendations to the Senior Director for additional training, documentation, and other adjustments as needed.

Professional Development & Leadership

• Attends conferences and user group/peer meetings to ensure Advancement stays current with industry’s best practices.
• Serves as a mentor and change management lead; guides and trains new/junior staff. May supervise junior reporting staff members and monitor work.

Other duties as assigned.

Minimum Education & Experience:

• Bachelor's degree and 5 years of relevant experience required
• Master's degree preferred
• Or equivalent combination of education and experience Experience with developing reports and dashboards with one or more Business Intelligence tools, such as PowerBI, Business Objects, MicroStrategy, Qlik, IBM Cognos, Tableau, required
• Experience in higher education field, medical or healthcare industry preferred
• Experience with project management methodologies, including Agile, from planning through implementation preferred
• 5 years of Student, HCM & Finance experience, specifically with reporting, preferred
• Experience in Oracle on Unix DBMS environment preferred

Knowledge, Skills & Abilities:

• Excellent verbal and written communications skills required
• Proven customer oriented approach to problem solving required
• Ability to handle multiple tasks at one time and meet required deadlines required
• Contribute individually and as a technical lead on the team that manages multiple business environments, interface with user communities to translate business needs into solution requirements required
• Proficiency with reporting tools IBM Cognos and Tableau preferred
• Ability to learn new technologies quickly preferred
• Ability to translate business needs into solution requirements preferred
• Knowledge of implementing expressions and business logic within an object oriented environment preferred
• In depth experience and developmental knowledge with SQL programming preferred
• Ability to provide on-call support as needed preferred
• Experience with Salesforce, SQL Server, or Oracle preferred
• Familiar with general contents of Privacy Act, Freedom of Information Act, HIPAA and FERPA preferred.

Licenses and Certifications:

• Certified Tableau Specialist (Tableau Desktop Associate Level 1, Level 2) upon hire preferred
• Workday Report Writer curriculum certificate upon hire preferred

The University of Rochester is committed to fostering, cultivating, and preserving an inclusive and welcoming culture to advance the University’s Mission to Learn, Discover, Heal, Create – and Make the World Ever Better. In support of our values and those of our society, the University is committed to not discriminating on the basis of age, color, disability, ethnicity, gender identity or expression, genetic information, marital status, military/veteran status, national origin, race, religion, creed, sex, sexual orientation, citizenship status, or any other characteristic protected by federal, state, or local law (Protected Characteristics). This commitment extends to non-discrimination in the administration of our policies, admissions, employment, access, and recruitment of candidates, for all persons consistent with our values and based on applicable law.