Data Architect

CAPGEMINI SINGAPORE PTE. LTD.; Singapore; On-site; SGD 180,000 - 260,000; Full time

Job summary

CAPGEMINI SINGAPORE PTE. LTD. seeks a senior data architect to analyze data landscapes, align with business goals, and design scalable data platforms.

You will lead cross-functional teams in architecture, development, and integration, ensuring high availability for enterprise BI environments. The role requires deep expertise in MDM, data governance, and banking domain knowledge, with hands-on experience across major databases and data tools.

Qualifications

• 15+ years leading data strategy, roadmaps and end-to-end programs.
• Expertise in enterprise data strategy and warehouse architecture models.
• Strong understanding of information flow, models, and data lifecycle management.
• Experience with analytical, regulatory reporting models and banking domain.
• MDM across multi-domain environments using Informatica MDM, Stibo PIM, Talend.
• Proficiency with architecture tools: PowerDesigner, ArchiMate, ERWin.

Responsibilities

• Analyze data landscape, client capabilities and business requirements to design scalable data solutions.
• Lead cross-functional teams to design and develop data solution configurations.
• Recommend best-fit approaches for data warehouse and BI environments.
• Define strategic direction and roadmaps for enterprise data initiatives.
• Serve as primary point of contact for architecture and development queries.
• Advise on emerging technologies to improve performance and scalability.
• Support business development by shaping architectures for proposals.

Skills

Data strategy

Architecture design

Data governance

MDM across multi-domain

Data migration planning

Platform knowledge (Postgres, Oracle,

Tools

Informatica MDM

Stibo PIM

Talend Data Fabric

PowerDesigner

ArchiMate

ERWin

Toad

Snowflake

Job description

Analyze the current data landscape, client capabilities, and business requirements to design scalable, high‑performance, and highly available data solutions.

Lead cross‑functional teams in designing and developing data solution configurations aligned with the proposed architecture.

Recommend best‑fit approaches to address development, integration, and performance challenges in data warehouse and business intelligence environments.

Define strategic direction and create implementation roadmaps for enterprise data initiatives.

Serve as the primary point of contact for architecture, design, and development‑related queries.

Apply deep expertise in both modern and traditional data technologies to guide architectural decisions.

Identify, evaluate, and adopt emerging technologies and methodologies to improve performance, automation, and scalability.

Support business development by shaping solution architectures for proposals and participating in client meetings with the sales team.

Experience and Qualifications

• 15+ years of experience in data engagements, leading data strategy, roadmaps, and end‑to‑end implementation programs.
• Expertise in enterprise data strategy, alignment with business objectives, transformation initiatives, and warehouse architecture models.
• Strong understanding of information flow, integration and interfacing approaches, business information models, logical and canonical data models, and data lifecycle management.
• Experience with analytical, regulatory, and compliance reporting models.
• Mandatory banking industry experience with strong domain expertise.
• Extensive experience in data migration strategy, planning, costing, execution, retention, archival, and disposal.
• Master Data Management (MDM) across multi‑domain environments using tools such as Informatica MDM, Stibo PIM, and Talend Data Fabric.
• Data governance capability assessment (as‑is/to‑be), framework design, model development, roadmap creation, and execution.
• Proficiency with architecture tools such as PowerDesigner, ArchiMate, Toad, and ERWin.
• Strong foundation in normalized/denormalized design, ER modeling, star schema design, hierarchical models, and Inmon and Kimball methodologies.
• Hands‑on experience with platforms including Postgres, Oracle, SQL Server, DB2, Teradata, Hive, Pig, Impala, MongoDB, Cassandra, HBase, and Snowflake.

Additional Skills

• Programming and scripting: MS SQL, PL/SQL, NoSQL, Shell scripting, VBA, T‑SQL, DAX.
• Reporting and UI tools: MS SSRS, Oracle Forms (6i, 9i, 10g), Intellimatch, MS Access.
• RDBMS experience: Oracle 9i/10g, MS SQL Server 2008-2014, Oracle 9i AS/10g.
• Web and cloud technologies: Sitecore, AWS, WordPress, Google Analytics/GTM.
• Management tools: MS Project, MS Office Suite, JIRA, rLean.
• Frameworks and certifications: TOGAF, DAMA‑DMBOK.