Data Architect or AWS Data Engineer

White Glove Hiring; Jakarta Pusat; On-site; IDR 400,000,000 - 700,000,000; Full time

Benefits offered by this job

Flexitime

Transport

Medical plans

Paid holidays

Job summary

MixWork mencari data engineer berpengalaman untuk mengelola data hub AWS dan CDP perusahaan. Posisi ini fokus pada desain, implementasi, dan pemeliharaan pipeline data pelanggan dari berbagai sistem, serta sinkronisasi profil ke platform pemasaran dan analitik.

Peran ini menuntut inisiatif tinggi, independensi, dan pemahaman kuat tentang SQL dan arsitektur data modern. Lokasi di Jakarta Pusat dengan skema kerja hybrid.

Qualifications

• Minimal 5 tahun pengalaman data engineering
• Pengalaman produksi dengan AWS Glue, S3, Athena, dan Lake Formation
• Pengalaman merancang CDP/unified customer profile
• SQL tingkat lanjut: queries kompleks & window functions
• Bahasa Inggris minimal B2 (IELTS 6.0)
• Mampu diagnose bootstrap pipeline secara independen

Responsibilities

• Mengelola AWS data hub (Bronze/Silver/Gold) dan CDP
• Merancang, membangun, dan mengelola CDP termasuk identity resolution
• Ingest data pelanggan dari berbagai sistem sumber secara real-time atau batch
• Sinkronisasi data profil pelanggan ke Eagle Eye, platform kampanye, dan layer Gold
• Mengelola ETL AWS Glue, DMS, Lambda, dan batch pulls
• Menjaga keamanan Lake Formation dan kepatuhan PDPA/UU PDP
• Memelihara AWS Glue Data Catalog dan skema evolusi
• Mengorkestrasi pipelines lewat AWS Step Functions
• Mengembangkan dashboard BI pada layer Gold Athena
• Bekerja dengan AI/Agent Engineer untuk personalisasi dan MCP
• Menghubungkan data cloud cross-cloud (Azure-AWS) dan sinkronisasi data

Skills

Data engineering

SQL & data modelling

Independence

Education

S1 (Sarjana)

Tools

AWS Glue

Amazon S3

Amazon Athena

AWS Lake Formation

Iceberg/Hudi

Python

Azure Data Factory

Power BI

Git/Azure DevOps

Job description

DESKRIPSI PEKERJAAN

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 clients'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 clients'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.

RINGKASAN PERKERJAAN

• SPESIALISASI: IT and Software
• PENDIDIKAN MINIMAL: S1 (Sarjana)
• SISTEM KERJA: Hibrid
• TIPE PEKERJAAN: Full time
• LOKASI: Central Jakarta, DKI Jakarta, Indonesia
• INDUSTRI: Human Resources / HR
• SITUS PERUSAHAAN: http://mixwork.co

FASILITAS & BENEFIT

Fasilitas: flexitime, trans, med_plans, paid_holidays

TENTANG PERUSAHAAN

MixWork is the premier integrated workforce solutions platform that builds and manages high performing, professional remote teams for global brands. With decades of experience in HR and corporate advisory, we provide Employer of Record (EOR), Business Process Outsourcing (BPO), and Talent Sourcing services from our offices in Singapore and Jakarta. Scale rapidly and efficiently while we handle the compliance, payroll, and day-to-day people management that operational excellence requires.