Senior Analytics Engineer

Responsibilities

• Build complex data models using dbt with optimal performance and maintainability
• Design and optimize Snowflake data pipelines leveraging advanced features for scalability
• Configure database environments, manage permissions, and implement data governance frameworks
• Implement ELT processes using modern data stack tools such as Fivetran
• Write high-quality code following Git workflows, code reviews, and CI/CD practices
• Conduct data quality audits and implement automated testing frameworks
• Leverage AI tools like Claude and ChatGPT to enhance development productivity
• Mentor Analytics Engineers and provide technical guidance
• Collaborate with Technical Leads on complex project decomposition and execution
• Present technical solutions and audit findings to clients

Requirements

• 5-7+ years of analytics engineering or data engineering experience
• Advanced dbt proficiency including macros and performance optimization
• Deep Snowflake expertise in architecture and optimization
• Hands-on experience with Fivetran and the modern data stack
• Proficient in Git/GitHub workflows and branching strategies
• Advanced SQL skills with query optimization capabilities
• Understanding of dimensional modeling and analytics engineering methodologies
• Experience with cloud environments such as AWS and/or GCP
• Demonstrated experience with LLM platforms (Claude, ChatGPT) and prompt engineering
• Familiarity with agentic tools and Model Context Protocols (MCP)
• Strong communication skills for technical and business stakeholders

About the Company

Mammoth Growth is a modern data analytics consultancy that uses agnostic tools expertise and data-driven decision making to help clients grow. They have completed over 850 engagements for clients ranging from startups to enterprises like Dropbox and Calendly.