Business Intel Developer II

University of Rochester; City of Rochester (NY); Hybrid; USD 61.000 - 85.000; Vollzeit

Zusammenfassung

University of Rochester is seeking a data reporting specialist to develop complex reports and dashboards for research, financial, and executive needs. You will design solutions, implement security, and support cloud-based data interactions.

The role requires strong SQL skills, experience with Cognos/Tableau, and collaboration with multiple teams. Hybrid work at a major New York campus with compensation aligned to experience.

Qualifikationen

• Bachelor's degree and 3 years of relevant experience.
• Experience with BI tools such as PowerBI, Business Objects, MicroStrategy, Qlik, IBM Cognos or Tableau.
• Experience in higher education, medical or healthcare industry preferred.
• Experience with Agile project management methodologies preferred.
• Experience in Oracle on Unix DBMS environments preferred.
• 2 years of Student, HCM & Finance reporting experience preferred.

Aufgaben

• Develop reports and dashboards; translate requirements into report objects with appropriate security.
• Design and implement complex dashboards for data warehouse and clarity; maintain reporting environments.
• Write complex ad-hoc queries and reports to support research, financial, and executive initiatives.
• Collaborate with teams to collect data needs and deliver executive reports and function-specific reporting.
• Mentor lower-level staff and support testing, security, and deployment of reporting solutions.

Kenntnisse

IBM Cognos

Tableau

SQL

Data visualization

Ausbildung

Bachelor's degree

Equivalent combination of education and experience

Tools

Oracle Unix DBMS

Jobbeschreibung

Hybrid

Strong Memorial Hospital

Full time

R276192

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 110

Compensation Range:

$61,000.00 - $85,400.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 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 lower level staff 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 to achieve goals and collaborates for solutions. Maintains current knowledge of technology, equipment, and/or systems.

• Other duties as assigned.

Minimum Education & Experience:

• Bachelor's degree and 3 years of relevant experience, including experience with developing reports and dashboards required

• Or equivalent combination of education and experience Experience with one or more Business Intelligence tools, such as PowerBI, Business Objects, MicroStrategy, Qlik, IBM Cognos or Tableau 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 of Student, HCM & Finance experience, specifically with reporting preferred

Knowledge, Skills & 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

• 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

Licenses and Certifications:

• Certified Tableau Specialist (Tableau Desktop Associate Level 1) upon hire preferred

• Workday Report Writer certificate upon 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.

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.