SAP BW Consultant

TechDigital Group; Dallas (TX); On-site; USD 80,000 - 110,000; Full time

Job summary

An established industry player is seeking a skilled SAP BI/BW Consultant to enhance their data modeling and reporting capabilities. The role involves hands-on experience with various SAP BI/BW versions, creating and managing reports, and ensuring data accuracy through system maintenance. You will collaborate with both business and IT teams to gather requirements and implement effective solutions. This position offers a dynamic environment where your expertise in SAP HANA and data modeling will significantly impact the organization’s analytical needs. Join a forward-thinking team dedicated to optimizing performance and delivering high-quality data insights.

Qualifications

• Hands-on experience in various SAP BI/BW versions like 7.1, 7.5, BW4AHANA.
• Expert in building graphical and script-based calculation views.

Responsibilities

• Design, develop, and maintain data models and ETL processes.
• Create and manage reports using BEx and other reporting tools.

Skills

SAP BI/BW

Mixed Modeling with Native HANA

Data Modeling

ETL Processes

Reporting Tools

System Maintenance

User Support

Collaboration

Performance Tuning

Documentation

Tools

HANA Studio

SAP BODS

Job description

Skill Requirements

1. Hands on experience in various SAP BI/BW versions like 7.1, 7.5, BW4AHANA.
2. Mixed Modeling with Native HANA.
3. Data Modeling: Design, develop, and maintain data models and data extraction, transformation, and loading (ETL) processes.
4. Reporting: Create and manage reports using BEx (Business Explorer) and other reporting tools.
5. System Maintenance: Ensure data accuracy and integrity, perform system audits, and troubleshoot issues.
6. User Support: Provide training and support to end-users on SAP BW tools and reports.
7. Collaboration: Work with business and IT teams to gather requirements and implement solutions.
8. Performance Tuning: Optimize data models and queries for better performance.
9. Documentation: Maintain detailed documentation of data models, ETL processes, and reporting solutions.
10. Involved in design/architecture of complex SAP HANA data model and visualization for HANA customer 360 analytical needs.
11. Designing and creation of Attribute, Analytical, and Calculation Views (Graphical) using HANA Studio; Creates schemas, tables; Working on different joins (left outer joins or referential joins; Inner Joins; Text Joins).
12. Data Provisioning through DXC, Data Services, SLT, SDA (Smart Data Access), File based.
13. Expert in building Graphical and Script based Calculation view.
14. Highly Skilled in using Rank, Aggregation, Projection, Union, Join Components.
15. Running Explain Plans to understand the backend SQL it generates and improving performance.
16. Performance Improvement of any Calculation Views.
17. Input Parameters: Passing Input Parameters from one Calculation view to other both in Graphical and Script based Calculation view.
18. Hands on experience on SAP BODS to create Job, workflow, Data Model, Transformations, Functions, etc.
19. Concepts on Data modeling.