About the role
Contentstack is seeking a Business Intelligence Data Architect to shape analytical architecture, data modeling standards, and engineering practices powering enterprise reporting and AI-enabled analytics.
You will implement governed semantic models across Snowflake and dbt, collaborate with Data Engineering, BI & Analytics, Revenue Operations, Finance, and executive leadership to build a trusted foundation for data-driven decision-making.
Lead analytical architecture and governance across modeling layers. Build governed data models and semantic layers for enterprise reporting and AI-enabled analytics. Set analytics engineering standards for dbt development, Git workflows, and CI/CD. Design secure data access patterns for applications consuming Snowflake data. Collaborate with Data Engineering, BI & Analytics, Revenue Operations, Finance, and executives. Mentor analytics engineers on modular architecture and semantic implementation. Drive platform evolution and reduce technical debt. 5-8 years of experience in data engineering, analytics engineering, or data architecture with at least 3 years in an architect capacity. Deep expertise in Snowflake architecture and RBAC, performance optimization. Expertise with dbt, including staging, intermediate, mart conventions and testing. Strong understanding of dimensional and semantic modeling for governance and analytics. Experience delivering production semantic layers and governed metrics across BI platforms. Proficiency in SQL and Python; familiarity with cloud-native analytics environments.