Senior BI Consultant & Architect

Turning data into decisions that drive business

Frank Ruiter brings over 17 years of Business Intelligence expertise — from data warehouse architecture to Azure cloud analytics — helping organisations make smarter, faster decisions.

View expertise About Frank
Skill proficiency
SQL / T-SQL
Expert
Power BI
Expert
Microsoft Fabric
Expert
Azure / ADF
Expert
Snowflake / dbt
Senior
Purview
Senior
Architecture
Expert
Microsoft Fabric Purview dbt Snowflake Data Vault DAX
Trusted by leading organisations
Eneco CIZ Trajectum Timon + more
About Frank

Senior BI Consultant
with a builder's mindset

Frank Ruiter
17+
Years in BI
10+
Certifications
40+
Projects delivered
5+
Industries served

Frank Ruiter has been building Business Intelligence solutions since 2007. Across dozens of projects spanning healthcare, energy, finance and social services, he has taken on roles from data engineer to solution architect — always combining deep technical skill with clear, pragmatic communication.

Based in Nijverdal, Frank operates as an independent consultant and is regularly engaged for complex data transformation programmes where architecture quality and stakeholder alignment both matter.

Microsoft Certifications

Microsoft Certified: Azure Data Fundamentals
Microsoft Certified: Azure Fundamentals
MCSE: Data Management & Analytics
MCSE: Data Platform
MCSE: Business Intelligence
MCSA: SQL Server 2012
MCITP: BI Developer 2008
Prince2 Foundation
Expertise

Full-stack BI capabilities

From raw source systems to polished executive dashboards — Frank covers the complete Business Intelligence stack.

🏛️

Data Architecture

Designing scalable, future-proof data warehouse and lakehouse architectures. Deep experience with Data Vault modelling, dimensional design (Kimball), and hybrid approaches — from classic on-premise DWH to modern cloud lakehouses.

Azure Synapse Microsoft Fabric Snowflake Data Vault 2.0 Kimball
🧱

Modern Data Stack

Building end-to-end analytics pipelines with the modern data stack. Experience with dbt for transformation, Snowflake as cloud data platform, and Microsoft Fabric as unified analytics foundation — bringing structure, testability and speed to BI delivery.

Microsoft Fabric dbt Snowflake Databricks Azure Data Factory
📊

Reporting & Dashboards

Creating interactive, self-service reporting layers in Power BI and SSRS. Advanced DAX modelling, row-level security, and enterprise deployment via Power BI Service — now also within the Microsoft Fabric ecosystem.

Power BI DAX Microsoft Fabric SSRS RLS
🔎

Data Governance & Purview

Implementing data governance frameworks and cataloguing using Microsoft Purview — lineage, classification, access policies and data quality monitoring across the full estate.

Microsoft Purview Data Lineage Data Catalog
🔄

ETL & Data Engineering

Reliable pipelines with full lineage and auditability — both classic SSIS/ADF patterns and modern dbt-based transformation layers on Snowflake or Fabric.

SSIS ADF dbt T-SQL
☁️

Cloud & Azure Platform

Migrating on-premise BI workloads to Azure and modernising legacy stacks across Synapse, ADF, ADLS, Databricks, and the full Microsoft Fabric suite.

Azure Fabric ADLS Gen2 Databricks
📐

Solution Architecture

Translating complex business requirements into coherent technical designs — with clear documentation, architecture decision records, and stakeholder buy-in at every step.

BI Architecture Prince2 Agile
Full technology overview
Microsoft Fabric Microsoft Purview dbt Snowflake Power BI SQL Server Azure Synapse T-SQL DAX Azure Data Factory SSIS SSAS MDX SSRS Azure Data Lake Gen2 Databricks Data Vault 2.0 Kimball DWH Azure DevOps Power BI Service Power Query / M Python Git Prince2 Agile / Scrum Row-level Security
From the blog

Insights & technical writing

All articles on SQLFrank.com
dbt

How to Use Seed Files in a dbt-Core Project

Seed files are a powerful feature in dbt-core that allow you to include static, structured data directly in your analytics project — especially useful for reference tables and mapping datasets that don't change often.

29 November 2024
dbt · Snowflake

Setting Up dbt-Core for Snowflake: A Step-by-Step Guide

Integrating dbt-Core with Snowflake opens up seamless possibilities for data modelling and management in the cloud. A practical walkthrough from setup to first model.

14 November 2024
Power BI · Azure

Extract Data with Power BI from Azure Data Lake Storage

How to connect Power BI directly to ADLS Gen2 — step by step.

23 December 2022
SSIS · SQL Server

Execute an SSIS Package with a SQL Task (Outer Project Reference)

Different ways to execute an SSIS package using an outer project reference via a SQL task.

6 September 2021
T-SQL · Tabular

Get Metadata from Cubes with T-SQL

Using dynamic management views to extract rich metadata from tabular cubes with simple T-SQL queries.

30 November 2020

✦ SQLFrank.com

Frank's personal technical blog covering dbt, Snowflake, Power BI, Azure, SQL Server and more. Practical deep-dives written from real project experience — no fluff, just working solutions.

Visit SQLFrank.com →
12+
Articles
6
Topics
2020
Since
Availability
Open for new engagements
Available from July 2026

Interested in working together before that date? Reach out — there may be flexibility depending on project fit and scope.

Discuss your project
Contact

Let's build something
data-driven together

📧
Emailfrank.ruiter@ruiterbisolutions.nl
📞
Phone+31 6 40 65 55 23
📍
AddressDille 27, 7443 EA Nijverdal, NL
🏢
Chamber of CommerceKVK 74260731

Whether you're embarking on a BI transformation, need a senior architect for a complex data project, or want a second opinion on your current setup — Frank is happy to connect and explore the possibilities.

Typical engagements range from architecture reviews and design sprints to long-term embedded consultancy. Both Dutch and English-speaking projects are welcome.

Currently available for
  • ✦ Interim BI Architect engagements
  • ✦ Data platform modernisation
  • ✦ Power BI & Azure advisory
  • ✦ Architecture reviews & audits