Senior Snowflake Engineer (Lead I - Data Engineering)

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

Do you have experience in SQL?, * 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.

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.