Senior Data Engineer

Collinson Group; Mumbai City; Hybrid; INR 1,500,000 - 2,100,000; Full time

Benefits offered by this job

Hybrid work arrangement (work fromHome

26 calendar days Annual Leave

Health Insurance

Maternity leave - Paid

Paternity leave - Paid

Job summary

Collinson Group seeks a skilled Data Engineer to develop and maintain Snowflake data products and models, and to build robust ELT pipelines using dbt. You will implement data quality checks, observability, and governance across data assets, collaborating with product teams to deliver secure, scalable datasets.

The role emphasizes real-time data integration with Kafka, CI/CD, and a drive toward platform modernization.

Qualifications

• Proven expertise in Snowflake-based data warehousing and dbt.
• Experience building ELT/ETL pipelines and data modelling.
• Ability to implement data quality, observability and CI/CD in data platforms.

Responsibilities

• Develop and maintain Snowflake data products and models.
• Build ELT pipelines with dbt and modern data engineering practices.
• Implement automated data quality checks, monitoring and observability across pipelines.
• Deliver secure, governed datasets for analytics and operations.
• Collaborate with Product Managers, Analysts and Stakeholders to meet data needs.
• Design scalable, maintainable, and cost-efficient data solutions.
• Support real-time data integration using Kafka and event-driven architectures.
• Develop reusable frameworks, standards and CI/CD pipelines.
• Troubleshoot data quality and performance issues.
• Contribute to platform modernization and governance alignment.
• Work with Data Governance to ensure GDPR/security compliance.
• Participate in code reviews and promote engineering excellence.
• Mentor junior engineers and share knowledge within Data & Analytics community.
• Evaluate emerging technologies and drive platform improvements.
• Support AI and advanced analytics initiatives with high-quality data assets

Skills

Advanced SQL

Python

Data Modelling

ELT/ETL

Data Warehousing

Data Lakehouse

Data Quality Engineering

Snowflake

dbt

Git

CI/CD pipelines

Data Observability

AWS fundamentals

Terraform

APIs

Docker

Kafka

Event-Driven Architecture

CDC

Agile delivery

Test-driven engineering

Code review

Performance optimisation

Cost optimisation

Tools

Confluent Kafka Platform

Airflow

Databricks

PySpark

Data Mesh concepts

Data Governance and Lineage tools

Monitoring and Observability platforms

Kubernetes

Job description

Key Responsibilities

• Develop and maintain Snowflake-based data products and data models.
• Build and manage ELT pipelines using dbt and modern data engineering practices.
• Implement automated data quality checks, monitoring and observability across data pipelines.
• Deliver reliable, secure and well-governed datasets for analytics and operational use cases.
• Collaborate with Product Managers, Analysts and Business Stakeholders to understand data requirements and deliver fit-for-purpose solutions.
• Design solutions with scalability, maintainability, performance and cost optimisation in mind.
• Support real-time and near-real-time data integration patterns using Kafka and event-driven architectures.
• Develop reusable frameworks, standards and engineering best practices across the data platform.
• Implement CI/CD pipelines and automated deployment processes.
• Troubleshoot and resolve data quality, performance and reliability issues.
• Contribute to platform modernisation and continuous improvement initiatives.
• Work closely with Data Governance teams to ensure compliance with GDPR, security and data management standards.
• Participate in code reviews and promote engineering excellence across the team.
• Mentor junior engineers and contribute to knowledge sharing across the Data & Analytics community.
• Evaluate emerging technologies and recommend improvements to the platform and engineering practices.
• Support AI and advanced analytics initiatives through the delivery of trusted, high-quality data assets

Knowledge, skills and experience required

Mandatory Technical Skills

Data Engineering

• Advanced SQL
• Python
• Data Modelling (Dimensional Modelling, Kimball, Data Vault fundamentals)
• ELT/ETL design and development
• Data Warehousing concepts
• Data Lakehouse concepts
• Data Quality Engineering
• Snowflake
• dbt
• Git
• CI/CD pipelines
• Data Observability and Monitoring
• AWS fundamentals
• Infrastructure as Code (Terraform)
• APIs and data integrations
• Containerisation fundamentals (Docker)
• Kafka fundamentals
• Event-Driven Architecture concepts
• CDC (Change Data Capture) concepts
• Agile delivery (Scrum/Kanban)
• Test-driven engineering principles
• Code review practices
• Performance optimisation
• Cost optimisation

Preferred Skills

• Confluent Kafka Platform
• Airflow
• Databricks
• PySpark
• Data Mesh concepts
• Data Products and Product Operating Model
• Data Governance and Lineage tools
• Monitoring and Observability platforms
• Kubernetes fundamentals

Nice to Have

• Generative AI fundamentals
• LLM integration patterns
• RAG architectures
• Vector databases
• AI Agent frameworks
• Machine Learning platform awareness
• Real-time analytics architectures

Person Specification

• Self-motivator with a desire to learn new skills and embrace new technologies in a constantly changing technology landscape
• Strong problem-solving and analytical skills.
• Passion for building scalable and maintainable data solutions.
• Self-motivated with a continuous learning mindset.
• Strong stakeholder management and communication skills.
• Ability to communicate technical concepts to non-technical audiences.
• Collaborative team player who thrives in agile environments.
• Quality-focused with strong attention to detail.
• Ability to balance business priorities with technical excellence.
• Proactive in identifying opportunities for improvement and innovation.
• Comfortable working across global teams and multiple business domains.

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.

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 [e-mail]

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)