Role Overview
We are looking for a Snowflake Developer / Data Engineer (IC3) to take self-directed ownership of features and small epics within our Snowflake data platform — including Bronze/Silver/Gold data layer architecture, ELT pipelines, and the data models that power analytics and reporting across Keyloop. Beyond hands-on delivery, you will lead design discussions for your own work, coach more junior developers, and work with stakeholders across Finance, Sales, and Operations to deliver reliable, scalable, and well-governed data products.
Key Responsibilities
- 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 comprehensive 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, pipeline runbooks
Required Skills & Experience
- 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, 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
Desirable Skills
- 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
Skills Required
- 4-7 years of Snowflake development experience in a production data environment
- Strong SQL skills including window functions, CTEs, recursive queries, and advanced aggregations
- Hands-on experience with Snowflake features: streams, tasks, dynamic tables, time travel, zero-copy cloning
- Experience building ELT/ETL pipelines from sources 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, 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 lead technical discussions
What We Do
As the largest global automotive technology company, Keyloop delivers cutting-edge solutions, tailored to the modern needs of auto retailers and OEMs alike. With 40 years of automotive DNA, and a deep understanding of what it takes to drive success, Keyloop solutions are delivered in over 90 countries, and trusted by more 20,000 retailers and 80 OEMs worldwide. From the showroom to the workshop, and everything in between, its technology facilitates distinctive customer experiences between key systems, tools and departments. With modern consumers demanding increasingly high levels of service and responsiveness, Keyloop and their partners connect retailers and OEMs to consumers through every step of their journey. Keyloop delivers a proven technology ecosystem that redesigns the automotive retail experience to cultivate lasting loyalty and optimise margins through increased efficiency, elevated experiences, and unrivalled connected data. For more information, please visit www.keyloop.com
