Senior Analytics Engineer
The Collinson Group1 month ago
Mumbai, IndiaSenior
Responsibilities
- Design and build domain, dimensional, and semantic data models and scalable reusable data products using Snowflake and dbt.
- Develop incremental models, optimize complex transformations, and reduce warehouse compute costs.
- Implement data quality, integrity, testing, documentation, coding, and naming standards across data models.
- Investigate data quality issues, perform root-cause analysis, resolve data gaps, and support data contracts for critical data elements.
- Build automation and AI capabilities for development, testing, deployment, documentation, and monitoring using Python, Snowflake Cortex, LLMs, and AI Agents.
- Support migration of Tableau and custom SQL workloads into governed dbt models and contribute to platform modernization.
- Own complex analytics engineering deliverables from design through production implementation and resolve technical risks, dependencies, blockers, and production issues.
- Collaborate with Product, BI, Data Engineering, Governance, and source-system teams on end-to-end solutions.
- Mentor Analytics Engineers through pairing, code reviews, and technical guidance while contributing to engineering standards and communities of practice.
Requirements
- Strong hands-on Analytics Engineering or Data Engineering experience with Snowflake, dbt, SQL, and data modeling.
- Ability to personally design, code, test, troubleshoot, and deliver production-grade data solutions.
- Strong understanding of dimensional modeling, incremental processing, data quality, and performance optimization.
- Experience with Git, CI/CD, code reviews, and modern software engineering practices.
- Ability to investigate complex data issues across source and downstream systems and drive technical problems through resolution.
- Experience supporting and mentoring other engineers while remaining an active individual contributor.
- Interest or practical experience applying GenAI, LLMs, AI Agents, or Snowflake Cortex to Analytics Engineering.
- Strong Python experience is preferred.
- Experience with semantic layers, data contracts, lineage, observability, AI or automation solutions, AWS, modern data integration patterns, Tableau, or other enterprise BI platforms is preferred.
Benefits
- Hybrid work arrangement with work-from-home and office options.
- 26 calendar days of annual leave.
- Health insurance.
- Six months of paid maternity leave.
- 15 days of paid paternity leave.
- Competitive salary and benefits plan.
About The Collinson Group
Collinson Group builds travel experience and customer loyalty products for airlines, payment networks, and financial services brands, and sells travel insurance and assistance direct and via partners. Its portfolio includes Priority Pass and LoungeKey airport lounge access, plus loyalty strategy and rewards platforms used worldwide. Privately held and headquartered in London, the company was founded in 1985 and operates across the travel and financial services sectors.