Principal Data Engineer - 6m contract

  • Schroders
  • 1 Heathgate Place, London, UK
  • 23/05/2024
Full time Data Engineering Business Intelligence Software Engineering Data Warehouse

Job Description

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 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.

Technology at Schroders
There is a huge amount of change going on at Schroders. Technology's shaping our business increasingly, so there are many opportunities waiting to be grabbed. And because we are a big financial player, we can put hefty backing behind good ideas.
We are a serious business – we have enormous responsibilities to our clients and shareholders. But just because we are suited and booted, that does not 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 current role is within the Corporate Data & Reporting team. The team’s primary objective is to support Business Analytics Community in Schroders through Governance and Best Practice guidance for Analytics Platforms and Reporting Solutions. We empower business and tech teams across the organisation to utilize the power of data insights and business analytics to improve strategic decision making. The team is supporting the reporting requirements of core customers through providing a data platform for full service end-to-end report development or co-create collaboration.

Who we’re looking for
We are looking for a person who is passionate about the possibilities of data-driven culture and the advantages that organisations adopting data-driven learning can have in this rapidly changing market environment. The primary focus of the Principal Data Engineer role is collaborating with stakeholders on various levels to gain a deep understanding of existing business processes and needs, identify key measures to provide meaningful insight into the various aspects of the business. The individual will be required to implement end to end reporting & analytics solutions applying the latest enterprise engineering practices ensuring security, performance, and quality standards.

What you’ll do
As part of the firm’s strategy to drive the adoption of Microsoft Power platform and streamline reporting and analytics processes across the organisation, we are looking for a Data Engineer with extensive multi-cloud data engineering experience and in-depth understanding of end-to-end development and deployment processes. The role provides a good balance of creativity and structure for somebody passionate about data.

The knowledge, experience and qualifications you need

  • Highly skilled in data analysis, data modelling and designing ETL processes;
  • Understanding the concepts of Data Mesh architecture and Data Products;
  • Expert at T-SQL with experience in performance tuning and dealing with large data volumes;
  • Good understanding on concepts of enterprise big data architecture;
  • Extensive experience of developing end-to-end reporting and analytics solutions. This includes Azure Synapse, Azure SQL Database, SSAS, Power Query / DAX, Power BI;
  • Knowledge of Azure platform including Data Lakes, Data Warehouse, Azure Data Factory;
  • Experience and good understanding of the full Software Development Lifecycle, including the use of Azure Dev Ops, Visual Studio (SSDT) for continuous integration and deployment;
  • Good level of understanding the differences in the approach for building self-service BI (business or IT managed) vs Corporate BI solutions including the choice of data sources and ETL approach;
  • Understanding security model designs within the data estate;
  • Business knowledge in the financial Investment services;
  • Experience of working in the Financial Industry is beneficial;
  • Understanding engineering processes for developing APIs;
  • Understanding of principles of building solutions using Snowflake, open-source frameworks, multi-cloud infrastructure;
  • Experience of implementation of other Power Platform solutions (Power Automate, Power Apps) is an advantage;
  • Experience of Agile working practices and
  • Understanding of Data Quality approaches such as shift left.

What you’ll be like

  • Personable, credible, with excellent communication skills, experienced in the consultative style necessary to gain the trust and cooperation of non-team members and senior staff;
  • Must have excellent attention to detail and ability to keep the bigger context and strategic vision in mind;
  • Ability to translate complicated technical data issues into business implications and impact to brief data owners and stakeholders;
  • Passionate, keen and energetic with demonstrable enthusiasm and commitment;
  • Receptive to others'ideas and responds constructively to challenges;
  • Be a change ambassador open to collaboration on all levels with a creative approach to each problem;
  • Able to easily adapt to changing environments and continue to deliver value and
  • Very open and pro-active in knowledge sharing, always helping team members grow and improve their skills.

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 characteristic.