Data Architect (eMPF) - IC

Classy Wheeler Limited; Hong Kong; On-site; HKD 800,000 - 1,000,000; Full time

Job summary

A data management firm in Hong Kong is looking for a Data Architect with over 10 years of experience in data warehouse and analytics, along with at least 5 years in a leadership role. The ideal candidate will lead IT teams in data discovery and visualization, focusing on governance and security. Strong SQL skills are essential, along with experience in big data technologies such as AWS and Hadoop. Candidates should also be proficient in both Cantonese and English.

Qualifications

• 10+ years in data warehouse & analytics, 5+ in a leadership role.
• Strong understanding of data management technologies.
• Experience in building large-scale analytical data pipelines.

Responsibilities

• Design and manage data pipelines for project requirements.
• Maintain a centralized data warehouse for effective data management.
• Oversee data quality management and implement best practices.

Skills

Data pipeline development

SQL

Data visualization

Data governance

Communication skills

Education

Degree in Information Technology or related fields

Minimum of 5 years in Data Management

Tools

SQL Server

Power BI

AWS

Hadoop

Informatica

Job description

• Lead and work with IT team on data discovery, data acquisition/integration/enrichment from a wide-spectrum of data sources
• Data modeling for datalake, data warehouse & data marts
• Data visualization, data governance as well as new technology adoption
• To lead and work with IT team to meet fast growing business needs; plan resources and prioritize with business stakeholders in a time-sensitive environment with competing deadlines.
• Improve and strengthen data governance especially on data privacy protection and security measures.
• Working closely with source system owners on data discovery, data glossary, data acquisition, ingestion and enrichment.
• Build enterprise data models for enterprise datalake, data warehouse and data marts.
• Working closely with downstream system owners on data integration
• Working with business units on data visualization: KPI/metric reporting, business intelligence for enterprise performance analysis
• Working closely with technical architecture team to identify, evaluate and adoption of new data management technologies (RDBMS, Hadoop, NoSQL, data integration, visualization) to keep up evolving business needs.

Responsibilities

• Design, develop, maintain, and manage the data pipeline, data quality and data management for meeting the core systems and project requirements, and business needs.
• Work closely with different business stakeholders to maintain and develop a centralized data warehouse for data management, and data pipeline
• Oversee and manage the work-flow of data quality management, data cleansing and data exchanges processes by designing and implementing different rules and best practice
• Write SQL, PL/SQL, Python to run queries and support data analysis work

Job Requirements

• Solid knowledge on database, modelling, data cleaning, transformation and warehousing, and data lake
• Good command in both Cantonese and English
• Solid experience to design and develop, maintain the Enterprise Data Warehouse and Business intelligence, and data visualization environments.
• Experience in designing and delivering solutions within big data environments such as AWS, Mango DB etc.
• Experience in Pension Business is preferred

Responsibilities

• Design data pipeline and dashboard to support different reporting purpose from existing multiple data sources;
• Develop and maintain the data mapping and Glossary for the BI reporting, analysis and data modelling;
• Design a good knowledge management BI tool to contribute the planning & execution of data-insights;
• Provide data statistical support for scheme review on key statistical issues;

Job Requirements

Data Architect (eMPF)

Requirements

• University graduate in Information Technology, Computer Science, Data Science or related disciplines
• 10+ years of experience in data warehouse & analytics domain, with 5+ years in leader role in BigData project.
• Strong business acumen and fast learner of new business.
• Strong problem solving skills, excellent communication and presentation skills
• Solid technical experience in datalake, data warehouse and data mart design, batch/real-time data integration (ETL/ELT), data visualization, and data analytics.
• Deep understanding of data security and compliance.
• Solid knowledge on data management technologies
• RDBMS, NoSQL, Hadoop eco-system
• Data integration coding and tools (Informatica, InfoSphere, Talend, etc)
• Data Visualization tools (e.g. QlikSense, Tableau, PowerBI, Jasper, Pentaho, etc.)
• Solid experience in marketing campaign system and digital marketing techniques.

Requirements

• Degree Holder or above in Computer Science or related disciplines
• Minimum 5 years of working experience in Data Management.
• Solid experience on Data Management or Data Engineering.
• Passionate in data management, data analysis and business intelligence
• Strong team player and with can-do attitude

Requirements

• Degree holder in computer science;
• 3 to 5 years of solid experience in ETL development and orchestration for building large scale analytical data pipelines;
• 3 to 5 years of development experience using Power BI Desktop as well as row level security/workspace management using Power BI service;
• Solid experience in database solution development by MS SQL and Oracle including stored procedures;
• Development experience in Data-warehouse or Business Intelligence tools;
• Experience in Database and Windows Server Clustering and Performance Tuning is a plus;
• Good command in Cantonese and English;