Business Intel Developer II

at  University of Rochester

QUALIFICATIONS:

• High School diploma or equivalent required
• Bachelor’s degree in related discipline such as Computer Science, Mathematics, Statistics, Business, Data Science or Engineering preferred
• 2 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, medical or healthcare industry preferred
• Experience with project management methodologies, including Agile, from planning through implementation preferred
• Experience in the Oracle on Unix DBMS environments preferred
• 2 years Student, HCM & Finance experience, specifically with reporting preferred
• 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
• Ability to contribute both individually and as part of or technically leading a team required
• 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 required preferred
• Tableau Desktop Associate Level 1 preferred
• Workday Report Writer certificate preferred
  The University of Rochester is committed to fostering, cultivating, and preserving a culture of equity, diversity, and inclusion 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 status protected by law. This commitment extends to the administration of our policies, admissions, employment, access, and recruitment of candidates from underrepresented populations, veterans, and persons with disabilities consistent with these values and government contractor Affirmative Action obligations.

GENERAL PURPOSE:

The Business Intelligence Developer II completes development activities as assigned. Additionally, the Business Intelligence Developer II 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. This position will serve as a backup report administrator for the primary application tools. The Business Intelligence Developer II utilizes software to identify metrics and recommend appropriate tasks. The Business Intelligence Developer II 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.

RESPONSIBILITIES:

• Works with users and Business Intelligence Developer I’s to understand and document reporting requirements. Assist in the translation of the business requirements into report objects with an understanding of the appropriate security needed. Develops and enables solutions (reports, 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 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. 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 (e.g. procurement, finance, student, executive/University-wide etc.) Delivers solutions (reports, visualizations) to support the University’s goals.
• Performs analysis activities and creates/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 reporting/database tools to support research, financial, and executive initiatives. Designs, develops and implements dashboard reports and visualizations for data warehouse and clarity. Supports development and maintenance of environments that support the applications used for report writing. Provides mentorship to Business Intelligence Developer I’s in the adoption of training and standards to follow.
• 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. Maintains current knowledge of technology, equipment, and/or systems.
• Performs other related duties, including presentation of seminars, courses and instruction on computer services as required. Participates in on-call responding to application issues as they occur.
  Other duties as assigned