Senior BI Data Architect for Enterprise Analytics & AI

Contentstack; Amsterdam; On-site; EUR 90,000 - 140,000; Full time

Benefits offered by this job

Interesting Work

Tribe Culture

Bragging Rights

One Team One Dream

Job summary

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.

Qualifications

• 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.

Responsibilities

• 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.

Skills

Data architecture

Analytics engineering

Governance & RBAC

SQL

Python

dbt

Snowflake

Tools

Snowflake

dbt

SQL

Python

Git

CI/CD

Looker/Tableau/Power BI

Job description

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.