FREE ACCESS
5,000–10,000 jobs/day
See all jobs on Scoutfield
Search thousands of fresh jobs every day.
Discover
- Fresh listings
- Fast filters
- No subscription required
Create a free account and start exploring right away.
Core Competencies
Role fitCore Competencies
Use this summary to align your resume positioning with the role.
Demonstrates expertise in Snowflake-based Data Lakehouse architecture, data modeling, and ETL/ELT pipeline development, ensuring compliance with FCA and GDPR standards. Proficient in SQL, DAX, and Power BI for operational reporting and analytics in financial services.
Highest-signal resume keywords
Snowflake Data Lakehouse DesignExpert SQL and Data ModelingPower BI DevelopmentETL/ELT Pipeline DevelopmentData Governance and Compliance
ATS Keywords
Tailor your resumeApplicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard Skills
SQLData ModelingDAXETLELTData AnalysisData VisualizationData GovernanceData IntegrityData Security
Soft Skills
Excellent CommunicationBusiness Requirement Translation
Tools & Technologies
SnowflakePower BIDbtAWSTerraformGitMicrosoft Fabric
Industry Keywords
Financial ServicesTradingFintechData EngineeringAnalytics Engineering
Tech Stack
Tools & technologiesAWSETLPythonSQLTerraform
About the role
Key responsibilities & impact- Lead the evolution of EC Markets' Snowflake-based Data Lakehouse
- Own a Snowflake-centric Data Lakehouse integrating structured, semi-structured and unstructured data
- Develop and support ETL/ELT pipelines ingesting and transforming data from trading, CRM, finance, risk and external APIs
- Implement data models, schemas and transformation frameworks for analytical and regulatory use cases
- Apply data versioning, orchestration and automation best practices
- Ensure scalability, data lineage and governance across the data lifecycle
- Build and own Snowflake semantic models using DirectQuery and Import, DAX, calculation groups, RLS/OLS and incremental refresh
- Develop operational reports, dashboards and data extracts for Trading, Finance, Marketing, Compliance and Operations
- Maintain data integrity, privacy and security aligned with FCA and GDPR requirements
- Monitor and optimise query performance and storage efficiency
- Partner with business units to capture data requirements and translate them into technical solutions
- Support regulatory, management and operational reporting through structured data models
- Report to the Head of Tech
Requirements
What you’ll need- Experience in financial services, trading or fintech environments
- Proven experience designing and delivering a DWH or Delta Lakehouse using Snowflake
- Expert-level SQL and data modelling expertise (star/snowflake schemas, dimensional modelling)
- At least 2 years writing dbt models in production
- Comfortable with sources, snapshots, tests, macros, exposures and the medallion (bronze/silver/gold) pattern
- At least 3 years building production Power BI on enterprise warehouses
- Expert DAX, including time intelligence, variables, virtual relationships, calculation groups, Power Query / M, Tabular Editor and DAX Studio
- Strong SQL on Snowflake, with a working understanding of warehouse sizing, clustering, query profiles and cost levers
- 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
- Degree in Computer Science, Data Engineering or a related field, or equivalent professional experience
- 5–8 years of hands-on experience in data engineering and/or analytics engineering
- Scripting in Python or another modern scripting language is nice to have
- Experience with AWS (ECS, S3, IAM), Terraform, Git / GitHub Actions is nice to have
- Power BI Embedded, Microsoft Fabric, or a credible point of view on when not to use them is nice to have
- Exposure to Microsoft Fabric Direct Lake, Snowflake Cortex, the Claude.ai connector or other AI-on-warehouse patterns is nice to have
Benefits
Comp & perks- Eligible for an annual company performance bonus under the Group bonus scheme; details shared at offer stage (Regional component)
- Employer contributions in line with statutory requirements
- Supplementary health insurance
- 20 working days plus public holidays of annual leave
- Company-provided hardware
- Annual learning & certification budget (incl. Snowflake, dbt, Microsoft)
- Reasonable adjustments available at any stage