Job Description
Who we are 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 and implement end to end reporting & analytics solutions applying the latest enterprise engineering practices ensuring security, performance, and quality standards.
About Schroders
We are 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 have been around for over 200 years but keep adapting as society and technology changes. What does not 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 are 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 Data Analytics & Visualisation team within the Business Platforms function. 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.
What You Will Do
As part of the firm’s strategy to streamline reporting and analytics processes across the organisation, we are looking for a Data and Analytics 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
* End-to-End Data Engineering: Demonstrable experience in designing, building, and maintaining scalable data pipelines, employing robust ETL/ELT methodologies and best practices.
* Power BI & Data Visualisation Expertise: Proven ability to design and deliver advanced, dynamic data visualisations using Power BI, including complex DAX, Power Query (M), and the development of enterprise-level dashboards and reports using both Direct Query and Import Mode
* Data Modelling & Analytics: Highly proficient in data analysis and dimensional modelling; adept at developing robust semantic models to underpin reporting and analytics initiatives.
* Data Mesh & Data Products: Strong conceptual understanding of Data Mesh architectures and the delivery of consumable, self-service data products.
* T-SQL Mastery: Expert in T-SQL, including database development, query optimisation, performance tuning, and handling large-scale, complex datasets.
* Modern Data Platforms and Cloud Engineering: Deep hands-on experience designing and delivering data solutions with Snowflake, Azure and Microsoft Fabric at the core. Proficient in building and integrating scalable data environments across multi-cloud platforms, using tools such as dbt, Airflow, and Python. Skilled in connecting these platforms with Power BI to deliver high-impact analytics, with a focus on performance, security, and governance.
* Software Development Lifecycle: Deep understanding of the software development lifecycle for data solutions, including CI/CD pipelines, and experience with Azure DevOps, SSDT, and GitHub.
* Data Security: Comprehensive understanding of security model design and implementation within the data estate, including data governance, access controls, and compliance requirements.
* Financial Services Domain Knowledge: Business knowledge in financial investment services and previous experience in financial services is advantageous.
* Power Platform Experience: Exposure to or experience with other components of the Microsoft Power Platform (Power Automate, Power Apps) is advantageous.
* Agile Working Practices: Comfortable working in Agile environments, contributing to iterative development within Scrum or Kanban teams.
* Data Quality: Practical knowledge of data quality frameworks, including “shift left” practices to ensure data quality is embedded early in the data lifecycle.
* Data Storytelling: Strong capability to translate complex data and analytics into clear, compelling narratives and actionable insights tailored to diverse business audiences, enabling strategic decision-making.
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
* Very open and pro-active in knowledge sharing, always helping team members grow and improve their skills
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.