Send me more jobs like this

Sorry, This job is expired.


Keywords / Skills : Server, ETL, Information Technology, data structures, Database, Data Warehouse, SQL, dimensions, data mining, prototype, PMP, SQL Server

6 - 11 years
Posted: 2018-11-03

Hong Kong
System Analyst/ Tech Architect
Posted On
3rd Nov 2018
Job Ref code
Job Description
  • Partner with regional and market business teams and regional IT domain heads and global BI team to define, document, implement and support the Regional BI Program that enable both business and IT strategies and objectives
  • Engage with Business stakeholders to understand and guide their requirements and ensure the BI solutions meet their analytical and reporting needs
  • Define the BI Architecture for the region in accordance with global guidelines
  • Data Presentation: Actively engage in the deployment of various data presentation technologies and Business Intelligence tools and ensure these are well integrated with underlying models
  • Analyze and in some cases reverse engineer existing data models, systematically understand current usage patterns, prototype and scientifically evaluate alternatives for improvement and quantitatively demonstrate the benefits of optimized data models
  • Assist application support in performance tuning on existing Data Warehouse databases and propose both short and long term solutions to address performance issues
  • Work with other teams on new BI project solution design and support business case development
  • Oversee implementation of data model designs during project execution and engage with development teams as necessary to ensure quality
  • Analyze data structures and existing usage patterns, including reverse engineering query SQL, optimize/re-design the data model as necessary
  • Data Presentation: Actively engage in the deployment of various data presentation technologies and Business Intelligence tools and ensure these are well integrated with underlying data models
  • Data Integration: Deploy and use data integration tools (e.g. ETL) to implement best practice data acquisition, transformation, movement and delivery
  • Create, document, reconcile and maintain logical and physical data models, reflecting the state and use of data across the business
  • Capture, integrate and publish descriptive metadata across the various applications and tools (modelling, integration and more) in the environment
  • Data quality definition and management – analyze and measure data-quality levels, identify data quality issues; work with users and other IT functions to improve data quality
  • Ensure new BI applications integrate and comply with the BI architecture
  • Bachelor Degree in Engineering, Computer Science, Information Technology or other related discipline
  • PMP or Prince 2 certified
  • At least 8+ years hands on experience in BI and Data Warehouse design and delivery with successful implementation references with at least 6 years in Data Modelling and/or Data Warehouse Development
  • Strong understanding of Database concepts and competence in SQL
  • Essential to have understanding and experience with dimensional modelling concepts (star schema, slowly changing dimensions etc.)
  • Working on the Microsoft BI Stack is essential (SQL Server, SSIS, SSAS, SSRS, Power BI)
  • Experience with other BI Tools and technologies (data modelling, data integration/ETL, reporting, metadata management, data quality management, data mining, corporate performance management etc.)
  • Experienced in managing end-to-end project life cycles with local/regional/global stakeholders, across multiple countries

If you would like to apply for this role or find out more, please contact Mandy Wong on (852) 2177 7577 or

About Company

Grey Anderson is a specialist recruitment consultancy dedicated in Information Technology, Sales & Marketing and General Management. We provide the highest level of professional service to meet your recruitment needs and to achieve your business goal in the ever-changing business environment.

At Grey Anderson, we strive to exceed your expectations at all times with our strong network and expertise in the industries. Whether you are looking for a permanent or contract position, we will always be able to identify the best-suited candidate to add to the success of your business. Our recruitment services cover industries including Information Technology, Telecommunication, Luxury Goods, Consumer Products, FMCG, Media, Supply Chain, Healthcare, Tourism, Property, Financial Services, Professional Services, Consultancy as well as Utilities spreading over across Asia Pacific.
We appreciate not only the business with you, but also the business that you are running. We value not only the long-term partnership with you, but also your relationship with your people. We believe not only in placing the best and brightest talent, but also the opportunities they bring to help you achieve your goals and succeed in the market.