SAP BW Consultant

Role: SAP BW Consultant

Duration: long term

Location: Princeton, NJ (3 days a week onsite)

Description:
Client is seeking an experienced SAP BW Consultant to join our team. The ideal candidate will be responsible for providing technical and functional support and overseeing the offshore team for SAP BW applications, ensuring data integrity, reporting accuracy, and seamless planning and consolidation processes.

Key Responsibilities:

• Support & Troubleshooting:
  Provide technical support for SAP BW, including troubleshooting issues, resolving system errors, and ensuring smooth operation.
• Data Modeling:
  Design, develop, and maintain data models in SAP embedded BW, ensuring optimal data flow and reporting capabilities.
• Reporting:
  Create and enhance reports using BW Query Designer, Hana Studio, Business Objects reports, and SAP Analysis for Office, ensuring stakeholders have access to accurate data.
• System Monitoring:
  Regularly monitor system performance and resolve any issues related to data loads, process chains, and system health.
• Documentation:
  Help with detailed documentation of processes, configurations, and user guides for BW systems.
• Collaboration:
  Work closely with cross-functional teams, including finance, operations, and IT, to gather requirements and deliver solutions.

Required Skills and Qualifications:

• Education:
  Bachelor or master's degree in Computer Science, Information Technology, Finance, or a related field.
• Experience:
  Minimum 4-7 years of experience in SAP BW support or consulting roles.
  Strong understanding of SAP data warehousing concepts and financial planning processes.
  Experience with SAP S4 Hana. Any experience with Embedded BPC, SAC Planning, and Analytics will be a positive.
• Technical Skills:
• Proficiency in SAP embedded BW, including data extraction, transformation, and loading (ETL).
• Create and manage BW InfoProviders (Multiproviders, Composite Providers, ADSO, DSO, Info Cube, etc.).
• Create/manage data sources within BW and how they can be leveraged.
• Create/maintain master data objects (Info objects, hierarchies, attributes, etc.).
• Create/maintain dimensions, BW hierarchies, BEx queries, BADI, Hana Views, CDS Views, including integration with ABAP classes.
• In-depth knowledge of SAP CO/FA code and maintenance (GL, Company Code, Profit Center, Cost Center, Location Allocation).
• In-depth knowledge of SAP Transport mechanism and Charm (knowledge is a plus).
• Ad-hoc reporting using BW SAP Tables and Analysis for Office front-end reports.
• Create/maintain transformation files and conversion files, and perform data loading related to master data, attributes, text hierarchies, and transaction data.
• Knowledge of ABAP, SQL, and data modeling principles.
• Experience with SAP BPC configuration and usage will be positive.
• Analytical Skills:
  Strong analytical and problem-solving skills with attention to detail.
• Communication:
  Excellent verbal and written communication skills, with the ability to work with diverse teams and stakeholders.
• Certifications:
  SAP BW and/or BPC certification is a plus.

Good to Have:

• Able to assist in the maintenance of BPC applications supporting financial planning, budgeting, and consolidation processes.
• Experience in configuration of Environment Models and Dimensions for Planning and Consolidation.
• Experience in supporting planning sequence, planning function, allocation process.
• Experience in configuration of Work status and Data Auditing.
• Worked on various period open activities, validation of version dimension ownership data, rates, work status, and business process flow activities.

Work Environment:

• Flexibility in working hours may be necessary to accommodate global teams.