Business Intel Developer II

Location: City of Rochester

## Business Intel Developer IIApplylocations:
120 Corporate Woodstime type:
Full time posted on:
Posted Todayjob requisition :
R272386

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):
** 120 Corporate Woods, Rochester, New York, United States of America, 14623
** Opening:
** Worker Subtype:

Regular Time Type:

Full time Scheduled Weekly

Hours:

40

Department:500160 Pharmacy SMH

Work Shift:

UR - Day (United States of America)
Range:

UR URG 110

Compensation Range:$60,431.00 - $84,603.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:
** Completes development activities as assigned. Assists the team with advanced design and development activities and configuration, testing, implementation, maintenance, security of reporting and associated applications, supporting the core University systems and applications. Serves as a backup report administrator for the primary application tools. Utilizes software to identify metrics and recommend appropriate tasks. 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:

*** Works with users to understand and document reporting requirements. Assists in the translation of the business requirements into report objects with an understanding of the appropriate security needed. Develops and enables solutions, such as reports and visualizations to support the University’s goals. Designs and develops executive reports, as well as function specific reporting. Develops and enables reporting solutions to interact with cloud-based solutions.

Writes complex ad-hoc queries and reports using various reporting/database tools to support research, financial, and executive initiatives. Analyzes and synthesizes complex and detailed 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. Oversees and contributes to the development and maintenance of environments that support the applications used for report writing.

Develops and supports strategies for warehouse implementation, data acquisitions, and archive recovery. Designs and conducts various data testing techniques against the deliverable. Develops SQL queries and modifications to facilitate problem resolution and reporting needs.
* Participates in design sessions to capture requirements and data for report development. Develops and reviews report specifications and ensures those requirements are met across all functional areas. Delivers solutions to support the University’s goals.
* Performs analysis activities and participates in the creation of the functional specification, under the direction of more senior applications development staff. Develops and maintains security architecture, security administration, and workflow automation within the applications suite. Prepares necessary paperwork and documentation to ensure conformance to departmental/University standards and procedures. Executes unit tests. Works with application testers on the preparation of test plans, test data, and integrated unit testing.

Delivers executive reports, as well as function specific reporting. Writes reports using cloud-based data sets. Writes adhoc queries and reports using various…