
VBA Expert in Zurich
for reliable Excel automation, matched in minutes with vetted and available freelancersHire experts who automate Excel workflows, connect Office applications and maintain business-critical macros. FRATCH quickly matches you with precise, vetted and available freelancers for your VBA project.
Meet FRATCH Experts in Zurich, who have recently used VBA
Oliver S.
Last position:
Managing Director and employed actuarial consultant at ARCS Actuarial and Risk Consulting Stoll GmbH
- Advising insurance companies on modelling, reporting, valuations, risk management and acting as Appointed Actuary
- 2023–2025: Improvement of Solvency II software, annual financial statements (HGB, SII), process optimisation, pricing, SQL- and Python-based reports for AXA Deutschland, Cologne
- 2022–2023: Support with portfolio transfer (RAFM optimisation; impact on HGB balance sheet, SII, reinsurance; migration to msg.Life Factory) for Zurich Deutschland, Cologne
- 2021 and 2024: Redesign of Solvency II model, implementation in Python and model enhancements; testing and documentation for PK Rück, Zurich
- 2021–2023: Control calculations for policy maturity benefits; specification and testing of an administration system for product launch at Youplus, Liechtenstein
- 2021: a) Support in drafting a reinsurance contract: project management and analyses; b) Support with Solvency II reporting and multi-year planning for Allianz Leben, Stuttgart
- 2020–2021: Further development and optimisation of models with Risk Agility FM (RAFM), integration into the IFRS 17 reporting process with Unify for Allianz Slovakia and Bulgaria
- 2017–2023: Quality improvement of the RAFM model; methodology development; documentation; optimisation of reporting and planning processes; automation with Excel and Oracle SQL (on COR-Life); implementation of a life reinsurance contract; validation of mathematical figures in the administration system for SV Versicherung, Stuttgart and Mannheim
- 2015–2017: Project management and senior actuary in the development of an actuarial projection tool and in the IMAP process with the regulator; guidance of the reporting team; analyses; methodology development; process design; coordination with IT, asset management and risk management for Allianz Leben, Stuttgart
- 2016–2020: Review of cash flow models for investment projects for B Capital, Zurich
- 2015: Rebuilding of methodology for MCEV calculation based on MVBS; weakness analysis and support in addressing weaknesses for Allianz SE, Munich
- 2014: Solvency II risk capital reporting project: validation of data submissions; analyses for management and the regulator; tool development; process and documentation improvements; training of team members for Aegon Group, The Hague, Netherlands
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
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
24 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 29 Oct 2026.
Daily rate distribution
The chart shows how the daily rates of experts in this technology in Zurich 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 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 29 Oct 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 and other Office applications. Companies use it to turn recurring manual work into controlled workflows, calculations, reports and user-driven tools without replacing their existing Office environment.
Typical deliverables
VBA specialists create practical solutions that fit how teams already work:
- Excel workbooks with automated calculations, imports and exports
- Macros for reporting, reconciliation and document generation
- Access databases with forms, queries and business logic
- Office workflows that connect Excel, Outlook, Word and SharePoint
Ecosystem and skills
Effective VBA work includes more than writing macros. Specialists understand the Excel object model, ranges, tables, PivotTables, charts, forms, events and error handling. Depending on the solution, they also work with SQL, Microsoft Access, Power Query, Power Automate, APIs, CSV files and data sources used by finance, operations and reporting teams.
When to bring in expertise
Companies often need freelance VBA expertise when a workbook has become a critical but fragile business tool, when manual reporting consumes too much time, or when the original author is no longer available. Zurich companies may also bring in a specialist to document and improve Office processes while coordinating with local teams on site or remotely.
- Replace error-prone copy-and-paste routines
- Stabilize inherited macros and undocumented workbooks
- Prepare repeatable management or regulatory reports
- Connect Office files with databases or external systems
What strong specialists deliver
Strong VBA professionals clarify the business rules before changing a workbook. They use modular code, clear naming, validation, defensive error handling and manageable configuration instead of hidden assumptions. They test realistic data, protect sensitive sheets where appropriate and explain how users can operate and maintain the result.
Choosing a project partner
Ask for examples involving the same Office applications, data volume and workflow complexity as your project. Review how the specialist approaches testing, version control, documentation and handover, not just whether a macro works in one file. For Zurich-based collaboration, agree early on the balance between remote work, on-site workshops and the language needed by business users.
Frequently asked questions
Not sure where to start with VBA? These answers cover the essentials.
VBA is used to automate Excel calculations, reporting, data preparation and document creation. It can also coordinate tasks across Excel, Access, Word and Outlook, especially where existing Office files are already central to daily work.
Visual Basic for Applications is often the quickest option when the process already lives in Excel or another Office application. Power Automate is better suited to cloud-based workflows, while Python is usually stronger for larger-scale data processing, integrations and standalone services.
A strong VBA specialist may also work with SQL, Microsoft Access, Power Query, Power Automate and REST APIs. Knowledge of Excel's object model, data structures, authentication and user permissions helps turn a macro into a dependable business process.
The right level depends on the workbook's complexity, integration needs and business risk. A simple macro may need focused automation skills, while a financial model or shared reporting system calls for a VBA professional who can refactor legacy code, test edge cases and document the design.
VBA work can usually be done remotely when the specialist has secure access to sample files, requirements and test data. On-site sessions in Zurich can still help with process discovery, user training and resolving issues that depend on local desktop settings or internal permissions.
VBA remains useful in desktop versions of Excel and other Office applications, including Microsoft 365 installations. A specialist should check compatibility, especially when files move between Windows and Mac, when 32-bit and 64-bit components differ, or when cloud collaboration changes how workbooks are opened.
Review whether the specialist separates business rules from interface code, handles errors clearly and provides documentation. Ask to see the testing approach, recovery plan and handover materials; reliable VBA work should remain understandable after the freelancer leaves.
VBA projects often involve undocumented workbooks, hidden dependencies and assumptions embedded in formulas or macros. Freelancers should begin with a controlled audit, preserve working behavior where necessary, add tests and agree with stakeholders which parts should be repaired, redesigned or replaced.
The average hourly rate of freelancers in Zurich, Switzerland who have used VBA in their recent projects is 138 €, which corresponds to a daily rate of about 1,101 € 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 24 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:
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!
