Offer summary

Qualifications:

5-7+ years of analytics engineering or data engineering experience, Advanced proficiency in dbt and deep expertise in Snowflake, Strong SQL skills with experience in query optimization, Excellent communication skills for both technical and business stakeholders..

Key responsibilities:

Build and optimize complex data models and pipelines using dbt and Snowflake

Implement data governance frameworks and manage database environments

Conduct data quality audits and mentor junior analytics engineers

Collaborate with cross-functional teams and present technical solutions to clients.

Job description

Mammoth Growth is a modern data analytics consultancy. We use our unique combination of agnostic tools expertise and data-driven decision making to help our clients grow and thrive in an ever-changing marketplace. We are world-class business consultants who optimize systems to deliver measurable business outcomes. We have completed 850+ engagements with clients in all areas - e-commerce, SaaS, media, D2C, B2B - from start-ups to enterprise. Mammoth is trusted by industry leaders from Dropbox to Calendly to verify their data, manage their reporting infrastructure, develop growth strategy and provide recommendations and insights that achieve measurable results.

At Mammoth Growth, the Senior Analytics Engineer / Jr. Tech Lead focuses on building complex data infrastructure using dbt, Snowflake, and modern ELT tools while providing technical guidance and expertise. You'll design scalable data pipelines, implement governance frameworks, and leverage AI tools to optimize development workflows. The position requires hands-on technical work combined with code review responsibilities and team guidance.

What You'll Do

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

What You'll Bring

Technical Skills

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

AI & Innovation Skills

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

Professional Skills

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

We love working with people who like to laugh, smile and joke around.

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. At this time, we are unable to provide sponsorship. Must be a resident or green card holder of the U.S.,U.K. or Canada.

So, what are you waiting for?

Required profile