SAP HANA & BW4HANA Architect

Ethereum Technologies; Chicago (IL); On-site; USD 72,000 - 102,000; Full time

Job summary

Ethereum Technologies in Chicago, IL seeks an SAP HANA & BW4HANA Architect to design and implement enterprise data warehousing and reporting solutions. You will model data using SAP HANA and BW/4HANA, and lead SDI/ETL developments to deliver high-performance analytics for business users.

The role requires ABAP and SQL proficiency, strong data modeling skills, and the ability to optimize data pipelines while collaborating with cross-functional teams.

Qualifications

• Proven experience designing and implementing SAP HANA and BW/4HANA data models.
• Hands-on ETL/SDI development and ABAP/SQL proficiency.
• Ability to design scalable data warehouses and optimize performance.

Responsibilities

• Requirement gathering with business stakeholders.
• Architect end-to-end SAP BW/4HANA and SAP HANA solutions.
• Develop and optimize SAP HANA calculation views, CDS views, and BW data models such as ADSOs and Open ODS Views.
• Design and implement SDI/ETL processes for data extraction, transformation and loading.
• Write and tune SQL queries, procedures and scripts for data processing.
• Monitor performance, data load efficiency and system scalability.
• Provide reporting support with clean, reliable data models.
• Perform unit and integration testing and document results.

Skills

SAP HANA Modeling

BW/4HANA Modeling

SDI/ETL

ABAP

SQL

Tools

BODS

Job description

Job Title: SAP HANA & BW4HANA Architect

Location: Chicago, IL

Duration: 6Months + Extension

Bill Rate: $63/hour

Job Type: W-2, 1099, C2C

Client: To Be Discussed Later

Work Authorization: US-Citizen, H-1B, OPT-EAD, GC-EAD

The SAP HANA and BW/4HANA consultant is responsible for designing, developing, and implementing enterprise data warehousing and reporting solutions using SAP HANA Modeling, SAP BW/4HANA, Smart Data Integration (SDI)/ETL, ABAP and SQL.

This role focuses on building scalable data models, integrating data from multiple source systems, and enabling high-performance analytics and reporting for business users.

Key Responsibilities / Steps:

• Requirement Gathering: Work with business stakeholders to understand reporting, analytics, and data integration requirements.


• Solution Design: Architect end-to-end SAP BW/4HANA and SAP HANA solutions aligned with business and technical needs.


• Data Modeling: Develop and optimize SAP HANA calculation views, CDS views, and SAP BW/4HANA data models such as ADSOs, Composite Providers, and Open ODS Views.


• Data Integration: Design and implement SDI/ETL processes for extracting, transforming, and loading data from SAP and non-SAP systems.


• SQL Development: Write and tune complex SQL queries, procedures, and scripts for data processing and performance optimization.


• Performance Optimization: Monitor and improve query performance, data load efficiency, and system scalability.


• Reporting Support: Enable reporting tools and dashboards by providing clean, reliable, and well-structured data models.


• Testing & Validation: Perform unit testing, integration testing, and data validation to ensure data accuracy and consistency.


• Documentation: Prepare technical design documents, data flow diagrams, and support documentation.

Experience in BW 7.5 on HANA to BW/4HANA migration Required Skills:

• Strong experience in SAP HANA Modeling


• Expertise in SAP BW/4HANA modeling


• Hands-on experience with Smart Data Integration (SDI) and ETL processes Experience on ABAP


• Advanced knowledge of SQL Knowledge on BODS Understanding of data warehousing concepts, performance tuning, and reporting architectures Ability to collaborate with cross-functional teams and business stakeholders

We are an equal opportunity employer. All aspects of employment including the decision to hire, promote, discipline, or discharge, will be based on merit, competence, performance, and business needs. We do not discriminate on the basis of race, color, religion, marital status, age, national origin, ancestry, physical or mental disability, medical condition, pregnancy, genetic information, gender, sexual orientation, gender identity or expression, national origin, citizenship/ immigration status, veteran status, or any other status protected under federal, state, or local law.