SAP Data Warehouse Expert

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

About the role

You will design, build and govern AXR's enterprise data warehouse on SAP BW/4HANA and SAP Datasphere. The warehouse will feed SAP Analytics Cloud and Power BI reporting for finance, project cost, sales and procurement. Your work decides whether the numbers can be trusted, so accuracy and reconciliation matter as much as speed.

Key responsibilities

• Design the data architecture, including layers, data models, star schemas, dimensions and hierarchies.
• Build and maintain extraction, transformation and load processes using SAP BW, Datasphere data flows, SAP Data Services or SLT replication.
• Model financial, project cost, sales and procurement data so that warehouse reports reconcile to the general ledger.
• Set and enforce data quality rules, master data standards and reconciliation controls.
• Build the semantic layer and reporting views for SAP Analytics Cloud and Power BI.
• Tune query, load and HANA object performance.
• Set data access roles and security in line with company policy.
• Document the data dictionary, data lineage and load schedules.
• Work with business owners to define KPIs and reporting requirements.

Essential requirements

• At least five years' experience in SAP data warehousing, with SAP BW/4HANA or SAP Datasphere in production.
• Strong data modelling skills, including dimensional modelling, star schemas and slowly changing dimensions.
• Advanced SQL, with HANA SQL or SQLScript experience.
• Experience with ETL and data replication tools.
• Experience reconciling warehouse data back to ERP financials.
• Experience with SAP Analytics Cloud or Power BI.

Desirable

• Knowledge of SAP S/4HANA finance (FI/CO) and project system (PS) data structures.
• SAP certification in BW, Datasphere or HANA.
• Python for data engineering tasks.
• Experience with a data governance framework.
• Construction, property or project-based sector experience.

The person we are looking for

• Exacting about data accuracy, and says so when a number doesn't reconcile.
• Can walk a finance team through a technical design without jargon.
• Plans for the next three years of reporting, not just this month's.

Work arrangement

Based in Beenleigh, Queensland . Remote and work-from-home arrangements are available for this role. Working from AXR offices in other Australian locations is acceptable. Some travel to project sites and to Beenleigh may be needed.