Sr. SAP Business Objects BI Analyst (Newark, NJ)

Cedent; Newark (NJ); On-site; USD 120,000 - 150,000; Full time

Job summary

A consulting firm is seeking a Sr. SAP Business Objects BI Analyst based in Newark, NJ. This position will focus on providing comprehensive technical and business support for financial reporting within the SAP Business Objects BI 4.2 ecosystem. Responsibilities include maintaining user security, creating SAP BI Universes, and debugging reports. Ideal candidates should possess strong skills in SAP, Oracle, and be resourceful in automating processes using Python. This role also requires availability for extended support during financial close periods.

Qualifications

• Strong experience with SAP Business Objects BI 4.2 ecosystem.
• Ability to create and maintain complex BI Dimensions and Measures.
• Experience with user security and performance tuning.

Responsibilities

• Provide technical and business support for financial reporting.
• Create and maintain SAP BI IDT Universes.
• Debug and support SAP BI reports and queries.
• Create and maintain complex Universe Dimensions, Measures, Formulas, Parameters, Prompts, and List of Values.
• Create and maintain Strip Lists in Oracle and Essbase Universes.
• Create and maintain dimensions and measures in IDT using Essbase as a data source and complex MDX functions and variables.
• Understanding of Essbase Applications, Hierarchy, Dimensions, Variables, Sessions, and Functions.
• Work with the SAP BI Team at Mars to ensure and maintain environment changes, security changes, and patch updates.
• Maintain complex Web Intelligence reports with multiple data sources, containing more than 10 data providers and several formulas.
• Experience maintaining a large‑scale enterprise with over 100 reports and 1000 SAP BI Publications/Schedules.
• Monitor and performance‑tune recurring schedules when necessary.
• Resourceful and trainable in third‑party software to create financial publications using the PDF Meld tool and Python automation.
• Maintain financial publications security through the web page.
• Assist in maintaining the Oracle tables, views, and materialized views for BO reports.
• Debug and support SAP BI reports, MDX queries, and Oracle SQL metadata.
• Availability for extended support during Week 1 of period close.
• Maintain technical/service documentation.
• Work on resolving technical and data issues.
• Able to move changes to production using promotion management.
• Conduct end‑user testing before the production move.
• Take initiative in understanding business processes.
• Create ServiceNow change requests and follow the defined process on the production move.
• Work on day‑to‑day activities using a logical and common sense approach.

Skills

SAP Business Objects BI

Oracle

Hyperion Essbase

MDX functions

SQL

ServiceNow

IDT Universe

Hyperion Essbase

Oracle

Tools

Python

PDF Meld tool

Oracle

Web Intelligence

Job description

Sr. SAP Business Objects BI Analyst (Newark, NJ)

This role will primarily provide comprehensive technical and business support for client’s Period and Annual Financial Reporting and data integrations across the SAP Business Objects BI 4.2 ecosystem for reporting and organizational hierarchy maintenance for financial close.

Tasks

• Create and maintain new SAP BI IDT Universes using Hyperion Essbase and Oracle.
• Maintain Essbase unit and organizational hierarchy based on business requirements.
• Ability to analyze and maintain user security.
• Create and maintain complex Universe Dimensions, Measures, Formulas, Parameters, Prompts, and List of Values.
• Create and maintain Strip Lists in Oracle and Essbase Universes.
• Create and maintain dimensions and measures in IDT using Essbase as a data source and complex MDX functions and variables.
• Understanding of Essbase Applications, Hierarchy, Dimensions, Variables, Sessions, and Functions.
• Work with the SAP BI Team at Mars to ensure and maintain environment changes, security changes, and patch updates.
• Maintain complex Web Intelligence reports with multiple data sources, containing more than 10 data providers and several formulas.
• Experience maintaining a large‑scale enterprise with over 100 reports and 1000 SAP BI Publications/Schedules.
• Monitor and performance‑tune recurring schedules when necessary.
• Resourceful and trainable in third‑party software to create financial publications using the PDF Meld tool and Python automation.
• Maintain financial publications security through the web page.
• Assist in maintaining the Oracle tables, views, and materialized views for BO reports.
• Debug and support SAP BI reports, MDX queries, and Oracle SQL metadata.
• Availability for extended support during Week 1 of period close.
• Maintain technical/service documentation.
• Work on resolving technical and data issues.
• Able to move changes to production using promotion management.
• Conduct end‑user testing before the production move.
• Take initiative in understanding business processes.
• Create ServiceNow change requests and follow the defined process on the production move.
• Work on day‑to‑day activities using a logical and common sense approach.