University of Rochester Advancement · 5 hours ago
Sr Business Intelligence Developer
30 Corporate Woods
Full-time
Onsite
Mid, Senior Level
$77K/yr - $116K/yr
5+ years expThe University of Rochester is committed to fostering an inclusive culture. They are seeking a Senior Business Intelligence Developer to lead development work and collaborate with cross-functional teams to enhance reporting and associated applications. The role involves creating data quality processes, developing metrics, and supporting research teams by analyzing data.
Higher Education
Responsibilities
The Senior Business Intelligence Developer is responsible for completing all development work assigned
The Senior Business Intelligence Developer collaborates with cross functional teams and provides leadership for design, development, configuration, testing, implementation, maintenance, security of reporting and associated applications supporting University systems and applications
This position creates and reviews data audit and quality processes for the validation of deliverables
The Sr Business Intelligence Developer utilizes software to generate metrics and develops actionable recommendations and may serve as the primary administrator for the business intelligence application tools
This position provides support to research teams or management by collecting and analyzing data and reporting results based on the needs of end users and collaborates with various functional teams based on their area of focus and IT to achieve business results
Serves / Assists as the lead application administrator for the Business Intelligence application which includes upgrades, patching, configuration and directory/security administration
Serves and assists as a systems administrator for the infrastructure supporting the business intelligence (BI) applications listed above including configuration, troubleshooting and periodic maintenance
Supports the development of strategies for warehouse implementation, data acquisitions and archive recovery
Develops SQL queries and modifications to facilitate problem resolution and reporting needs
Leads design sessions to capture requirements and data for report development
Leads development teams with proper span of control
Develops/reviews report specifications and ensure those requirements are met across all functional areas (e.g. procurement, finance, student, executive/University-wide etc.)
Translates/ reviews business requirements into report objects with appropriate security
Analyzes team member’s reports to ensure they meet user requirements
Develops, reviews and enables solutions (reports, visualizations) to support the University’s goals
Validates the audit and reconciliation processes associated with reporting
Leads activities supporting development and maintenance of security architecture, security administration and workflow automation within the applications suite
Ensure conformance to departmental/university standards and procedures by reviewing and preparing necessary paperwork and documentation
Executes unit tests
Works closely with application testers on the preparation of test plans, test data and integrated unit testing
Maintains a broad knowledge of technology, equipment, and/or systems
Designs and delivers executive reports as well as function specific reporting
Develops and enables reporting solutions to interact with cloud-based solutions
Writes ad-hoc queries and reports using various reporting/database tools to support research, financial, and executive initiatives
Analyzes and synthesizes complex and diverse information gathered from senior management and end-users to develop new reports and reporting systems as needed
Designs, develops and implements complex dashboard reports and visualizations for data warehouse and clarity
Outlines strategies for the development and maintenance of environments that support the applications used for report writing
Supports the University’s communications outlets for reporting tools such as Upstate NY Tableau Users Group and Upstate NY IBM Cognos Users Group
Coordinates with other resources (programmers, analysts) to achieve goals and collaborate for solutions
Serves as a mentor and change management lead in the delivery of reporting training
Performs other related duties, including presentation of seminars, courses and instruction on computer services as required
Other duties as assigned
Qualification
Required
Bachelor's Degree in related discipline required
5 years of relevant experience, including experience with developing reports and dashboards with one or more Business Intelligence tools such as PowerBI, Business Objects, MicroStrategy, Qlik, IBM Cognos, Tableau required
Equivalent combination of education training and/or experience required
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
Preferred
Master's degree preferred
Experience in higher education field, medical or healthcare industry preferred
Experience with project management methodologies, including Agile, from planning through implementation preferred
5 years Student, HCM & Finance experience, specifically with reporting preferred
Experience in the Oracle on Unix DBMS environments preferred
Experience with EPIC reporting preferred
Proficiency with reporting tools IBM Cognos, SQL, SSRS 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 required
Tableau Desktop Associate Level 1, Level 2 preferred
Workday Report Writer curriculum certificate preferred
Epic Clinical Data Model and/or Epic Revenue Data Model may be required within 12 months of hire preferred
Company
University of Rochester Advancement
The University of Rochester, one of the nation’s top private research universities, has built a national caliber advancement program in support of the largest campaign in the University’s history.
201-500 employees
Funding
Current Stage
Growth StageCompany data provided by crunchbase