Tillbaka till jobb

System Developer – Excel, VBA and Office Conversion

Software EngineeringMid-level
Sweden, SwedenContract · On-site Publicerad 5 november 2026 Ansök senast 12 november 2026
Språk: SwedishMinsta erfarenhet: 4 år

Liam Tran

HR Administrator

cv@veritaz.se

Efterfrågade kompetenser

.NETTypescriptVBAMicrosoft ExcelSASPowershellOffice ScriptsNSS

Om tjänsten

Role Summary

Our client is seeking a System Developer with strong expertise in Microsoft Excel, VBA, and Office Scripts for a consulting assignment within a statistical data environment. The assignment focuses on decommissioning legacy Microsoft Office file formats and enabling an efficient, reliable transition from formats such as .xls and .doc to modern formats such as .xlsx and .docx.

The consultant will provide technical expertise and hands-on support for converting Excel macros, VBA scripts, and related Office-based solutions. The role also involves supporting automated file conversion, interpreting Office file metadata, and helping determine whether macros, VBA, Office Scripts, or other technologies provide the most appropriate long-term solution. Close collaboration with business users, technical stakeholders, and an external system supplier is central to the assignment.

Key Responsibilities

  • Support the conversion of legacy Microsoft Office files, including .xls and .doc files, to modern formats such as .xlsx and .docx.
  • Review, troubleshoot, adapt, and enhance Excel macros and VBA scripts to ensure that existing applications continue to operate correctly after conversion.
  • Develop or modify automation solutions that support efficient and repeatable Office conversion workflows.
  • Participate in the continued development of the NSS system together with its supplier, particularly for file inventory and automated conversion capabilities.
  • Provide technical expertise when converting solutions in which SAS scripts perform statistical processing and the resulting data is subsequently refined or presented in Excel.
  • Develop conversion code and modify existing solutions using technologies such as PowerShell and .NET.
  • Read and use metadata from Office files to provide users with appropriate support during advanced automated file conversion.
  • Assess differences between Excel macros, VBA scripts, and Office Scripts and recommend suitable future-state solutions.
  • Work closely with business users and responsible stakeholders throughout the conversion process.
  • Continuously document implemented changes and provide both written and verbal handover of completed solutions.

Technical Stack & Requirements

  • Microsoft Excel: Strong understanding of Excel functionality, workbook behavior, and advanced features.
  • VBA and macros: Ability to inspect, edit, troubleshoot, and extend code to maintain correct application behavior and automate workflows.
  • Office Scripts: Ability to use the action recorder to capture actions and create scripts, with an understanding of how Office Scripts differ from VBA.
  • TypeScript: Ability to understand TypeScript code used in more advanced Office Scripts.
  • Programming fundamentals: Advanced practical knowledge of variables, loops, conditional logic, and functions.
  • PowerShell and .NET: Ability to develop conversion code and modify existing technical solutions.
  • SAS integration: Ability to support solutions where SAS scripts perform statistical processing and Excel is used for subsequent refinement or presentation.
  • Office file formats and metadata: Understanding of legacy and modern Office formats, conversion approaches, and the extraction and use of file metadata.
  • Security considerations: Understanding of the security differences between VBA, which may have broad access to the local computer, and Office Scripts, which are restricted to workbook access.
  • Cross-platform solution assessment: Ability to evaluate macros, VBA, and Office Scripts and recommend an appropriate technical approach.

Qualifications & Experience

The consultant must have strong practical expertise in Excel, VBA, Office Scripts, debugging, workflow automation, and Office file conversion. The role requires the ability to analyze existing code, resolve defects, adapt legacy solutions, and create new scripts where necessary. The consultant must also be able to communicate effectively with users and collaborate with multiple stakeholders involved in the conversion initiative.

Experience gained within the six years preceding the stated tender deadline of 16 November 2026 is considered advantageous. Preferred qualifications include documented experience with the NSS tool; at least four years of experience with VB scripting and PowerShell; at least four years of technical work with the Microsoft Office suite, including areas such as installation and patching; and at least one year of experience converting Office file formats.

Work Logistics & Location

This is a consulting assignment supporting a client organization operating in the statistical information domain. The source material does not specify a city, workplace arrangement, assignment duration, or remote-working terms. The assignment includes extensive interaction with business users and technical stakeholders, as well as ongoing documentation and structured knowledge transfer.

Intresserad av denna tjänst?

Skicka din ansökan så återkommer vi inom kort.

Ansök nu