About the Role
Join the Penguin Data Engineering team in London to shape and improve how data is accessed, understood, and used across DK and PRH. You will be part of the PRH Data Centre of Excellence, collaborating with various business areas to make trusted data available for reporting, analytics, and operational workflows.
Responsibilities
- Build and manage data pipelines for reliable data movement between systems.
- Maintain DK’s Snowflake data environment, including data models, schemas, performance, and data quality controls.
- Integrate data from different internal and external sources, ensuring security, accessibility, and alignment with PRH data standards.
- Automate manual data and reporting processes using cloud tools, GitHub, and other services.
- Manage CI/CD processes for data solutions, ensuring proper testing, documentation, and safe movement between environments.
- Support BI and reporting needs, working with analysts and stakeholders on dashboards and reports using tools like Power BI and Microsoft Fabric.
- Create clear documentation, including technical notes, data definitions, and service transition materials.
- Support testing, incident resolution, and performance monitoring for DK data solutions.
- Lead technical conversations and reviews, sharing best practices in data engineering, automation, data modelling, and BI.
- Continuously improve DK’s data infrastructure by staying current with tools and identifying better ways of working.
- Collaborate with Data Governance to ensure monitoring, alerting, and metadata are up-to-date.
Requirements
- Strong experience in data engineering, business intelligence development, or data platform engineering with a proven track record of designing, building, and supporting scalable data integration solutions.
- Strong knowledge of Snowflake and other cloud data platforms, including schema design, data modelling, secure access, and performance management.
- Excellent SQL skills, ideally within Snowflake, including data extraction, transformation, analysis, performance optimisation, and working with large, structured datasets.
- Strong Python skills for data processing, automation, and integration, with the ability to build maintainable, well-documented solutions.
- Practical experience of building and managing data pipelines using ETL or ELT frameworks, with knowledge of tools such as dbt, Fivetran, or similar.
- Understanding of BI data modelling and reporting tools, such as Power BI, Microsoft Fabric, or Looker, including how to structure data for reporting and self-service analytics.
- Experience working with technical and non-technical stakeholders to understand requirements, translate business needs into data solutions, and support the accurate use of data across an organisation.
- Good understanding of data governance, data quality, privacy, and compliance considerations, with an appreciation of how these apply to reliable and responsible data use.
- Familiarity with cloud services, deployment practices, or CI/CD pipelines, such as GitHub Actions or similar.
- Collaborative and inclusive approach, able to build trusted relationships across DK, PRH, technical teams, analysts, and business stakeholders.
- Ability to take ownership of problems and follow through to delivery, balancing pace with quality, security, and long-term maintainability.
- Some experience of mentoring colleagues, contributing to technical design discussions, or reviewing the work of other data professionals is beneficial.
Skills
- Snowflake
- Python
- SQL
- dbt
- Fivetran
- Power BI
- Microsoft Fabric
- GitHub
- Cloud services
- ETL
- ELT
- CI/CD
- Data modelling
- Data governance
- Data quality
- BI data modelling
- Reporting tools
Location
- London
Work Type
- Hybrid working
- Permanent
Experience Level
- Experienced
Salary/Compensations
- £60,000-£75,000
Benefits
- Generous bonus scheme
About the Company
- Penguin Random House is committed to fostering authenticity and human creativity in its recruitment process.
- As a Disability Confident Committed organisation, they offer interviews to candidates with a disability who meet the essential criteria for the role.
- They celebrate creativity and diverse perspectives.
Equal Opportunity
- As a Disability Confident Committed organisation, we offer interviews to candidates with a disability who meet the essential criteria for the role, and opt-in on their application form.
