Technical Architect
Mammoth Growth
full-time
Posted on:
Location Type: Remote
Location: United States
Visit company websiteExplore more
About the role
- 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
Requirements
- 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.
Benefits
- Rapid career advancement
- Exposure to a huge range of business challenges
- Amazing clients
- Competitive compensation
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard skills
dbtSQLSnowflakeBigQuerysystems architectureELT architectureprompt engineeringAI implementationmodel contractsperformance optimization
Soft skills
articulationproblem anticipationproactive mitigationproject managementclient strategy realizationrecommendation defensecollaborative developmentquality assurancecommunicationleadership