ST Asset Management Ltd – Database Architect

Job Description

Project Title: Data Architect

Background:

Company has embarked on Enterprise Data Warehouse (EDW) implementation for few years and would like to strengthen our data warehouse framework for further scalability to adapt more diverse and complex business.

Objectives:

As an intern, you will be responsible for:

• Study and review existing EDW model .
• Design and Development of Data Architecture for Enterprise wide adoption
• Develop data architecture best practices, guidelines and procedures into scalable framework
• Suggest optimal data schema and storage options based on the company operation context.

Special Knowledge / Skills Required:

• Strong Analytical, conceptual and problem solving abilities
• Strong Interest in Technology
• Prior working experience in implementing enterprise scale reporting systems
• Strong Proficiency in RDMS SQL eg T-SQL ,
• Hands on experience in Microsoft SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS)
• Familiar with Business Intelligence Tool ie Microsoft Power BI, Tableau
• Programming / Scripting experience and knowledge of software development life cycle i.

Hardware & Software provided:

Visual Studio 2017, Microsoft SQL Server 2016, Python, Tableau.