Excel Power Query & VBA Expert (Consolidation Template Developer)

Excel Modeller

interactive, VBA-enhanced Excel application

Key Responsibilities

• Design the overall

  data architecture and file structure

  for the Excel-based consolidation environment.
• Build the

  group consolidation workbook

  using Power Query, Power Pivot, VBA automation, and structured Excel tables through multiple iteration rounds together with our group accounting experts.
• Implement

  dynamic data imports

  from all entity workbooks via Power Query.
• Develop and automate

  consolidation logic

  (aggregation, FX conversion, intercompany elimination, equity consolidation) in collaboration with our group accounting experts.
• Create

  VBA-driven workflows and control macros

  , e.g. one-click refresh, validation, consolidation, and reporting routines.
• Develop

  reporting templates

  (P&L, Balance Sheet, Cash Flow, eliminations summary) and automate report generation (PDF/XLSX export).
• Establish

  data quality controls

  and ensure a complete

  audit trail

  .
• Prepare

  technical and user documentation

  and conduct

  training sessions

  with the finance team.

Qualifications

• Advanced Excel skills

  : Power Query, Power Pivot, structured tables, and dynamic named ranges.

• Strong VBA programming skills

  and ability to build automation routines that make the workbook operate like a small application.
• Basic understanding of

  group accounting and consolidation principles

• Experience building

  multi-entity consolidation models

  in Excel, including FX conversion and intercompany eliminations.
• Basic Knowledge of

  data structures

  ,

  chart of accounts mapping

  , and

  foreign currency translation

  .
• Strong

  analytical, testing, and documentation skills

  with attention to detail and audit-readiness.
• Excellent

  communication and stakeholder management skills

  in English.

Why Join Us?

• Fully remote position:

  Work from anywhere that suits you.

• Flexible engagement:

  You manage your own schedule (contractor arrangement; you are responsible for local taxes and social security).

• Freedom and autonomy:

  We value independence and trust our team to manage their work effectively. A minimum of 5 hours of overlap with

  CEST (Switzerland)

  time zone is required.

• Competitive rate:

  Up to

  USD 30/hour (or local equivalent)

  , depending on experience.