Data Engineer – Snowflake
Apply now, read the job details by scrolling down Double check you have the necessary skills before sending an application.
We are seeking an experienced Data Engineer with strong expertise in Snowflake, data analysis and data architecture to join our Data Services team and play a key role in delivering our Reporting & Analytics programme.
This is an exciting opportunity to help shape and develop an enterprise data platform, ensuring high-quality, reliable and accessible data supports business reporting and analytics across the organisation.
The Role
As a Data Engineer, you will be responsible for designing, developing and maintaining the enterprise data platform, with a particular focus on Snowflake. You will work across data architecture, engineering and analysis, ensuring data flows seamlessly from source systems into Snowflake and ultimately into the Power BI reporting layer.
You will help define the right data architecture, validate existing system designs and implementations, and build robust, scalable data pipelines and transformation processes.
Key Responsibilities
- Analyse existing datasets and data structures to help prioritise, design and implement the enterprise data platform.
- Design and implement dimensional data models within Snowflake to support enterprise reporting and analytics.
- Build and maintain production-grade data transformation workflows using robust development, testing, version control and documentation practices.
- Develop and optimise Snowflake environments, including warehouse configuration, query performance and cost efficiency.
- Develop and manage data pipelines using Azure Data Factory (ADF) to ingest data from a range of source systems.
- Automate, monitor and troubleshoot data loads to ensure data is available accurately and on time.
- Implement and manage Role-Based Access Control (RBAC) and data masking policies within Snowflake to protect sensitive business and client data.
- Contribute to data engineering standards, naming conventions, development practices and CI/CD processes. xwwtmva
- Support data analysis, data architecture and enterprise data modelling activities across existing and new data platforms.
- Work closely with technical and business stakeholders to understand requirements and translate t...