Sr. Snowflake Developer

Overview

Lead self-directed delivery of features and small epics on Keyloop's Snowflake data platform, including Bronze/Silver/Gold layer architecture, ELT pipelines and the data models that power analytics and reporting.

What you'll do

• Lead complete delivery of features and small epics on the Snowflake platform, from design through to production, without senior oversight
• Design and implement Snowflake database objects: tables, views, streams, tasks, stored procedures and dynamic tables
• Build and maintain ELT pipelines using Boomi, dbt or SQL-based transformations into Snowflake
• Architect and manage Bronze / Silver / Gold data layers in line with Keyloop's data platform standards
• Develop and optimise complex SQL for data transformation, aggregation and reporting use cases
• Implement Snowflake performance best practices: clustering keys, result caching, query profiling and warehouse right-sizing
• Own testing strategy for pipeline and model changes, ensuring coverage beyond unit-level checks
• Coach and support IC1/IC2 developers on Snowflake, SQL and data engineering best practices
• Lead technical design discussions for your features and represent the team in cross-functional planning meetings
• Coordinate cross-functional data requirements with adjacent teams (Finance, Sales, Operations)
• Support data quality checks, reconciliation processes and lineage documentation
• Manage Snowflake environment configuration across dev, QA and production
• Contribute to data governance: access control, data masking, row-level security and tagging
• Monitor pipeline health, proactively identify failures and provide production support, including occasional out-of-hours incident response
• Support UAT cycles with technical recommendations and sign-off
• Produce clear technical documentation: data dictionaries, ERDs and pipeline runbooks

What you'll need

• 4–7 years of Snowflake development experience in a production data environment
• Strong SQL skills: window functions, CTEs, recursive queries and advanced aggregations
• Hands-on experience with Snowflake-specific features: streams, tasks, dynamic tables, time travel and zero-copy cloning
• Experience building ELT/ETL pipelines from source systems such as Salesforce, NetSuite or ERP platforms
• Understanding of dimensional modelling and data warehousing concepts (star schema, slowly changing dimensions)
• Familiarity with Snowflake access controls: roles, grants and row/column-level security
• Experience with version control (Git) and CI/CD for data pipeline deployment
• Ability to translate business data requirements into technical data models
• Demonstrated ability to coach or mentor junior developers and to lead technical discussions within a team

Nice to have

• SnowPro Core or Advanced Data Engineer certification
• Experience with dbt (data build tool) for transformation orchestration
• Exposure to Boomi as an integration tool feeding Snowflake
• Familiarity with Salesforce data structures and Salesforce reporting requirements
• Experience with NetSuite financial data extraction and modelling
• Knowledge of data observability tooling (Monte Carlo, Great Expectations or similar)
• Experience working within Agile delivery teams and Jira-based project management
• Background in automotive, SaaS or financial systems data

Details

• Location: Hyderabad, India