Data Engineer

Job Description

Data Engineer - Hybrid (1-2 days Leeds City Centre) - up to £51k + benefitsHead resourcing are recruiting on behalf of our client Schroders Personal Wealth (SPW) who are a dynamic new company in the financial advice market who have a brilliant range of roles available across the IT space.About SPW:Schroders Personal Wealth aims to improve the way financial advice is offered, by making it more affordable, accessible and powerful for more people. We want to change lives for the better.Schroders Personal Wealth aims to improve the way financial advice is offered, by making it more affordable, accessible and powerful for more people. We want to change lives for the better.An exciting opportunity has arisen to join the Schroders Personal Wealth (SPW) Data Engineering team, based in Leeds city centre (hybrid). The role will be critical in delivering the Technology strategy for SPW, ensuring data quality, consistency, and reliability.Delivering this strategy will also provide ample development opportunities, in particular progressing our new Data Lakehouse and implementing an iPaaS solution throughout 2024.Working with Python, SQL, AWS and PowerBI, you will build, rebuild and maintain data pipelines as well as have the opportunity to work with Terraform and shape the role and your progressionLocation | Leeds, West YorkshireSalary | £47,272 - £51,000Key Responsibilities:

• Maintenance of existing data pipelines; pre-empting issues and responding to any incidents in a timely, professional manner.
• Development of new pipelines as per business requests or to stabilise the current operating environment.
• Liaising with other areas across the business to help define requirements for new projects, including both pipeline and ETL requests.
• Implementing and owning the monitoring on key processes.

Core Skills/Competencies

• Languages - Expert in SQL (Postgres, Athena Presto SQL) and proficient in using Python to build, maintain and orchestrate data pipelines across the business.
• Amazon AWS - Experience using a serverless approach primarily utilising Lambda Functions, Glue (Jobs, Crawlers, Catalogues), Step Functions, SNS (notifications), SQS (queue service) and S3 (object storage).
• Data Engineering - Demonstrable experience (> 2 years) working within a Data Engineering function, building data pipelines in a cloud native environment with an in-depth understanding of best practice.
• Communication skills - Able to communicate and engage with the business in a non-technical way to gather/replay requirements and ensure successful and timely delivery.
• Documentation and deployment - Experience delivering in a controlled manner ensuring changes are tested, approved and deployed in accordance with agreed business protocols (GitHub). Documentation should be clear and easy to understand forall audiences (technical and non-technical).

Preferable but not essential

• Infrastructure as Code (IAC) - Experience with Terraform (new/future infrastructure) and experience with CloudFormation (legacy infrastructure).
• Integration Platform as a Service (iPaaS) - Any experience working with an iPaaS would be preferable, particularly MuleSoft.

We understand not everyone will meet 100% of the requirements, however we encourage you to apply if you think your skills are a good fit for this role.You belong here…At Schroders Personal Wealth, we embrace individuality and encourage diversity of identity, experience, and thought.We actively strive for inclusive behaviours and actions across our company and our work, including making appropriate adjustments for disabilities, long-term health conditions or neurodiversities to ensure equal opportunities for all.We understand not everyone will meet 100% of the requirements, however we encourage you to apply if you think your skills are a good fit for this role.The Benefits and Perks...In addition to a competitive salary, we offer these enticing benefits to employees:Generous Holiday Entitlement: Enjoy 30 days of annual leave plus bank holidays, with the option to purchase 5 additional days.Company Pension Contribution: A matched pension contribution of up to 15% of your base pay if you contribute 6%.Additional Cash Allowance: Receive an extra 4% cash allowance that can fund various optional benefits, including Paid Sabbatical Leave, Dental Cover, Critical Illness Insurance, Gym Membership, or an electric/ULEV car.Health & Wellbeing: We offer company-paid Private Medical Insurance, Life Insurance, and Health Screening.Financial Advice: Access to free financial advice to help secure your financial future.Car Allowance: Up to £9,000 annually if your role demands over 10,000 business miles a year.Annual Bonus: Eligible after 3 months service, based on company/individual performance.If this opportunity sounds of interest and you would like more information, please apply with an up-to-date CV.Candidates of all ages and backgrounds will be considered for this role. Head Resourcing is acting as an Employment Agency