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, including data modeling, ETL/ELT pipeline development, and compliance with FCA and GDPR standards. Proficient in SQL, DAX, and Power BI for operational reporting and data visualization.
Highest-signal resume keywords
Snowflake Data Lakehouse DevelopmentExpert SQL and Data ModelingPower BI DevelopmentETL/ELT Pipeline DesignData 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 ModelingDAXETLELTDbtPower BIData AnalysisData VisualizationData Governance
Soft Skills
Excellent CommunicationBusiness Requirement Translation
Tools & Technologies
SnowflakePower BIDbtAWSTerraformGitDAX StudioTabular EditorMicrosoft FabricClaude.ai
Industry Keywords
Financial ServicesTradingFintechData EngineeringAnalytics EngineeringGDPRFCAData LakehouseData WarehouseOperational Reporting
Tech Stack
Tools & technologiesAWSETLPythonSQLTerraform
About the role
Key responsibilities & impact- Lead the evolution of the 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, 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
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, including star/snowflake schemas and dimensional modelling
- At least 2 years writing dbt models in production
- Familiarity with dbt 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, including 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
- Nice to have: Python or another modern scripting language
- Nice to have: AWS (ECS, S3, IAM), Terraform, Git/GitHub Actions
- Nice to have: Power BI Embedded, Microsoft Fabric, or a credible point of view on when not to use them
- Nice to have: Microsoft Fabric Direct Lake, Snowflake Cortex, Claude.ai connector or other AI-on-warehouse patterns
Benefits
Comp & perks- Annual performance bonus under the Group bonus scheme
- Employer pension and social security contributions in line with statutory requirements
- Supplementary health insurance
- 20 working days of annual leave plus public holidays
- Company-provided hardware
- Annual learning and certification budget, including Snowflake, dbt and Microsoft
- Reasonable adjustments available at any stage of the recruitment process