To tackle frontier problems using advanced data solutions, the full-time Technical Architect will architect client systems, orchestrate role-based agents, and implement complex dbt models while working remotely in the United States. Key responsibilities Evaluate and design architecture tailored to client business needs, leading plan reviews and making critical tier decisions Direct the deployment of role-based agents for complex builds, ensuring data parity and overseeing pull request reviews Implement and document sophisticated dbt solutions with full test coverage and versioning, ensuring maintainability post-engagement Required qualifications Expert-level proficiency in dbt, including complex modeling, macros, and performance optimization Extensive experience with cloud data warehouses, specifically Snowflake and BigQuery Advanced SQL skills with a focus on query optimization and troubleshooting Strong knowledge of Git workflows, including branching strategies and CI/CD pipelines Proven experience in designing scalable, cloud-based data solutions using medallion architecture