EC Markets
EC Markets
51 – 200 Employees
CryptoFinanceFintech
EC Markets is an online financial broker serving retail and institutional clients with contracts for difference (CFDs) across forex, precious metals, energy, global indices and cryptocurrencies. Its trading offering includes MetaTrader 4 and 5, a mobile app, copy trading and market analysis and educational resources. The company operates internationally under multiple regulatory licences and describes its focus as retail trading, order execution and client protection.

Senior Data Engineer, Snowflake and Power BI

Lead EC Markets’ Snowflake lakehouse for trading, regulatory and business intelligence data. Build dbt models, Power BI reporting and enterprise data solutions.

Description

  • Guide the development of EC Markets’ Snowflake data lakehouse.
  • Own a Snowflake-centered lakehouse that brings together structured, semi-structured and unstructured data.
  • Build and maintain ETL/ELT pipelines that ingest and transform data from trading, CRM, finance, risk and external APIs.
  • Create data models, schemas and transformation frameworks for analytics and regulatory reporting.
  • Use sound practices for data versioning, workflow orchestration and automation.
  • Maintain scalability, data lineage and governance throughout the data lifecycle.
  • Develop and manage Snowflake semantic models with DirectQuery and Import.
  • Create operational reports, dashboards and data extracts for Trading, Finance, Marketing, Compliance and Operations.
  • Safeguard data integrity, privacy and security in line with FCA and GDPR requirements.
  • Track and improve query performance and storage efficiency.
  • Work with business teams to gather data needs and turn them into technical solutions.
  • Enable regulatory, management and operational reporting through structured data models.
  • Report to the Head of Tech.

Requirements

  • Background in financial services, trading or fintech.
  • Track record of designing and delivering a Snowflake data warehouse or Delta Lakehouse.
  • Advanced SQL and data modelling skills, including star or snowflake schemas and dimensional modelling.
  • At least two years of writing dbt models used in production.
  • Experience with dbt sources, snapshots, tests, macros and exposures, and the bronze, silver and gold medallion pattern.
  • At least three years of building production Power BI solutions on enterprise data warehouses.
  • Advanced DAX, including time intelligence, variables, virtual relationships, calculation groups, RLS/OLS and incremental refresh.
  • Experience with Power Query/M, Tabular Editor and DAX Studio.
  • Strong SQL skills with Snowflake.
  • Working knowledge of warehouse sizing, clustering, query profiles and cost optimisation.
  • Familiarity with orchestration and data transformation frameworks.
  • Practical experience in data analysis, visualisation and operational reporting tools.
  • Strong communication skills and the ability to turn business needs into scalable data architecture.
  • Degree in computer science, data engineering or a related field, or equivalent professional experience.
  • Five to eight years of hands-on experience in data engineering and/or analytics engineering.
  • Desirable: Python or another modern scripting language.
  • Desirable: AWS, Terraform, Git or GitHub Actions.
  • Desirable: Power BI Embedded or Microsoft Fabric.
  • Desirable: Microsoft Fabric Direct Lake, Snowflake Cortex, Claude.ai connector or other AI-on-warehouse approaches.

Benefits

  • Annual performance bonus through the Group bonus scheme.
  • Employer pension and social security contributions as required by law.
  • Supplementary health insurance.
  • 20 working days of annual leave, plus public holidays.
  • Company-provided hardware.
  • Annual budget for learning and certifications, including Snowflake, dbt and Microsoft.
  • Reasonable adjustments available at any stage of the recruitment process.

Related Jobs

No jobs found

Try adjusting or clearing your filters to find more opportunities.