Senior Business Intelligence Data Architect

Responsibilities

• Architectural Leadership and Governance
• Define and govern enterprise analytical architecture standards and scalable modeling frameworks across all layers (staging, intermediate, dimensional, fact, semantic, and mart layers), leveraging Snowflake and dbt.
• Establish standards for model grain declaration, naming conventions, ownership metadata, lineage, and documentation.
• Lead architectural design reviews for new modeling initiatives and analytical platform changes.
• Partner with Data Engineering teams to align ingestion patterns and source system architecture with downstream analytical requirements.
• Data Modeling and Semantic Layer
• Lead the design and technical implementation of governed business entities, semantic models, and enterprise metrics in partnership with BI andAnalytics.
• Design, implement, and enforce secure access patterns (APIs, RBAC, query design) for
• applications, AI agents, and self-service tools consuming Snowflake data through governed
• semantic models.
• Translate complex business requirements from Revenue Operations, Finance, and executive leadership into scalable, trustworthy data models and BI solutions.
• Analytics Engineering and Platform Enablement
• Establish and enforce scalable analytics engineering standards for dbt development, testing, deployment workflows, Git practices, CI/CD, model performance, observability, and deployment reliability.
• Partner with BI Data Engineering teams to improve model consistency, modularity, scalability, and long-term maintainability.
• Mentor analytics engineers on modular architecture, semantic implementation, reusable modeling patterns, and modern analytics engineering best practices.
• Evaluate and recommend tooling, governance capabilities, semantic technologies, and platform improvements that support scalability and reduce technical debt.
• Required Qualifications:
• 8+ years in data engineering, analytics engineering, or data architecture roles, with at least 3 years operating in a senior or lead architect capacity with direct analytical platform ownership.
• Deep, hands-on expertise with Snowflake architecture, including virtual warehouse design, RBAC, materialization strategies, dynamic tables, and query performance optimization.
• Expert-level dbt Labs practitioner with experience in staging/intermediate/mart conventions, Jinja macros, incremental strategies, testing frameworks, documentation, and reusable modeling patterns; dbt Certified Data Architect or Analytics Engineer certification preferred.
• Demonstrated experience designing and deploying production semantic layers serving govern

Benefits

Additional Information

What is Contentstack? 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. While many organizations adopted headless CMS or standalone AI tools expecting transformation, they often found themselves managing disconnected systems and manual workflows. Contentstack helps enterprises move beyond that complexity by connecting content, data and AI in a way that makes digital experiences faster to launch, easier to manage and more adaptive in real time. Leading brands including Steve Madden, LG Electronics, Subaru of America, Dolce & Gabbana, ASICS, Decathlon, and Caesars Entertainment rely on Contentstack to reduce operational friction and deliver personalized, scalable digital experiences with confidence. The company is known for its customer-first culture and commitment to the communities it serves through the Contentstack Cares program. Learn more at www.contentstack.com . Who Are We? At Contentstack we are more than colleagues, we are a tribe. Our vision is to pursue equity among our communities, employees, partners, and customers. We are global-diverse yet close; distributed yet connected. We are dreamers and dreammakers who challenge the status quo. We do the right thing, even when no one is watching. We are curious trendspotters and brave trendsetters. Our mission is to make Contentstack indispensable for organizations to tell their stories and to connect with the people they care about through inspiring, modern experiences. We care deeply about our customers and the communities we serve. #OneTeamOneDream. Chalo, let's go! What Are We Looking For? We are seeking a Senior BI Data Architect to lead the analytical modeling architecture and engineering standards that power reporting, semantic modeling, and AI-enabled analytics across the enterprise. In this high-impact role, you will establish scalable modeling patterns and reusable frameworks across Snowflake and dbt while partnering with leadership to operationalize governed metrics and long-term analytics strategy through architectural implementation best practices.

Your Match

How well this role fits your profile.

Company Intel

What employees say

Worked at contentstack? Share your experience