About the role
Contentstack is seeking a Business Intelligence Data Architect to shape analytical architecture, data modeling standards, and governance across the enterprise. You will lead scalable modeling frameworks in Snowflake and dbt, partner with cross-functional teams, and drive AI-enabled analytics with trusted data foundations.
You will establish reusable semantic models, govern access, and set engineering best practices while mentoring a team of analytics engineers in a distributed environment.
Define enterprise data models, standards, and governance for enterprise reporting and AI analytics. Build governed data models and semantic layers to support self-service analytics and applications. Set analytics engineering practices for dbt development, testing, Git workflows, and CI/CD. Design secure access patterns for Snowflake-based apps and AI agents. Partner with Data Engineering, Revenue Ops, Finance, and leadership to translate requirements into scalable solutions. Mentor analytics engineers on modular architecture and reusable modeling patterns. Evaluate platform evolution and tooling to reduce technical debt and increase scalability. 5-8 years of experience in data engineering, analytics engineering, or data architecture, with at least 3 years in an architect capacity. Deep Snowflake architecture knowledge including virtual warehouses, RBAC, materialization strategies, and performance optimization. Expertise with dbt including staging, intermediate, and mart conventions, testing, and documentation. Strong understanding of dimensional and semantic modeling for enterprise reporting and AI-enabled workflows. Experience designing governance frameworks, data catalogs, and secure data access patterns. Proven ability to collaborate with global teams across US, Europe, and Asia. Snowflake SnowPro Core or Advanced certification; dbt Certified Data Architect or Analytics Engineer. Interesting Work Tribe Culture Bragging Rights One Team One Dream