The Zeal Group (https://www.zfx.com ) is a global financial corporation with a diversified portfolio of businesses spanning across Europe and Asia. Headquartered in London, with international affiliates in Hong Kong, Greater China, Taipei, Bangkok, Vietnam, Cambodia, Moscow, Abu Dhabi, Cairo. ZFX provides a wide range of financial products & services (FX, Commodities, Indices, Cryptocurrencies) to investors, professional traders, and financial institutions worldwide.
Zeal Technology Solutions Limited (ZTS) is a group company under the Zeal Group. We are young, energetic, and rapidly expanding. our Hong Kong office is the Asia Pacific headquarter and we provide strategic management, technology, marketing and manpower support to our affiliates across the regions.
The digital data engineer will work within the marketing technology team. The Data Engineer will provide end-to-end assistance with data pipeline from MySQL to Google Big Query, while supporting and optimizing the Marketing Data Architecture construct. This includes ETL, designing & building data models, data validation, and managing uptime. You will work closely alongside teams within our Marketing and IT departments to best align support for Marketing
Some projects include:
Pipelines from our MySQL database to Google BigQuery
Airflow pipelines to several analytics and ad-network destinations
Maintenance of Google BigQuery
SQL reports in Metabase
Matching media spend to ROAS
GTM service side tracking and implementation
Understanding the principles of organizing data warehouses, the principles of operation of columnar databases.
Working with data warehouse in designing data storage schemas.
Loading data from various sources (both internal databases and external analytical / marketing platforms, etc.) into data warehouse.
Automation of data-pipelines, ETL processes.
Search for errors and anomalies in data, automation of data quality check.
Preparing data marts.
Preparation and maintenance of the metadata catalog.
Organization of CI / CD and monitoring of data processing pipelines.
Great educational background, preferably in the fields of computer science or engineering
3– 5 years of relevant experience data analysis experience from Financial industry
Previous experience working with digital marketing teams
Understanding the Forex market is an advantage.
Strong knowledge of SQL, ability to build complex queries and optimize performance.
Experience with Apache Airflow, Vertica, Google Cloud Platform.
Strong Knowledge of Python
Fluent in English
If you believe you have the right skills, attitude and experience, please click Apply Now and upload your updated resume with current and expected salary. Only shortlisted candidate will be contacted.
(Personal Data collected will be used for recruitment purposes only)