Consulting Application Developer / Business Intelligence Report Developer

Rutgers University; New Brunswick (NJ); Hybrid; USD 122,000 - 176,000; Full time

Benefits offered by this job

Medical benefits

Paid vacation

Retirement plan

Educational benefits

Life insurance

Employee discounts

Job summary

Rutgers University is seeking a Consulting Application Developer / Business Intelligence Report Developer in the Enterprise Applications and Research Computing (EARC) within the Office of Information Technology (OIT). This hands-on role collaborates with stakeholders to gather dashboard requirements and deliver BI reporting solutions using Oracle Analytics Cloud, Oracle BI Publisher, and Tableau.

The role emphasizes data warehousing, data delivery, and best practices across the full project

Qualifications

• Bachelor's degree in relevant field is required.
• Seven (7) years of experience as a BI reporting/dashboard development.
• Equivalent education, experience and/or training may be substituted for the degree requirements.

Responsibilities

• Responsible for all aspects of the BI reporting and dashboard development life cycle, from the initial kickoff through the requirements analysis, design, implementation, and support.
• Establish standards and best practices for BI dashboards and related technologies.
• Provides guidance, and mentoring to less experienced developers on BI reporting development lifecycle including tools, methodology and best practice, and provides support to user community.
• Helps with BI strategy and evangelize business intelligence reporting solutions to foster user adoption (including demos, educational materials, etc.)
• Keeps abreast of the latest BI, reporting and ETL technologies. Participates in the BI community, participates in forums, conferences, meetings, and presentations.

Skills

SQL

Data Visualization

BI Reporting

Tableau

Oracle Analytics Cloud

Oracle BI Publisher

ETL

Communication

Education

Bachelor's degree in relevant field

Tools

Tableau

Oracle Analytics Cloud

Oracle BI Publisher

Job description

Title

Consulting Application Developer / Business Intelligence Report Developer

Job Category

Staff & Executive - Information Technology

Department

Enterprise Application Service

Overview

Rutgers, The State University of New Jersey, is a leading national research university and the State of New Jersey's preeminent, comprehensive public institution of higher education. As one of the largest employers in the State of New Jersey, Rutgers University is committed not only to the students and the State that we serve, but also to the faculty and staff who work on our campuses.

For two consecutive years, Rutgers is ranked on Forbes' list of America's Best Large Employers. Rutgers holds #64 of 500 employers and is the #1 New Jersey employer on the publication's 2023 list. Rutgers' commitment to its employees includes maintaining and fostering a safe, diverse, and respectful workplace environment, creating employment opportunities for our nation's military veterans, and ensuring accessibility, and accommodation for individuals with disabilities.

Posting Summary

Rutgers, The State University of New Jersey, is seeking a Consulting Application Developer / Business Intelligence Report Developer in the Department of Enterprise Applications and Research Computing (EARC) within the Office of Information Technology (OIT).

Under the direction of the Sr. Manager of Business Intelligence within OIT Enterprise Application Services (EAS), this position is a hands-on technical role. The position works closely with stakeholders to discuss organizational needs and gather dashboard requirements. They design, develop and implement Business Intelligence based reporting/dashboard solutions (i.e. Oracle Analytics Cloud reporting, Oracle BI Publisher reporting, Tableau reporting) to address business questions and improve business outcomes. The BI developer partners with various IT personnel and stakeholders in identifying required data elements. The developer has knowledge of data warehousing and business intelligence, including data architecture, sourcing, reporting and analytics through the entire project lifecycle. The Business Intelligence Developer is a key role in the architecture, delivery and governance of reporting and data delivery. They help evangelize business intelligence reporting solutions to foster user adoption (including demos, educational materials, etc.). They provide support as a BI subject matter expert and are responsible for ensuring that Rutgers creates and adheres to Business Intelligence best practices and principles.

Among the key duties of this position are the following:

• Responsible for all aspects of the BI reporting and dashboard development life cycle, from the initial kickoff through the requirements analysis, design, implementation, and support. Includes, performing detailed data analysis (i.e. determining the structure, content, and quality of the data through examination of source systems and data samples). Defines, executes and interpret complex/nested SQL queries determining data requirements.
• Establish standards and best practices for BI dashboards and related technologies. Manages a repository of re-usable data visualization templates and views. Support activities to document, evolve, and communicate artifacts developed using BI reporting work.
• Provides guidance, and mentoring to less experienced developers on BI reporting development lifecycle including tools, methodology and best practice, and provides support to user community.
• Helps with BI strategy and evangelize business intelligence reporting solutions to foster user adoption (including demos, educational materials, etc.)
• Keeps abreast of the latest BI, reporting and ETL technologies. Participates in the BI community, participates in forums, conferences, meetings, and presentations.

FLSA

Exempt

Grade

37S

Salary

• Minimum Salary: 121608.000
• Mid Range Salary: 147221.000
• Maximum Salary: 175737.000

Offer Information

The final salary offer may be determined by several factors, including, but not limited to, the candidate's qualifications, experience, and expertise, and availability of department or grant funds to support the position. We also take into consideration market benchmarks, if and when appropriate, and internal equity to ensure fair compensation relative to the university's broader compensation structure. We are committed to offering competitive and flexible compensation packages to attract and retain top talent.

Benefits

• Medical, prescription drug, and dental coverage
• Paid vacation, holidays, and various leave programs
• Competitive retirement benefits, including defined contribution plans and voluntary tax-deferred savings options
• Employee and dependent educational benefits (when applicable)
• Life insurance coverage
• Employee discount programs

Position Status

Full Time

Standard Hours

37.50

Work Arrangement

Consistent with the current application of Rutgers Policy 60.3.22 or the applicable provisions of relevant collective negotiations agreements, this position may be eligible for a hybrid work arrangement. Flexible work arrangements are not permanent, are subject to change or discontinuation, and contingent on the employee receiving approval in the FlexWork@RU Application System.

Union Description

HPAE 5094

Payroll Designation

PeopleSoft

Terms of Appointment

Staff - 12 month

Position Pension Eligibility

ABP

Minimum Education and Experience

• Bachelor's degree in relevant field is required.
• Seven (7) years of experience as a BI reporting/dashboard development.
• Equivalent education, experience and/or training may be substituted for the degree requirements.

Required Knowledge, Skills, and Abilities

• Knowledge of best practices in data visualization and Business Intelligence, including but not limited to cutting-edge software features and capabilities of Oracle Analytics Cloud, Oracle BI Publisher and Tableau.
• Experience using BI reporting solutions including troubleshooting issues and explaining functionality to business users.
• Experience developing content for and delivering training to others on the use of Oracle Analytics Cloud, Tableau or similar Business Intelligence solution.
• Experience with ETL tools or performing ETL processes.
• Strong aptitude for enhancing and automating queries from data sources such as relational databases and flat files.
• Experience analyzing data from large datasets, using geospatial and/or statistical analysis tools.
• Extensive experience developing and delivering BI reporting training, managing and tracking end user requests and troubleshooting BI reporting solution issues.
• Excellent communication skills and proven ability to work with business customers, and technical teams.

Physical Demands

• Standing, sitting, walking, talking or hearing. No special vision requirements.

Work Environment

• Office environment. Moderate noise.

Posting Details

• Regional Campus: Rutgers Biomedical and Health Sciences (RBHS)
• Home Location Campus: Off Campus
• City: Somerset
• State: NJ

Pre-employment Screenings

All offers of employment are contingent upon successful completion of all pre-employment screenings.

Immunization Requirements

Under Policy 100.3.1 Immunization Policy for Covered Individuals, if employment will commence during Flu Season, Rutgers University may require certain prospective employees to provide proof that they are vaccinated against Seasonal Influenza for the current Flu Season, unless the University has granted the individual a medical or religious exemption. Additional infection control and safety policies may apply. Prospective employees should speak with their hiring manager to determine which policies apply to the role or position for which they are applying. Failure to provide proof of vaccination for any required vaccines or obtain a medical or religious exemption from the University will result in rescission of a candidate's offer of employment or disciplinary action up to and including termination.

Equal Employment Opportunity Statement

It is university policy to provide equal employment opportunity to all its employees and applicants for employment regardless of their race, creed, color, national origin, age, ancestry, nationality, marital or domestic partnership or civil union status, sex, pregnancy, gender identity or expression, disability status, liability for military service, protected veteran status, affectional or sexual orientation, atypical cellular or blood trait, genetic information (including the refusal to submit to genetic testing), or any other category protected by law. As an institution, we encourage all qualified applicants to apply. For additional information please see the Non-Discrimination Statement at the following web address: http://uhr.rutgers.edu/non-discrimination-statement