About the job

Job SummaryWe are seeking a highly experienced Data Lead/ Senior Data Engineer with a strong background in relational databases to lead a strategic data transformation initiative within the insurance domain. This role will drive the migration of legacy systems from on-perm and IBM DB2 to AWS-based platforms, particularly PostgreSQL, ensuring high performance, scalability, and data integrity.

• Key ResponsibilitiesDefine and drive end-to-end data architecture strategy for enterprise systems
• Lead database migration from IBM DB2 to AWS (PostgreSQL), including planning, design, and execution
• Design conceptual, logical, and physical data models aligned with business needs
• Ensure data consistency, integrity, security, and governance across platforms
• Optimize database performance and scalability in AWS environments
• Collaborate with cross-functional teams (data engineers, developers, business stakeholders)
• Establish architecture standards, best practices, and frameworks
• Perform impact analysis, risk assessment, and mitigation planning for migration activities
• Provide technical leadership and mentorship to data engineering teams

• Key Requirements10+ years of experience in Data Engineering, with at least 3 years in a Data Architect role
• Strong hands-on expertise in relational databases (IBM DB2, PostgreSQL preferred)
• Proven track record in large-scale data migration projects, especially to AWS
• Strong knowledge of data modeling, database design, and performance tuning
• Hands-on experience with AWS data services (RDS, Aurora, DMS; Redshift is a plus)
• Solid understanding of ETL/ELT processes and data integration
• Experience in the insurance or financial services domain is highly preferred
• Knowledge of data governance, compliance, and security frameworks
• Strong problem-solving skills and ability to work with senior stakeholders

• Benefits15% EPF employer contribution for local candidates
• Health insurance coverage (including spouse and children)
• Health screening allowance
• Transport allowance
• Integration activities
• Optical coverage reimbursement
• Additional 2 days of annual leave upon completion every 1 year in Billennium
•