About the Role
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.
Responsibilities
- 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.
- 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.
- Maintain high data integrity, privacy, and security aligned with FCA and GDPR requirements.
- Monitor and optimise query performance and storage efficiency.
- 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.
Requirements
- 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.
- 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.
Skills
- Snowflake
- ETL/ELT
- Data Modelling
- Data Versioning
- Orchestration
- Automation
- Data Lineage
- Data Governance
- DAX
- Power BI
- Power Query / M
- Tabular Editor
- DAX Studio
- SQL
- Python
- AWS
- Terraform
- Git/GitHub Actions
- Microsoft Fabric
- Snowflake Cortex
- Claude.ai
Location
- Remote
Work Type
- Full-time
Experience Level
- Senior
- 5–8 years of hands-on experience in data engineering and / or analysis
Education Level
- Degree in Computer Science, Data Engineering, or related field
About the Company
- EC Markets is building a next-generation data platform to power trading, operational, and marketing intelligence.
