SQL Server Analysis Services Experts in Switzerland
, matched with vetted professionals in minutesHire experts who design tabular and multidimensional models, tune DAX and MDX queries, and connect enterprise data to Power BI and Excel. FRATCH matches you quickly and precisely with vetted, available freelancers.
Meet FRATCH Experts in Switzerland, who have recently used SQL Server Analysis Services
Marco S.
Last position:
MS Power BI Developer at Bayern Facility Management GmbH
Power BI development and administration, training, consulting, data modeling, DAX development
MS Fabric, MS Power BI, DAX
Reinhold S.
Last position:
Senior Software Developer at Hitachi Energy
- Support and further development of the Leegoo Builder
- Handling ad hoc requests
- Definition of rules/attributes and their rules
- Optimizing and managing SQL queries
Rainer S.
Last position:
Microsoft DAT207x Certificate at edX
- Earned the Microsoft DAT207x certificate on edX.
- Completion date: 21.01.2020.
Daniel L.
Last position:
SQL, .NET and VBA Developer at Postfinance AG
- For the internal MIS, which gathers data in a complex, comprehensive system landscape and loads it into a central database via ETL, existing processes and packages had to be maintained and new KPIs analyzed, specified, and implemented.
Oscar M.
Last position:
IT Specialist / DBA at Rothschild Private Swiss Bank
- Act as DBA SME for MS SQL Server and primary contact for MSSQL infrastructure and long-term technology roadmap in a critical 24/7 banking environment
- Maintain and evolve SQL infrastructure and monitoring system across development, test, UAT, and production environments (10 servers, 4 always-active Windows clusters, MSSQL 2014–2022 on VMs hosted by Inventix)
- Automate SQL operations using Brent Ozar scripts, PowerShell, and Inventix cloud script integration
- Build and improve ETL processes and BI applications (Power BI); plan resources and mentor BI team
- Participate in review, delivery, and deployment of database improvements across the software development lifecycle
- Migrate SQL Server instances from 2017 to 2019 and 2022
- Integrate new applications requiring MSSQL databases
- Manage and support on-premise and Azure SQL Server solutions; advise on industry standards, best practices, and creative database solutions
- Develop automation scripts for internal systems using PowerShell and Git
- Monitor systems with Splunk and Grafana; manage alerts, filters, data ingestion, and dashboard configuration
- Collaborate with operations, development, and business teams to identify and resolve operational and performance issues proactively
- Implement new SQL Server technologies such as Query Store, Extended Events, Tuning Advisor, and system traces
- Provide on-call support and regular maintenance during evenings and weekends
- Define and enforce system policies and standards; work closely with application managers, HR, and IT platforms in Switzerland and the UK
- Handle 2nd/3rd level support service requests; document resolutions and cooperate with vendors
- Use internal and external monitoring tools to detect performance trends and implement alerts and processes to prevent database issues
- Document and share knowledge to improve technical understanding across operations and development teams; administer Confluence (installation, configuration, document management, performance, upgrades)
- Work professionally in cross-functional teams to advise, influence, and coach development and operations teams on database topics
Udo W.
Last position:
Julius Bär
Application ownership and further development of test user management (TUM)
Areas of responsibility: Application ownership (Application Ownership / ITSO), application management, incident management, deployment / release management, requirements management, prioritization, further development, automation, and interface management
Technologies: SQL Server, Python, GitLab, UC4, Lieberman, Linux
Responsible for the operation and continuous development of a central application for managing more than 5.000 technical test users and their data.
Gathered and assessed business requirements, independently prioritized further development, and planned and coordinated implementation using agile methods and PI Planning, in close collaboration with the relevant business units and IT teams.
Expanded the central SQL Server database with additional information about test and real users, and integrated further applications through defined interfaces. The modular application used Python-based processing components, with execution and workflows controlled through UC4. This enabled data from different source systems to be automatically transferred, processed, and made available, as well as new test users to be created automatically.
Ensured reliable application operations and continuously optimized and automated existing processes.
Application ownership, modernization, and migration of incident management (TRANT)
Areas of responsibility: Application ownership (Application Ownership / ITSO), application management, incident management, deployment / release management, requirements management, software modernization, migration, interface integration, and quality assurance
Technologies: UC4, Jira, SQL Server, Oracle, Java, Python, Lieberman, Linux, Jai
Responsible for the operation and development of an application that automatically records, processes, and forwards technical incidents in various test environments.
Automated the creation of Jira incident tickets when UC4 workflows were blocked, including routing them to the relevant application managers.
Modernized the application by migrating from Java to Python, moving the database from Microsoft SQL Server to Oracle, and replacing the Jenkins scheduler with UC4.
Integrated the Jira API and used the bank's internal AI solution Jai to support code migration and subsequent validation. Independently and critically reviewed AI-generated results for business and technical accuracy.
Shift lead for operations control in test environments
Areas of responsibility: Monitoring various test systems
Technologies: UC4, TSO, HOST, Azure-Cloud
Responsible for monitoring and controlling automated processing workflows in various test environments, including systems running in the Azure-Cloud.
Monitored UC4 and HOST workflows and analyzed and handled incidents. When processing workflows were blocked, Jira tickets were automatically created through TRANT and assigned to the relevant application owners. In coordination with them, affected jobs were restarted or stopped as needed. HOST processes were also monitored and controlled through OPC.
A multi-shift operation was introduced to ensure stable and as continuous as possible testing.
Test data anonymization manager
Areas of responsibility: Planning/anonymizing/publishing production data for test systems
Technologies: UC4, Informatica (PowerCenter and IDMC)
To ensure test environments could run with real data, production databases were cloned regularly. Production data had to be untraceable in test environments. For this reason, the cloned databases were first anonymized with Informatica PowerCenter and later with Informatica IDMC. Critical tables and columns in the various databases (Oracle, SQL-Server, MongoDB) had to be identified and analyzed at the data level. Rules for handling critical data were agreed with the application owners.
Discover over 15,000 top freelancers
Statistics of experts using SQL Server Analysis Services
Aggregated from the professional profiles of matched freelancers.
Experience
27 years
Position duration
2.3 years
Positions per freelancer
19
Top business areas
Business Intelligence, Information Technology, Project Management
Top industries
Information Technology, Banking and Finance, Insurance
Certification focus areas
Information Technology, Business Intelligence, Project Management
Bachelor's degree or higher
100%
Master's degree or higher
100%
Certifications per freelancer
7
Most common languages
German, English, Spanish
Speak two or more languages
100%
Based on our profile pool as of 29 Oct 2026.
Daily rate distribution
The chart shows how the daily rates of experts in this technology in Switzerland are distributed, based on recent contracts on our platform. Each bar covers a rate range — its height shows the share of experts charging within that range.
Average rates of experts in Switzerland 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 29 Oct 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 (100%)
- Banking and Finance (67%)
- Insurance (67%)
- Manufacturing (67%)
- Telecommunication (67%)
- Energy (50%)
- Professional Services (50%)
- Aerospace and Defense (33%)
Please note that freelancers can work across multiple industries, so percentages overlap.
About the technology
Analytical models
SQL Server Analysis Services, commonly called SSAS, is Microsoft’s analytical engine for turning operational data into governed models. It supports tabular and multidimensional models that serve interactive reporting, dashboards and self-service analysis. Models can be hosted on premises or in supported cloud-connected environments.
Tabular and multidimensional
Tabular models use in-memory or DirectQuery storage, relationships, measures and DAX calculations. Multidimensional models use cubes, dimensions, hierarchies and MDX. The right approach depends on data volume, existing investments, query patterns, governance needs and the reporting tools already used by the business.
Microsoft ecosystem
SSAS works closely with SQL Server, Azure services, Power BI, Excel and SQL Server Data Tools. Strong specialists also understand:
- Data warehouses, star schemas and incremental processing
- DAX, MDX, calculation groups and row-level security
- Tabular Editor, deployment pipelines and source control
- Monitoring, partitioning and processing automation
When companies need help
Companies bring in freelance expertise when a model is slow, difficult to maintain or no longer reflects business rules. Specialists can modernize a multidimensional cube, migrate workloads to tabular models, or establish reliable deployment practices. In Switzerland, remote delivery is common, while regulated or complex data environments may require workshops on site.
- Rework unclear measures and inconsistent definitions
- Improve processing and query performance
- Connect SSAS models to Power BI and Excel
- Document and secure shared business logic
What strong specialists deliver
Effective professionals start with the reporting questions and the source data, not with isolated measures. They create a clear semantic layer, validate results with business users and explain trade-offs between storage modes and model designs. They also leave behind documentation, tests and repeatable deployment steps.
Selecting the right professional
Look for specialists who can show how they diagnosed a slow model, handled changing dimensions and protected sensitive data. Ask how they test DAX or MDX, manage processing failures and coordinate with data warehouse teams. For Swiss organizations, language fit, time-zone overlap and experience with on-site collaboration can matter alongside technical depth.
Frequently asked questions
Quick answers to the questions that come up most around SQL Server Analysis Services.
SQL Server Analysis Services is used to create governed analytical models for reporting, dashboards and business analysis. It centralizes measures, hierarchies, calculations and security so tools such as Power BI and Excel can use consistent definitions.
SSAS provides a dedicated analytical model layer that can serve multiple reporting tools and applications. Power BI semantic models are closely integrated with the Power BI service, while SSAS can suit organizations that need broader control over hosting, reuse, governance or existing SQL Server investments.
SQL Server Analysis Services tabular models are often preferred for modern semantic modeling with DAX and Power BI. Multidimensional models remain relevant when a company relies on established cubes, complex MDX logic or existing reporting workloads that would be costly to redesign.
A strong SQL Server Analysis Services specialist usually understands SQL Server, dimensional data warehousing, ETL, Power BI and Excel connectivity. Useful adjacent skills include DAX, MDX, Tabular Editor, Azure data services, source control and deployment automation.
SSAS work can be straightforward when the warehouse and business definitions are already stable, but complex models need proven analytical modeling experience. For a serious engagement, assess whether the professional has handled performance tuning, security, processing design and validation with business users.
SQL Server Analysis Services projects can often be delivered remotely through secure access, shared documentation and regular workshops. On-site collaboration may still help when teams must map sensitive data, resolve unclear business definitions or coordinate closely with Swiss stakeholders.
Ask a SQL Server Analysis Services professional to explain a model they designed, including grain, relationships, calculation logic and processing strategy. Good answers connect technical choices to user needs and cover testing, performance evidence, documentation and long-term maintainability.
SQL Server Analysis Services assignments often involve more than writing DAX or MDX. Professionals may need to clarify business definitions, profile warehouse data, coordinate with Power BI teams, manage deployments and communicate model limitations to non-technical stakeholders.
The average hourly rate of freelancers in Switzerland who have used SQL Server Analysis Services in their recent projects is 103 €, which corresponds to a daily rate of about 824 € based on an 8-hour working day.
Of the freelancers in Switzerland who have used SQL Server Analysis Services in their recent projects, 100% hold at least a Bachelor's degree and 100% hold at least a Master's degree.
On average, freelancers in Switzerland who have used SQL Server Analysis Services in their recent projects have 27 years of professional experience, with a single engagement typically lasting around 2.3 years.
The most common languages among freelancers in Switzerland who have used SQL Server Analysis Services in their recent projects are German (100%), English (100%), and Spanish (50%).
The most common industries among freelancers in Switzerland who have used SQL Server Analysis Services in their recent projects are Information Technology (100%), Banking and Finance (67%), and Insurance (67%).
The most common business areas among freelancers in Switzerland who have used SQL Server Analysis Services in their recent projects are Business Intelligence (100%), Information Technology (100%), and Project Management (83%).
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.
Countries:
Zurich Geneva Basel Bern 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
