Senior Data Warehouse Architect – Banking & Finance

Tangspac Consulting Group; Singapore; Sur place; SGD 120 000 - 180 000; Plein temps

Résumé du poste

Tangspac Consulting Group is seeking an experienced Senior IT Analyst (Data Warehouse) to design and implement an enterprise data warehouse for a financial institution. This role emphasizes banking data platforms, ETL pipelines, data modelling, and end-to-end SDLC delivery.

You will lead requirements gathering, data mapping, solution design, and data flow optimisation while ensuring data quality, governance, and regulatory compliance.

Qualifications

• Minimum 12 years of experience in data warehouse, ETL, or enterprise data roles within banking or financial services.
• Hands-on experience with ETL tools: Informatica, Teradata, DataStage or equivalent.
• Proven capability in data mapping, data modelling, data flow design, and large-scale data integration.
• Solid understanding of RDBMS, SQL, and performance optimisation across complex datasets.
• Strong experience preparing BRDs, FSDs, technical specifications, and traceability matrices.
• Demonstrated ability to support SIT/UAT, including test planning, test data preparation, and defect resolution.
• Excellent stakeholder management skills across business, operations, technology, and data teams.
• Experience working with data in finance, AML, payments, or core banking systems is highly preferred.

Responsabilités

• Lead requirement gathering and translate business needs into detailed functional specifications, data mapping sheets, and technical design documents.
• Analyse, design, and optimise data flows, data lineage, and integration patterns across enterprise data warehouse environments.
• Drive end‑to‑end SDLC delivery, including analysis, design, development support, SIT/UAT coordination, defect triage, and release readiness.
• Perform data modelling (conceptual, logical, physical) and ensure alignment with enterprise architecture and banking data standards.
• Oversee and validate ETL workflows, transformation logic, and data pipelines to ensure accuracy, completeness, and performance.
• Conduct data analysis, profiling, reconciliation, and quality checks across large and complex datasets.
• Collaborate with cross‑functional teams including business users, data engineers, QA, and project managers to deliver high‑quality data solutions.
• Ensure compliance with regulatory reporting, data governance, metadata standards, and security controls.

Connaissances

Data warehouse

ETL

Data modelling

Data mapping

SQL

Stakeholder management

Outils

Informatica

Teradata

DataStage

Description du poste

Tangspac Consulting Group is seeking an experienced Senior IT Analyst (Data Warehouse) to design and implement an enterprise data warehouse for a financial institution. This role emphasizes banking data platforms, ETL pipelines, data modelling, and end-to-end SDLC delivery.

You will lead requirements gathering, data mapping, solution design, and data flow optimisation while ensuring data quality, governance, and regulatory compliance.