Brookson

Following the acquisition of Brookson by People2.0, the responsibilities of the Data and Analytics team have significantly expanded. We are now seeking a skilled Data Engineer to join our dynamic team. As a Data Engineer within the Data and Analytics team, you will play a pivotal role in designing, maintaining, and optimising the data architecture for People2.0 Group. This architecture ensures the seamless flow of data from source systems to the Data Warehouse, providing a robust foundation of aggregated analytical base tables and operational sources. Our data architecture is critical in enabling People2.0 Group to become a data-driven organisation. Your responsibilities will include maintaining existing data pipelines, developing new branches within the architecture, and collaborating closely with stakeholders across the business. You will engage with stakeholders from various regions, including EMEA, US, and APAC, ensuring that the architecture aligns with regional and global requirements. Reporting directly to the Senior Data Engineer within the Data and Analytics team, you will work alongside internal and external stakeholders, depending on project requirements. Your ability to communicate effectively and adapt to different regions and business needs will be key to your success. This role offers an exciting opportunity to be part of a team that directly contributes to the data-driven evolution of People2.0 Group. Our Warrington office (WA1) is easily accessible by car and a 10-minute walk from the nearest train station. We offer hybrid working, with a minimum requirement of 2 days in the office and the flexibility to work from home the rest of the week. What will you be doing as Data Engineer: ETL Maintenance: Collaborating with the Senior Data Engineer to ensure that the ETL process between source systems and the Data Warehouse remains fully operational, with minimal downtime and blockages. Implementing new systems: Working with key stakeholders to integrate new systems and acquisitions into the People2.0 Data Architecture. This includes mapping fields to existing systems, evaluating master data management (MDM) opportunities, and building core data sources for end-user consumption. Building Data Marts: Working with analytical operations and business analyst to develop key data sources for business end users. This includes analytical base tables for MI, operational metrics for data integrity, Develop Native Databases: Working with the business and/or the Analytics team to build bespoke and native applications that require database structures. This includes designing, optimising and promoting it through the Development process. Improve Data Literacy: Work with the Senior Data Engineer to improve data literacy on end point architecture. Improving engagement, business buy-in and understanding of the data, thus promoting a self-serve analytical culture. What are the qualities that can help you thrive as a Data Engineer? Essential Experience and Qualifications: Strong SQL skills - Tables, Stored Procedures, performance tuning etc. Experience with Azure ETL tools - Azure data Factory / Synapse Strong experience in Data movement methodologies and standards, ELT & ETL. A self-motivated, enthusiastic problem solver, with the ability to work under pressure and prioritise workload in order to meet deadlines. Educated to degree level BSc in - for example - Computer Science, Mathematics, Engineering or other STEM A strong team player with empathy, humility and dedication to joint success and shared development. Desirable Experience and Qualifications: Experience with Databricks or Delta Lake architecture. Experience building architecture and Data Warehousing within the Microsoft Stack Experience in development Source control (e.g. Bit Bucket, Github) Experience in Low Code Analytical Tools (e.g. Alteryx) Experience in Power Platform Stack (Power BI, Power Automate) In Return for joining us as a Senior Data Engineer: Salary of £34,000 - £38,000, depending on experience 23 days annual leave, plus bank holidays Your birthday off 2 Press Pause Days (An opportunity to step back, breathe, and focus on your wellness - whatever that may look like) Hybrid working 5% company pension contribution after 3 months Access to free Financial Advice including Mortgages, and Savings Cyle2Work scheme Perkbox employee discounts Next Steps If you are interested in being considered for this opportunity, please apply with your CV highlighting your relevant skills in relation to the above criteria. Regardless of the outcome of your application, all candidates will be contacted, and we aim to do this within 3 working days.