An AI agent that applies to roles like this on employers' own sites. 25 applications free, no card needed.
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.
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
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)
Skills
PythonSQLExpressData EngineeringTableauDbtSnowflakeAWSCI/CDGitPRRecruitmentTeamsIf a job posting appears fraudulent, asks for payment, contains misleading information, or violates our guidelines, please report it immediately. Our team will review it promptly, Jobaaj does not charge any fee from the applicants.
About Company
Similar Jobs
View allLooking for something similar?
New Data Science Analytics & Machine Learning roles in Mumbai.
One email a day. Unsubscribe any time.

