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,