Snowflake and Integration Developer
Posted Updated 5
views
Description
Keyloop bridges the gap between dealers, manufacturers, technology suppliers and car buyers.
We empower car dealers and manufacturers to fully embrace digital transformation. How? By creating innovative technology that makes selling cars better for our customers, and buying and owning cars better for theirs.
We use cutting-edge technology to link our clients’ systems, departments and sites. We provide an open technology platform that’s shaping the industry for the future. We use data to help clients become more efficient, increase profitability and give more customers an amazing experience. Want to be part of it?
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
Why join us?
We’re on a journey to become market leaders in our space – and with that comes some incredible opportunities. Collaborate and learn from industry experts from all over the globe. Work with game-changing products and services. Get the training and support you need to try new things, adapt to quick changes and explore different paths. Join Keyloop and progress your career, your way.
An inclusive environment to thrive
We’re committed to fostering an inclusive work environment. One that respects all dimensions of diversity. We promote an inclusive culture within our business, and we celebrate different employees and lifestyles – not just on key days, but every day.
Be rewarded for your efforts
We believe people should be paid based on their performance so our pay and benefits reflect this and are designed to attract the very best talent. We encourage everyone in our organisation to explore opportunities which enable them to grow their career through investment in their development but equally by working in a culture which fosters support and unbridled collaboration.
Keyloop doesn’t require academic qualifications for this position. We select based on experience and potential, not credentials.
We are also an equal opportunity employer committed to building a diverse and inclusive workforce. We value diversity and encourage candidates of all backgrounds to apply.
"At Keyloop, AI is a daily ally: We encourage and train every employee to use our AI tools to boost their creativity and productivity."
Skills
As published by lever · 14 questions · 11 written answers
Basics
Resume/CV, Full name, Pronouns, Email, Phone, Current location, Current company, LinkedIn URL, Twitter URL, GitHub URL, Portfolio URL, Other website, What is your age range?, I identify my ethnicity asSelect all that apply, What gender do you identify as?, Do you consider yourself to have a disability or be differently abled?, Were you previously employed by Armed Forces?
Short answers (1)
- Please confirm type of right to work document
Pick from a list (2)
- Are you currently authorised to work in the country of the job without any restrictions? optional
- Will you now or in future require visa sponsorship to work in country of the job optional
Written answers (11)
- What is your experience with AI Tools like Claude? optional
- Describe your experience with Snowflake Development.
- Describe your experience in ETL, ELT and their differences.
- Do you have experience in SQL Transformation/Performance Tunning, CTE’s and Stored Procedures ?
- Do you have Knowledge on Boomi/Salesforce/Netsuite ?
- Do you have any experience in Data Base Migration ?
- How would you rate your communication skills in English on a sacle of 1-10 ?
- This role requires you to work Hybrid, are you comfortable with it ?
- Kindly provide your current, expected salary, notice period
- Visa status
- This role requires you to work in the UK hours, is that comortable with you ?