Data Engineer - Snowflake / Portfolio Suitability Programme

Experis; City Of London; On-site; GBP 90,000 - 120,000; Full time

Job summary

Experis is seeking an experienced Snowflake Data Engineer to join a strategic Portfolio Suitability Programme within a leading wealth and investment management environment. You will design, develop, and maintain scalable data solutions that support portfolio suitability, investment governance, client outcomes, and regulatory compliance.

The role focuses on building robust data pipelines, integrating market and time-series data, and enabling AI-enabled insights while partnering with stakeholders

Qualifications

• Experience delivering data solutions for portfolio suitability, investment governance, or wealth management platforms.
• Strong knowledge of Snowflake data warehousing and data modelling.
• Proficiency with SQL, ETL/ELT development, and performance tuning.
• Experience with data governance, lineage, and regulatory reporting.
• Ability to work with stakeholders to translate requirements into scalable data solutions.

Responsibilities

• Design, develop, and maintain scalable data solutions for the Portfolio Suitability Programme.
• Build and optimize data pipelines for market, portfolio, and client datasets.
• Develop robust data models to support reporting and regulatory needs.
• Collaborate with architects, product owners, and delivery teams to implement solutions.
• Ensure data quality, governance, and lineage across platforms.

Skills

Snowflake data engineering

Cortex AI (Snowflake Cortex AI)

Star Schema Data Modelling

Market Data integration

Time-Series Data engineering

Dbt (Data Build Tool)

SQL and performance optimisation

Cloud-based data engineering

Tools

Claude Code

Cloud Platforms

Job description

Data Engineer - Snowflake / Portfolio Suitability Programme

My leading client is seeking an experienced Snowflake Data Engineer to join a strategic Portfolio Suitability Programme within a leading wealth and investment management environment.
This is an exciting opportunity to work on a high-profile data transformation initiative focused on portfolio suitability, investment governance, client outcomes, and regulatory compliance. Candidates with direct experience delivering data solutions on portfolio suitability, suitability assessments, investment management, wealth management platforms, or related regulatory programmes will be highly advantageous.
Key Responsibilities

• Design, develop, and maintain scalable data solutions supporting a Portfolio Suitability Programme.
• Build and optimise data pipelines for market, portfolio, client, and suitability datasets.
• Develop robust data models to support reporting, analytics, regulatory requirements, and AI-driven insights.
• Integrate and manage large-scale market and time-series data sources.
• Collaborate with business stakeholders, architects, product owners, and delivery teams to translate business requirements into technical solutions.
• Ensure data quality, governance, lineage, and consistency across multiple platforms.
• Support the adoption of AI-enabled capabilities within the data ecosystem.

Required Technical Skills

• Snowflake (expert level)
• Cortex AI (Snowflake Cortex AI)
• Star Schema Data Modelling
• Market Data integration and management
• Time-Series Data engineering and modelling
• Dbt (Data Build Tool)
• Claude Code
• Data warehousing and ETL/ELT development
• SQL and performance optimisation
• Cloud-based data engineering experience

Highly Desirable Experience

• Wealth Management or Private Banking experience
• Investment Management platforms and data
• Portfolio Suitability programmes
• Suitability monitoring and assessment frameworks
• Investment performance and analytics data
• Regulatory programmes impacting wealth or investment management
• Front-office, investment, or advisory data domains