Teradata Architect | Unison Consulting | Singapore

Unison Consulting; Singapore; On-site; SGD 180,000 - 240,000; Full time

Job summary

Unison Consulting seeks a senior Teradata Architect in Singapore to lead enterprise data warehouse initiatives for tier‑1 banking clients. You will design scalable Teradata Vantage architectures, optimize pipelines, and govern data across complex financial cores.

The role requires 8+ years in data warehousing with Teradata expertise, strong SQL/BTEQ/TPT skills, and banking domain experience. This position offers high visibility, competitive compensation, and growth within a premier IT consulting

Qualifications

• Bachelor’s degree in Computer Science, IT, Software Engineering, Data Analytics or related technical discipline.
• 8+ years of enterprise data warehousing and Teradata architecture experience.
• Banking/financial services domain experience required.
• Strong Teradata SQL, BTEQ, TPT, and Stored Procedures proficiency.
• Knowledge of data modeling (Inmon, Kimball) and data governance.
• Experience with query tuning, performance optimization, and Teradata Vantage.

Responsibilities

• Architect and deliver enterprise Teradata data warehouse solutions for banking clients.
• Design logical and physical data models, star/snowflake schemas, and data vault architectures.
• Tune queries, optimize performance, and manage distributions and PI/NUPI designs.
• Configure Teradata Active System Management (TASM) and workload management (WLM).
• Build robust ETL/ELT pipelines linking core banking systems to the warehouse.
• Ensure banking regulatory compliance and data privacy, and support cybersecurity standards.
• Collaborate with data scientists, BI teams, and stakeholders; maintain runbooks and data dictionaries.

Skills

Teradata SQL

BTEQ

Teradata Parallel Transporter

Stored Procedures

Data modeling (Inmon/Kimball)

Data governance

Teradata Vantage cloud

Education

Bachelor’s degree in Computer Science / IT / Software Engineering / Data Analytics or related field

Tools

TASM

Job description

Position Summary

Driving enterprise data warehouse architecture, large-scale enterprise analytics, and mission-critical banking data solutions in Singapore, Unison Consulting is actively seeking an accomplished Teradata Architect for a premier professional engagement. In this vital technical leadership role, you will architect, design, build, and optimize enterprise Teradata data warehouse platforms tailored specifically for tier-1 banking and financial institutions. Bringing extensive hands‑on expertise in advanced database architecture, high-performance data modeling, and complex financial data integration, you will empower global banking clients to achieve uncompromised analytical processing speed, regulatory data compliance, and robust operational intelligence. This prestigious career opportunity offers competitive remuneration, high executive visibility, and professional growth within a premier global IT consulting and executive recruitment enterprise.

Detailed Job Description

As a Teradata Architect supporting Unison Consulting in Singapore, you will take full operational, tactical, and technical ownership of enterprise data architecture, logical and physical data modeling, workload management, and system performance tuning. Your day-to-day responsibilities include designing scalable Teradata Vantage architectures, optimizing complex SQL queries and ETL pipelines, implementing data governance and security frameworks, collaborating with multidisciplinary engineering and banking squads, and interacting directly with technical recruitment leaders like Manish Jagasia.

Key Responsibilities

• Architect, design, develop, and deploy enterprise‑grade Teradata data warehouse solutions and analytical platforms for banking clients.
• Create comprehensive logical and physical data models, star schemas, snowflake schemas, and data vault architectures.
• Optimize database performance, query execution plans, table indexing, distribution strategies, and PI/NUPI designs.
• Configure and manage Teradata Active System Management (TASM) and workload management (WLM) rulesets for resource prioritization.
• Design and implement robust ETL/ELT data integration pipelines connecting disparate financial core systems to the Teradata enterprise data warehouse.
• Ensure strict adherence to banking regulatory compliance, data privacy standards, and enterprise cybersecurity frameworks.
• Collaborate seamlessly with data scientists, BI developers, financial analysts, and client stakeholders during enterprise projects.
• Maintain meticulous technical documentation, data dictionary specifications, architecture runbooks, and performance audit logs.

Required Qualifications & Skills

• Bachelor’s degree in Computer Science, Information Technology, Software Engineering, Data Analytics, or related technical discipline.
• Minimum of 8+ years of progressive professional hands‑on experience in enterprise data warehousing and Teradata database architecture.
• Mandatory domain experience working within top‑tier banking and financial services institutions.
• Strong, demonstrable operational expertise in Teradata SQL, BTEQ, Teradata Parallel Transporter (TPT), and Stored Procedures.
• Comprehensive working knowledge of data modeling methodologies (Inmon, Kimball) and enterprise data governance.
• Deep practical experience in query tuning, performance optimization, and Teradata Vantage cloud environments.
• Exceptional analytical problem‑solving aptitude, architectural vision, and professional stakeholder communication capabilities.
• Mandatory legal work authorization and physical availability for professional operations in Singapore.

Nice-to-Have Skills

• Professional certifications such as Teradata Certified Master or Teradata Certified Enterprise Architect.
• Hands‑on familiarity with cloud data platforms (AWS, Azure, GCP) and data lake integration (Hadoop, Spark).
• Experience utilizing enterprise IT service management and agile tracking platforms (Jira, Confluence) for project execution.
• Prior professional working experience in top‑tier multinational consulting firms or global banking technology centers.
• Active participation in enterprise data architecture communities, database forums, or technical publications.

Application Information

• Recruiter: Unison Consulting Recruitment Division
• Contact Name: Manish Jagasia (Talent Acquisition Lead – APAC, AU & MEA)
• Email: [e-mail]
• Phone:
• Company Website: https://www.unisonconsulting.com.sg
• Salary/Rate: Market Competitive / Enterprise Banking Data Package
• Deadline: Open until filled (Urgent Singapore Teradata Architect Opening)
• Notice Period: Immediate to 30 Days Preferred
• Contract Duration: Permanent / Full-Time Professional Engagement (Singapore)

Recruitment Pro Tip

• When applying for this Teradata Architect position through Unison Consulting, ensure your resume explicitly highlights your enterprise data modeling portfolio, TASM optimization expertise, and banking domain background.