SQL Server Analysis Services Experts in Germany
from over 15,000 CVs with fast AI matchingHire experts who design semantic models, build tabular and multidimensional cubes, and connect Power BI to trusted enterprise data. FRATCH matches you quickly with vetted, available freelancers whose skills fit your SQL Server Analysis Services project.
Meet FRATCH Experts in Germany, who have recently used SQL Server Analysis Services
Stefan O.
Last position:
Founder at ProtocolEngine.io
Evidence-led health intelligence platform turning published research into personal health protocols. It scores 430 habits, foods, and supplements against the studies behind them, and moves the score when the evidence moves. Built solo.
- Built the daily ingestion pipeline across PubMed, bioRxiv, and medRxiv: 43,000+ papers from 3,400+ journals processed into 230,000+ typed evidence claims, each one traceable back to the study it came from.
- Designed the six-factor evidence scoring model and the public changelog behind it, so no recommendation ever appears without the papers underneath it. 23,000+ grade changes recorded and explained to date.
- Shipped an entity information model connecting every intervention to its mechanisms, biomarkers, and outcomes: 118 biomarkers with region-specific reference ranges, 77 mechanisms, 32 graded outcomes.
- Built the personalisation layer: blood panel ingestion that reads lab PDFs with a vision model and corrects results for draw time against the user's wake anchor, plus Oura, WHOOP, and Withings integration for daily readiness context.
- Operate eleven specialised review agents over the corpus and codebase, covering paper curation, retrieval quality, health-claim compliance across EU and US regimes, and security.
- Shipped the Evidence Assistant, a RAG assistant that answers from the claim database and cites the underlying papers, plus a B2B practitioner tier, an Expo React Native app, and localisation across 3 languages and 7 markets.
Stack: Next.js 16, TypeScript, Supabase, pgvector, Anthropic Claude, Vercel, DeepInfra.
Muhammad Y.
Last position:
SynQ × AutoStore
- Enterprise WMS customisation for Albert Heijn and EDEKA.
- Owned end-to-end test planning, automation, and performance validation for logistics automation software serving high-volume grocery warehouse operations.
Alexander B.
Last position:
Senior Data Engineer at RWE AG
Architected and maintained data products for renewable energy operations, covering wind turbine, grid-meter, and weather data. Built scalable ETL/ELT pipelines in Azure Databricks using Delta Lake (bronze/silver/gold layers) and processed data in various formats, including structured and semi-structured data. Contributed to a data quality framework supporting table and column documentation, outlier detection, and completeness metrics across all datasets within a data product. In addition, implemented a DORA KPI Databricks dashboard used across all data products. Optimized CI/CD processes in Azure DevOps to streamline deployment across development, test, and production environments.
Technology stack: Azure Databricks, PySpark, SQL, Delta Lake, Unity Catalog, Azure Data Lake, APIs, Dremio, Azure DevOps, YAML, Git, Databricks Workflows, Application Insights, Terraform, OpenAI API, Codex, LLM-assisted workflows
Monika T.
Last position:
Senior ETL Lead at Takeda GmbH
- Led design, development, and deployment of data solutions supporting a major pharma acquisition for Takeda Pharmaceutical Company, delivering transparency reporting systems across Azure,Databricks (Python and Shell Scripting) platforms.
- Owned,Designed and developed scalable ELT pipelines to process Customer and Product data using Azure, complex SQL, Databricks, and shell scripting, enabling efficient data integration and processing across multiple sources including job orchestration and workflow automation.
- Implemented performance optimization techniques (query tuning, parallelism, workload optimization), improving system efficiency and processing time.
- Applied strong analytical and problem-solving skills to assess technical solutions and support business requirements for compliance and transparency reporting.
- Designed scalable data foundations suitable for downstream analytics and AI workloads.
- Led data quality initiatives by assessing multiple source data, defining quality metrics, and establishing processes for monitoring and continuous improvement.
Stefan W.
Last position:
Architect/Software Developer at Global Logistics Support GmbH
Task
- Further development of a new ERP system with Blazor
- Creation of e-invoices with the XRechnung and ZUGFeRD format
- UI/UX design Client-server system
- Windows 11 Technology
- Microsoft .NET 9, Git, Azure DevOps, ASP.NET, MSSQL, Blazor Programming languages
- C#, MVVM Development tools
- Microsoft Visual Studio .NET 2022 Database
- MSSQL Industry
- Other
Matthias W.
Last position:
Freelance Consultant Business Intelligence (Self-employed) at mw-consult.it
Data Engineering
Business Analyst
Consulting
2025 – present
Data Engineer & Architect
- Azure Data Factory
- Azure Databricks (PySpark)
- PowerBI Service
Lead developer for the further development of the Modern Data Warehouse, as well as Power BI reports and data models based on the ERP systems Amparex and EyeOffice. Focus on topics for the marketing department with data connection via API to Amplitude and Klaviyo with Python
- 2024 – present
Data Engineer & Architect
- SQL Server (T-SQL)
- SSIS (ETL)
- SSAS Tabular
- PowerBI Report Server
- Atlassian Jira & migration to Azure DevOps with GIT (KANBAN)
Development of Power BI reports and data models based on Infor LN ERP data after migration from Baan, including the underlying data structures with Microsoft SQL Server for further development of the Data Warehouse
Consulting for controlling on the specification of business requirements and development of reporting solutions
- 2025 – 06.2025
Data Engineer & Architect
- PowerBI Dataflows
- PowerBI Service
Cloud migration of the Data Warehouse, as well as Power BI reports and data models from Microsoft Dynamics BC 2021 to Microsoft Dynamics BC Cloud, including migration of the underlying data structures from Microsoft SQL Server to Power BI Dataflows
- 2022 – 06.2024 (ongoing support for data engineers)
Data Engineer & Architect
- SQL Server (T-SQL)
- SSIS (ETL) & BIML
- SSAS Tabular
- Azure DevOps with GIT (SCRUM)
Development of analytical models based on Microsoft Dynamics BC 2021 in combination with data from the company's own MariaDB database, including the setup of the underlying data structures with Microsoft SQL Server to build a Data Warehouse. Merging of the ERP systems BC 2021 and DATEV in the Data Warehouse
Consulting for business users on the specification of business requirements and coaching of developers for the development of reporting solutions
- 2022 – 08.2023
Business Analyst & Interim Manager
- PowerBI Service
- Azure Databricks (PySpark)
- Atlassian Jira (SCRUM)
Project management for reporting solution requirements, as well as development of Power BI reports and data models with data from Azure Databricks based on SAP R/3, Google Analytics, webshop and CRM with a business focus on customer, sales and marketing
- 2022 – 05.2022
Power BI Specialist
- PowerBI Service
- Azure DevOps with GIT (SCRUM)
Development of Power BI reports and data models based on data from Exasol with a business focus on assortment management in purchasing
- 2021 – present (ongoing support for existing customers)
Power BI Specialist & Data Engineer
- SQL Server (T-SQL)
- SSIS (ETL) & BIML
- PowerBI Service
- Azure DevOps with GIT (KANBAN)
- Azure Functions (Python)
Development of Power BI reports and data models based on abas ERP data, including the setup of the underlying data structures with Microsoft SQL Server to build a Data Warehouse.
Synchronization of customer data for Pipedrive CRM via Azure Functions with Python.
Consulting for controlling and management on agile project management, the specification of business requirements and development of reporting solutions
- 2021 – present (ongoing support for existing customers)
Data Engineer & Architect
- SQL Server (T-SQL)
- SSIS (ETL) & BIML
- SSAS Tabular
- Azure DevOps with GIT (SCRUM)
Development of analytical models based on Microsoft Dynamics 365 FO, CS & CRM in combination with Microsoft Dynamics AX 2012 R3, including the setup of the underlying data structures with Microsoft SQL Server to build a Data Warehouse
Concept for the migration of the SQL Server-based Data Warehouse to Microsoft Fabric with planned future implementation and temporary use of a hybrid data architecture for the introduction of Power BI Service during the migration phase
Consulting for business users on the specification of business requirements and development of reporting solutions
Mirza A.
Last position:
Consultant Data Warehouse at InfoFabrik GmbH
- Data Management of Oracle based Data Warehouse
- Operational monitoring of DWH
- ETL Processes in Oracle SQL
- Consulting in reporting and DWH development
- Developing Dynamic List, Grid, Jxls, Pivot Reports in Report Server
- Data visualization in Report Server
Franziska M.
Last position:
Business Insights & Analytics Working Student at Eurowings Holidays
- Built & maintained 10+ Power BI dashboards tracking booking, revenue & yield KPIs, reducing manual reporting effort
- Developed a centralized data model (SQL & Azure Analysis Services), integrating multiple data sources to improve reporting consistency & scalability
- Delivered ad-hoc analyses for leadership, supporting data-driven decision-making across multiple business units
Olga M.
Last position:
Telefónica Deutschland Holding AG
- Implemented the BI solution and replaced the old BI landscape
- Led the “Sales Bonus Plan” subproject: expanded the existing solution and migrated to Azure (Databricks)
- Led the “Cognos Migration” subproject: expanded existing data warehouses based on MS technologies (source systems: Oracle), analyzed business requirements and designed the technical solution
- Expanded the relational DWH database
- Developed ETL processes using SSIS
- Developed the multidimensional database (OLAP Cubes/SSAS)
Mario T.
Last position:
Project Lead/Manager / Consultant at all-BI GmbH
- Establishing the Microsoft Fabric platform with the company as the central data warehouse and reporting system.
- The company migrated several operational systems including D365 to new version. The new data warehouse is based on a Fabric/Power BI architecture with Azure cloud Entra Authentication.
Tasks Performed:
- Full administrative responsibility for the Fabric platform F64 and F32 capacities, as well as two F8 capacities for development and prototyping.
- Integration of Fabric with Microsoft Entra.
- Data modeling for the data warehouse bronze, silver and gold layers using data modeling tools.
- Star Schema as well as entity relationship modeling.
- Data modeling for data marts and for dimensional modeling and Power BI (semantic model).
- Design of data models for Microsoft SSAS multidimensional and tabular OLAP cubes using DAX and MDX.
- Definition of design patterns for the ETL team for loading OLAP cubes (Tabular and MD), star schemas and data vault structures.
- Planning and managing team of 4 ETL and reporting developers.
- Performance Tuning of Power BI reports, particularly the semantic layer, as well as the Fabric notebooks
- SQL Performance Tuning.
- DB Design for Azure SQL.
- Reporting directly to project senior management.
Label: Power BI, Fabric, Analysis Services (multidimensional and tabular), D365, SSIS, Tabular Editor, SQL Server and Azure SQL, TOAD Data Modeler, DBSchema, Visual Studio Code, DAX Studio, SSMS, Visual Studio, Jira and Confluence.
Vincent R.
Last position:
Freelancer at VINROTLAB.IO
- Consulting and creation of various web applications based on SharePoint and the React framework for different clients
- Development and testing of accessible apps for SharePoint
- Creation of various test cases for test automation
- Development of various solutions based on Azure
- Creation of various web services based on .NET
- Development of various SharePoint Framework solutions
- Development of various UI solutions based on SharePoint
- Consulting and creation of various Power Apps applications and Power Automate for the steel industry and an IT consulting company
- Support, consulting, and development with offshore teams for SharePoint 2013, 2016, and microservices for a logistics company
- Consulting, concept design, and development of microservices and web applications based on Microsoft technology and the React framework for a logistics company
- Consulting, concept design, and development of various SharePoint Framework solutions on SharePoint 2016 for logistics
- Consulting for the migration from SharePoint 2010 to 2016 for an IT consulting company
Umut G.
Last position:
Data Architect at BA Technology
I am an experienced data engineer specializing in end‑to‑end data integration, cloud DWH architectures, and high‑quality, governed data products.
I delivered following projects and engagements as a freelancer.
- Data Migration of CRM System for AL-FA Objekt Service Gmbh
- Microsoft Software Resales Partnership
I am looking for freelance roles like: Freelance Data Engineer Cloud Data Warehouse Architect Data Modeling & Architecture Consultant MDM & Data Governance Specialist BI & Analytics Developer
Technical Focus Areas
- Data Engineering & Integration: SQL Server/SSIS, Informatica PowerCenter/IDQ, Talend, Kafka, Azure Data Factory – Delta/CDC/ELT patterns, robust pipelines, monitoring/recovery, data lineage & impact analysis, medallion architecture Bronze/Silver/Gold layers
- DWH & Cloud: Azure SQL / Data Lake / Synapse, AWS Redshift/S3, on‑prem SQL/Oracle – scalable data marts with a strong cost/benefit focus.
- Data Modeling: Atomic (Inmon) and Dimensional (Kimball), Data Vault (Linstedt), Domain‑Driven Design, clear lineage & contracts.
- MDM & Governance: Informatica MDM, IBM MDM, stewardship processes, data quality rules, survivorship/XREF, catalog/glossary, SIF/BES/REST publication.
- Analytics/BI: Power BI, SSAS, Cognos – business‑ready, maintainable data products.
Henok A.
Last position:
Founder and Managing Director at Afworki GmbH IT-Consulting
The goal of Afworki GmbH IT-Consulting is to make small and medium-sized companies more competitive by overcoming challenges in digitalization, automation, and data management.
Tailored technology, strategy, and specialist consulting designed to meet the individual needs of each company.
Analyzing the company's current situation and developing the best possible solution together with the client.
Using both agile and classical IT project management methods to deliver projects on time and within budget.
Focusing on automating and orchestrating all data flows in a data warehouse to create a unified and standardized data foundation.
Considering the dependencies between IT and business to achieve sustainable positive effects.
Employing modern strategies and tools specifically tailored to the company's needs.
Supporting digitalization, the introduction of agile working methods, and the creation of up-to-date reports and analyses.
Objective: streamlining management and enabling well-founded, data-driven decision-making.
André B.
Last position:
External Attack Surface Assessment & Cybersecurity Readiness Checks at Graydaxe Cybersecurity GmbH
- Conducting cybersecurity readiness checks based on an in-house assessment methodology
- Analyzing the external attack surface using the Graydaxe EASM platform
- Assessing maturity levels and deriving prioritized recommendations for action
Moez S.
Last position:
Data Engineer at Loschelder Rechtsanwälte Partnerschaftsgesellschaft mbB
- Designed a future-proof client database for marketing purposes
- Analyzed requirements, designed, and modeled an entity-relationship model
- Consolidated and optimized a client file from various data sources for targeted marketing campaigns
- Worked closely with marketing and IT in an agile environment to iteratively develop the solution
- Technologies and methods: MS Office (mainly Excel), MS Dynamics CRM, MS SharePoint
Discover over 15,000 top freelancers
Statistics of experts using SQL Server Analysis Services
Aggregated from the professional profiles of matched freelancers.
Experience
19 years
Position duration
2.5 years
Positions per freelancer
15
Top business areas
Information Technology, Business Intelligence, Project Management
Top industries
Information Technology, Banking and Finance, Professional Services
Certification focus areas
Information Technology, Business Intelligence, Project Management
Bachelor's degree or higher
87%
Master's degree or higher
57%
Doctorate
7%
Certifications per freelancer
3
Most common languages
German, English, French
Speak two or more languages
95%
Based on our profile pool as of 19 Sep 2026.
Daily rate distribution
The chart shows how the daily rates of freelancers in this technology in Germany are distributed, based on recent contracts on our platform. Each bar covers a rate range — its height shows how many freelancers charge within that range.
Average rates of experts in Germany using SQL Server Analysis Services
Rates are based on recent contracts and do not include FRATCH margin.
The average daily rate is the mean of all daily rates from recent contracts of comparable freelancers on our platform.
The median daily rate is the middle value of all daily rates — half of comparable freelancers charge less, half charge more. Unlike the average, it is barely affected by outliers.
Calculated based on our freelancers’ daily rates as of 19 Sep 2026. Actual rates may vary depending on seniority level, experience, skill specialization, project complexity, and engagement length.
SQL Server Analysis Services experts industry focus
See which industries our matched freelancers work in most often — every figure is calculated live from the freelancers on FRATCH.
- Information Technology (90%)
- Banking and Finance (65%)
- Professional Services (60%)
- Manufacturing (48%)
- Retail (43%)
- Automotive (40%)
- Insurance (38%)
- Energy (33%)
Please note that freelancers can work across multiple industries, so percentages overlap.
About the technology
What it does
SQL Server Analysis Services, commonly called SSAS, is Microsoft’s analytical data platform for turning operational data into governed models for reporting and business intelligence. It supports tabular models and multidimensional cubes, letting users explore measures, dimensions, hierarchies and calculated business logic without querying source systems directly.
Core models
Tabular projects use relational structures, relationships and DAX calculations to provide a flexible semantic layer for Power BI, Excel and other clients. Multidimensional projects use cubes, MDX, dimensions and aggregation designs, which remain important in established enterprise environments. Strong specialists choose the model according to data volume, existing assets, query patterns and long-term maintenance needs.
Ecosystem and tooling
SSAS works closely with SQL Server Database Engine, SQL Server Integration Services, SQL Server Reporting Services, Power BI and Excel. Typical work includes:
- Designing tabular models, perspectives, relationships and calculation groups
- Developing DAX measures or MDX calculations and validating business definitions
- Configuring processing, partitions, aggregations, roles and row-level security
- Deploying models through Visual Studio, SSDT, Tabular Editor or automated pipelines
When companies need experts
Companies bring in freelance SSAS expertise when a reporting layer has become slow, inconsistent or difficult to govern. Specialists can modernize multidimensional cubes, migrate workloads toward tabular models, improve processing reliability or connect an established warehouse to Power BI. In Germany, this work often supports manufacturing, logistics, financial services and retail teams with complex reporting structures.
Delivery and collaboration
A capable professional starts by mapping source systems, business terms, security rules and reporting consumers. They then define a model, test results against trusted figures, document dependencies and establish a repeatable deployment process. Remote delivery works well when access, environments and decision owners are clear; on-site collaboration can help when the model depends on deeply embedded business knowledge.
What quality looks like
Look for experience with both model design and the operational details that keep SSAS reliable. Strong experts explain why they choose tabular or multidimensional, write maintainable DAX or MDX, and understand storage modes, processing strategy, performance analysis and permissions. They also test calculations with business users, separate data issues from model issues and leave behind clear documentation for the internal team.
Frequently asked questions
Key details about SQL Server Analysis Services, drawn from the questions we get asked most.
SQL Server Analysis Services is used to create semantic models for business intelligence and analytical reporting. It organizes measures, dimensions, hierarchies, calculations and security rules so users can work with consistent data in Power BI, Excel, reporting tools and custom applications.
SSAS provides a governed analytical model that can serve many reports, applications and teams, while Power BI semantic models are often managed within a specific workspace or reporting environment. The right choice depends on reuse, governance, deployment architecture, capacity and how closely the organization wants the model tied to Power BI.
A specialist should assess the existing warehouse, client tools, calculation language, performance requirements and migration plans before choosing. Tabular SSAS with DAX is usually the natural fit for newer Power BI-oriented solutions, while multidimensional SSAS with MDX may remain appropriate when established cubes and reporting dependencies are central to the business.
A strong SSAS specialist usually understands SQL Server, dimensional modeling, data warehousing and ETL processes. Power BI, DAX, MDX, Excel, source-system analysis, deployment automation and data security are also valuable, because model quality depends on the wider reporting landscape.
The need depends on the scope rather than a fixed duration of experience. A focused model adjustment may need a specialist who can work within an existing design, while a new enterprise model requires proven skill in architecture, requirements discovery, performance tuning, security and production rollout.
Yes. SQL Server Analysis Services work is often suitable for remote collaboration when the specialist can access source data, development environments and deployment pipelines securely. On-site sessions may still help with workshops, sensitive data processes or close coordination with German-speaking business teams.
Ask the professional to explain a model they designed, including grain, relationships, calculation logic, processing approach and security. Good answers connect technical choices to business requirements and show how performance, data accuracy, testing and documentation were handled.
A typical SQL Server Analysis Services engagement can produce a tabular model or cube, DAX or MDX calculations, deployment configuration, security roles and processing routines. It should also include validation against agreed business results, performance findings, technical documentation and guidance for ongoing ownership.
The average hourly rate of freelancers in Germany who have used SQL Server Analysis Services in their recent projects is 101 €, which corresponds to a daily rate of about 811 € based on an 8-hour working day.
Of the freelancers in Germany who have used SQL Server Analysis Services in their recent projects, 87% hold at least a Bachelor's degree, 57% hold at least a Master's degree, and 7% hold a doctorate.
On average, freelancers in Germany who have used SQL Server Analysis Services in their recent projects have 19 years of professional experience, with a single engagement typically lasting around 2.5 years.
The most common languages among freelancers in Germany who have used SQL Server Analysis Services in their recent projects are German (100%), English (95%), and French (23%).
The most common industries among freelancers in Germany who have used SQL Server Analysis Services in their recent projects are Information Technology (90%), Banking and Finance (65%), and Professional Services (60%).
The most common business areas among freelancers in Germany who have used SQL Server Analysis Services in their recent projects are Information Technology (100%), Business Intelligence (98%), and Project Management (73%).
Main locations of FRATCH Experts, who have recently used SQL Server Analysis Services
Our freelancers and interim experts are at home across the DACH region — available on-site in the major business hubs or fully remote. Choose a location to discover matched specialists, local market insights and up-to-date availability.
Berlin Hamburg Munich Cologne Frankfurt Stuttgart Dusseldorf Leipzig Dortmund Essen Bremen Dresden Hanover Nuremberg 
Frankfurt Request a free demo
Get in touch with the FRATCH team and we will get back to you within 4 hours.
Would you rather directly get in touch?
We always have the time for a call or email!
Philipp Thomaschewski
FRATCH CEO
