Senior Software Engineer-Senior Consultant

Major Duties and Responsibilities: Software developers implement or program all kinds of software systems based on specifications and designs by using programming languages, tools, and platforms. • to be responsible for the overall system analysis, design, development, enhancement, testing, implementation, and technical documentation in relation to the relevant Systems in accordance with client’s requirements. • to be responsible for all stages of business intelligence (“BI”) and data warehouse project work, including requirements, logical and physical design, development, testing, implementation, and deployment. • to evaluate and analyse the existing user requirements, functional and technical specifications. • To evaluate and analyse the existing data architectures, data models and data warehouse. • to create written communication materials that effectively summarise findings of and support recommendations of client or the Assigned Person. • to plan and perform quality assurance and testing by writing test plans, and managing the execution of unit testing and user acceptance test; and • to provide such other services or perform such other tasks in relation to the relevant Systems as required by client from time to time. Requirements: • has working experience in all stages of BI and data warehouse project work, including requirements, logical and physical design, development, testing, implementation, and deployment. • has extensive knowledge of BI and data warehouse implementation methodologies and has in-depth working experience in BI and data warehouse. • possesses the necessary analysis and communication skills, including the ability and skills to perform the work set out in paragraph A.2 above. • understands and has expertise in the various technologies needed to implement Microsoft BI solutions. • has working experience using the Microsoft BI stack and other technologies related to the Systems including Oracle, SAP BW and SAP Business Objects; This information/document has been classified: Internal – Use • possesses the specific technical skills of an experienced BI and data warehouse senior developer, including technical skills in the following: (i) SQL Relational Database; (ii) Data warehouse design; (iii) Dimensional modelling; (iv) Extraction, transformation and loading (ETL) using Microsoft SQL Server Integration Services (SSIS); (v) Solution Design; (vi) Online Analytical Processing (OLAP) cube development using Microsoft SQL Server Analysis Services (SSAS) and Multidimensional Expressions (MDX); (vii) Report development using Microsoft SQL Server Reporting Services (SSRS); (viii) Microsoft Data Visualization tools such as Power Pivot and Power BI; (ix) Advanced skill level and advanced knowledge in SQL Language (Query) and Stored Procedure; (x) Big Data skills and knowledge (added advantage) • possesses bachelor’s degree in Computer Science/Information Technology or equivalent. • has minimum 5 years’ working experience in the specific technical skills of a BI and data warehouse senior developer as set out in paragraph A.3(f) above. • has minimum 5 years’ working experience in database design using SQL Server databases. • (j) has knowledge in financial risk assessment. • has working experience using Microsoft SQL Server 2016 or any higher version including SQL Server Management Studio, SQL Server Reporting Services, SQL Server Integration Services. • is a team player with good communication and interpersonal skills. • has positive attitude and good analytic skills, and is creative in problem solving; and • has excellent verbal and written communication skills in English.