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

Are you an experienced business consultant, strategist, analyst, digital marketer or technologist?  If so, then you are exactly who we are looking for!

You will work directly on projects with our high growth and fast paced clients, bring fresh ideas and direct the strategy that makes our critical data analysis drive growth for our clients. We do our work in a modern data stack environment, working with the best tools in the industry.

If you do not see a current opening that is the perfect fit for you but you feel you bring valuable "Mammoth" skills to the table please apply to the Aspiring Mammoth role and our recruiters will review your application.

Are you an experienced business consultant, project strategist and data technologist all wrapped-up into one?  If so, then you are exactly who we are looking for!

As a Senior Delivery Lead at Mammoth Growth, you will be responsible for overseeing multiple client engagements, ensuring project success from inception to completion. You will lead multidisciplinary teams implementing agentic AI-driven analytics and data engineering solutions while maintaining client satisfaction and project profitability.

What You’ll Do:

• Manage multiple concurrent client projects, ensuring they remain on schedule and within budget
• Serve as the primary client liaison, communicating effectively with both executive and technical stakeholders
• Lead implementation teams comprised of data engineers, analytics engineers, and AI specialists
• Lead sprint (or Kanban) planning and execution, driving agile practices that foster alignment, transparency, and accountability across the team
• Develop and manage project plans and roadmaps, ensuring clear timelines for upcoming initiatives while proactively identifying risks and mitigation strategies to keep delivery schedules on track
• Facilitate client workshops and discovery sessions to identify business requirements
• Ensure architecture decisions and data implementations meet business objectives 
• Present project progress and deliverables to client stakeholders with visual storytelling excellence
• Communicate project health to executive and account management teams, highlighting business value delivered, renewal risks, and opportunities for expansion or extension.
• Coach and mentor team members to enhance delivery capabilities

What You’ll Bring:

• 5+ years of experience in consulting or professional services, preferably in data analytics or AI implementation
• Proven track record of successful project delivery in data-driven environments
• Previous exposure to Snowflake, DBT, or similar modern data stack technologies preferred
• Strong understanding of analytics engineering and data engineering principles
• Excellent communication skills, with the ability to translate technical concepts to business stakeholders
• Experience building and presenting strategic roadmaps for data initiatives
• Background in managing multidisciplinary teams in an agile environment
• Bachelor's degree in a relevant field or equivalent work experience

What Sets You Apart:

• Demonstrated experience leveraging AI tools, particularly in marketing or analytics contexts
• Understanding of data privacy regulations and best practices
• Prior consulting experience in mid-market or enterprise environments
• Demonstrated ability to maintain client relationships while driving business outcomes
• History of successful on-time, on-budget project delivery

Ready to architect the future of data? We'd love to hear from you.

Why This Role is Different

Here at Mammoth Growth, we’re going beyond just building data pipelines, we're pioneering the future of AI-enhanced analytics engineering. Our team has developed custom workflows that combine our decade of best practices with cutting-edge AI capabilities. We've built a team, toolset and workflow that utilizes the best AI models to accelerate delivery while maintaining the quality standards we're known for.

As a Technical Architect, you'll be at the forefront of this transformation, working with our AI-enhanced tooling while guiding clients through complex data challenges. You'll define architecture, code hand in hand with agents, review code, and deliver solutions that exceed industry standards.

You will be immersing yourself in a contemporary data stack environment. While familiarity with tools like dbt, Snowflake, and BigQuery are vital, your ability to draw from broad experiences will be paramount.

What You’ll Do:

Technical Leadership

• Be the go-to expert in the room of how we are going to implement the solution
• Articulate and defend your recommendations
• Doing what it takes to move the project toward its goals
• Anticipate future problems and proactively mitigating them

Create Solutions

• Evaluate and document a client’s current systems
• Helping clients to realize their strategy and define their future roadmap
• Design and recommend new systems architecture
• Design the data architecture based on business requirements
• Design custom engineering integrations and solutions

Hands On Execution

• Build complex dbt implementations following medallion architecture patterns
• Design and implement model contracts, versioning strategies, and frameworks
• Conduct rigorous code reviews ensuring quality and testing coverage

What You’ll Need:

• Expert-level dbt proficiency: Complex modeling, macros, testing strategies, model contracts, state comparison, and performance optimization
• Deep cloud data warehouse experience: Extensive hands-on work with Snowflake AND BigQuery, including architecture, optimization, and advanced features
• Advanced SQL mastery: Query optimization, complex transformations, and performance troubleshooting
• Git proficiency: Branching strategies, PR workflows, CI/CD pipelines, and collaborative development practices
• Systems architecture: Proven experience designing and implementing scalable cloud-based data solutions
• Modern ELT architecture: Solid understanding of medallion architecture and evolving best practices
• Prompt engineering: Experience crafting detailed, effective prompts for LLMs
• AI Experience: understanding of top models and how to effectively implement them in development workflows. 

Qualities:

• Demonstrated ability to quickly assess, strategize, and resolve high-stakes situations with calm precision and efficiency
• Inquisitive with an attention to detail and ability to ask the right questions at the right time
• Independently organized; self-starter; ability to work with minimal direction
• Good communication / client facing skills / ability to work in a team environment
• Enjoy learning new tools to better solve new challenges