Solution Architect (Data and AI Platform)

Overview

In this role you shape Elsevier’s Operational Data Platform, working with an embedded team to design Snowflake-based data warehouse solutions, add AI-enabled capabilities, and establish secure, scalable, and compliant data platform capabilities that drive strategic outcomes. You will influence architecture direction, governance, and integration across data tooling and AI capabilities. This position offers impact at scale within a global information and analytics leader, tackling real-time data, API-led integration, and GenAI use cases.

Pay / Benefits

• wellbeing initiatives
• shared parental leave
• study assistance
• sabbaticals

Responsibilities

• Lead the architecture and design of Snowflake-based data warehouse solutions and dependent systems
• Develop next-generation platform capabilities, including real-time ingestion, AI-driven insights and API-led integration
• Design data structures and interfaces that enable natural-language querying and GenAI use cases
• Support the adoption of modern data-engineering methods and best-in-class tooling
• Integrate data toolchains with internal systems using API-driven approaches, including MCP
• Establish secure, standardised best practices across data warehousing, integration and AI tooling
• Define inter-system data flows, architectural roadmaps and governance standards
• Ensure solutions comply with Elsevier and RELX policies and standards
• Problem-solve, involving leading teams in identifying, researching, and coordinating the resources necessary to effectively troubleshoot/diagnose complex system issues
• Drive technical direction and architecture evolution via reviews, roadmaps and on-floor leadership

Key requirements

• Significant experience in software development, solution architecture or data-platform architecture
• Strong experience designing Snowflake data warehouse solutions and working across the Snowflake ecosystem
• Understanding of operational technology data, technology assets, dependencies, relationships and end-to-end flows within a large enterprise
• Solution architecture across Snowflake, DBT and SqlDBM, including data modelling and schema design
• AWS architecture, including EC2, RDS, databases, SQS, Kinesis, S3 and Lambda, plus familiarity with Azure
• Experience with real-time ingestion, streaming and processing technologies, API design, graph databases, and AI-enabled solutions including MCP
• Familiarity with Tableau, GitHub, Jira, CI/CD and Agile delivery
• Strong knowledge of architectural governance, requirements gathering and end-to-end data-flow design

• Strong organisational, project planning and time management
• Excellent problem-solving abilities
• Excellent communication, presentation and stakeholder management
• Snowflake data warehouse design
• DBT
• SqlDBM

…