Apply on Employer Site

Mammoth Growth · 5 hours ago

Technical Architect

United States

Full-time

Remote

Senior Level

Mammoth Growth is a modern data analytics consultancy that focuses on using data-driven decision making to help clients grow. As a Technical Architect, you will lead the implementation of AI-enhanced analytics solutions, define architecture, and ensure quality through code reviews while guiding clients through complex data challenges.

AdvertisingAnalyticsConsultingMarketing

No H1B

U.S. Citizen Only

Hiring Manager

Kristin MacMahon

Responsibilities

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

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

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

Qualification

Dbt proficiencyCloud data warehouseSQL masterySystems architectureGit proficiencyModern ELT architecturePrompt engineeringAI experienceCommunication skillsAttention to detailSelf-starter

Required

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

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

Benefits

Access 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 challenges

Work with amazing clients across every industry

Competitive compensation

100% 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)