Senior Snowflake Engineer (Lead I - Data Engineering)

Role description

Job Title: Senior Snowflake Engineer

Location: [London/ UK – Hybrid, 3 days work from client office]

Employment Type: [Permanent/FTC / Contract inside IR35]

Immediate Candidates preferred

Applicants must be legally authorized to work in the United Kingdom without the need for current or future visa sponsorship

Job Summary:

We are seeking a skilled Senior Snowflake Engineer to join our client's Platform Engineering

team. As the Senior Snowflake Engineer, you will lead the architecture, design, and implementation of Snowflake for various domain teams in a multi-tenant environment. You will ensure that the platform meets the needs of multiple teams while maintaining high levels of performance, reliability, and security.

Responsibilities:

As a Senior Snowflake Engineer, you will:

Play a key role in modernizing an enterprise data function following a decentralized approach

breaking silos.

Work closely with domain teams to understand their needs and translate them into technology solutions.

Provide expertise as a technical resource to solve complex business issues that translate into

data integration and database systems designs.

Problem-solve to resolve issues and remove barriers throughout the lifecycle of domain team

engagements.

Ensure all deliverables are of high quality by setting development standards, adhering to the

standards, and participating in code reviews.

Participate in integrated validation and analysis sessions of components and subsystems on

production servers.

Mentor, support, and manage team members.

Create runtime tools/processes that optimize cloud triaging and limit downtime.

Define best practices around making our systems and services measurable.

Participate in on-call rotation and ensure uptime of services.

Introduce tools to facilitate greater automation and operability of services.

Our Ideal Senior Snowflake Engineer will have:

Experience in the implementation, execution, and maintenance of Data Integration technology solutions.

Experience advancing and supporting information management practices within business

processes, applications, and technology that underpin the data discipline (e.g. establishing data quality processes, performing data analysis, participating in technology implementation

planning, implementing data integration processes, etc.).

Expertise in Snowflake data modeling, ELT using snowpipe, implementing stored procedures,

and standard DWH and ETL concepts.

Expertise in Snowflake concepts like setting up resource monitors, RBAC controls, virtual

warehouse, query performance tuning, Zero copy clone, time travel, and understanding how to use these features.

Experience in Data Migration from RDBMS to Snowflake cloud data warehouse.

Experience with enterprise cloud economics.

Experience in enterprise data management concepts (Data Governance, Data Engineering, DataScience, Data Sharing, Data Applications).

Hands-on expertise with SQL and SQL analytics.

Industry benchmarking experience in major industries such as Financial Services and Retail.

Experience with DevOps tools like Azure DevOps (ADO), GitHub, and Octopus Deploy.

Experience building solution using DBT, Python and Snowpark.

Good knowledge of distributed systems, APIs, cloud computing patterns.

Ability to debug, troubleshoot, and resolve complex technical issues.

Self-driven and motivated, with a strong work ethic and a passion for problem-solving.

If you are interested, please apply for an immediate discussion with Talent team

#UST

Skills

snowflake,snowpipe,rbac,elt,

About UST

UST is a global digital transformation solutions provider. For more than 20 years, UST has worked side by side with the world’s best companies to make a real impact through transformation. Powered by technology, inspired by people and led by purpose, UST partners with their clients from design to operation. With deep domain expertise and a future-proof philosophy, UST embeds innovation and agility into their clients’ organizations. With over 30,000 employees in 30 countries, UST builds for boundless impact—touching billions of lives in the process.