Business Intelligence Data Architect
Job description
Business Intelligence Data Architect responsible for shaping analytical architecture, data modeling standards, and engineering practices that power enterprise reporting, governed metrics, and AI-enabled analytics at Contentstack. The role establishes scalable modeling frameworks across Snowflake and dbt and partners with Data Engineering, BI & Analytics, Revenue Operations, Finance, and executive leadership.
At a glance
- Work mode
- Remote
What you'll do
- Lead analytical architecture and governance
- Design and implement reusable business entities, semantic models, and enterprise metrics that support consistent reporting, self-service analytics, applications, and AI-enabled workflows
- Set standards for dbt development, testing, Git workflows, CI/CD, deployment reliability, model performance, and observability to improve scalability and maintainability
- Design governed access patterns for applications, AI agents, and self-service tools consuming Snowflake data, including role-based access control (RBAC), APIs, service layers, and query optimization
- Work closely with Data Engineering, BI & Analytics, Revenue Operations, Finance, and executive stakeholders to translate business requirements into trustworthy data models and scalable analytics solutions
- Guide analytics engineers on modular architecture, semantic implementation, reusable modeling patterns, and modern analytics engineering practices
- Evaluate tools, semantic technologies, governance capabilities, and architectural improvements that support long-term scalability while reducing technical debt
What we're looking for
- 5-8 years of experience in data engineering, analytics engineering, or data architecture, including at least 3 years in an architect capacity with direct ownership of an analytical platform
- Deep, hands-on expertise in Snowflake architecture, including virtual warehouse design, RBAC, materialization strategies, dynamic tables, and query performance optimization
- Expert-level experience with dbt, including staging/intermediate/mart conventions, Jinja macros, incremental models, testing, documentation, and reusable modeling patterns
- Strong understanding of dimensional and semantic modeling, with the ability to select and justify approaches based on business and analytical needs
- Proven experience designing and deploying production semantic layers and governed metrics across BI platforms, analytics applications, and AI-enabled workflows, including text-to-SQL and MCP-based integrations
- Advanced SQL skills and experience with Python, along with familiarity with dbt Cloud, Fivetran, Git, CI/CD, and cloud-native analytics environments
- Experience designing secure data access patterns for applications consuming Snowflake data, including APIs, service layers, RBAC, query performance, and governed semantic access
- Strong written and verbal communication skills, with the ability to explain architectural decisions to technical teams, executive leaders, and cross-functional stakeholders
- Experience collaborating with globally distributed teams across the US, Europe, and India
Nice to have
- Snowflake SnowPro Core or Advanced certification; dbt Certified Data Architect or Analytics Engineer certification
- Experience with Snowflake Cortex and Snowpark ML for in-warehouse AI/ML workloads
- Experience working with Salesforce as a source system, including dimensional modeling for go-to-market (GTM) data
- Experience with retrieval-augmented generation (RAG) architectures that connect large language models to governed analytical data
- Familiarity with BI tools such as Tableau, Looker, or Power BI
- Experience implementing data governance frameworks, including data catalogs, column-level lineage, and row-level security
- You value a fun, collaborative, and innovative culture
Benefits
One Team One Dream: no artificial hierarchies, your voice will be heard and you will receive regular updates about the business and its performance
- Interesting Work: learn something new every day, never stop growing, and have fun while doing it
- Tribe Vibe: spontaneous office happy hours, organized outings, and community volunteer opportunities
- Bragging Rights: work with the most prestigious brands, from big-name retailers to airlines to professional sports teams
Apply
Direct apply at Contentstack
Opens the job posting at Contentstack
About Contentstack
Pioneer of the Agentic Experience Platform (AXP)
Contentstack is redefining how modern digital experiences are built and managed. As the pioneer of the Agentic Experience Platform (AXP), Contentstack brings together structured content and brand governance (Content Cloud), real-time customer data, omnichannel personalization (Data Cloud) and autonomous AI orchestration (Agent OS) into one unified system.
Mission
To make Contentstack indispensable for organizations to tell their stories and to connect with the people they care about through inspiring, modern experiences.
Key facts
- Digital experience / content management software
- Pioneer of the Agentic Experience Platform (AXP)
- Brings together Content Cloud, Data Cloud and Agent OS into one unified system
- Known for its customer-first culture and commitment to the communities it serves through the Contentstack Cares program
- Values: One Team One Dream
- Has a strict "no a**hole policy"
Partners & customers
What they value
- One Team One Dream
- Do the right thing, even when no one is watching
- Curious trendspotters and brave trendsetters
- Customer-first culture