Sr. Business Intelligence Developer

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) :

601 Elmwood Ave, Rochester, New York, United States of America, 14642

Opening : Worker Subtype :

Regular

Time Type : Full time

Scheduled Weekly Hours :

40

Department : 900081 ISD Analytics

Work Shift :

UR - Day (United States of America)

Range : UR URG 113

Compensation Range :

$77,216.00 - $115,824.00

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.

Responsibilities : GENERAL PURPOSE

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.

ESSENTIAL FUNCTIONS

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

MINIMUM EDUCATION & EXPERIENCE

Bachelor's Degree in related discipline Required

Master's degree preferred

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

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

KNOWLEDGE, SKILLS AND 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, 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.

LICENSES AND CERTIFICATIONS

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

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.

Notice : If you are a Current Employee, please log into myURHR to search for and apply to jobs using the Jobs Hub. Your application, if submitted using this portal, cannot be moved forward.

Learn. Discover. Heal. Create.

Located in western New York, Rochester is our namesake and our home. One of the world's leading research universities, Rochester has a long tradition of breaking boundaries-always pushing and questioning, learning and unlearning. We transform ideas into enterprises that create value and make the world ever better.

If you're looking for a career in higher education or health care, the University of Rochester may offer the perfect opportunity for your background and goals

At the University of Rochester, we are committed to fostering, cultivating, and preserving an inclusive and welcoming culture and are united by a strong commitment to be ever better-Meliora. It is an ideal that informs our shared mission to ensure all members of our community feel safe, respected, included, and valued.