VBA Experts in Zurich
to automate office workflows with vetted freelancers matched by AIHire experts who automate Excel reporting, connect Microsoft Office applications and modernize legacy business tools with VBA, Visual Basic for Applications and SQL. FRATCH matches you quickly and precisely with vetted, available freelancers.
Meet FRATCH Experts in Zurich, who have recently used VBA
Jakob F.
Last position:
Core Team Member at Jafa Consulting
- SME for operational processes, contract negotiation and product design for the implementation of a SaaS contact center solution & carrier services
- Definition of several operational processes, organizational setup, ITSM application integrations, creation of contract schedules and advising contract negotiation
- Scrum Master with agile tooling (processes & automation)
- Commercial manager to create business cases and closing the sales process
- Increasing impact, trusted relationship, and key team member within a short time
Piotr S.
Last position:
CTO Program Manager, Theme Owner / Senior Project Manager at Avaloq Group AG
- Clients: Central banks of the most developed economies in the world, German, Swiss, Luxembourgish, Monegasque, Singaporean, Japanese wealth managers and universal/private banks, world’s largest investment banks
- Accountable for managing the delivery of a portfolio of digital wealth and consumer relationship management initiatives
- Project managing portfolios of projects within CTO product and technology business area (cyber security, architectural changes, re-organisational transformation, 3rd party apps)
- Products: Kernel & Parametrisation for Core Avaloq Banking Platform; modules: CRM, client data management, wealth management, portfolio management (generating over 90% of company revenues)
- Key responsibilities:
- Reporting to Head of Disruptive Innovation Division; stakeholder to five product owners & two domain owners
- Accountable for delivery of annual themes and quarterly key deliverables
- Managing demand vs supply via QBR process: book of work, execution, reporting, risk management
- Directly managing around 40 external consultants (front-end/back-end engineers, BAs, designers)
- Hiring and managing resources in eight countries
- Running quarterly divisional closure meetings presenting achievements and challenges
- Resolving cross-team dependencies and internal/external conflicts
- Owning and controlling maintenance budget; planning, forecasting, execution; ensuring demand matches supply
- Identifying and staffing key roles with chapter leads
- Approach: Agile, Scrum of Scrums, QBR/OKRs
- Technology: Angular, PL/SQL, JavaScript, Confluence, JIRA (JQL)
Philipp S.
Last position:
Equity Portfolio Manager - Digital Wealth Management at Interactive Brokers LLC
- Solely responsible for two portfolios totaling USD 1 million with an average monthly performance of 2%
- Responsible for the investment strategy, specializing in US equities and ETFs (exchanges: NASDAQ and NYSE)
- Market, trend, data, and technical chart analysis
- Risk management – diversification, daily/weekly risk mitigation measures (rebalancing) to ensure optimal portfolio profitability
Károly A.
Last position:
NIS2 & Risk Strategy Consultant at RRC power solutions GmbH
- Developed a compliant information security management system (ISMS)
- Advanced a modern risk management framework based on NIST for NIS2 compliance
David B.
Last position:
External Project Manager in the Supply Chain Network at DEUTZ AG
- Project management (SAP BN (Ariba) onboarding, support for SAP ECC and SAP TM for supplier topics)
- Standardization of global value creation processes
- Basic training as well as central contact person for suppliers and support for planners
Csaba K.
Last position:
ServiceNow Consultant at DXC
- Worked in mixed teams with several clients
- Performed requirement engineering, proposal and time estimation
- Developed ACLs, business rules, flows, workflows, catalog items, various scripts, UI actions, policies, scoped applications
- Customized mobile apps: Now Agent and Now Mobile
- Implemented integrations using the Integration Hub
- Coordinated continuously with clients during development
- Performed testing and helped clients with testing
- Deployed to production and applied main version upgrades and patches
- Managed CMDB, domain separation and asset management
- Integrated between instances at different clients
- Developed GlideScript: business rules, scripted REST endpoints, extension points, fix scripts, background scripts
Oliver S.
Last position:
Managing Director and Employed Actuarial Consultant at ARCS Actuarial and Risk Consulting Stoll GmbH
- Advising insurance companies on modeling, reporting, valuations, risk management and acting as the responsible actuary
- 2023–2025: Improving Solvency II software, annual financial statements (HGB, SII), process optimizations, pricing, SQL and Python-based reports for AXA Germany, Cologne
- 2022–2023: Support for portfolio transfer (RAFM optimization; impact on HGB balance sheet, SII, reinsurance; migration to msg.Life Factory) for Zurich Germany, Cologne
- 2021 and 2024: Redesign of Solvency II model, implementation in Python and model extensions; testing and documentation for PK Rück, Zurich
- 2021–2023: Control calculations for maturity benefits of contracts; specification and testing of policy administration system for product launch at Youplus, Liechtenstein
- 2021: a) Support in preparing a reinsurance treaty: project management and analyses; b) assistance with Solvency II reporting and multi-year planning for Allianz Leben, Stuttgart
- 2020–2021: Further development and optimization of models with Risk Agility FM (RAFM), integration into IFRS 17 reporting process using Unify for Allianz Slovakia and Bulgaria
- 2017–2023: Quality improvement of the RAFM model; methodology development; documentation; process optimization in reporting and planning; automation with Excel and Oracle SQL (on COR-Life); implementation of a life reinsurance treaty; validation of numerical results in the policy administration system for SV Versicherung, Stuttgart and Mannheim
- 2015–2017: Project management and senior actuary in developing an actuarial projection tool and in the IMAP process with the regulator; guiding the reporting team; analyses; methodology development; process design; coordination with IT, asset and risk management for Allianz Leben, Stuttgart
- 2016–2020: Review of cash flow models for investment projects for B Capital, Zurich
- 2015: Redevelopment of MCEV calculation methodology based on MVBS; weakness analysis and collaboration on fixes for Allianz SE, Munich
- 2014: Solvency II risk capital reporting project: validation of data deliveries; analyses for management and regulator; tool development; process and documentation improvements; training of team members for Aegon Group, The Hague, Netherlands
Beat Z.
Last position:
SAP Test Manager at E.ON Grid Solutions GmbH
- Responsible for IT integration test and user acceptance test for SAP S/4 Hana and BDO BO Customer Financials Management
- Led the test team (business testers and IT testers)
- Resource planning and control within the test team
- Created test concepts and test plans
- Performed test risk analysis
- Coordinated test execution and defect tracking
- Ensured test progress
- Generated and visualized reports
- Summarized test reports and reported to management
- Prepared and conducted user acceptance tests
- Managed SIGMA and JIRA/Confluence at project level
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.
Viktor D.
Last position:
Application Manager / IT Operations Engineer at SBB
- Coordination and implementation of setting up and further development of applications in close collaboration with external service providers as the internal technical contact person
- Ensuring stable, proper operation and maintenance of business-critical applications to support central business processes
- Analysis, handling, and sustainable resolution of application issues (incidents, problems) including workarounds in 2nd and 3rd level support
- Planning, coordination, and implementation of changes in ongoing application operations according to ITIL processes
- Participation in project teams for maintenance, further development, and integration of interfaces between different applications
- Support in creating, maintaining, and executing test cases as well as assisting with system, integration, and acceptance tests
- Operation, deployment, and maintenance of containerized applications using Docker
- Installation, configuration, integration, and testing of server and application software in virtualized and cloud environments (VMware, AWS)
- Operation and maintenance of virtualized application platforms (Windows Server/Client, VMware, AWS Cloud)
- User, role, and permission management in complex enterprise environments
- Creation and maintenance of technical documentation (operations concepts, changes, projects, interfaces)
- Close collaboration with internal departments, project management, and external partners and suppliers
Discover over 15,000 top freelancers
Statistics of experts using VBA
Aggregated from the professional profiles of matched freelancers.
Experience
23 years
Position duration
2.5 years
Positions per freelancer
13
Top business areas
Information Technology, Project Management, Product Development
Top industries
Professional Services, Banking and Finance, Insurance
Certification focus areas
Information Technology, Product Development, Project Management
Bachelor's degree or higher
78%
Master's degree or higher
67%
Certifications per freelancer
4
Most common languages
English, German, French
Speak two or more languages
100%
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 Zurich 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 Zurich using VBA
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.
VBA experts industry focus
See which industries our matched freelancers work in most often — every figure is calculated live from the freelancers on FRATCH.
- Professional Services (90%)
- Banking and Finance (80%)
- Insurance (80%)
- Information Technology (80%)
- Telecommunication (60%)
- Government and Administration (50%)
- Automotive (40%)
- Transportation (30%)
Please note that freelancers can work across multiple industries, so percentages overlap.
About the technology
What VBA does
VBA, or Visual Basic for Applications, is Microsoft’s scripting language for automating tasks inside Excel, Access, Word, Outlook and other Office applications. Companies use it to turn repetitive spreadsheet work into reliable processes, create tailored forms, validate data and generate reports. It is especially useful when business teams already depend on Microsoft Office and need practical automation without replacing the whole environment.
Office ecosystem
VBA specialists work across the Microsoft Office object model and connect documents, workbooks, databases and email workflows. Their toolkit may include Excel formulas, Power Query, Power Pivot, Access, SQL, Windows file systems and REST or COM integrations. Strong solutions use structured modules, clear references, controlled permissions and reusable procedures rather than isolated macro recordings.
Typical deliverables
- Excel workbooks for financial models, planning and operational reporting
- Automated imports, exports, reconciliations and data-quality checks
- Access applications with forms, queries, tables and reporting workflows
- Office templates that create documents, emails or presentations from structured data
- Interfaces between Office files, databases and internal business systems
When expertise matters
Companies bring in freelance VBA expertise when manual spreadsheet work has become slow, inconsistent or difficult to audit. Specialists can stabilize inherited macros, document undocumented logic and replace fragile copy-and-paste routines with controlled automation. In Zurich, this can support finance, insurance, manufacturing, professional services and public-sector teams working across German- and English-speaking stakeholders.
Modernization choices
VBA remains valuable when users need an interactive Office-based tool and the existing process is deeply embedded in Excel or Access. It may be weighed against Power Automate, Office Scripts, Python, .NET applications or dedicated business software. The right choice depends on security, deployment, integration needs, maintainability and whether the workflow must run outside the Office desktop environment.
Quality signals
A strong VBA professional first maps the business process, data sources and failure points before writing code. They separate interface logic from calculations, handle errors clearly, protect sensitive workbooks and test unusual inputs. They also explain dependencies, provide handover documentation and design for future changes, so another person can maintain the solution after delivery. Remote collaboration works well when requirements, sample files, access rules and acceptance checks are agreed in advance.
Frequently asked questions
Not sure where to start with VBA? These answers cover the essentials.
VBA is commonly used to automate Excel models, reports, data imports, reconciliations and document creation. It can also connect Microsoft Office applications with Access databases, SQL systems, files and email workflows.
Visual Basic for Applications runs mainly within desktop Office applications and is well suited to mature Excel and Access workflows. Power Automate and Office Scripts are often better for cloud-based processes, browser use and centrally managed automation, while VBA can offer deeper control of desktop workbooks.
A strong Microsoft Office VBA professional often understands advanced Excel formulas, Power Query, Access, SQL, data modeling and Windows file handling. Knowledge of APIs, COM, Power Automate or .NET can help when an Office workflow must connect to other systems.
The right level depends on the risk and scope of the workflow. A small macro may need focused spreadsheet expertise, while a business-critical application requires someone who can design modules, manage dependencies, protect data, test edge cases and document the handover.
VBA projects can usually be delivered remotely when the specialist receives clear requirements, sample workbooks and a safe way to test integrations. On-site collaboration may help when the process depends on local files, restricted systems or workshops with several business teams in Zurich.
Ask for examples of maintainable automation rather than only impressive macros. Review error handling, code structure, performance, security, documentation and how the professional tests changes against real business cases.
VBA can often stabilize and improve legacy Excel or Access tools without forcing an immediate replacement. A specialist can remove duplicated logic, improve validation, separate configuration from code and identify where Power Query, Office Scripts, APIs or a new application would be safer.
A VBA professional should clarify the Office versions, data sources, permissions, expected outputs and who will maintain the solution. They should also confirm whether macros are permitted by company policy and agree on test data, deployment steps and acceptance criteria.
The average hourly rate of freelancers in Zurich, Switzerland who have used VBA in their recent projects is 137 €, which corresponds to a daily rate of about 1,099 € based on an 8-hour working day.
Of the freelancers in Zurich, Switzerland who have used VBA in their recent projects, 78% hold at least a Bachelor's degree and 67% hold at least a Master's degree.
On average, freelancers in Zurich, Switzerland who have used VBA in their recent projects have 23 years of professional experience, with a single engagement typically lasting around 2.5 years.
The most common languages among freelancers in Zurich, Switzerland who have used VBA in their recent projects are English (100%), German (90%), and French (40%).
The most common industries among freelancers in Zurich, Switzerland who have used VBA in their recent projects are Professional Services (90%), Banking and Finance (80%), and Insurance (80%).
The most common business areas among freelancers in Zurich, Switzerland who have used VBA in their recent projects are Information Technology (90%), Project Management (90%), and Product Development (70%).
Main locations of FRATCH Experts, who have recently used VBA
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
