Kerja Sepenuh Masa, Data Architect - 1 year Contract di PetroChina International (Singapore) - Maukerja

Job Overview

The Data Architect is responsible for designing, building, and maintaining scalable data pipelines and enterprise data warehouse solutions. This role focuses on data integration, transformation, and optimization to support business intelligence and analytics. The position works closely with business stakeholders, data analysts, and engineering teams to ensure high-quality, reliable, and accessible data for decision-making.

Job Responsibilities

Data Acquisition, Cleansing & Integration

• Design and implement enterprise-wide data collection strategies across heterogeneous source systems (ETRM, ERP, CRM, external APIs, flat files, and databases).
• Develop robust data cleansing and standardization pipelines to ensure data accuracy, consistency, and completeness across all data sources.
• Build data integration frameworks to consolidate data from disparate systems into a unified enterprise data warehouse, handling schema evolution and data drift.
• Implement Change Data Capture (CDC) mechanisms and incremental data loading strategies to ensure near real-time data freshness.

Data Warehouse Architecture & Modeling

• Lead the design and construction of the enterprise data warehouse (EDW) using industry-proven methodologies (Inmon, Kimball, or Data Vault).
• Apply dimensional modeling expertise to design star schemas, snowflake schemas, and constellation models optimized for analytical query performance.
• Architect data marts for specific business domains (finance, sales, supply chain, operations) with a clear separation of concerns.
• Select and implement appropriate data warehouse technologies based on workload characteristics: batch analytics (Hive, Spark SQL), real-time analytics (ClickHouse, Apache Doris, StarRocks), or MPP databases (Greenplum, Vertica).
• Design layered data architectures (ODS → DWD → DWS → ADS / Bronze → Silver → Gold) with clear data flow and transformation logic at each layer.

ETL/ELT Pipeline Development

• Design, build, and maintain scalable ETL/ELT pipelines using Apache Spark, Flink, Hive, MapReduce, or proprietary ETL tools (Informatica, Talend, Kettle).
• Implement workflow orchestration using Apache Airflow, DolphinScheduler, Azkaban, or Oozie to schedule, monitor, and manage data pipelines.
• Establish data quality frameworks, including automated validation rules, anomaly detection, data profiling, and quality scorecards, to ensure pipeline reliability and data trustworthiness.
• Build comprehensive monitoring and alerting systems for pipeline health, data freshness, and SLA compliance.
• Optimize pipeline performance through partitioning, bucketing, indexing, and query tuning strategies.

Business Intelligence & Reporting

• Develop enterprise BI reporting systems and interactive dashboards using tools such as Apache Superset, FineBI, Tableau, Power BI, or Quick BI.
• Design executive dashboards, operational reports, and self-service analytics interfaces tailored to business stakeholders across finance, trading, operations, and management.
• Implement metrics frameworks (KPIs, OKRs) and ensure data definitions are standardized, documented, and consistently applied across all reports.
• Work directly with business units to understand analytical requirements and translate them into effective data models and visualizations.

Data Governance & Standards

• Design and implement enterprise data governance frameworks from the ground up, including data ownership policies, stewardship roles, and governance workflows.
• Build a centralized data catalog (using Apache Atlas, DataHub, Amundsen, or similar) documenting all data assets, business glossaries, and metadata.
• Implement data lineage analysis systems to track data flow from source to consumption, enabling impact analysis and root cause diagnosis.
• Establish data security and audit frameworks, including access control (RBAC/ABAC), data masking, encryption policies, sensitive data discovery, and compliance audit trails.
• Define and enforce data standards, including naming conventions, data dictionaries, master data management (MDM) rules, and data quality SLAs.
• Ensure regulatory compliance with data protection laws (GDPR, PIPL, and industry-specific regulations) through governance controls and documentation.

Job Requirements

• Bachelor’s degree or above in Computer Science, Statistics, Mathematics, Information Systems, or a related technical field.
• 3+ years of professional experience in data development, data engineering, or data architecture roles, with a proven track record of building production data warehouse systems.
• Expert-level proficiency in SQL (complex queries, window functions, CTEs, query optimization) and Python for data processing and pipeline development.
• Mastery of data warehouse modeling theories and methodologies, including dimensional modeling (Kimball), normalized modeling (Inmon), and Data Vault 2.0. Demonstrated experience designing star schemas, snowflake schemas, and aggregate tables for complex business domains.
• Deep domain experience in at least one complex industry: financial services (banking, securities, insurance), international trade (import/export, supply chain, logistics), or manufacturing (production planning, quality control, industrial IoT). Strong understanding of industry-specific data entities, business processes, and analytical requirements.
• Strong hands-on experience with ETL/ELT tools and frameworks, including Apache Spark (batch and streaming), Apache Flink, Hive, MapReduce, Sqoop, DataX, SeaTunnel, or commercial ETL platforms (Informatica PowerCenter, Talend, IBM DataStage).
• Proficiency in workflow orchestration tools such as Apache Airflow, DolphinScheduler, Azkaban, Oozie, or equivalent scheduling and monitoring platforms.
• Production experience with at least one major data warehouse or analytics database: ClickHouse, Apache Doris, StarRocks, Hive, Greenplum, Vertica, Teradata, or Snowflake.
• Strong hands-on experience with BI and visualization tools, including Apache Superset, FineBI, Tableau, Power BI, Quick BI, or similar enterprise BI platforms.
• Deep expertise in data governance, with demonstrated ability to build governance systems from scratch, including data catalog implementation, metadata management, automated lineage tracking (using OpenLineage, Marquez, or similar), data quality monitoring, and security audit frameworks.
• Solid understanding of relational and analytical databases: PostgreSQL, MySQL, Oracle, SQL Server, Greenplum, including performance tuning, indexing strategies, and query optimization.
• Experience with big data ecosystem components, including HDFS, YARN, ZooKeeper, Kafka, and Hadoop distributions (CDH, HDP, Apache).

Please write in with a full resume, present and expected salary, contact telephone number(s) and any other relevant information to:

Email: *************

We regret to inform that only shortlisted candidates will be notified.

Personal Data Protection

In submitting your personal data and/or resume, you shall be deemed to consent to us collecting, using and disclosing your personal data for the purpose of assessing your job application. Information collected may also be disclosed to the PetroChina Group of Companies (which includes PetroChina International (Singapore) Pte. Ltd., Singapore Petroleum Company Limited) for this purpose.