Engineering Lead - Data Engineering - Schroders
14 hours ago
London
Job Description Who we're looking for The Engineering Lead is a highly proficient, versatile, and active engineer with excellent communication skills. The Engineering Lead works across one or more Engineering delivery teams to deliver high-quality data, quickly and reliably. The Engineering Lead also strives to create a collaborative engineering culture. This role requires a high level of competence and up-to-date knowledge on design and best practice in data engineering. The Engineering Lead's responsibilities and objectives are broadly split into two areas: • Within their area, the Engineering Lead will focus on the continued improvement of data design, implementation, and delivery. This will be achieved by ensuring that sustainable engineering practices are prioritised and embedded in the way teams work. As an expert in their data development field, the Engineering Lead will guide and mentor developers (including 3rd party partners), setting technical objectives and reviewing subsequent performance., • The Engineering Lead will work collaboratively with both Enterprise Engineering and Enterprise Software Engineering to help shape the development culture at Schroders, contributing to standards, patterns, practices, reference architectures, shared components, and other things that will improve the way we deliver engineering and software to the business. About Schroders We're a global investment manager. We help institutions, intermediaries and individuals around the world invest money to meet their goals, fulfil their ambitions, and prepare for the future. We have around 5,000 people on six continents. And we've been around for over 200 years, but keep adapting as society and technology changes. What doesn't change is our commitment to helping our clients, and society, prosper. Technology at Schroders There's a huge amount of change going on at Schroders. Technology's shaping our business more and more, so there are many opportunities waiting to be grabbed. And because we're a big financial player, we can put hefty backing behind good ideas. We're a serious business - we have enormous responsibilities to our clients and shareholders. But just because we're suited and booted, that doesn't make us stuffy; our tech teams are friendlier and more informal than you might expect. The base We moved into our new HQ in the City of London in 2018. We're close to our clients, in the heart of the UK's financial centre. And we have everything we need to work flexibly. The team The Engineering Lead for Data Engineering will be the technical expert in one of the key teams within the Enterprise Data function. Working along-side a Delivery Lead, the role will determine the technical direction of the team and its technical staff. This function exists to drive the way Schroders sources and consumes high-quality data to provide business value. Enterprise Data own the creation of the enterprise-wide data strategy and rely on the Engineering teams to help to deliver on our plans. The Data Engineering team also own the Data Engineering for the associated acquisition and integration of enterprise data assets and the analytics service that will consume the foundational components. Engineering Leads also form part of the broader Enterprise Engineering function within Enterprise Technology. This function exists to help Schroders improve the way they provide business value through quality, predictable, and supportable software delivery. What you'll do You'll lead the team technically to help deliver data sources and data capabilities (that is: tools, data sources and data products that enable business teams to find, create and exploit data) across a wide range of technologies and stakeholders. This is a hands-on role, where you'll be partnering closely with both business subject matter experts and technology counterparts to deliver data solutions collaboratively, and you will lead the way in creating re-usable patterns and templates for the team to leverage, but this is not purely a technical role. You'll also be a people manager, who enjoys being a mentor and can convey complex ideas in a way that helps your Engineering reports learn and grow. Working as part of different backlog - focused squads, you'll be responsible for contributing to analysis and owning solution designs, as well as the implementation and testing of data pipelines. You'll need to be comfortable with agile methodology, either scrum or Kanban, having worked in teams that use this approach before. Snowflake experience is essential to hit the ground running in our team, and any Snowflake certifications would be advantageous. Experience in Airflow, Docker/Kubernetes or DBT will also be highly desirable, especially if you have experience in using them to build data ingestion processes or any aspect of data warehousing/Data Product building. As a team, we support each other in our personal development knowing that each has their strengths, and we work to share those throughout the team. We also highly value innovation and are beginning to implement AI / ML in our data platform to expand our data services and automate our workloads. We hope you'll have something to offer and something to gain in return. The knowledge, experience and qualifications you need • Experience of cloud technologies, ideally in Azure and AWS., • Excellent Python skills, specifically within data engineering in a commercial setting, • Excellent SQL / Snow SQL knowledge, including an understanding of how to write optimised SQL code, good general knowledge of different SQL engines, and what considerations they bring when optimising., • Practical understanding of how to profile SQL and manage performance trade-offs., • Good working knowledge of agile methodology, and capable of following the framework, contributing to team success through participation in ceremonies and occasionally assisting with scrum-master duties, own actions and maintaining scrum artefacts., • Experience of implementing a data quality framework, • Highly knowledgeable in how to build data pipelines that robustly handle different possible modes of failure., • Excellent understanding of ETL/ELT patterns, idempotency and other data engineering best practices, that you can share with more junior team members, • Demonstratable competency with data modelling (3rd normal form, star schemas, wide/tall projections). Any experience of Data Mesh implementation would be advantageous., • Good knowledge of source control (GitHub especially) and working on a shared codebase., • Strong background and up-to-date knowledge of cloud-based data platform technologies such as Snowflake, AWS and Azure, • AI coding experience, especially in the data or automation space What you'll be like, • Friendly, approachable and a collaborative team player who enjoys working with people across the business and can act as a mentor to more junior colleagues when required., • Having a continuous improvement mind-set, always thoughtful about the status quo, and making sure that standard approaches continue to make practical sense., • Self-motivated, someone who shows initiative often and is keen to help the team improve engineering processes across Schroders., • A continuous learner - always willing to spend time learning and developing your technical skills on our current tool suite and related disciplines such as data modelling and architecture., • A problem solver, comfortable analysing, breaking down and ultimately resolving complex and sometimes ambiguous requirements., • Down-to-earth, honest and straightforward, you'll be able to stand your ground and communicate apposing ideas, without being confrontational We recognise potential, whoever you are Our purpose is to provide excellent investment performance to clients through active management. Diversity of thought facilitated by an inclusive culture will allow us to make better decisions and better achieve our purpose. This is why inclusion and diversity are a strategic priority for us and why we are an equal opportunities employer: you are welcome here regardless of your age, disability, gender identity, religious beliefs, sexual orientation, socio-economic background or any other protected characteristics About Us We're a global investment manager. We help institutions, intermediaries and individuals around the world invest money to meet their goals, fulfil their ambitions, and prepare for the future. We have around 6,000 people on six continents. And we've been around for over 200 years, but keep adapting as society and technology changes. What doesn't change is our commitment to helping our clients, and society, prosper.