{"schemaVersion":"jobsearcher.job.v1","id":"e5d7c33e14e39edf3e097e4c","url":"https://jobsearcher.com/jobs/e5d7c33e14e39edf3e097e4c","canonicalUrl":"https://jobsearcher.com/jobs/e5d7c33e14e39edf3e097e4c","title":"Technical Architect","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 across e-commerce, SaaS, media, D2C, and B2B—from Series A startups to publicly traded Fortune 100 firms. 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.Why This Role is DifferentHere 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 LeadershipBe the go-to expert in the room of how we are going to implement the solutionArticulate and defend your recommendationsDoing what it takes to move the project toward its goalsAnticipate future problems and proactively mitigating themCreate SolutionsEvaluate and document a client’s current systemsHelping clients to realize their strategy and define their future roadmapDesign and recommend new systems architectureDesign the data architecture based on business requirementsDesign custom engineering integrations and solutionsHands On ExecutionBuild complex dbt implementations following medallion architecture patternsDesign and implement model contracts, versioning strategies, and frameworksConduct rigorous code reviews ensuring quality and testing coverageWhat You’ll Need:Expert-level dbt proficiency: Complex modeling, macros, testing strategies, model contracts, state comparison, and performance optimizationDeep cloud data warehouse experience: Extensive hands-on work with Snowflake AND BigQuery, including architecture, optimization, and advanced featuresAdvanced SQL mastery: Query optimization, complex transformations, and performance troubleshootingGit proficiency: Branching strategies, PR workflows, CI/CD pipelines, and collaborative development practicesSystems architecture: Proven experience designing and implementing scalable cloud-based data solutionsModern ELT architecture: Solid understanding of medallion architecture and evolving best practicesPrompt engineering: Experience crafting detailed, effective prompts for LLMsAI 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 efficiencyInquisitive with an attention to detail and ability to ask the right questions at the right timeIndependently organized; self-starter; ability to work with minimal directionGood communication / client facing skills / ability to work in a team environmentEnjoy learning new tools to better solve new challengesWhat We OfferAccess to all of the latest AI tooling and models. If there is a tool that makes your job more productive, we’re open to it. Subscriptions to Claude, Open AI, etc.Rapid career advancement and exposure to a huge range of business challengesWork with amazing clients across every industryCompetitive compensation100% remote (we were distributed before COVID and will be forever)Flexibility to work from home, anywhere in the US or Canada (sponsorship not available, must be a resident or GreenCard holder)Ready to architect the future of data? We'd love to hear from you!","company":"Mammoth Growth","rawCompany":"mammoth growth","city":"Millbrae","state":"CA","isRemote":false,"isActive":false,"createdAt":"2026-04-22T19:05:35.576Z","occupations":[{"code":"15-1243.01","title":"Data Warehousing Specialists","slug":"data-warehousing-specialists"},{"code":"15-1243.00","title":"Database Architects","slug":"database-architects"},{"code":"15-1299.08","title":"Computer Systems Engineers/Architects","slug":"computer-systems-engineers-architects"}],"industries":[{"code":"541512","title":"Computer Systems Design Services","slug":"computer-systems-design-services"},{"code":"541511","title":"Custom Computer Programming Services","slug":"custom-computer-programming-services"},{"code":"513210","title":"Software Publishers","slug":"software-publishers"}],"jobPosting":{"@context":"https://schema.org","@type":"JobPosting","title":"Technical Architect","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 across e-commerce, SaaS, media, D2C, and B2B—from Series A startups to publicly traded Fortune 100 firms. 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.Why This Role is DifferentHere 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 LeadershipBe the go-to expert in the room of how we are going to implement the solutionArticulate and defend your recommendationsDoing what it takes to move the project toward its goalsAnticipate future problems and proactively mitigating themCreate SolutionsEvaluate and document a client’s current systemsHelping clients to realize their strategy and define their future roadmapDesign and recommend new systems architectureDesign the data architecture based on business requirementsDesign custom engineering integrations and solutionsHands On ExecutionBuild complex dbt implementations following medallion architecture patternsDesign and implement model contracts, versioning strategies, and frameworksConduct rigorous code reviews ensuring quality and testing coverageWhat You’ll Need:Expert-level dbt proficiency: Complex modeling, macros, testing strategies, model contracts, state comparison, and performance optimizationDeep cloud data warehouse experience: Extensive hands-on work with Snowflake AND BigQuery, including architecture, optimization, and advanced featuresAdvanced SQL mastery: Query optimization, complex transformations, and performance troubleshootingGit proficiency: Branching strategies, PR workflows, CI/CD pipelines, and collaborative development practicesSystems architecture: Proven experience designing and implementing scalable cloud-based data solutionsModern ELT architecture: Solid understanding of medallion architecture and evolving best practicesPrompt engineering: Experience crafting detailed, effective prompts for LLMsAI 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 efficiencyInquisitive with an attention to detail and ability to ask the right questions at the right timeIndependently organized; self-starter; ability to work with minimal directionGood communication / client facing skills / ability to work in a team environmentEnjoy learning new tools to better solve new challengesWhat We OfferAccess to all of the latest AI tooling and models. If there is a tool that makes your job more productive, we’re open to it. Subscriptions to Claude, Open AI, etc.Rapid career advancement and exposure to a huge range of business challengesWork with amazing clients across every industryCompetitive compensation100% remote (we were distributed before COVID and will be forever)Flexibility to work from home, anywhere in the US or Canada (sponsorship not available, must be a resident or GreenCard holder)Ready to architect the future of data? We'd love to hear from you!","datePosted":"2026-04-22T19:05:35.576Z","dateModified":"2026-04-22T19:05:35.576Z","hiringOrganization":{"@type":"Organization","name":"Mammoth Growth","sameAs":"https://jobsearcher.com"},"jobLocation":{"@type":"Place","address":{"@type":"PostalAddress","addressLocality":"Millbrae","addressRegion":"CA","addressCountry":"US"}},"identifier":{"@type":"PropertyValue","name":"JobSearcher","value":"e5d7c33e14e39edf3e097e4c"},"url":"https://jobsearcher.com/jobs/e5d7c33e14e39edf3e097e4c"}}