Principal Data Engineer - Temporary Contract

Principal Data Engineer - Temporary Contract

Posted 1 day ago by Schroders

Negotiable
Undetermined
Undetermined
London, England, United Kingdom

Summary: The Principal Data Engineer role at Schroders focuses on leveraging data-driven insights to enhance business processes and reporting solutions. The position requires collaboration with stakeholders to implement end-to-end analytics solutions while adhering to security and quality standards. The ideal candidate will possess extensive experience in multi-cloud data engineering and a strong understanding of data visualization and analytics. This role is integral to supporting the organization's strategic decision-making through effective data management and reporting.

Key Responsibilities:

  • Collaborate with stakeholders to understand business processes and reporting needs.
  • Design, build, and maintain scalable data pipelines using ETL/ELT methodologies.
  • Create advanced data visualizations and dashboards using Power BI.
  • Develop robust semantic models for reporting and analytics initiatives.
  • Implement Data Mesh architectures and deliver self-service data products.
  • Optimize T-SQL queries and manage large-scale datasets.
  • Design data solutions using Snowflake, Azure, and Microsoft Fabric.
  • Ensure data security and compliance within the data estate.
  • Contribute to Agile development practices within Scrum or Kanban teams.
  • Translate complex data insights into actionable narratives for business audiences.

Key Skills:

  • Experience in end-to-end data engineering and scalable data pipeline development.
  • Proficiency in Power BI and advanced data visualization techniques.
  • Strong skills in data analysis, dimensional modeling, and semantic model development.
  • Understanding of Data Mesh architectures and self-service data products.
  • Expertise in T-SQL, database development, and query optimization.
  • Hands-on experience with Snowflake, Azure, and Microsoft Fabric.
  • Knowledge of software development lifecycle and CI/CD pipelines.
  • Comprehensive understanding of data security and governance.
  • Business knowledge in financial investment services.
  • Experience with Microsoft Power Platform components.
  • Ability to work in Agile environments and contribute to iterative development.
  • Strong communication skills and ability to convey technical issues to non-technical stakeholders.

Salary (Rate): undetermined

City: London

Country: United Kingdom

Working Arrangements: undetermined

IR35 Status: undetermined

Seniority Level: undetermined

Industry: Other

Detailed Description From Employer:

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.