Job Summary

We are looking for an experienced Data Engineer to design, build, and maintain a scalable, metadata-driven data ingestion and transformation framework on Google Cloud Platform (GCP).

The role will be responsible for developing configuration-driven ingestion pipelines, onboarding multiple source systems, and implementing Raw, Bronze, Silver, and Gold data layers. The Data Engineer will use technologies including BigQuery, Cloud Composer/Apache Airflow, Python, Dataform, Datastream, Pub/Sub, Dataflow, Cloud Run, and Cloud Storage to deliver reliable and reusable data solutions.

The ideal candidate will have strong experience in metadata-driven pipeline development, CDC, advanced SQL, Python, data quality, reconciliation, automated testing, and CI/CD. The engineer will work closely with Data Governance and other platform stakeholders to ensure that data pipelines are scalable, governed, auditable, testable, and production-ready.

Responsibilities

1. Design and build a metadata-driven and configuration-driven ingestion framework using reusable pipeline templates.

2. Design, develop, and maintain the metadata configuration model covering source systems, source objects, load configurations, execution parameters, run logs, audit information, and reprocessing.

3. Build dynamic Cloud Composer / Apache Airflow DAGs that generate and execute ingestion workflows based on metadata configurations.

4. Develop reusable ingestion patterns and pipeline generators instead of building separate pipelines for individual source tables.

5. Onboard multiple source systems, including relational databases, SAP, REST APIs, files, streaming sources, and other enterprise platforms.

6. Implement data ingestion into Raw and Bronze layers following defined lakehouse architecture and engineering standards.

7. Implement source-to-target reconciliation to ensure completeness and accuracy of ingested data.

8. Implement robust operational controls, including error handling, retries, quarantine processing, alerting, monitoring, and audit logging.

9. Develop replay-by-batch and reprocessing capabilities to support failed loads, historical reloads, and controlled data recovery.

10. Support batch, incremental, streaming, and Change Data Capture (CDC) ingestion patterns.

11. Implement Bronze-layer processing, including data typing, cleansing, schema validation, and schema enforcement.

12. Implement data de-duplication using appropriate source keys, primary keys, or business keys.

1. Implement soft-delete representation and appropriate handling of deleted source records.

2. Implement CDC change-history materialization and maintain historical changes where required.

3. Develop appropriate BigQuery partitioning, clustering, MERGE, and incremental processing strategies.

4. Perform data compaction and other performance optimization activities where required.

5. Design and develop Silver and Gold transformation models using Dataform.

6. Develop reusable transformation components, macros, dependencies, and incremental transformation strategies.

7. Implement assertions and automated tests for transformation models and ensure no untested transformation reaches production.

8. Implement in-pipeline data quality checks, validation rules, and automated promotion gates.

9. Work closely with the Data Governance Consultant to incorporate data quality, governance, lineage, audit, and control requirements into the engineering framework.

10. Prevent data that fails critical quality requirements from being promoted to downstream layers.

11. Implement geospatial data ingestion, including GeoJSON processing and conversion to BigQuery GEOGRAPHY.

12. Ensure appropriate preservation and handling of Spatial Reference System (SRS) information for geospatial datasets.

13. Implement ingestion and management of semi-structured and unstructured data using Google Cloud Storage and BigQuery object tables.

14. Follow Git-based development practices, including branching, pull/merge requests, peer reviews, and code reviews.

15. Develop automated tests as a standard part of pipeline and transformation development.

16. Integrate data pipelines and Dataform transformations with CI/CD processes.

17. Document each source-system onboarding, including configuration, mappings, dependencies, reconciliation, operational procedures, and troubleshooting guidance.

18. Develop and maintain operational runbooks and onboarding documentation that enable ESNAD teams to independently onboard additional data sources.

Must-Have Skills

1. Minimum 5+ years of professional Data Engineering experience.

2. Minimum 2+ years of hands-on experience building data pipelines on Google Cloud Platform (GCP).

3. Strong hands-on experience with Google Cloud Platform data engineering services.

4. Expert-level SQL skills, including complex analytical SQL development.

5. Strong hands-on experience with Google BigQuery, including data modeling and large-volume data processing.

6. Strong Python programming skills for data engineering, automation, API integration, validation, and framework development.

7. Strong hands-on experience with Cloud Composer / Apache Airflow.

8. Proven experience developing dynamic Airflow DAGs.

9. Experience developing metadata/configuration-driven DAG generation.

10. Experience with Airflow sensors, custom operators, task dependencies, scheduling, retries, and failure management.

11. Proven experience designing and implementing metadata-driven or configuration-driven ingestion frameworks.

12. Experience developing pipeline generators and reusable ingestion templates, rather than only building individual pipelines for individual tables.

13. Experience designing metadata configurations for source systems, source objects, load parameters, runtime configurations, audit logs, and reprocessing.

14. Hands-on experience with Google Cloud Datastream or an equivalent log-based CDC technology.

15. Strong understanding of CDC patterns, including inserts, updates, deletes, soft deletes, incremental loads, and historical change management.

16. Experience implementing CDC recovery, reconciliation, replay, and reprocessing patterns.

17. Hands-on experience with Dataform or dbt.

18. Strong understanding of transformation model structures, macros, reusable logic, assertions, automated tests, dependencies, and incremental strategies.

19. Experience developing Raw, Bronze, Silver, and Gold data layers or equivalent medallion/lakehouse architecture.

20. Experience implementing source-to-target data reconciliation and validation.

21. Experience implementing exception handling, quarantine processes, retry mechanisms, operational monitoring, and alerting.

22. Working knowledge of Google Cloud Pub/Sub and event-driven or streaming ingestion patterns.

23. Working knowledge of Dataflow / Apache Beam for data processing.

24. Working knowledge of Cloud Run and/or Cloud Data Fusion.

25. Strong understanding of relational database extraction and database-engine-specific CDC constraints.

26. Working knowledge of SAP data extraction patterns, including ODP, SLT, or certified SAP connectors.

27. Experience with REST API ingestion, including authentication, pagination, error handling, and incremental extraction.

28. Experience with file-based data ingestion and file manifest validation.

29. Experience implementing automated data quality checks, validation rules, and pipeline quality gates.

30. Strong knowledge of BigQuery partitioning, clustering, MERGE operations, de-duplication, schema enforcement, and incremental processing.

31. Strong understanding of data pipeline monitoring, auditability, traceability, and operational support.

32. Strong experience with Git-based development and version control.

33. Experience working with peer reviews, code reviews, and controlled development workflows.

34. Experience writing unit, integration, data quality, or pipeline tests as a standard engineering practice.

35. Experience implementing or working with CI/CD pipelines for data engineering workloads.

36. Ability to produce high-quality technical documentation, source onboarding documentation, and operational runbooks.

Good-to-Have Skills

1. Google Cloud Professional Data Engineer certification.

2. Google Cloud Associate Cloud Engineer certification.

3. dbt Analytics Engineering Certification.

4. Advanced hands-on experience with Google Cloud Datastream and enterprise-scale CDC implementations.

5. Advanced experience with Dataflow / Apache Beam for batch and streaming workloads.

6. Advanced experience with Pub/Sub and event-driven data architectures.

7. Advanced BigQuery performance optimization and cost-optimization experience.

8. Experience designing and implementing enterprise-scale lakehouse or medallion architectures.

9. Experience designing reusable enterprise data ingestion frameworks and platform accelerators.

10. Advanced hands-on experience with Dataform, including reusable components, assertions, incremental models, and CI/CD.

11. Experience designing enterprise-level automated data quality frameworks.

12. Experience with data governance, metadata management, data lineage, data cataloging, auditability, and traceability.

13. Strong hands-on experience with SAP ODP, SAP SLT, or certified SAP extraction connectors.

14. Experience implementing SAP CDC and incremental extraction patterns.

15. Experience processing GeoJSON and BigQuery GEOGRAPHY data.

16. Knowledge of geospatial data engineering and Spatial Reference Systems (SRS).

17. Experience handling semi-structured and unstructured data at enterprise scale.

18. Experience with Google Cloud Storage and BigQuery object tables.

19. Experience implementing CI/CD pipelines for Dataform, dbt, Airflow, and other data engineering workloads.

20. Experience with automated deployments, environment promotion, testing gates, and release-management practices.

21. Knowledge of cloud security, IAM, service accounts, secrets management, and secure data pipeline design.

22. Experience implementing monitoring, observability, logging, alerting, and operational dashboards for enterprise data pipelines.

23. Experience working in large enterprise data transformation or cloud migration programs.

24. Experience working closely with Data Governance, Data Architecture, Security, DevOps, and Business teams.

25. Experience mentoring junior and mid-level Data Engineers and establishing engineering standards.

26. For a Senior Data Engineer / Technical Lead, 8+ years of overall Data Engineering experience is preferred, along with demonstrated technical leadership and architecture ownership.