Senior Data Engineer - 18 Month FTC

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.

What will you be doing?

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.

To be successful in this role, you should:

• Snowflake/Cloud Engineering experience is required:
  • Proven experience working as a Data Engineer, with expertise in Snowflake, ADF, Azure Storage, dbt and GitHub.
  • Extensive experience in designing, building, deploying, and supporting cloud-based data products and pipelines.
  • Experience with Azure Storage services such as Blob Storage, Data Lake Storage, or Azure Files.
  • 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:

• 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

As a colleague here at Evelyn Partners you will have access to benefits that include:

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

We are happy to make any reasonable adjustments to accommodate for your needs throughout the application process. Please let your Recruiter know.