Job Type Permanent Closing Date 24/10/2024 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. Location | Leeds, West Yorkshire Salary | £50,000 - £55,000 Key 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 for all 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. The Next Step Click on apply and complete your application. If you have any questions, please contact the Hiring Manager on this advert. 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. To find out more go to https://www.spw.com/careers-at-spw/rewards-and-benefits The Next Step To join a dynamic team and contribute to our mission of changing lives, click "Apply" to complete your application. 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. Schroders Personal Wealth operates under the Senior Managers and Certification Regime as a solo-regulated firm and if this role is classed as a Certified Role under that regime you will be subject to enhanced vetting and will have a number of additional conduct and regulatory duties to adhere to, as well as certifying at least annually that you are fit and proper to perform this role.