Hybrid Cloud Data Architect - Snowflake & BI Focus

Penguin Random House UK; Greater London; Hybrid; GBP 59,000 - 72,000; Full time

Benefits offered by this job

Hybrid work

Bonus scheme

London office

Job summary

Penguin Random House UK is seeking an experienced Data Architect to join our Technology team in London. The role focuses on designing robust, scalable data foundations for our end-to-end cloud data platform, aligning data architecture with business outcomes and our Dev/DataOps culture.

You will translate priorities into practical architectural designs, collaborating with Product, Data Platform, and Data Engineering to support analytics, ML/AI use cases and governance, with a hybrid working model

Qualifications

• Extensive experience in cloud-based data engineering, BI and data science solutions.
• Experience with dbt for transforming, modelling, testing and documenting data.
• Strong data modelling skills for structured and unstructured data including CRM and marketing data.
• Expert knowledge of data structures and when to apply different approaches.
• Very strong SQL and experience with PostgreSQL, SQL Server and Data Vault.
• Experience migrating legacy data to cloud platforms and refactoring accordingly.
• Ability to work with governance, GDPR compliance and data cataloguing.

Responsibilities

• Design robust, scalable data pipelines and architecture for cloud data platform.
• Plan migration of legacy data into Snowflake with data lake and transformed layers.
• Embed security, quality, performance and scalability into data environments.
• Ensure data architecture supports Power BI reporting and broader BI needs.
• Set technical direction aligned with data strategy and platform roadmaps.
• Support data governance with compliant, catalogued data structures.
• Collaborate with data science to design environments for advanced analytics/ML/AI.
• Stay updated on data industry developments to improve the platform.

Skills

Cloud data architecture

Data pipelines

SQL

Data modelling

Data governance

Communication

Tools

dbt

Snowflake

AWS

Power BI

Job description

Penguin Random House UK is seeking an experienced Data Architect to join our Technology team in London. The role focuses on designing robust, scalable data foundations for our end-to-end cloud data platform, aligning data architecture with business outcomes and our Dev/DataOps culture.

You will translate priorities into practical architectural designs, collaborating with Product, Data Platform, and Data Engineering to support analytics, ML/AI use cases and governance, with a hybrid working model