Job ref no.: CT3117255-01#6667

Business Intelligence Architect

Robert Walters

Salary Negotiable

Location Hong Kong

FULL_TIME

Consultant Eddie Wang


Working with a leading luxury retail company, seeking a talented BI Architect to join their global team and help define their BI architecture in the region.

Responsibilities

  • 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

Requirements

  • 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
  • Proven experience in applying Software Engineering best practices and techniques such as structured analysis, use cases and formal estimation
  • Proven experience in managing a team of technology professionals (that include in-house, external, off-shore resources) to run strategic IT projects
  • Essential to have 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
  • Experience in consumer goods, retail, hospitality or luxury retail is an advantage

Get in touch

Eddie Wang

+852 21035341

[via CTgoodjobs Apply Now ]

All applications applied through our system will be delivered directly to the advertiser and privacy of personal data of the applicant will be ensured with security.