Data Engineer (London, UK based)

Company:
Location: Hong Kong

*** Mention DataYoshi when applying ***

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.

Job description

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

Responsibilities:
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.

Requirements:
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)

Full-time

*** Mention DataYoshi when applying ***

Offers you may like...

  • Amazon.com Services LLC

    Data Engineer II (L5) - Business Data Technologies
    Seattle, WA
  • Bank of America

    Data Engineer
    Dallas, TX
  • Central Mutual Insurance Company

    Senior Data Engineer
    Van Wert, OH 45891
  • Qcentrio

    Data Engineer - Bigdata
    Fine, NY
  • Uber

    Data Engineer II, Fintech
    San Francisco, CA 94103