Senior Data Engineer

Overview

EC Markets is building a next-generation data platform to power trading, operational, and marketing intelligence. We are seeking a Senior Data Engineer to drive evolution of our Snowflake-based Data Lakehouse, establishing a modern data ecosystem that supports advanced analytics, compliance, and decision-making across the business.

This is a high-impact role for an experienced engineer with a track record of architecting and implementing scalable data platforms — ideally in financial or trading environments — who can talk and think data from ingestion to MI dashboards.

Key Responsibilities

Architecture & Development

• Assume ownership of a Snowflake-centric Data Lakehouse integrating structured, semi-structured, and unstructured data.
• Develop and support robust ETL/ELT pipelines that ingest and transform data from multiple internal systems (trading, CRM, finance, risk, etc.) and external APIs.
• Implement data models, schemas, and transformation frameworks optimised for analytical and regulatory use cases.
• Apply best practices in data versioning, orchestration, and automation using modern data engineering tools.
• Ensure scalability, data lineage, and governance across the data lifecycle.

Reports and data visualisation

• Build and own semantic models on top of Snowflake (DirectQuery and Import), using DAX, calculation groups, RLS/OLS, and incremental refresh.
• Develop operational reports, dashboards and data extracts

Data Governance & Quality

• Maintain high data integrity, privacy, and security aligned with FCA and GDPR requirements.
• Monitor and optimise query performance and storage efficiency.

Cross-Functional Collaboration

• Partner with business units (Trading, Finance, Marketing, Compliance, Operations) to capture data requirements and translate them into robust technical solutions.
• Support regulatory, management, and operational reporting requirements through structured data models.

Skills & Experience (Non-negotiable)

• Experience in financial services, trading, or fintech environments.
• Proven experience designing and delivering DWH / Delta Lakehouse using Snowflake.
• Expert level SQL and data modelling expertise (star/snowflake schemas, dimension/al modelling).
• 2+ years writing dbt models in production. Comfortable with sources, snapshots, tests, macros, exposures, and the medallion (bronze/silver/gold) pattern.
• 3+ years building production Power BI on enterprise warehouses. Expert DAX (time intelligence, variables, virtual relationships, calculation groups), Power Query / M, Tabular Editor, DAX Studio.
• Strong SQL on Snowflake. Understand warehouse sizing, clustering, query profiles, and the cost levers that matter.
• Familiarity with orchestration and transformation frameworks.
• Hands-on experience with data analysis, visualisation, and operational reporting tools.
• Excellent communication skills and ability to translate business requirements into scalable data architecture.

Skills & Experience (nice to have)

• Ability to create scripts in Python or another scripting language.
• Experience with AWS (ECS, S3, IAM), Terraform, Git/GitHub Actions.
• Power BI embedded, Fabric, or a credible opinion on when not to use them.
• Exposure to Microsoft Fabric Direct Lake, Snowflake Cortex / Claude.ai connector, or other AI-on-warehouse patterns.

Qualifications

• Degree in Computer Science, Data Engineering, or related field.
• 5–8 years of hands-on experience in data engineering and / or analysis.