Emeria Technologies
Emeria Technologies
Emeria Technologies provides residential and commercial real estate services across Europe, supporting property owners, tenants, investors, and businesses throughout the property lifecycle. Its services span property acquisition, leasing, rentals, block management, and sales, delivered through local branch networks and technology-enabled operations. The group works across eight European countries through a multi-brand model that includes Foncia in France, with a large team serving both individual consumers and business clients.

Freelance Data Engineer, Snowflake Migration

Migrate Emeria’s UK analytics platform from Azure Synapse to Snowflake, rebuilding ingestion pipelines and converting T-SQL procedures. The role covers data parity checks, LLM-assisted code translation, and knowledge transfer.

Description

  • Oversee 15 Azure Data Factory pipelines and rebuild ingestion with Fivetran, CDC, or incremental extraction scripts.
  • Convert around 200 T-SQL stored procedures to Snowflake, supported by a lightweight Spark layer.
  • Use LLM tools to speed up code conversion and test creation.
  • Run processes in parallel and reconcile data to match existing reporting.
  • Document the work and transfer knowledge to the UK team.
  • Help migrate the UK analytics platform from Azure Synapse to Snowflake, Fivetran, and Airflow (MWAA).

Requirements

  • Strong proficiency with Snowflake and Airflow.
  • Practical experience converting T-SQL or MS SQL stored procedures to Snowflake, including SCD2, transactions, loops, and MERGE.
  • Recent experience using LLMs to translate code and generate tests for a migration project.
  • Strong understanding of incremental ingestion methods such as delta and watermark.
  • Fluent in English.
  • Able to work independently and take a proactive approach.
  • Knowledge of Spark or PySpark, Fivetran, Azure Synapse, or Data Factory is an advantage.

Benefits

  • Remote work.
  • The assignment may be extended.

Related Jobs