Senior Data Engineer - 18 Month FTC

Evelyn Partners

Bracknell

Hybrid

GBP 75,000 - 110,000

Full time

10 days ago

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Benefits offered by this job

Competitive salary
Private medical insurance
Life assurance
Pension contribution
Hybrid working model
Generous holiday package
Option to purchase additional holiday
Shared parental leave

Job summary

Evelyn Partners seeks a Senior Data Engineer to design, develop, and maintain their Snowflake-based data warehouses and Azure Data Factory pipelines. You will contribute to the Evelyn Data Platform, support regulatory reporting, BI needs, and system integrations in an agile team.

The role requires strong SQL and ETL/ELT skills, experience with Snowflake, ADF, Azure Storage, and dbt, and collaboration with analysts and data scientists. Hybrid work is available.

Qualifications

  • Proven Data Engineer with Snowflake, ADF, Azure Storage, dbt, GitHub.
  • Experience designing cloud data products and pipelines.
  • Hands-on with Azure Blob Storage/Data Lake Storage.
  • Snowflake SQL programming, stored procedures, functions.
  • Strong SQL, ETL/ELT development.

Responsibilities

  • Design, develop, and implement data warehouse solutions using Snowflake and Azure.
  • Use Astronomer for orchestration of the data warehouse processing.
  • Develop data models and database schemas that support reporting and analytics needs.
  • Extensive use of and fully conversant in SQL.
  • Create and maintain ETL/ELT processes for data integration into data platforms.
  • Develop and deploy ADF pipelines and manage pipeline performance.

Skills

Snowflake
Azure Data Factory
dbt
GitHub
Azure Storage
SQL
Python
Java
Spark
C#
Power BI

Tools

Snowflake
Azure Data Factory

Job description

We're seeking a talented individual to join a growing team in Bracknell on an 18 month FTC, which is responsible for designing, developing, and maintaining our Snowflake Data Warehouses and associated data feeds into and out of the warehouses. As such, experience in Snowflake and Azure Data Factory is essential. We use our data platforms to support regulatory requirements, business intelligence & reporting needs as well as numerous system integrations. This role requires strong technical proficiency and a deep understanding of data engineering and data warehousing principles and practices. You will be critical in the development and support of the Evelyn Data Platform, which has been recently migrated to Snowflake, utilising Azure Data Factory pipelines for data integration, Azure blob storage for data storage, Astronomer for orchestration and GitHub for version control and collaboration. You will be working in an agile and collaborative environment within a growing and skilled team. An understanding of the wealth management industry, including products & services and the associated data, is a plus. As Senior Data Engineer, your responsibilities will include among others:

  • Design, develop, and implement data warehouse solutions using Snowflake and Azure.
  • Use of Astronomer for orchestration of the data warehouse processing.
  • Develop data models and database schemas that support reporting and analytics needs.
  • Extensive use of and fully conversant in SQL.
  • Experience working with programming languages like C#, Python, Java, Spark.
  • Create and maintain ETL/ELT processes to extract, transform, and load data from various sources into the data platforms.
  • Design, develop, and deploy ADF pipelines.
  • Manage and troubleshoot ADF pipelines, ensuring data integrity and error handling is robust.
  • Creation and maintenance of complex SQL stored procedures.
  • Integrate data from various sources, including flat files, REST/SOAP APIs, and third-party databases, into the data warehouse/platform.
  • Develop and maintain complex stored procedures, views, and functions in SQL to support data integration and reporting needs.
  • Collaborate with business analysts, data scientists, and other stakeholders to understand data requirements and deliver solutions.
  • Consideration for data warehouse/platform performance
  • Support the development of reports and dashboards using tools like Power BI
  • Provide ad-hoc queries and data extracts to support business needs.
  • Work closely with other engineers, DBAs, and Tech staff to ensure seamless data integration and system compatibility.
  • Document data warehouse architecture, ETL processes, and database configurations.
  • Maintain effective relationships with stakeholders and ensure communication is effective and timely.
  • Provide time estimates for work so stakeholder expectations and resources can be managed.
  • Collaborate with stakeholders to understand business requirements and translate them into technical specifications for data engineering solutions.
  • Continuously improve processes and codebases.
  • Design and deliver data warehousing solutions and key data engineering workstreams for any required solution.
  • Stay up to date with the latest trends, technologies, and best practices in data engineering.
Key Requirements
  • + Snowflake/Cloud Engineering experience is required:
  • o Proven experience working as a Data Engineer, with expertise in Snowflake, ADF, Azure Storage, dbt and GitHub.
  • o Extensive experience in designing, building, deploying, and supporting cloud-based data products and pipelines.
  • o Experience with Azure Storage services such as Blob Storage, Data Lake Storage, or Azure Files.
  • o Hands‑on experience designing and developing data pipelines using Azure Data Factory.
  • + Proven experience building data pipelines in Azure Data Factory and Snowflake and extensive experience with Azure Data Factory and GitHub, for ETL development
  • + Advanced capability with Snowflake, including Snowflake SQL programming, stored procedures, and functions
  • + Solid understanding of data warehousing concepts, including star/snowflake schemas, dimensional modelling, and data vault 2.0, and of the principles of ETL technical design
  • + Ability to write efficient and optimized SQL queries for data retrieval and manipulation
  • + Experience of data warehouse design and implementation using Snowflake and dbt modelling
Desired Qualifications
  • + SnowPro and Microsoft Cloud certifications - SnowPro Core, SnowPro Advanced: Data Engineer, Azure Data Fundamentals and Azure Data Engineer Associate
  • + Experience with Snowflake Cortex AI and/or Azure AI Services would be a plus
  • + Familiarity with data visualization tools such as Power BI is desirable
  • + Experience with DevOps practices is an advantage

Evelyn Partners (now a part of Natwest) is a UK leader in wealth management, providing personalised, expert investment management and financial planning advice to support clients in embracing what's next. Our success hinges on our people and that's our secret for longevity. We are a team of passionate professionals and everything we do is guided by our purpose - placing the power of good advice into more hands, we go further to understand the needs of our clients and what matters most to them. We're here to help them make significant decisions with confidence, provide strong foundations for the future and guide them towards their goals.

Benefits
  • + Competitive salary
  • + Private medical insurance
  • + Life assurance
  • + Pension contribution
  • + Hybrid working model (role dependant)
  • + Generous holiday package
  • + Option to purchase additional holiday
  • + Shared parental leave

We are proud to value the differences that a diverse workforce brings, representative of society and our clients. At Evelyn Partners we have a wide range of highly active employee resource groups and we're delivering multiple diversity, equity and inclusion initiatives across the organisation. It is our commitment to provide a workspace where all colleagues, regardless of identity, background, or circumstance, feel respected as individuals and feel that they can achieve their full potential and work in a safe, supportive, and inclusive environment.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Associate Investment Strategy - 12 Month Ftc
Associate Investment Strategy - 12 Month Ftc

Evelyn Partners • Greater London

Hybrid
GBP 50,000 - 70,000
Competitive salary
Private medical insurance
Life assurance
+5
Associate Investment Strategy - 12 Month FTC
Associate Investment Strategy - 12 Month FTC

Evelyn Partners • City of Westminster

Hybrid
GBP 32,000 - 52,000
Competitive salary
Private medical insurance
Life assurance
+5
Senior Data Engineer
Senior Data Engineer

EC Markets LTD • Greater London

Hybrid
GBP 90,000 - 130,000
Private Medical Insurance
Group Income Protection
Cycle to Work
+3
Associate Director Investment Management
Associate Director Investment Management

Evelyn Partners • Greater London

Hybrid
GBP 90,000 - 130,000
Private medical insurance
Life assurance
Pension contribution
+3
Financial Planning Client Administrator
Financial Planning Client Administrator

SW Group • Bracknell

Hybrid
GBP 26,000 - 32,000
Competitive salary
Life assurance
Pension contributions
+4
Senior Snowflake Consultant - Data & AI Engineering
Senior Snowflake Consultant - Data & AI Engineering

EPAM Systems Ltd • Greater London

On-site
GBP 90,000 - 135,000
EPAM Employee Stock Purchase Plan (ESR
Life assurance and income protection
Private medical insurance and dental
+8
Senior Data Engineer
Senior Data Engineer

EC Markets LTD • City Of London

Hybrid
GBP 90,000 - 130,000
Private Medical Insurance
Group Income Protection
Cycle to Work
+3
Financial Planning Client Administrator
Financial Planning Client Administrator

Evelyn Partners • Bracknell

Hybrid
GBP 23,000 - 32,000
Competitive salary
Life assurance
Pension contribution
+4
IFA Client Administrator
IFA Client Administrator

Evelyn Partners • Birmingham

On-site
GBP 25,000 - 35,000
Private medical insurance
Life assurance
Pension contribution
+3
Senior Data Engineer - 3m FTC
Senior Data Engineer - 3m FTC

Novatus • Greater London

On-site
GBP 70,000 - 110,000
Private Medical Insurance (AXA)
Life Insurance - 4× salary
Unum’s Help@Hand
+12