Position Name : DW Architect

Mode of Hiring : Permanent with a Leading IT Company

Working Location : Hong Kong 

Job Description Summary 

The incumbent is responsible for the development and support of the Data Warehouse and Business Intelligence Analytics products including but not limited to data visualizations and interactive reports. Responsible for developing and applying Business Intelligence and Analytics subject matter expertise (data modeling, data discovery, BI product offering development and conceptual insurance acumen) to provide the business support departments with the tools and data representations which meeting strategic goals.

Responsibilities:

• Continuously develops and maintains an understanding of Business Intelligence technology and architecture, including data warehousing, dimensional modeling, data mining, reporting tools, and other methods of information delivery;
• Develops and maintains expertise with Microsoft Business Intelligence tools including: Excel/PowerPivot, SSRS, PerformancePoint, SSIS, & SQL Server Analysis Services;
• Develops database and/or data presentation solutions to deliver information to end-users accurately and efficiently;
• Extracts, transforms, & loads data using data management tools;
• IFRS17 lead for data warehouse integration
• General Ledger new interface development

 Required Qualifications

• Bachelor’s degree in computer science or equivalent education;
• Minimum of 5 years (depending on the level) work experience;
• Strong Experience with MSBI tools, including SSRS, SSIS and SSAS;
• Strong understanding of Data Warehouse concepts & design;
• Demonstrated ability to write SQL/TSQL queries to retrieve/modify data;
• Ability to abstract a concept into a series of lifecycle components and events;
• Significant experience  developing physical dimensional models, processes or data visualizations;
• Significant experience in data modeling, data discovery and the application of data to solve business problems Working knowledge of multiple IT platforms
• Insurance Industry experience preferred but not essential;