Consulting Application Developer / Business Intelligence Report Developer

Consulting Application Developer / Business Intelligence Report DeveloperRutgers, 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.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 - ExemptGrade - 37SSalary DetailsMinimum Salary - 121608.000Mid Range Salary - 147221.000Maximum Salary - 175737.000Benefits - 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 programsPosition Status - Full TimeWorking HoursStandard Hours - 37.50Daily Work ShiftWork 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 View email address on click.appcast.io Application System.Union Description - HPAE 5094Payroll Designation - PeopleSoftSeniority UnitTerms of Appointment - Staff - 12 monthPosition Pension Eligibility - ABPQualificationsMinimum 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/LicensesRequired 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.Preferred QualificationsEquipment UtilizedPhysical Demands and Work Environment - PHYSICAL DEMANDS: Standing, sitting, walking, talking or hearing. No special vision requirements. WORK ENVIRONMENT: Office environment. Moderate noise.Special Conditions Rutgers University