Technical Architect

Avensys Consulting; Singapore; On-site; SGD 170,000 - 210,000; Full time

Benefits offered by this job

Attractive company benefits

Job summary

Avensys Consulting is hiring a Technical Architect in Singapore to lead enterprise data migration architecture, design scalable solutions, and define governance for complex data projects. You will work with business, functional, and technical stakeholders to ensure secure, compliant migration strategies and cutting-edge data integration patterns.

The role requires 8+ years in data management, strong SQL, and hands-on ETL tool experience with platforms like Azure Data Factory, Informatica, SSIS,

Qualifications

• 8+ years in Data Management, Data Engineering, or large-scale data migration projects.
• Strong SQL, database administration, and data modelling knowledge.
• Hands-on ETL experience with Azure Data Factory, Informatica, SSIS, Talend, or Databricks.
• Experience with SQL Server, Oracle, PostgreSQL, MySQL, or Azure SQL.
• Knowledge of data governance, MDM, data warehousing and migration activities (profiling, transformation, validation, reconciliation).
• TOGAF and/or CDMP certification preferred.
• Strong analytical, problem-solving, and communication skills.

Responsibilities

• Define enterprise data migration architecture and roadmap.
• Develop migration frameworks, standards, and best practices.
• Create source-to-target mapping specifications.
• Design data validation and reconciliation processes.
• Establish migration governance and controls.
• Design scalable and secure migration solutions.
• Define data integration patterns and architecture.
• Perform data profiling and impact assessment.
• Develop migration runbooks and cutover plans.
• Identify dependencies, risks, and mitigation strategies.
• Define data quality rules and validation frameworks.
• Ensure compliance with data governance and security standards.
• Review migration design documents and technical deliverables.
• Conduct architecture reviews and technical quality assurance.
• Support performance tuning and optimization activities.
• Engage business, functional, and technical stakeholders.
• Present architecture recommendations to senior leadership.
• Collaborate with project managers and solution architects.

Skills

SQL

Database administration

Data modelling

Analytical thinking

Communication skills

Data governance

MDM

Data warehousing

Profiling

Transformation

Validation

Reconciliation

TOGAF/CDMP

Tools

Azure Data Factory

Informatica

SSIS

Talend

Databricks

SQL Server

Oracle

PostgreSQL

MySQL

Azure SQL

Job description

Avensys is a reputed global IT professional services company headquartered in Singapore. Our service spectrum includes enterprise solution consulting, business intelligence, business process automation, and managed services. Given our decade of success, we have evolved to become one of the top trusted providers in Singapore and service a client base across banking and financial services, insurance, information technology, healthcare, retail, and supply chain.

We are currently looking to hire aTechnical Architect. This is an exciting opportunity to expand your skill set, achieve job satisfaction, and enjoy a healthy work-life balance. More details are below.

ROLES AND RESPONSIBILITIES

Migration Strategy & Architecture

• Define enterprise data migration architecture and roadmap.
• Develop migration frameworks, standards, and best practices.
• Create source-to-target mapping specifications.
• Design data validation and reconciliation processes.
• Establish migration governance and controls.

Solution Design

• Design scalable and secure migration solutions.
• Define data integration patterns and architecture.
• Perform data profiling and impact assessment.
• Develop migration runbooks and cutover plans.
• Identify dependencies, risks, and mitigation strategies.

Data Quality & Governance

• Define data quality rules and validation frameworks.
• Ensure compliance with data governance and security standards.
• Review migration design documents and technical deliverables.
• Conduct architecture reviews and technical quality assurance.
• Support performance tuning and optimization activities

Stakeholder Management

• Engage business, functional, and technical stakeholders.
• Present architecture recommendations to senior leadership.
• Collaborate with project managers and solution architects.

REQUIREMENTS

• Minimum 8 years of experience in Data Management, Data Engineering, or large-scale data migration projects.
• Strong SQL, database administration, and data modelling knowledge.
• Hands-on experience with ETL tools such as Azure Data Factory, Informatica, SSIS, Talend, or Databricks.
• Experience with SQL Server, Oracle, PostgreSQL, MySQL, or Azure SQL.
• Knowledge of data governance, MDM, data warehousing, and migration activities including profiling, transformation, validation, and reconciliation.
• TOGAF and/or CDMP certification is preferred.
• Strong analytical, problem-solving, and communication skills.

WHAT'S ON OFFER

You will be remunerated with an excellent salary and be entitled to attractive company benefits. Additionally, you will have the opportunity to work in a fun and collaborative environment with excellent career growth prospects.