VBA Experts in Switzerland
in minutes with vetted, available freelancers matched by AIHire experts who automate Excel workflows, build Access databases and connect Office files to business systems. FRATCH matches you quickly and precisely with vetted, available freelancers who fit your VBA requirements.
Meet FRATCH Experts in Switzerland, who have recently used VBA
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
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
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
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
Frank G.
Last position:
Project Lead at Flamingo Med Solutions
- Led the founding of a startup for AI-based consulting products for dental practices.
- Developed and launched PraxisScore, a data-driven consulting product for economic analysis and corporate consulting of dental practices.
- Held full responsibility for technical implementation, AI integration, and structured startup setup from product idea to public launch at IDS 2025 in under three months.
Thorsten O.
Last position:
Program / Project / IT Controller (ICT Controller) at Federal Department of Defence, Civil Protection and Sport
Project Management Office: analysis and setup, master plan, standardized project planning (generic work breakdown structure according to HERMES), earned value management, milestone trend analysis.
Finance management at portfolio, program and project level.
Resource management and single point of contact for resource procurement (human resources / operating costs / investments).
Process management.
Implementation of a program management tool for unified program and project management.
Program controlling: finance management, earned value management, milestone trend analysis, consolidation of project budgets, actual costs and forecasts at the program level.
Variance analyses at program level.
Transition from total cost view to commitment credit view (federal administration terminology).
Calculation of available reserves (rolling), forecasts and scenarios.
Monthly, quarterly, half-year and annual reports, preparation of annual planning at program level, special analyses / ad-hoc reports.
Project controlling: support for project managers in project planning, earned value management, milestone trend analysis.
Review of projects for budget compliance, adherence to phases and schedules, deliverables, resource planning and deployment.
Variance analyses at project level, special analyses / ad-hoc reports.
Resource management: resource planning based on program and project plans, review of timesheets.
Supply chain (until April 2022): single point of contact for resource procurement (human resources / operating costs / investments).
Change management: involvement in change management for cost-relevant changes (change requests), tracking of service contract price for contract-related changes, participation in change control boards / decision boards at management level.
Establishment of controlling structures in a new Swiss federal agency (becoming a federal office as of January 1, 2024) since April 2022.
Credit monitoring with validation of actual costs and commitment values.
Resource management: cross-project resource planning (HRP).
Earned value analysis and milestone trend analysis for key ICT projects of the federal government.
Participation in the introduction of the JIRA Tempo module.
Tools & methods: HERMES 5.1 / Agile HERMES, Sciforma 7, JIRA, Confluence, Tempo, Signavio, Microsoft SharePoint, Microsoft Office Prof., Excel-VBA.
Jürgen A.
Last position:
Requirements Engineer / System Engineer at CCC Systems Engineering Suisse GmbH
- Supported design, setup, maintenance and enhancement of IBM Rational DOORS (9.6 and DNG) and IBM Rational Publishing Engine
- Conceived IT solutions and implemented them, including acceptance tests, considering customer-specific requirements
- Ensured functionality of tools and systems in scope
- Identified needs and advised departments and projects, designed single solutions when necessary
- Monitored and maintained central requirements engineering systems (servers, software, subcomponents)
- Advised on tool selection, features and application use cases for engineering applications
- Handled support requests from employees, customers and development teams autonomously
- Created system documentation and user guides
- Participated in cross-departmental IT projects and led subprojects
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
Reto B.
Last position:
Managing Director at Atsoft GmbH
- Consulting in ICT, business processes, system architecture, web integration, client-server computing, cross-platform development, responsive web design, social media integration, GUI
- Custom and specialized solutions
- Applications for small and medium-sized enterprises
- Web services, web applications, portals, application extensions (add-ins, plug-ins)
- Database design, interface solutions
- Outsourcing in various industries
- Solutions for other software houses
- Project management and project support (software engineering, coding)
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
Rainer S.
Last position:
Microsoft DAT207x Certificate at edX
- Earned the Microsoft DAT207x certificate on edX.
- Completion date: 21.01.2020.
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
Discover over 15,000 top freelancers
Statistics of experts using VBA
Aggregated from the professional profiles of matched freelancers.
Experience
25 years
Position duration
2 years
Positions per freelancer
18
Top business areas
Information Technology, Project Management, Business Intelligence
Top industries
Information Technology, Professional Services, Banking and Finance
Certification focus areas
Information Technology, Project Management, Product Development
Bachelor's degree or higher
71%
Master's degree or higher
64%
Doctorate
7%
Certifications per freelancer
7
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 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 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.
- Information Technology (90%)
- Professional Services (75%)
- Banking and Finance (65%)
- Manufacturing (60%)
- Government and Administration (60%)
- Insurance (50%)
- Telecommunication (50%)
- Automotive (35%)
Please note that freelancers can work across multiple industries, so percentages overlap.
About the technology
Office Automation
VBA, short for Visual Basic for Applications, is the programming language built into Microsoft Office. It lets teams automate Excel models, generate Word documents, manage Outlook workflows and create repeatable processes inside familiar business files. VBA is often used where desktop productivity tools remain central to daily operations.
Typical Deliverables
- Excel workbooks with formulas, forms, macros and validation
- Automated reports, dashboards and document generation
- Access databases with queries, forms and data workflows
- Imports and exports using CSV, XML, SQL or API connections
- Office solutions that reduce manual handoffs and errors
Ecosystem Skills
Strong VBA specialists understand more than macro syntax. They work with the Excel object model, UserForms, PivotTables, Power Query and Power Pivot, and may connect Office applications with SQL Server, SharePoint or ERP data. Knowledge of Visual Basic, COM, Windows security and Microsoft 365 helps when a solution must work across a wider environment.
When Expertise Helps
Companies bring in freelance VBA experts when a critical workbook has become difficult to maintain, reporting depends on repetitive manual steps or a department needs a tailored internal tool quickly. In Switzerland, this can include finance, insurance, manufacturing, logistics and professional services teams. Remote work is often practical, provided access, data protection and Office versions are coordinated.
Quality Signals
- Clear module structure, naming and documentation
- Error handling, input validation and safe recovery paths
- Tests using realistic workbooks and edge cases
- Awareness of calculation speed, file locking and version control
- A migration view when VBA should later connect to web or cloud tools
Collaboration Fit
The right professional first maps the business process and its data sources before writing macros. They clarify who owns the workbook, how updates are released and what happens when a user changes a template. For distributed Swiss teams, concise documentation and clear communication in the required working language matter as much as technical delivery.
Frequently asked questions
Everything clients usually want to know about VBA, in one place.
VBA is commonly used to automate Excel calculations, reporting, data preparation and document workflows. It can also coordinate tasks across Excel, Word, Outlook and Access, especially when a company already relies on Microsoft Office.
VBA is often the most direct choice when the process already lives inside Excel or another Office file. Python is usually stronger for larger data workflows and broader integrations, while Power Automate suits cloud-based process orchestration; the right option depends on data, security and maintenance needs.
A strong VBA specialist may also work with SQL, Access, Power Query, Power Pivot, SharePoint, REST APIs and Microsoft 365. Familiarity with Excel’s object model, COM, Windows permissions and source control is valuable for solutions that must remain reliable beyond one workbook.
The required experience depends on the risk and scope of the solution. A simple macro may need focused Office automation knowledge, while a multi-user Access system or financial model requires proven design, testing, security and support practices.
Yes, many VBA projects can be delivered remotely through secure file access, screen sharing and structured reviews. Swiss companies should agree early on data handling, Microsoft Office versions, access rights and the language used for documentation and meetings.
A company should reassess VBA when a process needs browser access, high concurrency, extensive audit trails or integrations that Office cannot support safely. Extending an existing solution can still be sensible when users depend on Excel and the code can be tested, documented and governed.
Ask whether the VBA solution has clear structure, meaningful error handling, input validation and tests for unusual cases. Review its performance with realistic files, its behaviour when paths or templates change, and the quality of its documentation before accepting the work.
Before starting a VBA assignment, clarify the Office versions, workbook ownership, data sources, user roles and delivery environment. Also confirm whether the goal is a one-off automation, a maintained internal application or a step toward a different technology.
The average hourly rate of freelancers in Switzerland who have used VBA in their recent projects is 124 €, which corresponds to a daily rate of about 993 € based on an 8-hour working day.
Of the freelancers in Switzerland who have used VBA in their recent projects, 71% hold at least a Bachelor's degree, 64% hold at least a Master's degree, and 7% hold a doctorate.
On average, freelancers in Switzerland who have used VBA in their recent projects have 25 years of professional experience, with a single engagement typically lasting around 2 years.
The most common languages among freelancers in Switzerland who have used VBA in their recent projects are English (100%), German (95%), and French (45%).
The most common industries among freelancers in Switzerland who have used VBA in their recent projects are Information Technology (90%), Professional Services (75%), and Banking and Finance (65%).
The most common business areas among freelancers in Switzerland who have used VBA in their recent projects are Information Technology (95%), Project Management (85%), and Business Intelligence (75%).
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.
Zurich 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
