Sr Business Intel Developer, Advancement

University of Rochester
•$77,600 - $116,400•Onsite

About The Position

The Sr Business Intel Developer, Advancement provides primary oversight, responsibility, and leadership for implementing and managing University Advancement reporting systems, information assets, and business intelligence delivery. The role designs, develops, directs, tests, implements, and maintains policies and procedures supporting Advancement reporting systems. The developer collaborates with cross-functional teams and the Advancement Salesforce ascend support team to optimize reporting systems and provide accurate, timely data and reports. The role serves as a functional project manager and application administrator for new functionality and enhancements, creates and reviews data audits and quality processes, and coordinates with university finance and business managers to assess needs and resources. In partnership with the Senior Director of Advancement Information Services, the role supports the strategic vision of the Associate Vice President of Advancement Services and may mentor or train junior staff. The position covers business intelligence and application administration, report development and optimization, data integrity and security oversight, customer service, and professional development and leadership. It may supervise junior reporting staff and monitor their work. Other duties may be assigned.

Requirements

  • Bachelor's degree and 5 years of relevant experience, or an equivalent combination of education and experience.
  • Experience developing reports and dashboards with one or more business intelligence tools, such as PowerBI, Business Objects, MicroStrategy, Qlik, IBM Cognos, or Tableau.
  • Excellent verbal and written communication skills.
  • Customer-oriented approach to problem solving.
  • Ability to handle multiple tasks and meet deadlines.
  • Ability to contribute individually and as a technical lead on a team managing multiple business environments, and to work with user communities to translate business needs into solution requirements.

Nice To Haves

  • Master's degree.
  • Experience in higher education, medical, or healthcare industries.
  • Experience with project management methodologies, including Agile, from planning through implementation.
  • Five years of Student, HCM, and Finance experience, specifically with reporting.
  • Experience in an Oracle on Unix DBMS environment.
  • Proficiency with IBM Cognos and Tableau reporting tools.
  • Ability to learn new technologies quickly.
  • Ability to translate business needs into solution requirements.
  • Knowledge of implementing expressions and business logic within an object-oriented environment.
  • In-depth experience and developmental knowledge with SQL programming.
  • Ability to provide on-call support as needed.
  • Experience with Salesforce, SQL Server, or Oracle.
  • Familiarity with the general contents of the Privacy Act, Freedom of Information Act, HIPAA, and FERPA.
  • Certified Tableau Specialist (Tableau Desktop Associate Level 1 or Level 2) upon hire.
  • Workday Report Writer curriculum certificate upon hire.

Responsibilities

  • Oversee and manage reporting systems and business intelligence assets and delivery for University Advancement.
  • Design, develop, direct, test, implement, and maintain reporting-system policies and procedures.
  • Collaborate with cross-functional teams and the Advancement Salesforce ascend support team to optimize systems and deliver accurate, timely data and reports.
  • Act as functional project manager and application administrator for the design, testing, and implementation of system functionality and enhancements.
  • Create and review data audits and quality processes to validate deliverables.
  • Coordinate with university finance and business managers to assess needs and resources.
  • Communicate problems and resolutions with the Senior Director and discuss data-integrity issues with the Advancement IS team; help align data-entry practices with documented policies and procedures.
  • Develop queries of Salesforce data tables to verify report accuracy and compliance with business rules.
  • Ensure reports and dashboards meet Advancement reporting standards and are thoroughly tested.
  • Outline strategies for developing and maintaining environments that support the Salesforce ascend report-writing application.
  • Lead design, development, and testing sessions with Advancement staff and teams to capture report requirements and data.
  • Develop and review report specifications and ensure requirements are met across functional areas.
  • Develop, write, and maintain standard reports, and guide the functionality of ad hoc reports created by the Advancement reporting team.
  • Translate business requirements into report objects with appropriate security levels.
  • Develop, review, and implement reporting functionality and solutions that support Advancement goals, including solutions that interact with cloud-based systems.
  • Analyze complex information from Advancement staff and leadership to develop reports and reporting systems as needed.
  • Design, develop, and implement complex dashboard reports and visualizations.
  • Organize, document, and streamline reporting methods; write functional specifications and prepare testing scripts for new functionality and enhancements.
  • Direct testing of system modifications and obtain customer approvals.
  • Investigate reporting-system concerns by monitoring logs, communicate issues with University IT as appropriate, conduct repairs, and test reports for accuracy and data integrity.
  • Lead development and maintenance of security architecture and workflow automation within the reporting application.
  • Ensure conformance with Advancement and university standards and procedures, including required paperwork and documentation.
  • Prepare and maintain data models and reporting policies as needed, and review standards and documentation for report and dashboard conformance.
  • Work with Advancement Learning & Development to document and communicate new processes, enhancements, and reporting-application modifications to customers.
  • Meet with customers to ensure reports are developed to meet their needs, and recommend solutions such as training, preferred report types, documentation, or reporting structures.
  • Recommend additional training, documentation, and other adjustments to the Senior Director.
  • Attend conferences and user-group or peer meetings to keep Advancement current with industry best practices.
  • Mentor staff and lead change management; guide and train new or junior staff, and potentially supervise junior reporting staff and monitor their work.
  • Perform other duties as assigned.
© 2026 Teal Labs, Inc
Privacy PolicyTerms of Service