GCP Data Engineer

Job Description

End dateMonday 30 October 2023Salary range£45,054 - £50,060Agile Working OptionsHybrid WorkingJob descriptionJOB TITLE: Data EngineeringLOCATION’S: Bristol, Halifax, Leeds, EdinburghHOURS: Full timeWORKING PATTERN: Hybrid, 40% (or two days) in an office siteAbout this opportunityThis position will play a critical role in designing, developing, and maintaining robust data pipelines and infrastructure within P&P Data Hub for the purposes of insight as well as supporting enterprise processes. By leveraging Google Cloud native products,the role aims to enable efficient data integration, transformation, and analysis, empowering evidence-based HR decision-making and enhancing workforce management strategies.About usIf you think all banks are the same, you’d be wrong. We’re an innovative, fast-changing business that’s shaping finance as a force for good. A bank that’s empowering its people to innovate, explore possibilities and grow with purpose.What you’ll need

• Data Pipeline Architecture: Design, build, and maintain scalable and efficient data pipelines that facilitate the seamless flow of HR data from various sources to data warehouses and analytical platforms.
• Data Transformation: Develop ETL (Extract, Transform, Load) processes to cleanse, transform, and enrich raw HR data, ensuring data accuracy and quality.
• Database Management: Administer and optimise data storage and database systems, ensuring high performance, availability, and security of HR data.
• Data Modelling: Create and manage data models that support HR analytics and reporting requirements, ensuring data consistency and usability.
• Google Cloud Solutions: Utilise Google Cloud native products (e.g., BigQuery, Dataproc, Dataflow) to build data engineering solutions that align with the banks technology strategy.
• Quality Assurance: Implement data quality checks, validation processes, and data lineage to ensure accuracy and reliability of HR data.
• Automation: Implement automation techniques for data pipeline orchestration, data loading, and monitoring.

More about the role

• Collaborate with HR stakeholders and other members of the P&P data hub to understand data requirements and translate them into technical data engineering solutions.
• Build and maintain ETL pipelines using Google Cloud Dataflow or similar tools to extract and transform HR data.
• Develop and optimise SQL queries for data retrieval, transformation, and aggregation within Google BigQuery.
• Create and maintain data integration workflows using Google Cloud native technologies for real-time data updates.
• Monitor and troubleshoot data pipeline performance issues, ensuring timely resolution.
• Design and implement data governance practices, including data cataloguing and lineage documentation.
• Collaborate with data scientists and data vis teams provide them with clean, reliable, and accessible data for analysis.

About working for usOur focus is to ensure were inclusive every day, building an organisation that reflects modern society and celebrates diversity in all its forms.We want our people to feel that they belong and can be their best, regardless of background, identity or culture.We were one of the first major organisations to set goals on diversity in senior roles, create a menopause health package, and a dedicated Working with Cancer initiative.And it’s why we especially welcome applications from under-represented groups.We’re disability confident. So if you’d like reasonable adjustments to be made to our recruitment processes, just let us know.We also offer a wide-ranging benefits package, which includes:

• A generous pension contribution of up to 15%
• An annual bonus award, subject to Group performance
• Share schemes including free shares
• Benefits you can adapt to your lifestyle, such as discounted shopping
• 28 days’ holiday, with bank holidays on top
• A range of wellbeing initiatives and generous parental leave policies

Want to do amazing work, that’s interesting and makes a difference to millions of people Join our journey.