
Data Warehouse Experts in Switzerland
for trusted reporting and analytics, matched in minutes with vetted professionalsHire experts who design scalable warehouse architectures, build reliable ELT pipelines and connect tools such as Snowflake, BigQuery, Amazon Redshift and dbt. FRATCH matches you quickly and precisely with vetted, available freelancers.
Meet FRATCH Experts in Switzerland, who have recently used Data Warehouse
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.
Charles S.
Last position:
Data Delivery Lead at Westpac
- Owned and managed the product roadmap and backlog for the Consumer Banker reporting framework, prioritising features and driving iterative delivery of banker scorecards and network performance reporting in an agile environment.
- Developed and iterated portfolio financial reporting on a weekly cadence based on stakeholder feedback, replacing manual PowerPoint packs and saving the program hours of effort weekly.
- Integrated Generative AI (MS Copilot) to automate data lineage documentation across a large legacy codebase, eliminating est. 6 months of analyst effort and accelerating data governance outcomes.
- Led a unified data delivery approach and standards across five UNITE initiatives (~CHF 115m portfolio) supporting consolidation of legacy systems into the Digital Banker platform.
- Led cross-functional delivery team of 3 while also drawing on BA and DA talent pools, coordinating analytical resource across workstreams to accelerate data, reporting & governance outcomes.
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
Claus N.
Last position:
Oracle Database Engineer at BBV.ch
- Migration of databases from ODA to ExaData
- Migration of databases from ExaData to ExaCC/OCI
- Reduced UCC usage by 10%
- Developing automation scripts using Python
- Performance tuning
- Reduced development databases from 6 TB to 3 TB using Exadata columnar compression
- Improved application performance by 30% using the inmemory option
- Improved non-production Exadata performance by 20% to free up CPU resources before ExaCC migration
- Database patching of Oracle 19c
- Basic Ansible scripting for deployments and database cloning
- Developing an accounting model for a shared Oracle platform
- Migrating single-instance databases to Oracle RAC
- Analysis of RAC issues
- Advising development teams on how to migrate to RAC
Revealed U.
Last position:
Executive Enterprise Data & Analytics Advisor at A medium-size private bank
- Responsible for defining and implementing an enterprise Data Governance framework with an initial focus on BCBS-239, including Data Catalog tooling and formalized data asset ownership.
- Led the turnaround and delivery of an Enterprise Data Warehouse to support regulatory and management reporting on a robust, integrated data platform with a primary focus on Finance.
- Served as a key contributor to the bank’s Data, Analytics & AI strategy, which was subsequently approved by the management board.
Rainer S.
Last position:
Data Engineer | Data Analyst | Power BI Architect
Banking project
- Analyzed and built a report store with the related data integration workflows.
- Developed and optimized T-SQL stored procedures and SSIS packages for data preparation and loading.
- Developed Power BI reports and delivered business reporting requirements.
Technologies: SQL Server, T-SQL, SSIS, Power BI, Visual Studio 2022, PowerShell, VBA, .NET
Stefan H.
Last position:
Senior Project Manager at Bechtle Schweiz AG
- Led multiple client projects according to the PRINCE2 standard in the healthcare sector, focusing on migrating existing infrastructures and applications to Bechtle Clouds
- Technologies used: MS Azure, Azure AVD, Exchange Online, SharePoint Online, Intune, Autopilot, Meraki vMX Firewall, and Bechtle Smart Workplace
- Improved and documented project-related processes
Deschances T.
Last position:
Senior Data Architect at Odd Parrot
- Supporting UBS Wealth Management as Senior Data Architect within a multi-year enterprise data mesh transformation.
- Guiding a strategic stream to design and implement a data product aligned with UBS’s enterprise-wide data mesh framework.
- Leading architecture definition, governance alignment, and cross-domain integration to ensure scalable, compliant, and reusable data products across global stakeholders.
- UBS – Global Wealth Management Data Product Architecture: Designed an enterprise-aligned data product spanning 26 countries, defining data contracts, metadata standards, and federated architecture patterns enabling cross-domain reuse across the bank.
- Defined cross-jurisdictional data policies and access controls to ensure compliance with regulatory requirements across multiple regions (EU, APAC, LATAM, CH).
Matthias I.
Last position:
Fractional CTO (Principal Engineer / Technical Architect)
- Designed large-scale systems and APIs serving thousands of concurrent users.
- Refactored a 650k-LOC monolith and led full AWS migration for stable performance.
- Introduced SLO-based observability, improving reliability and recovery flow.
- Optimised cloud and databases, achieving significant cost and latency reduction.
- Delivered LLM, RAG, and document-automation pipelines adopted in production.
Doris N.
Last position:
Expert Consultant at multiprovider gmbh/ASC GmbH/all for one Group
DWH development (backend) for SRG (2022)
Media: redesigned the HR data model to prepare for migration to BW/4HANA
Support and training for HR and controlling reporting solutions
Technologies: SAP BW/4HANA, SAP BW on HANA 7.5, SAP HCM, SAP CO, SAP FI, IBCS, SAP Lumira Design Studio, Graphomate, SAP Fiori Launchpad
DWH development (frontend) for Constellium (2017)
Redesigned reporting according to the IFRS 17 standard
Designed and implemented improvements and automated migration programs
Project “Markt & Publikumsforschung”: blueprint and implementation of BW on HANA data models and reporting based on SAP ERP and third-party data (extraction using CDS views)
Proof of concept for reporting with SAC, Microsoft Power BI, SAP BusinessObjects Design Studio
Proof of concept for replacing Broadcaster with BO Scheduling
Project “Adamant – Profitability Analysis”: blueprint and implementation of BW on HANA data models and reporting with Design Studio using data from SAP CO-PA
Technologies: SAP BW 7.5, SAP BEX Analyzer, SAP BEx Broadcaster, SAP ABAP, SAP BCS, SAP HANA native, Mediapulse, R, REST-API, Confluence, MS Power BI, SAP SAC, SAP BO Design Studio, SAP BO Scheduling and Publications XI 3.0, SAP Lumira Design Studio
Sibylle H.
Last position:
SAP Development ABAP-OO (cross-module) at Asendia
- Created interfaces for transferring SD orders and customer master data (including various protocols and the ability to process erroneous data)
- Analyzed and adapted existing programs due to infrastructure changes
- SOAP and REST API for creating customer master data from SugarCRM
- REST APIs in Json (SD orders, invoices, payments, PDF forms)
- Logging program for REST APIs
- Created various invoice forms in 8 languages, including document links, email delivery, and PDF generation
- Provided data for the data warehouse
- Various user exits and enhancements in SD and FI
- Intercompany sales order creation, program for creating credit memos (uploads from Excel and the server)
- Reports (VAT, sales orders, invoices)
- Correction program for CO data
- Support for various interfaces, Notes, etc.
- Enhancement for Idoc INVOIC02
- XML file upload program (Rydoo) for posting cash receipts to FI (FB01)
- Created dunning forms in various languages (Smartforms and Adobe, including email delivery)
- Account statement program (ALV displaying postings, emailed to accounts receivable as a PDF using Smartform)
Stefan L.
Last position:
Senior Manager, Project Manager, Auditor and Consultant at Laager Consulting GmbH
Many years of experience in application development, ICT infrastructure, systems management, hardware and software, telecommunications, ICT strategies, business models, database management, data center consolidation, support and call center setup
Independent consultant and project manager since 1999: ICT strategies and governance, processes, audits, security, infrastructure (including cloud, DevOps and tools), data and output management, organizational restructuring, business project management and consulting across various industries
Generalist with strong analytical skills and excellent communication at all organizational levels, able to work as a manager, coach, project manager or consultant
Thomas H.
Last position:
Sales Partner at SourceWeb Group
- Consulting and sales in cyber security
Kalin S.
Last position:
Sr Data Engineer / Architect at Samsung Logistics
- Architected and implemented a structured three-layer enterprise data warehouse model in Azure, establishing a robust and scalable data environment.
- Migrated legacy stored procedures to streamlined Azure Data Factory (ADF) pipelines, enhancing data processing efficiency.
- Introduced comprehensive Git-based source control, ensuring rigorous version management and collaborative development practices.
- Established automated data quality frameworks with proactive monitoring and alerting, significantly improving data integrity and reliability.
- Spearheaded the design of an enterprise data model, enabling a self-service BI environment that empowered business teams with advanced analytics capabilities.
- Developed and delivered insightful dashboards and reports in Power BI, transforming raw data into actionable business insights.
- Technologies: Azure Data Factory (ADF), Azure, MS-SQL, DataVault 2.0, Git, Power BI, data quality automation, Agile/Scrum, data modeling, self-service BI, stakeholder management.
Max R.
Last position:
Senior ICT Solution Architect at ewb, Energy, Water
- Clarifying and discussing technical requirements and coordinating with the team
- Contributing to the objectives of the Digital Transformation Services unit and implementing them
- Analyzing, specifying, updating and delivering architecture models to implement digital solutions in line with business, data infrastructure and requirements
- Selecting suitable technical options for application design, considering interoperability, reversibility, scalability, usability, accessibility and security, and optimizing the cost/quality ratio
- Creating and maintaining concept documents, architecture models and other technical documentation
- Reviewing services to be provided and other documents for solution development
- Collaborating with the IT enterprise architect, business analyst, project manager, developers, testers and process owner on the design and documentation of technical specifications for new developments and enhancements
- Communicating concepts to relevant stakeholders and supporting them
- Participating in enterprise architecture activities and ensuring compliance with principles, standards and guidelines
- Monitoring compliance with defined designs at application, solution and enterprise levels
- Developing and testing existing and new solutions as required
- Supporting and guiding development teams in implementing new projects or maintaining existing products, taking on the product manager role if required
- Establishing and ensuring best practices in implementation, documentation, testing and packaging for distribution
- Contributing to the handling of reported incidents and requests assigned to third-level support, and following up as required
Discover over 15,000 top freelancers
Statistics of experts using Data Warehouse
Aggregated from the professional profiles of matched freelancers.
Experience
28 years

Position duration
3.2 years

Positions per freelancer
16

Top business areas
Information Technology, Project Management, Business Intelligence

Top industries
Information Technology, Banking and Finance, Professional Services

Certification focus areas
Information Technology, Project Management, Product Development
Bachelor's degree or higher
84%
Master's degree or higher
68%

Certifications per freelancer
4

Most common languages
English, German, French

Speak two or more languages
100%
Based on our profile pool as of 18 Nov 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 Data Warehouse
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 18 Nov 2026. Actual rates may vary depending on seniority level, experience, skill specialization, project complexity, and engagement length.
Data Warehouse 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 (83%)
- Banking and Finance (78%)
- Professional Services (61%)
- Manufacturing (52%)
- Healthcare (43%)
- Insurance (43%)
- Telecommunication (39%)
- Energy (35%)
Please note that freelancers can work across multiple industries, so percentages overlap.
About the technology
Analytical foundation
A Data Warehouse centralizes structured business data from operational systems, applications and external sources. It prepares consistent information for reporting, dashboards, financial analysis and decision-making. Unlike a transactional database, it is optimized for reading, aggregation and historical comparison.
Modern warehouse stack
Experts work across cloud and on-premises environments, choosing components that fit data volume, governance needs and operating models. Common tools include Snowflake, Google BigQuery, Amazon Redshift, Microsoft Fabric, Azure Synapse Analytics, Databricks and dbt. Strong SQL, dimensional modeling, orchestration and cloud security skills connect these components into a dependable system.
Typical delivery work
- Design star schemas, data marts and governed semantic layers
- Build ELT pipelines from ERP, CRM, SaaS and event sources
- Configure orchestration, testing, lineage and monitoring
- Connect warehouses to Power BI, Tableau, Looker or other BI tools
- Improve query performance, cost control and data freshness
The right architecture makes trusted data available without forcing every team to interpret raw source systems independently.
When companies need specialists
Companies bring in freelance expertise during a warehouse migration, a cloud transformation or a reporting overhaul. Specialists also help when pipelines fail regularly, definitions differ between departments or analysts cannot access complete historical data. In Switzerland, remote collaboration is common, while some regulated or complex environments benefit from on-site workshops and local language capability.
Quality signals
Strong professionals clarify business definitions before choosing schemas or tools. They document source-to-report lineage, separate transformation logic from presentation logic and build automated checks for freshness, completeness and validity. They also understand access controls, retention, privacy and the operational cost of each design decision.
Sustainable ownership
A successful warehouse is maintainable after delivery. Experts create clear models, reusable transformations, deployment processes and practical documentation for internal teams. They leave behind monitoring and incident procedures, explain trade-offs in plain language and ensure that new sources can be added without undermining trust in existing reports.
Frequently asked questions
Questions about Data Warehouse? Start with the answers below.
A Data Warehouse combines information from systems such as finance, sales, customer support and operations. Companies use it for trusted reporting, business intelligence, trend analysis, forecasting and consistent metrics across departments.
A Data Warehouse stores curated, structured data that is ready for analysis, while a data lake can hold raw structured, semi-structured and unstructured data. Many modern architectures use both, with the warehouse serving governed reporting and the lake supporting exploration or data science.
A strong Data Warehouse specialist usually brings advanced SQL, dimensional modeling, ELT, orchestration and data quality practices. Useful adjacent skills include dbt, Python, cloud infrastructure, BI tools, metadata management, identity controls and CI/CD for data pipelines.
The right level depends on the scope, source complexity and compliance requirements. A focused reporting layer may need a specialist who can model data and build pipelines, while a migration or enterprise redesign calls for someone experienced in architecture, governance, performance and stakeholder alignment.
Much Data Warehouse work can be completed remotely because source access, modeling and deployment happen through shared technical environments. On-site sessions can still help with discovery, security reviews and workshops, especially when teams in Switzerland need close coordination or specific language support.
A Data Warehouse platform should be selected according to workload patterns, existing cloud services, security requirements, skills and cost controls. Snowflake, BigQuery, Amazon Redshift, Microsoft Fabric and other options can all work well when the surrounding architecture and operating model are sound.
Ask how the specialist defines business metrics, handles changing source data and tests transformations before release. A capable Data Warehouse professional can show clear lineage, explain trade-offs, plan for monitoring and make the model understandable to both technical and business users.
A Data Warehouse freelancer should clarify source systems, data owners, target users, refresh expectations, security boundaries and the definition of success. It is also important to understand the existing orchestration, deployment process, documentation standard and who will maintain the solution after delivery.
The average hourly rate of freelancers in Switzerland who have used Data Warehouse in their recent projects is 119 €, which corresponds to a daily rate of about 956 € based on an 8-hour working day.
Of the freelancers in Switzerland who have used Data Warehouse in their recent projects, 84% hold at least a Bachelor's degree and 68% hold at least a Master's degree.
On average, freelancers in Switzerland who have used Data Warehouse in their recent projects have 28 years of professional experience, with a single engagement typically lasting around 3.2 years.
The most common languages among freelancers in Switzerland who have used Data Warehouse in their recent projects are English (100%), German (91%), and French (48%).
The most common industries among freelancers in Switzerland who have used Data Warehouse in their recent projects are Information Technology (83%), Banking and Finance (78%), and Professional Services (61%).
The most common business areas among freelancers in Switzerland who have used Data Warehouse in their recent projects are Information Technology (100%), Project Management (87%), and Business Intelligence (83%).
Main locations of FRATCH Experts, who have recently used Data Warehouse
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.
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!

Zurich