Senior Analytics Engineer

Summary

Join Mammoth Growth, a modern data analytics consultancy, as a Senior Analytics Engineer/Jr. Tech Lead. You will build complex data infrastructure using dbt, Snowflake, and modern ELT tools, providing technical guidance and expertise. Responsibilities include designing scalable data pipelines, implementing governance frameworks, and leveraging AI tools. You will mentor junior team members, collaborate with senior colleagues, and present solutions to clients. The role requires advanced dbt and Snowflake proficiency, along with experience in Fivetran and modern data stack tools. Mammoth Growth offers a 100% remote work environment and competitive compensation.

Requirements

• Advanced dbt proficiency with complex modeling, macros, and performance optimization
• Deep Snowflake expertise including architecture, optimization, and advanced features
• Hands-on experience with Fivetran and modern data stack ecosystem
• Proficient in Git/GitHub workflows, branching strategies, and collaborative development
• Advanced SQL skills with query optimization and performance troubleshooting
• Understanding of dimensional modeling and analytics engineering methodologies
• Experience with cloud environments and scalable solutions in AWS and/or GCP
• Familiarity with project management tools like Jira
• Demonstrated experience with Claude, ChatGPT, and other LLM platforms
• Familiarity with agentic tools such as CoPilot, RooCode, and others
• Prompt engineering skills for code generation, documentation, and problem-solving
• Strong interest or direct experience in agentic workflows and Model Context Protocols (MCP)
• Ability to integrate AI tools into technical workflows
• 5-7+ years of analytics engineering or data engineering experience
• Strong problem-solving abilities with complex technical challenges
• Excellent communication skills for technical and business stakeholders
• Experience mentoring junior team members
• Self-motivated with ability to work independently and collaboratively

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, access control, 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 (Claude, ChatGPT) to enhance development productivity and solution quality
• Apply prompt engineering and implement agentic workflows using MCPs
• Mentor Analytics Engineers I and II, providing technical guidance and code reviews
• Collaborate with Technical Leads and Sr. Consultants on complex project decomposition and execution
• Present technical solutions and audit findings to clients
• Independently manage project components while coordinating with cross-functional teams
• Support project planning with technical expertise and risk assessment

Benefits

• We provide rapid career advancement, exposure to a huge range of business challenges, amazing clients and competitive compensation
• We are 100% Remote. Our team is fully distributed (before Covid and forever), allowing you the flexibility of working from home