Senior Business Intelligence Data Architect

🔥 8 minutes ago

🌐 Netherlands, Portugal – Remote

🇳🇱 Netherlands – Remote 🇵🇹 Portugal – Remote

⏰ Full Time

🟠 Senior

📚 Business Intelligence Analyst

👻 Ghost score 10%

What it means: how likely this posting is sitting open without active hiring.How to read it: 60% or higher means we think this is a ghost. Lower scores are less of a worry.How we score it: age, reposts, open roles vs team size, how fast jobs close, and whether pay is listed.Fine print: an estimate from public data, not a judgment of the company. Real jobs can score high, so treat it as a hint, not a fact.

Apply Now

Find Similar Remote Jobs

Set Up Email Alert For New Jobs

📊 Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Upload Resume

Contentstack

WebsiteLinkedInAll Job Openings

501 - 1000 employees

Founded 2018

💼 Consulting

📣 Marketing

✈️ Travel

Consulting • Marketing • Travel

Contentstack is a headless content management system (CMS) that provides businesses with a flexible and scalable platform to manage and deliver content across various digital channels. Recognized as a visionary in the digital experience platform (DXP) space, Contentstack offers API-first capabilities that deliver seamless digital customer experiences. The platform enables personalization, automation, and integration of content for diverse industries such as retail, financial services, and travel, helping organizations to innovate quickly and enhance customer engagement.

📋 Description

• Define enterprise modeling standards across staging, intermediate, dimensional, fact, semantic, and mart layers • Establish conventions for model grain, naming, ownership, lineage, and documentation • Lead architectural design reviews • Design and implement reusable business entities, semantic models, and enterprise metrics • Establish standards for dbt development, testing, Git workflows, CI/CD, deployment reliability, model performance, and observability • Design governed access patterns for applications, AI agents, and self-service tools consuming Snowflake data, including RBAC, APIs, service layers, and query optimization • Partner with Data Engineering, BI & Analytics, Revenue Operations, Finance, and executive stakeholders • Translate business requirements into trustworthy data models and scalable analytics solutions • Guide analytics engineers on architecture, semantic implementation, reusable modeling patterns, and analytics engineering practices • Evaluate tools, semantic technologies, governance capabilities, and architectural improvements • Reduce technical debt and support long-term platform scalability

🎯 Requirements

• 8-12 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 • 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 • 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 • Experience collaborating with globally distributed teams across the US, Europe, and India • 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 GTM data • Experience with retrieval-augmented generation (RAG) architectures • Familiarity with Tableau, Looker, or Power BI • Experience implementing data governance frameworks, including data catalogs, column-level lineage, and row-level security • Value a fun, collaborative, and innovative culture

🏖️ Benefits

• Interesting, challenging work with opportunities to learn and grow • Spontaneous office happy hours • Organized outings • Community volunteer opportunities • Opportunity to contribute and have your voice heard • Regular updates about the business and its performance