Senior Business Intelligence Data Architect

This is a fully remote position, open to applicants in Netherlands, +1 more country.

📋 Description

• Establish enterprise modeling standards spanning staging, intermediate, dimensional, fact, semantic, and mart layers.

• Set conventions for model grain, naming, ownership, lineage, and documentation.

• Conduct architectural design reviews.

• Create and implement reusable business entities, semantic models, and enterprise metrics.

• Develop 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 that utilize Snowflake data, including RBAC, APIs, service layers, and query optimization.

• Collaborate with Data Engineering, BI & Analytics, Revenue Operations, Finance, and executive stakeholders.

• Convert business requirements into reliable data models and scalable analytics solutions.

• Mentor analytics engineers on architecture, semantic implementation, reusable modeling patterns, and analytics engineering methodologies.

• Assess tools, semantic technologies, governance capabilities, and architectural enhancements.

• Minimize technical debt and facilitate long-term platform scalability.

⛳️ Requirements

• 8-12 years of experience in data engineering, analytics engineering, or data architecture, with a minimum of 3 years in an architect role overseeing an analytical platform.

• Extensive, hands-on knowledge of Snowflake architecture, covering virtual warehouse design, RBAC, materialization strategies, dynamic tables, and query performance optimization.

• Expert-level proficiency with dbt, including staging/intermediate/mart conventions, Jinja macros, incremental models, testing, documentation, and reusable modeling patterns.

• Strong grasp of dimensional and semantic modeling principles.

• Proven track record in 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 proficiency and experience with Python.

• Knowledge of dbt Cloud, Fivetran, Git, CI/CD, and cloud-native analytics environments.

• Experience in designing secure data access patterns for applications leveraging Snowflake data, encompassing APIs, service layers, RBAC, query performance, and governed semantic access.

• Excellent written and verbal communication abilities.

• Experience working collaboratively with globally distributed teams across the US, Europe, and India.

• Snowflake SnowPro Core or Advanced certification; dbt Certified Data Architect or Analytics Engineer certification.

• Familiarity with Snowflake Cortex and Snowpark ML for in-warehouse AI/ML workloads.

• Experience with Salesforce as a source system, including dimensional modeling for GTM data.

• Background in retrieval-augmented generation (RAG) architectures.

• Familiarity with Tableau, Looker, or Power BI.

• Experience implementing data governance frameworks, incorporating data catalogs, column-level lineage, and row-level security.

• Appreciation for a fun, collaborative, and innovative workplace culture.

🏝️ Benefits

• Engaging and challenging work with opportunities for professional growth and development.

• Casual office happy hours.

• Organized team outings.

• Opportunities for community volunteering.

• Chance to contribute and express your ideas.

• Regular updates on business performance and developments.