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.