Senior Data Engineer BigQuery (GCP/SAP Data) (m/f/d)

About the Role

Halian is seeking a Senior Data Engineer – BigQuery (GCP/SAP Data) for a contract position in Al Khobar, Eastern Province. This role supports a significant enterprise cloud data transformation project focused on migrating critical Finance and HR reporting workloads from SAP BW on HANA to Google BigQuery. The successful candidate will manage the data engineering layer, ensuring data quality, performance, and security.

Role Context and Objectives

The Senior Data Engineer will take ownership of various aspects of the data engineering layer, including SAP S/4HANA ingestion, migration of SAP BW transformation logic, BigQuery data modelling, and pipeline orchestration. The role also involves implementing robust security measures, optimizing performance, and ensuring data reconciliation. A key objective is to support the creation of high-quality, AI-ready datasets for advanced analytics, conversational analytics, and predictive use cases.

Key Responsibilities

• Analyze existing SAP BW data flows, including DataSources, DSOs, InfoCubes, transformations, ABAP routines, and APDs, and rebuild the required transformation logic using BigQuery SQL.
• Ingest and integrate data from SAP S/4HANA, SAP ECC, and/or SAP BW into Google Cloud-based data platforms.
• Design scalable BigQuery data models utilizing raw, curated, and reporting layers.
• Build complex data structures, including hierarchies, time-dependent master data, dimensional models, and star schemas.
• Develop, orchestrate, and monitor data pipelines using Cloud Composer / Apache Airflow, including automated alerting for pipeline and load failures.
• Implement data security within BigQuery, including row-level security (RLS), column-level security (CLS), authorized views, role-based access, and PII masking.
• Optimize BigQuery workloads for performance and cost using partitioning, clustering, query optimization, and efficient data modelling.
• Build automated data-quality controls and reconciliation processes to validate migrated datasets against existing SAP BW reporting.
• Produce and maintain data lineage, transformation documentation, and source-to-target mappings.
• Prepare governed AI-ready datasets for conversational analytics, predictive use cases, and downstream AI applications.
• Support downstream reporting and analytics solutions developed using Looker or custom web applications.
• Collaborate with business, Finance, HR, SAP, cloud, analytics, and reporting teams to validate business logic and data accuracy.

Experience and Qualifications

Candidates should possess 5-10 years of experience in data engineering, with a strong focus on cloud data transformation projects. Expertise in SAP data environments and Google BigQuery is essential for this role.

Work Environment

This is a contract position based in Al Khobar, Eastern Province. The role involves working closely with various internal teams, including business stakeholders, Finance, HR, SAP, cloud, analytics, and reporting teams, to ensure successful project delivery and data integrity.