Data Architect / BI Architect in London

Job DescriptionWe have a new opportunity for an experienced Data Architect to join our Technology team here at Penguin. This role is offered on a permanent basis with hybrid working from our office in Embassy Gardens, London. This role will play a key part in the continued development of our new end-to-end cloud data platform, helping us to ensure that our data architecture and platform strategy remain closely aligned with the needs of the business and the value we want to create. Working closely with the Product Manager, Data Platform and Lead Data Engineer, you'll use your data management and architecture expertise to design robust, scalable data foundations and structures that support clearly defined business outcomes. You'll help to translate product priorities, epics and user stories into practical architectural designs that can be delivered by our Data Engineering team, whilst supporting our broader move towards a Dev/DataOps culture and a more product-led approach to data. Design robust, scalable data pipelines and architecture to bring together internal and external data sources within our cloud data platform. Develop the architecture and migration approach for moving legacy data into Snowflake, whilst supporting appropriate data lake and transformed data layers. Embed security, quality, performance and scalability into the design of our data environments, ensuring they can be used confidently by analysts and decision makers. Ensure the data architecture supports our Power BI reporting and analytics capability, as well as wider analytical and business intelligence needs. Set the technical direction for data architecture, ensuring it remains aligned with our wider data strategy, platform roadmap and business priorities. Support strong data governance by ensuring data structures align with agreed policies, are appropriately catalogued and enable secure and compliant use of first and third-party data. Partner with data science and analytics teams to design environments and structures that support advanced analytics, machine learning and AI use cases. Stay connected to developments across the data industry, identifying opportunities to improve the platform, increase efficiency and support new business outcomes. Extensive experience architecting cloud-based data engineering, BI and data science solutions. Experience with dbt for transforming, modelling, testing and documenting data within a modern data platform. Strong experience designing scalable data models and schemas for a range of structured and unstructured data, including transactional, web analytics, CRM and marketing data. Expert knowledge of data modelling and data structures, with the ability to select the right approach for different business and technical use cases. Very strong SQL skills, alongside technical experience of database technologies including PostgreSQL, SQL Server and Data Vault. Experience designing both code-based and tool-based solutions for data ingestion and storage, with the judgement to understand when each approach offers the greatest benefit. Experience migrating and refactoring legacy data solutions and physical environments into cloud-based platforms, including identifying and managing the challenges and opportunities involved. Experience designing data structures that enable the appropriate use of first and third-party data whilst supporting GDPR requirements. The ability to work closely with engineering teams to design and build complex data environments, proactively addressing data issues as they arise. Experience with AWS Functions and related cloud technologies. We would encourage you to apply as soon as possible. This helps us get a true sense of who you are and what you might bring to our team. While we recognise AI tools can be helpful, we recommend using them thoughtfully to ensure your responses reflect you. Disability Confident 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. Salary The salary for this opportunity is up to 65,000 depending on how your skills and experience align to the role, plus a generous bonus scheme and benefits. Hybrid workingWhile our offices across the UK are places to connect, collaborate and celebrate with colleagues, we recognise that flexibility around where you work is just as important. For this role we expect that you will work from our head office in Embassy Gardens, London a minimum of 2 days per week (Tuesday & Thursday) with additional days for team meetings, townhalls etc as required. There may also be occasional travel to our warehouse site in Frating, Colchester. Additional InformationDisclosure requirements pertaining to the collection of your personal data: Responsible for processing the information provided in your application is the company specified in the job advertisement, with its registered office as indicated. The company processes your data for the purpose of establishing an employment relationship on the basis of Art. The retention period for your data is determined by the statutory time limits applicable in the respective country, beginning upon completion of the recruitment process. You can contact the company's Data Protection Officer at the above-mentioned postal address. Further information on data protection and your rights can be found here.