Data Engineer - Snowflake / Portfolio Suitability Programme

Experis - ManpowerGroup; Greater London; On-site; GBP 70,000 - 110,000; Full time

Job summary

Confidential client in wealth management seeks a Snowflake Data Engineer to support a Portfolio Suitability Programme. You will design scalable data solutions and pipelines for market, portfolio and client data, enabling governance, reporting and AI-driven insights.

Role focuses on data modelling (Star Schema), time-series data, and integration across platforms, with collaboration across delivery teams. Strong SQL optimization and cloud experience required.

Qualifications

• Expert-level Snowflake data engineering skills and SQL performance tuning.
• Experience with data modelling for Star Schema and time-series datasets.
• Hands-on experience with data integration of market, portfolio and client data.
• Proficiency in building data pipelines and ETL/ELT processes.
• Familiarity with AI-enabled data capabilities and governance.

Responsibilities

• Design scalable data solutions for Portfolio Suitability Programme.
• Build and optimize pipelines for market, portfolio, client and suitability data.
• Develop data models to support reporting, analytics, and regulatory requirements.
• Integrate large-scale market and time-series data sources.
• Collaborate with stakeholders to translate requirements into technical solutions.
• Ensure data quality, governance, and lineage across platforms.
• Support adoption of AI-enabled capabilities in the data ecosystem.

Skills

Snowflake

Cortex AI

Star Schema Data Modelling

Time-Series Data engineering

SQL optimization

Tools

Dbt

Claude Code

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