About the Role
The Senior Business Intelligence Developer is responsible for completing assigned development work, collaborating with cross-functional teams, and providing leadership for the design, development, configuration, testing, implementation, maintenance, and security of reporting and associated applications supporting University systems. This role involves creating and reviewing data audit and quality processes, utilizing software to generate metrics, developing actionable recommendations, and potentially serving as the primary administrator for business intelligence application tools. The position supports research teams and management by collecting and analyzing data, reporting results, and collaborating with various functional teams and IT to achieve business objectives.
Responsibilities
- Serves/Assists as the lead application administrator for the Business Intelligence application, including upgrades, patching, configuration, and directory/security administration.
- Serves and assists as a systems administrator for the infrastructure supporting the business intelligence (BI) applications, 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 ensures requirements are met across all functional areas.
- 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.
- Ensures 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.
- 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.
Requirements
- Bachelor's degree and 5 years of relevant experience required
- Experience with developing reports and dashboards with one or more Business Intelligence tools, such as PowerBI, Business Objects, MicroStrategy, Qlik, IBM Cognos, Tableau, 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
Skills
- PowerBI
- Business Objects
- MicroStrategy
- Qlik
- IBM Cognos
- Tableau
- SQL programming
- reporting tools
- dashboard development
- data analysis
- problem solving
- communication
- project management methodologies
- Agile
Location
- 1000 South Ave, Rochester, New York, United States of America, 14620
Work Type
- Full time
- 40 hours per week
Experience Level
- 5 years of relevant experience
Education Level
- Bachelor's degree
- Master's degree preferred
Salary/Compensations
- $77,600.00 - $116,400.00
Benefits
- On-call support as needed preferred
About the Company
- 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.
Equal Opportunity
- 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.
