SQL Server Analysis Services Experts in Germany
in minutes from over 15,000 CVs with the power of AI.Hire experts who design SSAS tabular and multidimensional models, write DAX and MDX measures, tune cube processing, and secure semantic layers for reporting. Get fast, precise matching with vetted, available freelancers.
Meet FRATCH Experts in Germany, who have recently used SQL Server Analysis Services
Umut Gülac
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.
Alexander Bromberg
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
Moez Seyedan
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
Guido Klein
Last position:
NOBILIS Group GmbH
- Support during SSRS implementation, including training employees on SSRS
Monika Thepale
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.
Matthias Wähler
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 Avdibegovic
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
Stefan Wimmer
Last position:
Architect/Software Developer at Global Logistics Support GmbH
Task
- Further development of a new ERP system with Blazor
- Creation of e-invoices in the XRechnung and ZUGFeRD formats
- 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
Franziska Meyndt
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
Mario Techera
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.
Olga Methner
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)
Philipp Gies
Last position:
BI Consultant at accantec information solutions AG
Energy Management (2023-08-01 – present):
Designing a planning solution to improve energy efficiency
Creating a concept for an energy management system
Planning a measures planning component to gradually reduce energy consumption
Evaluating planned measures by assessing opportunities, risks, and effectiveness for integration into planning
Defining requirements for a data model to compare planned vs actual data in the dashboard
Consulting (2023-05-01 – present):
Expanding accantec PerCon permission management to IBM Planning Analytics
Analyzing permission requirements and aligning with IBM Cognos Analytics and Tableau
Extending accantec PerCon with IBM Planning Analytics via REST API
Printing (2023-04-01 – present):
Supporting the rollout of a data warehouse solution with IBM Cognos Analytics 11
Assisting in the introduction of a reporting system based on a standard data warehouse
Supporting report developers and creating custom controls to optimize the user interface
Healthcare (2020-08-01 – 2023-03-31):
Optimizing, extending, and operating a long-standing BI planning landscape
Upgrading the Jedox solution from version 2019.1 to 2022.2
Optimizing ETL processes and reports, and implementing automated ETL
Connecting various accounting and management systems
Writing back completed plans to source systems and implementing complex allocation logic
Building and maintaining dimensions and hierarchies (company structure, P&L)
Developing planning scenarios for FP&A and creating budget monitoring reports
Designing and implementing new OLAP cubes and reporting
Conducting user trainings based on customer requirements
Industrial sector (2020-04-01 – 2020-12-31):
Migrating and optimizing an existing Jedox solution
Merging reporting and planning systems in Jedox
Building a central group reporting with plan vs actual comparison for FP&A
Optimizing metric calculations, existing reports, and creating new reports
Producing forecast reports, managing permissions, and training users in an international setting
Finance (2020-05-01 – 2023-03-31):
Enhancing and operating an existing Jedox solution
Designing and developing new OLAP cubes for controlling
Building hierarchies in dimensions (e.g., P&L) and updating the Jedox system in a Linux environment
Conducting user trainings for report creation
Trade fair (2020-06-01 – 2023-03-31):
Designing and developing a BI planning solution in Jedox with a data warehouse setup
Creating ETL processes to load dimensions and OLAP cubes
Building reports, planning input forms, and implementing business logic (P&L, allocation logic)
Implementing planning and analysis reports, as well as a security concept in Jedox
Industrial sector (2021-03-01 – 2023-03-31):
Migrating and optimizing an existing Jedox solution
Upgrading the Jedox solution and migrating ETL processes from Pentaho Kettle to Jedox Integrator
Optimizing SQL queries, analyzing the system, removing redundancies, and developing new ETL processes
Reviewing and adjusting existing reports
Staffing services (2022-07-01 – 2022-10-31):
Migrating a Jedox solution from version 5 to 2022.2
Performing a system update with configuration adjustments and performance issue analysis
Optimizing the OLAP database by streamlining dimensions and removing unused cubes/data
Finance (2021-10-01 – 2022-02-28):
Creating OLAP cubes in Microsoft SSAS
Building dimensions and hierarchies, and calculating metrics with MDX
Supporting users with Power BI requests
Vincent Rothländer
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
Henok Abraham
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é Beran
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
Discover over 15,000 top freelancers
Statistics of experts using SQL Server Analysis Services
Aggregated from the professional profiles of matched freelancers.
Experience
20 years
Position duration
2.6 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
88%
Master's degree or higher
62%
Doctorate
8%
Certifications per freelancer
3
Most common languages
German, English, French
Speak two or more languages
94%
Based on our profile pool as of 30 Aug 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 30 Aug 2026. Actual rates may vary depending on seniority level, experience, skill specialization, project complexity, and engagement length.
About the technology
What SSAS does
SQL Server Analysis Services, often called SSAS or just Analysis Services, turns raw warehouse data into a trusted semantic layer for reporting and self-service BI. It powers tabular models and multidimensional cubes that give teams consistent measures, hierarchies, and calculations.
Typical deliverables
- Tabular models for Power BI and Excel reporting
- Multidimensional cubes for complex analysis
- DAX and MDX measures, KPIs, and calculations
- Processing, partitions, and aggregation design
- Security roles and row-level access rules
Ecosystem and skills
Strong specialists work across SQL Server, Visual Studio, SSDT, Azure Analysis Services, Power BI, and related data warehouse layers. They need solid SQL, dimensional modeling, performance tuning, and a clear way of translating business logic into reusable measures.
When companies bring in help
Teams usually need freelance expertise when a model is slow, reporting logic has spread across many files, or an older cube needs to be moved to a tabular design. They also bring in specialists for upgrades, model reviews, and support during a BI rollout in Germany where business users want reliable English or German documentation.
What good work looks like
A strong SSAS professional writes clean measures, keeps naming and relationships consistent, and designs models that are easy to refresh and extend. They test processing, check query patterns, and keep business rules in the model instead of hiding them in reports.
Common project signs
- Reports return different numbers in different tools
- Refreshes take too long or fail often
- DAX or MDX logic is hard to maintain
- A cube or model needs redesign after growth
- Security rules need to be clarified and tested
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 analytical models that sit between source systems and reporting tools. It is commonly used for tabular models, multidimensional cubes, and business logic that must stay consistent across dashboards and Excel reports.
SSAS is still a strong choice when a company needs a shared semantic layer, deeper governance, or a model that multiple tools can reuse. Power BI data models can cover simpler cases, but Analysis Services is often chosen when the logic, security, and structure need to be managed more centrally.
A strong SQL Server Analysis Services specialist usually also knows SQL, data warehouse design, DAX, MDX, and performance tuning. Experience with Power BI, Visual Studio, SSDT, and refresh or deployment processes is also valuable because the model rarely lives alone.
Projects need Analysis Services expertise when reporting numbers do not line up, a model is slow, or a cube needs to be refactored. It also matters when a team inherits an older SSAS solution and needs help understanding the business rules before making changes.
In SQL Server Analysis Services, tabular models use a relational style with DAX, while multidimensional models use cubes, dimensions, and MDX. Tabular is often easier to work with for modern BI, while multidimensional still fits some complex legacy analytic structures.
Yes, SSAS work is often suited to remote collaboration because model reviews, DAX changes, and query tuning can be done through shared environments. For sensitive data or tight governance, some teams in Germany prefer a hybrid setup with occasional on-site sessions.
Look for clear model design, stable processing, readable measures, and a calm approach to troubleshooting. A good SQL Server Analysis Services professional explains trade-offs, documents assumptions, and can show how the model supports the business, not just the tool.
Before hiring for SSAS, prepare source system details, sample reports, business definitions, and access to the current model or cube. The faster a specialist can see the data flow and the reporting pain points, the faster they can improve the design.
The average hourly rate of freelancers in Germany who have used SQL Server Analysis Services in their recent projects is 104 €, which corresponds to a daily rate of about 831 € based on an 8-hour working day.
Of the freelancers in Germany who have used SQL Server Analysis Services in their recent projects, 88% hold at least a Bachelor's degree, 62% hold at least a Master's degree, and 8% hold a doctorate.
On average, freelancers in Germany who have used SQL Server Analysis Services in their recent projects have 20 years of professional experience, with a single engagement typically lasting around 2.6 years.
The most common languages among freelancers in Germany who have used SQL Server Analysis Services in their recent projects are German (100%), English (94%), and French (25%).
The most common industries among freelancers in Germany who have used SQL Server Analysis Services in their recent projects are Information Technology (89%), Banking and Finance (64%), and Professional Services (64%).
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 (97%), and Project Management (72%).
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
