SAP BW on HANA Consultant

Job Title: SAP BW on HANA Consultant
Location: Dallas, TX (Hybrid)
Duration: 7 Months
 
Note: Preferred candidate will be based in the Dallas area and able to work onsite two days per week. Remote candidates with strong SAP BW 7.5, BW on HANA, and Native HANA Modeling experience will also be considered. Local talent is strongly preferred.
 
Position Summary
We are seeking an experienced SAP BW on HANA Consultant to support enterprise data and analytics initiatives within a large-scale SAP landscape. This role will be responsible for designing, developing, and optimizing SAP BW and Native HANA solutions that enable high-volume data extraction, integration, reporting, and advanced analytics. The ideal candidate will possess deep expertise in SAP BW 7.5, BW on HANA, Native HANA Modeling, Calculation Views, SQLScript, and data provisioning frameworks, along with the ability to translate complex business requirements into scalable and high-performing data solutions. Experience supporting Supply Chain data domains and integrating SAP data with external platforms is highly desirable.
 
 
Key Responsibilities

• Lead and support end-to-end SAP BW on HANA implementation and enhancement initiatives.
• Design, develop, and optimize SAP BW data models to support enterprise reporting, analytics, and data integration requirements.
• Build and maintain Native HANA solutions using Calculation Views, SQLScript, Stored Procedures, and advanced modeling techniques.
• Design and implement scalable data extraction and provisioning mechanisms from SAP BW and HANA environments for external platform consumption.
• Develop and optimize BW objects including ADSOs, Composite Providers (HCPRs), and data flows within BW on HANA architectures.
• Perform BW object conversions from legacy DSOs, Cubes, MultiProviders, and InfoSets to modern BW on HANA structures.
• Create efficient data integration processes across SAP and non-SAP systems using ODP, Open Hub, and related SAP technologies.
• Proactively identify and resolve performance bottlenecks within SAP BW and HANA environments through tuning and optimization best practices.
• Collaborate with cross-functional teams to integrate SAP data with enterprise analytics and reporting platforms.
• Develop reporting and analytical solutions utilizing SAP BW, SAP BusinessObjects, SAP Analytics Cloud, and related technologies.
• Define and maintain technical specifications, data lineage documentation, governance controls, and solution documentation.
• Partner with business stakeholders and client teams to gather requirements, provide technical guidance, and ensure successful project delivery.
• Support data governance initiatives and ensure data quality, integrity, traceability, and compliance across the SAP landscape.

 
Required Qualifications

• Expert-level experience in SAP Native HANA Modeling, including Calculation Views, SQLScript, and Stored Procedures.
• Deep expertise in SAP BW 7.5 development, administration, data modeling, and data flows.
• Strong understanding of SAP data extraction and provisioning methodologies for external system consumption.
• Experience designing high-volume, real-time, and batch-oriented data pipelines from SAP environments.
• Ability to bridge SAP technical solutions with enterprise analytics and data platform requirements.
• Strong analytical, problem-solving, communication, and consulting skills.

Required Experience

• 10-15 years of professional experience in SAP BW and SAP HANA development, architecture, and implementation.
• Proven experience delivering end-to-end SAP BW on HANA implementations and modernization initiatives.
• Strong consulting and stakeholder management skills with experience working directly with client teams and business users.

 
Required Technical Skills

• SAP BW 7.5
• SAP BW on HANA
• Native SAP HANA Modeling
• SQLScript
• HANA Calculation Views
• HANA Stored Procedures
• ADSO (Advanced DataStore Objects)
• HCPR (Composite Providers)
• Data Warehousing Architecture
• Data Modeling and Data Integration
• Performance Tuning and Optimization
• Data Extraction and Provisioning
• ODP (Operational Data Provisioning)
• Open Hub
• SAP to Non-SAP Data Integration
• Technical Documentation and Data Governance

 
Preferred Skills

• SAP Supply Chain Management (SCM)
• Materials Management (MM)
• Production Planning (PP)
• Sales & Distribution (SD)
• SAP Analytics Cloud (SAC)
• SAP BusinessObjects (BOBJ)
• Databricks Integration
• Enterprise Reporting and Analytics Solutions

 
Preferred Domain Experience

• Supply Chain Management (SCM)
• Procurement and Materials Management (MM)
• Production Planning (PP)
• Sales & Distribution (SD)

 

At SPECTRAFORCE, we are committed to maintaining a workplace that ensures fair compensation and wage transparency in adherence with all applicable state and local laws. This position's pay range is $41.18/hr – $50.85/hr.