Sr Business Intel Developer

University of Rochester • City of Rochester, NY

8d • $77,600 - $116,400 • Onsite

About The Position

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.

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.

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

Nice To Haves

• Master's degree preferred
• Or equivalent combination of education and experience
• 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
• Experience with EPIC reporting preferred
• 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
• Certified Tableau Specialist (Tableau Desktop Associate Level 1, Level 2) upon hire preferred
• Workday Report Writer curriculum certificate upon hire preferred
• Epic Clinical Data Model and/or Epic Revenue Data Model may be required within 12 months of hire preferred

Responsibilities

• Completing all development work assigned.
• Collaborating with cross functional teams and providing leadership for design, development, configuration, testing, implementation, maintenance, security of reporting and associated applications supporting University systems and applications.
• Creating and reviewing data audit and quality processes for the validation of deliverables.
• Utilizing software to generate metrics and developing actionable recommendations.
• Serving as the primary administrator for the business intelligence application tools.
• Providing support to research teams or management by collecting and analyzing data and reporting results based on the needs of end users.
• Collaborating with various functional teams based on their area of focus and IT to achieve business results.
• Serving/Assisting as the lead application administrator for the Business Intelligence application which includes upgrades, patching, configuration and directory/security administration.
• Serving and assisting as a systems administrator for the infrastructure supporting the business intelligence (BI) applications including configuration, troubleshooting and periodic maintenance.
• Supporting the development of strategies for warehouse implementation, data acquisitions and archive recovery.
• Developing SQL queries and modifications to facilitate problem resolution and reporting needs.
• Leading design sessions to capture requirements and data for report development.
• Leading development teams with proper span of control.
• Developing/reviewing report specifications and ensuring those requirements are met across all functional areas (e.g. procurement, finance, student, executive/University-wide etc.).
• Translating/ reviewing business requirements into report objects with appropriate security.
• Analyzing team member’s reports to ensure they meet user requirements.
• Developing, reviewing and enabling solutions (reports, visualizations) to support the University’s goals.
• Validating the audit and reconciliation processes associated with reporting.
• Leading activities supporting development and maintenance of security architecture, security administration and workflow automation within the applications suite.
• Ensuring conformance to departmental/university standards and procedures by reviewing and preparing necessary paperwork and documentation.
• Executing unit tests.
• Working closely with application testers on the preparation of test plans, test data and integrated unit testing.
• Maintaining a broad knowledge of technology, equipment, and/or systems.
• Designing and delivering executive reports as well as function specific reporting.
• Developing and enabling reporting solutions to interact with cloud-based solutions.
• Writing ad-hoc queries and reports using various reporting/database tools to support research, financial, and executive initiatives.
• Analyzing and synthesizing complex and diverse information gathered from senior management and end-users to develop new reports and reporting systems as needed.
• Designing, developing and implementing complex dashboard reports and visualizations for data warehouse and clarity.
• Outlining strategies for the development and maintenance of environments that support the applications used for report writing.
• Supporting the University’s communications outlets for reporting tools such as Upstate NY Tableau Users Group and Upstate NY IBM Cognos Users Group.
• Coordinating with other resources (programmers, analysts) to achieve goals and collaborate for solutions.
• Serving as a mentor and change management lead in the delivery of reporting training.
• Performing other related duties, including presentation of seminars, courses and instruction on computer services as required.
• Other duties as assigned

Benefits

• 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.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior