Data Architect / AWS Data Engineer

About MixWork & Our Client

MixWork is the premier HR outsourcing partner for strategic workforce solutions, empowering brands and global organizations with skilled, dedicated, and professional top-tier regional teams from South East Asia to accelerate their business growth. On behalf of our client, a premier, household-name retail enterprise headquartered in Singapore with a well-established international footprint and a heritage of quality and operational excellence, we are seeking a dedicated professional to join their team as they actively modernize their omni-channel capabilities and leverage a sophisticated regional technology footprint to support their digital and brick-and-mortar operations.

Role Summary

Own client’s AWS-based Unified Data Hub and Customer Data Platform (CDP), the Bronze/Silver/Gold medallion architecture that forms the data foundation for all AI agents, business intelligence reporting, the Claude Cowork MCP integration, and the unified customer profile that powers personalisation and loyalty across all concept stores. The CDP is client’s source of truth for customer identity and behaviour: it ingests data from all touchpoints, maintains unified customer profiles with identity resolution, and syncs enriched customer data to downstream systems including Eagle Eye (loyalty execution) and the marketing platform. Eagle Eye is a loyalty execution system in this model – it does not host the core customer record; the CDP does. The Data Architect is responsible for CDP architecture, pipeline reliability, schema governance, data quality, Lake Formation access controls, and the Gold layer Athena views that every downstream consumer depends on. This role shadows CloudMile's ECI delivery (Jul–Nov 2026) and takes full platform ownership at handover.

Key Responsibilities

• Own and operate the complete AWS data hub: Bronze (S3, raw partitioned data), Silver (Apache Iceberg on S3, ACID transactions, domain tables), and Gold (Amazon Athena views with business rules applied – Sales Performance, Loyalty Health, Campaign ROI, Staff Performance, Financial View, Unified Customer).

• Design, build, and own the Customer Data Platform (CDP): architect the unified customer profile store on AWS, implement identity resolution logic (matching customers across clients’s main chain, Beauty, Fashion, and Sleep concepts by email, phone, loyalty member ID, and device identifiers), and maintain a golden customer record per individual across all touchpoints.

• Manage CDP data ingestion: ingest customer event data from all source systems – POS transactions, e-commerce orders, loyalty events from Eagle Eye, CRM interactions, and web/app behavioural data – into the CDP in near-real-time or batch as appropriate per source.

• Manage CDP outbound syncs: push enriched customer profiles, segment memberships, and loyalty tier data from the CDP to Eagle Eye (loyalty execution), the marketing platform (campaign targeting), and the AI/Agent Engineer's Gold layer views (personalisation and agent use cases).

• Manage all data ingestion pipelines: AWS Glue Python ETL jobs, AWS DMS replication, Lambda event-driven ingestion, and scheduled batch pulls, covering all client’s source systems.

• Govern Lake Formation security: row-level and column-level access controls per consumer role; monthly access reviews; PDPA and UU PDP compliance for all customer PII fields.

• Maintain the AWS Glue Data Catalog: schema registration, schema evolution management, partition projections, and table properties.

• Orchestrate pipelines via AWS Step Functions: scheduling, retry logic, failure alerting, and inter-job dependencies.

• Maintain and extend business intelligence dashboards and reports connected directly to the Gold Athena layer.

• Collaborate with the AI/Agent Engineer: ensure Gold layer views and CDP customer profiles are structured for effective MCP natural language query generation and personalisation agent use cases.

• Manage the Azure-to-AWS data bridge for client’s hybrid cloud architecture: design and operate pipelines that replicate Microsoft system data (D365 F&SCM transactions, Dataverse/Power Pages records, SharePoint document metadata) from Azure into the AWS Bronze layer.

• Govern cross-cloud data consistency: ensure that key business entities remain consistent across AWS and Azure; define and monitor reconciliation checks that flag divergence between the two platforms.

• Shadow CloudMile during ECI build phase; produce client’s internal architecture runbooks before handover.

Required Qualifications & Experience

• Minimum 5 years of data engineering experience; at least 3 years on AWS data platforms in production, not training environments.

• Demonstrable production experience with AWS Glue, Amazon S3, Amazon Athena, and AWS Lake Formation.

• Hands-on experience with Apache Iceberg or Apache Hudi on S3: ACID transactions, schema evolution, time travel.

• Experience designing or building a Customer Data Platform or unified customer profile store: identity resolution, profile merging, and customer event ingestion from multiple source systems.

• Advanced SQL: complex Athena queries, window functions, CTEs, partition optimisation.

• English proficiency at B2 minimum (IELTS 6.0); mandatory assessment at interview.

• Strong independence: able to diagnose pipeline failures, identify data quality risks proactively, and own the platform without a team around them.

Technical Proficiency

• AWS: S3, AWS Glue (Python ETL, Data Catalog, Data Quality), AWS DMS, AWS Step Functions, Amazon Athena, AWS Lake Formation, Amazon CloudWatch, CloudTrail, AWS Lambda, Amazon DynamoDB.

• CDP architecture: unified customer profile design, identity resolution logic, customer event schema design, real-time and batch ingestion patterns, and outbound sync to loyalty and marketing systems.

• Apache Iceberg: snapshot management, schema evolution, compaction, time travel.

• Python (intermediate–advanced): ETL scripting, schema standardisation, deduplication, identity resolution.

• Azure Data Factory (ADF): sufficient working knowledge to design and operate data pipelines bridging Microsoft Azure sources into AWS S3 (leeway given for learning if experience is rare).

• BI reporting tools: experience with at least one cloud-connected BI platform (e.g., Amazon QuickSight, Power BI, or equivalent).

• Git / Azure DevOps.

Nice to Have

• AWS Certified Data Engineer – Associate.

• dbt for Athena view management as code.

• Amazon Bedrock Knowledge Base familiarity.

• Experience with commercial CDP platforms (Segment, mParticle, Tealium) as a reference for design patterns.

• Real-time streaming ingestion (Amazon Kinesis or Kafka) for high-frequency customer event pipelines.

• Azure Synapse Analytics or Azure SQL experience.

Statutory Provisions & Compliance

• Full Legal Compliance: Official employment contract managed under MixWork Indonesia, ensuring complete adherence to local labor laws and employment standards.

• Healthcare & Social Security: Full registration and contributions for both BPJS Kesehatan and BPJS Ketenagakerjaan to ensure comprehensive coverage.

• Religious Holiday Allowance: Guaranteed annual mandatory Religious Holiday Allowance (THR) paid in accordance with statutory government regulations.

What We Offer

• Flexible Medical Benefit: Comprehensive healthcare coverage fully inclusive of dental, optical, outpatient care, and wellness treatments to support your overall well-being.

• Daily Allowances: Competitive transportation and meal allowances to support your operational needs.

• Workstation Provisioning: High-performance corporate laptop and necessary technical equipment provided.

• Regional Ecosystem: Access to ongoing global corporate alignment, dedicated HR support, and a stable, creative career trajectory with a premier international brand.

Important Notes

• Language Requirement: As this is an international role, please note that all screenings and interviews will be conducted exclusively in English.

• Equal Opportunity Employer: MixWork is committed to creating an inclusive, diverse, and fair workplace culture. We value talent and capability above all else, completely free from discrimination or bias.