08.11.2025 aktualisiert
verifiziert
Premiumkunde
100 % verfügbarLead Data & Analytics Architect (Snowflake) • Project Lead • Power BI/DAX • AI-ready analytics
Oberägeri, Schweiz
Schweiz
Fach Hochschule Computer TechnikÜber mich
Snowflake-certified Lead Data & Analytics Architect with 20+ yrs experience designing scalable data platforms & AI-ready reporting using Power BI/DAX, SQL Server & Python. Strong in Data Vault 2.0, modeling & performance tuning.
Skills
Microsoft SQL-Server BIAnalyseSQLSnowflakeArtificial IntelligencePythonLarge Language Models (LLMs)Microsoft-Power-BI DAX
Architects and leads end-to-end data-platform implementations,
combining BI and AI using Snowflake and the Microsoft BI stack.
Previously co-founded and led BI Architects (the Netherlands), managing a small team delivering end-to-end BI solutions for clients such as VARO Energy, Albron and APM Terminals.
Extensive knowledge of, and experience with the Snowflake ecosystem, including using AI capabilities to make full use of both your structured and unstructured enterprise data.
Proficient in utilizing the full suite of Microsoft BI tools, encompassing SQL Server, SSIS, SSAS (Tabular and Multi-Dimensional), MS Fabric, Azure Synapse, DAX, MDX, SSRS, Stored Procedures, Power-BI, and Excel for comprehensive data management and analysis.
Analysis and visualization with Power-BI, Tableau Desktop and Tableau Server.
Performance optimization of ETL processes, cube processing as well as query optimization.
Skilled in dimension modelling adhering to the Kimball methodology, as well as designing and implementing Data Vault versions 1.0 and 2.0 for robust data architecture solutions.
ETL Process Automation using Templates and BIML.
Good knowledge and hands-on experience in the latest AI topics: Machine Learning, Deep Learning, Large Language Models, Prompt engineering, and the application of LLMs using LangChain, RAG, Vector Search, etc., using Python.
Extensive experience with Enterprise Application Integration, using SSIS and Workato.
Extensive experience with: T-SQL, Python, C#, ASP.NET (MVC 5, EF 6), DB2, RPG IV ILE.
Some experience with: R, Java, Delphi, BizTalk, Oracle PL/SQL.
Familiar with the data model and APIs of: Investran, iLevel, DealCloud, CommodityXL, Planview AdaptiveWork (previously called Clarizen).
Sprachen
DeutschverhandlungssicherEnglischverhandlungssicherNiederländischMuttersprache
Projekthistorie
Delivering freelance Data & AI projects and developing the Snowflake-based Capital Focus 360 solution for Private-Markets reporting.
Designed Snowflake architectures with hybrid models and dynamic tables supporting both real-time and pre-aggregated analytics.
Optimized data pipelines for multi-source AUM, ESG and performance reporting; implemented Snowflake and Power BI semantic models.
Leveraged Snowflake Cortex and Python AI components to translate natural-language queries into SQL and reduce manual reporting and analytics effort by ~70 %.
Technologies used: Snowflake (Dynamic Tables, Hybrid Tables, Cortex AI, Python, Streamlit, SSO, OAuth 2.0, Key Pair Authentication), Power-BI (Hybrid Semantic Models, Dashboards), Azure Web App (C#, ReAct), Excel exports and dynamic updates from Snowflake.
As Data Solutions Architect (Lead), designed and implemented a 'Management Information System' data solution that consolidates the Assets Under Management (AUM) from various alternative investments (liquid investments, insurance-linked investments, private equity, private debt, hedge funds, etc.). This system enables analysis and reporting of AUM, Fees, and Performance in a Fund-of-Funds environment, as well as analysis and reporting of Sales activities and the resultant AUM and fee revenues generated.
Developed a 'Private Equity Investment Management' data solution, combining data from four different sources. This includes Fund-of-Funds look-through capabilities with dynamic FX conversions and aggregations, as well as ESG aggregation capabilities.
Played an active role in the selection processes for the Enterprise Application Integration solution (evaluating Workato, Dell Boomi, Snaplogic), new hardware, and the cloud data platform (considering Snowflake, Azure Synapse/Fabric, Databricks), contributing significantly to the preparation of the migration plan. This plan aims to transition from a Stored Procedure approach to a View-on-View approach in an automated manner, thereby reducing data mart development time for future and existing projects.
Designed the MS SQL Data Vault 1.0 to the Snowflake Data Vault 2.0 migration.
Served as Team Lead for 15 months while acting as Head of Data Warehouse (ad interim).
Development and Optimisation of SSAS Cubes with large Data Volumes.
Optimisation of both Calculated Measures (MDX), as Dimension structures and Aggregations.
Development of near-real-time automatic Cube Processing and Partitioning framework.
Development of custom, event driven ETL framework.