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.
Senior Data Engineer in City of Westminster employer: EC Markets LTD
EC Markets LTD is an exceptional employer that fosters a dynamic work culture focused on collaboration and innovation within the financial services sector. Employees benefit from comprehensive training programs, opportunities for professional growth, and a supportive environment that values attention to detail and proactive problem-solving. Located in a vibrant market, the company offers unique advantages such as exposure to diverse financial instruments and the chance to work closely with industry experts.
