Technical Architect
Join Mammoth Growth as a Technical Architect and lead the future of AI-enhanced analytics engineering. You'll leverage your expertise in data architecture and coding while guiding clients through complex data challenges. Collaborate with a talented team to design and implement innovative data solutions using cutting-edge tools like dbt, Snowflake, and BigQuery. Enjoy a fully remote workspace with opportunities for rapid career advancement and exposure to diverse business challenges.
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. 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
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.
Job details
- Published
- January 13, 2026
- Last checked
- September 1, 2026
- Job source
- greenhouse
- Workplace
- Remote · US
- First seen
- July 23, 2026
See how well you match this job
Log in or sign up and Eva will compare your profile with this role, explain your strengths and show what to improve.
Sign up to see your matchAlready have an account? Log inMore at Mammoth Growth
Similar jobs from this company
None listed.
Across the market
Similar jobs from other companies
- Technical ArchitectNECSWSRemote, GBRemote
- Technical ArchitectSalesforce Tecnologia, Ltda.BRRemote
- Technical ArchitectUtopiaTELECOMMUTE, Fortaleza, Fortaleza, BrazilRemote
- Technical ArchitectInfotel UKChennai, INRemote
- Technical ArchitectStitch Consulting Services, Inc.USRemote
- Technical ArchitectMammoth GrowthUSRemote
Third-party content disclaimer
Full job descriptions are sourced directly from third-party applicant tracking systems (ATS), job boards, recruitment platforms, and employer career pages.
LiftmyCV does not claim ownership of this content or guarantee its accuracy or current availability. All original content is the intellectual property of the respective employers or other rights holders.
LiftmyCV hiring intelligence, availability checks, and related-job recommendations are generated from LiftmyCV data and public sources.
If you prefer, you may apply directly via the original listing for transparency.