Hybrid AI-First BI Architect for Scalable Analytics Platform

Energyzero; Almere; Hybrid; EUR 83,000 - 165,000; Part time

Job summary

Energyzero is seeking an experienced BI Architect to build an AI-first BI platform from scratch in Almere (hybrid work). You will design architecture, establish governed data models and implement the platform using Snowflake, dbt and Fivetran, collaborating with a junior BI Specialist and stakeholders.

You will translate complex business concepts into clear definitions, deliver a scalable data foundation and an AI-ready semantic layer, and provide hands-on implementation along with knowledge

Qualifications

• Experience designing and building a BI, analytics or data platform from scratch.
• Strong data architecture, modelling and SQL skills.
• Hands-on experience with Snowflake and dbt.
• Experience building and operating modern ELT/data pipelines.
• Experience creating governed semantic or business data models.
• Practical experience applying AI or natural-language analytics to business data.
• Ability to translate ambiguous business concepts into clear and testable definitions.
• Strong communication skills and enjoy sharing knowledge with less experienced colleagues.
• Experience with Fivetran and working with existing or legacy BI environments such as Tableau is highly relevant.

Responsibilities

• Lead design and build of the new BI foundation.
• Assess source systems, existing Tableau environment and reporting needs.
• Designing the target BI and data warehouse architecture.
• Setting up Snowflake, Fivetran and a maintainable dbt structure.
• Designing ingestion patterns for databases, events, APIs and SaaS platforms.
• Translating raw data into reusable business entities, dimensions and metrics.
• Establishing clear definitions for KPIs such as active customers, products, churn and recurring revenue.
• Rebuilding the agreed operational, churn and revenue reporting on top of the new governed models.
• Designing an AI-ready semantic layer.
• Delivering a practical AI analytics and/or anomaly detection proof of concept.
• Introducing standards for testing, documentation, data quality, lineage, security and monitoring.
• Working side by side with our junior BI Specialist and actively transferring your knowledge.
• At the end of the project, we want our internal team to understand not just what has been built, but why it was built that way.

Skills

Data architecture

SQL

ELT pipelines

AI analytics

Governed data models

Communication

Hands-on implementation

Architectural design

Tools

Snowflake

dbt

Fivetran

Tableau

Job description

Energyzero is seeking an experienced BI Architect to build an AI-first BI platform from scratch in Almere (hybrid work). You will design architecture, establish governed data models and implement the platform using Snowflake, dbt and Fivetran, collaborating with a junior BI Specialist and stakeholders.

You will translate complex business concepts into clear definitions, deliver a scalable data foundation and an AI-ready semantic layer, and provide hands-on implementation along with knowledge