DevOps + Snowflake Engineer - 6 months (Outside IR35) - London (1 day pw)
Daily Rate: £500 to £600
We are looking to appoint a DevOps + Snowflake engineer to support the definition and delivery of an enterprise data platform with engineering best practices. Specifically, this role will help the divisional data team (DDT) to understand, manage, and prioritise DevOps activities and administration of the data warehouse.
The role is reporting to the AVP Data engineering, who is responsible for prioritising, planning, and driving forward the data engineering and transformation tasks required.
Core Responsibilities
The combined role demands expertise in both traditional database administration and modern DevOps principles:
* Security and Compliance:
Implementing and managing security measures like role-based access control (RBAC), user authentication (SSO, MFA), data encryption, and data masking to enforce security policies and compliance standards.
* Automation and CI/CD:
Automating routine administrative tasks and building/maintaining CI/CD pipelines (using tools like Azure DevOps, or GitHub) for reliable and automated deployment of Snowflake SQL scripts and stored procedures.
* Monitoring and Troubleshooting:
Setting up and managing monitoring and alerting systems to track platform health and performance, and serving as the first point of contact for troubleshooting and resolving pipeline issues and operational incidents. Keeping artefactory certificates updated and solving snyk scanner/SonarQube issues. Understand networking issues is also a plus.
* Collaboration:
Acting as a liaison between data engineering and networking teams to solve issues in the pipeline
* Platform Administration:
Administering the Snowflake platform across different environments (development, test, production), including managing accounts, warehouses, databases, schemas, and other database objects. Managing secrets, RBAC (role hierarchy), Database change management and reporting role needs.
* Performance and Cost Optimization:
Monitoring system performance, optimizing query performance, managing warehouse sizes, and proactively controlling credit usage and storage costs to ensure efficiency.
Technologies
* Azure DevOps (or any other CI/CD pipeline technology)
* SQL
* Snowflake
* DBT
* DCM tech