Job Description

Key Responsibilities

• Data Modelling & Development
• Design and build domain, dimensional, and semantic data models using Snowflake and dbt.
• Develop scalable, reusable, and maintainable Data Products aligned with enterprise modelling standards.
• Build efficient incremental models and optimise complex transformations for performance and cost.
• Understand end-to-end data lineage and work with source teams to resolve data gaps.
• Identify and remove duplicated, redundant, and deprecated models where appropriate.

2. Data Quality & Engineering Standards

• Implement appropriate data quality, integrity, and testing controls across data models.
• Ensure models comply with established coding, naming, documentation, and testing standards.
• Participate actively in PR reviews and DCB, providing technical feedback to other engineers.
• Investigate data quality issues, perform root-cause analysis, and implement sustainable fixes rather than downstream workarounds.
• Support implementation and adoption of Data Contracts for critical data elements.

3. Automation & AI

• Build practical automation that improves development, testing, deployment, documentation, and monitoring.
• Develop solutions using Snowflake Cortex, LLMs, AI Agents, Python, and other relevant technologies.
• Contribute to reusable AI and automation capabilities rather than creating isolated solutions.
• Identify repetitive engineering activities that can be automated to improve squad productivity.

4. Performance & Platform Optimisation

• Optimise Snowflake queries, dbt models, and warehouse consumption.
• Support migration of complex Tableau/custom SQL workloads into governed dbt models.
• Identify opportunities to improve model performance, reduce compute costs, and simplify the warehouse.
• Contribute to platform modernisation and technical-debt reduction initiatives.

5. Squad Delivery & Technical Support

• Take hands-on ownership of complex Analytics Engineering deliverables within the squad.
• Work closely with Product, BI, Data Engineering, Governance, and source-system teams to deliver end-to-end solutions.
• Support investigation and resolution of production and data quality issues.
• Proactively identify technical risks, dependencies, and blockers and drive them towards resolution.
• Support cross-squad initiatives where specialist Analytics Engineering expertise is required.

6. Mentoring & Engineering Enablement

• Support and mentor Analytics Engineers through pairing, code reviews, and technical guidance.
• Share reusable patterns, solutions, and lessons learned across squads.
• Contribute to engineering standards and Communities of Practice.
• Help raise overall engineering capability while remaining a hands-on individual contributor.

Key Technology Areas

Snowflake • dbt • SQL • Python • AWS • Git/CI/CD • Data Modelling • Semantic Layers • Data Contracts • Data Quality & Observability • Snowflake Cortex • LLMs & AI Agents

Skills & Experience

Must Have

• Strong hands-on Analytics Engineering/Data Engineering experience, with expertise in Snowflake, dbt, SQL, and data modelling.
• Proven ability to personally design, code, test, troubleshoot, and deliver production-grade data solutions.
• Strong understanding of dimensional modelling, incremental processing, data quality, and performance optimisation.
• Experience working with Git, CI/CD, code reviews, and modern software engineering practices.
• Strong problem-solving skills with the ability to investigate complex data issues across source and downstream systems.
• Ability to take ownership of complex technical problems and drive them through to resolution.
• Experience supporting and mentoring other engineers while remaining an active individual contributor.
• Interest or practical experience in applying GenAI, LLMs, AI Agents, or Snowflake Cortex to Analytics Engineering.

Nice to Have

• Strong Python experience.
• Experience with semantic layers, data contracts, lineage, and observability.
• Experience developing AI/automation solutions for data engineering.
• Experience with AWS and modern data integration patterns.
• Experience supporting Tableau or other enterprise BI platforms.

Success Measures

• Hands-on Delivery: Consistently delivers high-quality, production-ready solutions and takes ownership of complex engineering problems from design through implementation.
• Data Modelling: Builds scalable and reusable models aligned with enterprise standards while reducing duplication.
• Data Quality: Improves trust in data through effective testing, integrity controls, and root-cause remediation.
• Performance & Cost: Demonstrates measurable improvements in Snowflake/dbt performance and compute efficiency.
• Automation & AI: Delivers practical automation and AI capabilities that reduce manual engineering effort.
• Squad Enablement: Helps the squad deliver independently by solving technical blockers and mentoring engineers.
• Engineering Excellence: Produces maintainable, well-tested, documented code and consistently follows engineering standards.

About us: Our story

Collinson Group is a global leader in driving loyalty and engagement for many of the world’s largest companies. Predominantly through the provision of travel related benefits within a market leading digital travel ecosystem. The group offers a unique blend of industry and sector specialists who together provide market-leading experience in delivering products and services across four core capabilities: Loyalty, Lifestyle Benefits and Insurance.

The group provides unrivalled insight and expertise around affluent consumers and frequent travellers, creating and delivering products and services now accessible to over 400m end consumers.

We have more than 25 years’ experience, with 28 global locations, servicing over 800 clients in 170 countries, employing 1,800 people.

We have been bringing innovation to the market since inception – from launching the first independent global VIP lounge access Programme, Priority Pass to being the first to sell direct travel insurance in the UK through Columbus Direct and creating the first loyalty agency of its kind in the travel sector with ICLP. Today we still invest heavily in innovation to ensure that we continue to deliver superior customer experiences.

Key clients include: Visa, Mastercard, American Express, Cathay Pacific, British Airways, LATAM, Flying Blue, Accor, EasyJet, HSBC, Chase, HDFC.

Our mission is focused on doing good beyond profit, which for us means we seek out opportunities for our people to share in our success and that we give back to the communities and people within which we work.

Never short of ambition, the success of our business is delivered through the diverse and talented team of over 1,800 colleagues globally.

Reward & Benefits: What's in it for me?

You can look forward to a competitive salary and benefit plan including but not limited to:

• Hybrid work arrangement (work from home/office)
• 26 calendar days Annual Leave
• Health Insurance
• Maternity leave (6 months- Paid)
• Paternity leave (15 days- Paid)

Equal Opportunities: Our commitment to inclusion

Collinson is an equal opportunity employer and welcomes differences in all their forms including: colour, race, ethnicity, gender identity, sexual orientation, neurodivergence, family status, age, individuals with disabilities and people from all backgrounds, cultures and experiences as we strongly believe this contributes to our on-going success.

We are focused on continually evolving our purpose driven, high performing culture, providing an environment where our people have the opportunity to achieve their full potential and do interesting and meaningful work. Our company values are: Act smarter, Do the right thing, One team and Be insight led. These help guide everything we do internally in terms of how we think, act and interact, right through to how we deliver value to our customers and clients.

If you need any extra support throughout the interview process, then please email us at recruitment@collinson.com