Data Warehouse Architect

APPLY using Our Form

(Preferred for Singapore based candidates)

Role Purpose

The DW Architect leads key data initiatives focused on the management and use of the organisation’s Enterprise Data Warehouse (EDW) and associated processes.

This individual understands end-to-end master data processes and flows and uses that knowledge to implement data management functional solutions, in concert with owners of the data in other business areas.

This role will be the pioneer member in the organisation in creating the internal data platform/architecture. You will act as a technical consultant to the management team in advising and as a project manager in delivering solution to build and scale the business intelligence data platform to service the various business stakeholders

Key Responsibilities

  • Responsible for planning and delivery of organisation data warehouse and reporting project.
  • Responsible for architecture of data lake and execute data integration activities to ingest structured/unstructured data into big data platform.
  • Responsible for designing offline data model, deploying data consumption methods for the offline data and formulation of offline data access matrix.
  • Responsible for organisation’s data migration strategy, identifying and recommending data cleansing rules and procedure, owning and managing data cleansing exercise
  • Design data models and associated metadata for high volume, multiple application systems data - real-time and distributed data processing systems (data lake/warehouse/marts).
  • Gather business requirements from stakeholders and design/build data visualization dashboards to support reporting and decision making.
  • Managed, lead and collaborate with implementation partner to deliver data warehouse and reporting solution to the organisation.
  • Execution of data governance roles and activities to ensure the organisation adhere to the data governance structure and data quality levels are met.
  • Recommend and formulate data policy and procedures.
  • Performs root-cause analysis on data related system problems and recommends or executes corrective action.
  • Identify and resolve data integration issues (data validation and data cleansing) using various data architecture concepts and techniques.
  • Ensures data integrity and compliance by performing data quality, data profiling, data validation, administering and maintaining the master data tables.
  • Work with business user and data owners to identify data access rights and formulate data access matrix.


Qualifications, attributes and experience

  • Minimum Bachelor’s degree in a quantitative or technical field (math, statistics, computer science) preferred.
  • At least 8 years working experience. At least 3 to 5 years of working experience in data domain.
  • Proven experience as a data warehouse architect & developer, including full implementation of data warehousing solution.
  • Strong expertise in data warehouse design methodologies and technologies, data architecture, data quality, metadata
  • Strong understanding and demonstrated experience in data models, data normalisation and data warehouse dimensional modelling.
  • Ability to be agile to assume multiple facet of data management roles.
  • Experience with visualization tools such as Qlik, Tableau, Business Objects or Power BI.
  • Experience in using cloud platform is preferred (MS Azure or others)
  • Experience and/or exposure to digital rights management software, concept and implementation.
  • Ability to design big data platform (such as Hadoop, Hive, HBase) architecture
  • Proficient knowledge of programming language, preferably in JavaScript, .NET, Java, Python or Ruby
  • Experience in working with business and technical stakeholders will be desirable
  • Strong communication and interpersonal skills
  • A good team player, proactive in nature, fast learner, highly organized and positive attitude.


General CV submission 


Country: Singapore
Employment Type: Full time
Salary: Open