Remote SAP BW/4HANA Data Warehouse Architect

AXR Group Pty Ltd; Logan City; Hybrid; AUD 150,000 - 190,000; Full time

Job summary

AXR Group Pty Ltd is seeking an experienced SAP data warehouse architect/engineer to design, build and govern a enterprise data warehouse on SAP BW/4HANA and SAP Datasphere. The role feeds SAP Analytics Cloud and Power BI for finance, project cost, sales and procurement; accuracy and reconciliation are critical as the numbers drive trust.

Based in Beenleigh, Queensland, with remote and work-from-home options available and occasional travel to project sites and AXR offices across Australia.

Qualifications

• Five+ years in SAP data warehousing in production.
• Strong dimensional modelling and star-schema skills.
• Expertise in HANA SQL/SQLScript.
• Experience with ETL and data replication tools.
• Ability to reconcile warehouse data to ERP financials.
• Experience with SAP Analytics Cloud or Power BI.

Responsibilities

• Design data architecture, including layers, models, dimensions and hierarchies.
• Build and maintain ETL/ELT using SAP BW, Datasphere data flows, SAP Data Services or SLT.
• Model financial, project cost, sales and procurement data for reconciled reports.
• Set data quality rules, master data and reconciliation controls.
• Develop semantic layer and reporting views for SAC and Power BI.
• Tune query, load and HANA object performance.
• Set data access roles and security per policy.
• Document data dictionary, lineage and load schedules.
• Collaborate with business owners to define KPIs and reporting requirements.

Skills

Data modelling

Advanced SQL

ETL & data replication

ERP reconciliation

BI reporting

Tools

SAP BW/4HANA

SAP Datasphere

HANA SQL

SQLScript

Power BI

SAP Analytics Cloud

Job description

AXR Group Pty Ltd is seeking an experienced SAP data warehouse architect/engineer to design, build and govern a enterprise data warehouse on SAP BW/4HANA and SAP Datasphere. The role feeds SAP Analytics Cloud and Power BI for finance, project cost, sales and procurement; accuracy and reconciliation are critical as the numbers drive trust.

Based in Beenleigh, Queensland, with remote and work-from-home options available and occasional travel to project sites and AXR offices across Australia.