Consulting Application Developer / Business Intelligence Report Developer

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., Working Hours Standard Hours 37.50 Daily Work Shift 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 Seniority Unit 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.

Certifications/Licenses 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.

Grade 37S Salary Details Minimum Salary 121608.000 Mid Range Salary 147221.000 Maximum Salary 175737.000, Rutgers provides a comprehensive benefits package to eligible employees. The specific benefits vary based on the position and may include:

• 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

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.