Address
Hong Kong, HK, HK
Hong Kong, HK, HK
Senior System Analyst, Information And Technology Transformation
Country :
Area Hong Kong
Town : Hong Kong
Category : Retail
Contract type : Permanent
Availability : Full time
Job description
The Role:
Be a subject matter expert in data management and reporting, develop a data-driven model by delivering business insights via user-friendly dashboards for easier visualization.
Reports to: Senior Manager - Applications
Responsibilities
- Be a subject matter expert in data management and reporting, develop a data-driven model by delivering business insights via user-friendly dashboards for easier visualisation.
- Consolidate and optimize available data warehouse infrastructure
- Work with various departments, analyze user needs and turn multi-source data into meaningful business information, using advanced analytics, reporting and BI applications.
- Design and implement ETL procedures for intake of data from both internal and outside sources
- Identify valuable data sources, undertake pre-processing of structured and unstructured data.
- Work closely with IT peers and 3rd-party vendors to ensure deliverables meet business requirements; Prepare and maintain function specifications and relevant documentation.
- Assist in other digital and ad-hoc projects whenever required.
Be a subject matter expert in data management and reporting, develop a data-driven model by delivering business insights via user-friendly dashboards for easier visualization.
Reports to: Senior Manager - Applications
Responsibilities
- Be a subject matter expert in data management and reporting, develop a data-driven model by delivering business insights via user-friendly dashboards for easier visualisation.
- Consolidate and optimize available data warehouse infrastructure
- Work with various departments, analyze user needs and turn multi-source data into meaningful business information, using advanced analytics, reporting and BI applications.
- Design and implement ETL procedures for intake of data from both internal and outside sources
- Identify valuable data sources, undertake pre-processing of structured and unstructured data.
- Work closely with IT peers and 3rd-party vendors to ensure deliverables meet business requirements; Prepare and maintain function specifications and relevant documentation.
- Assist in other digital and ad-hoc projects whenever required.
Profile
- Postgraduate Degree or equivalent
- 8-10 years of work experience with at least 4-6 years in data analytics, business intelligence, or system integration roles, preferably in retail industry
- Experience in data analysis with proven ability to develop and manage advanced level SQL, familiar in data stack (especially in cloud platform)
- Hands-on experience in database design and reporting tools like SSRS, Power BI and/or other similar data visualization tools
- Ability to interpret and manipulate large data sets, data storage, ETL and data modelling. Exposure to big data technology and good understanding of data governance, data quality, reference data and data lineage is strongly preferred;
- Proven experience in web services, SSRS/SSAS/SSIS, and other system integration and components, including application-to-application integrations and services, internal and external API, file transfer, and EDI and SQL queries.
- Strong data analytical capability and mindset, with creative problem-solving skills. Capable of handling details with sense of ownership and responsibilities
- Hands-on experience with data solutions and system integration in fast-paced multi-channel retail background is strongly preferred;
- Hands-on experience in eCommerce, POS, CRM, and/or supply chain would be advantageous
- Experienced in financial reporting would be advantageous
- Good interpersonal, stakeholder and vendor management skills
- Good command of both written and spoken English and Chinese (Cantonese & Mandarin)
- Knowledge in Salesforce and SAP would be advantageous
- 8-10 years of work experience with at least 4-6 years in data analytics, business intelligence, or system integration roles, preferably in retail industry
- Experience in data analysis with proven ability to develop and manage advanced level SQL, familiar in data stack (especially in cloud platform)
- Hands-on experience in database design and reporting tools like SSRS, Power BI and/or other similar data visualization tools
- Ability to interpret and manipulate large data sets, data storage, ETL and data modelling. Exposure to big data technology and good understanding of data governance, data quality, reference data and data lineage is strongly preferred;
- Proven experience in web services, SSRS/SSAS/SSIS, and other system integration and components, including application-to-application integrations and services, internal and external API, file transfer, and EDI and SQL queries.
- Strong data analytical capability and mindset, with creative problem-solving skills. Capable of handling details with sense of ownership and responsibilities
- Hands-on experience with data solutions and system integration in fast-paced multi-channel retail background is strongly preferred;
- Hands-on experience in eCommerce, POS, CRM, and/or supply chain would be advantageous
- Experienced in financial reporting would be advantageous
- Good interpersonal, stakeholder and vendor management skills
- Good command of both written and spoken English and Chinese (Cantonese & Mandarin)
- Knowledge in Salesforce and SAP would be advantageous