03 Jul, 2019

Business Intelligence Developer (Consultant) - Geneva, Switzerland

  • DataCareer GmbH
  • Vernier, Switzerland
Big Data

Töö kirjeldus - job description.

The United Nations Institute for Training and Research (UNITAR) pursues a strong partnership strategy to deliver on its mandate to strengthen the capacities of beneficiaries through training and related activities, with more than two-thirds of training beneficiary outputs delivered in partnership.

Finance and Budget Unit (FBU) is responsible for financial management of UNITAR and provides financial services and advisory role for its clients, namely staff, auditors, collaborators and beneficiaries of UNITAR. In order to efficiently manage resources and better serve its clients, (FBU) rationalizes the development of financial reporting tools to simplify and automate existing processes of financial reporting, building Project closure KPI dashboard, and Payment advisory system using in-house technologies.

Under the supervision of the Chief Finance and Budget Unit, the incumbent will be required to perform services in the design, development and training of the end users of developed applications.

The incumbent will:

1. Design and develop solutions by:

  • Collect user requirements, design, build, financial statements automation model using in-house latest technologies to requiring no on-going user maintenance and superseding prior lengthy, manual process.
  • Develop Project closure KPI Dashboard consisting of tabular views and interactive components to allow selection of different data views.
  • Develop automated payment advisory system using in-house latest technologies.
  • Producing mockups and prototype to give clients an idea of the outcomes of project.
  • Working in a collaborative manner to incorporate the feedback

2. Support and training on tools developed by:

  • Provide interactive support in UAT (Users Acceptance Testing) debugging of models and providing support in testing and enhancing the developed solutions.
  • Provide guide on how to operate and maintain of developed tools.
  • Providing user support and troubleshooting incidents and problems during beta release.
  • Provide recommendations on performance, security, and user interface of the solutions.

Work implies frequent interaction with the following

Managers and focal points of Finance and Budget Unit with whom projects are undertaken in order to discuss the most appropriate solutions for a given set of requirements.

Results Expected

The result of work of the Business Intelligence Developer impacts directly on delivery of services that satisfy the requirements of the Finance and Budget Unit.


Professionalism — Excellent knowledge in the field of Business Intelligence development, particularly of latest BI technologies; very good knowledge of general IT concepts and techniques. Working experience in the following:

  • Proficiency in development of BI solutions using Power BI
  • Front-end development of interfaces using Microsoft technologies.
  • Experience in Microsoft Office 365 platform and SharePoint web services/APIs
  • Experience in cross application programming using VBA
  • Proficiency in “M” Query language
  • Proficiency in DAX and MDX expression
  • Ability to produce mockups and design user interfaces
  • Ability to query databases and model data
  • Working knowledge of Office.JS

Planning & Organizing — Sound planning and organizational skills and ability to prioritize own work, delivering results and quality work, including when working under pressure.

Communications — Excellent communication skills (spoken, written and presentation), including the ability to draft/edit a variety of written documents, such as proposals for solutions to develop, and documentation of components and packages used in projects.

Technology awareness — Fully proficient in computer skills, with ability to use a variety of software and applications.

Teamwork — Strong interpersonal skills; ability to deal effectively with multiple constituencies and to establish and maintain effective working relations in a multi-cultural, multi-ethnic environment with sensitivity and respect for diversity.


Minimum requirements


High School Diploma with required skills in advanced Microsoft Excel, Power BI tools , Office 365 and VBA, developed and demonstrated through professional work experience, project work and/or consultancy assignments.


Minimum 4-5 years’ experience in the area Business Intelligence development and IT support.


Fluency in oral and written English is required.

Desired requirements

Knowledge of French or another official UN language would be an advantage.

Performance Indicators for Evaluation of Results

  • All deliverables submitted within the established timeframe
  • Polit testing and release of specified tools for use to the satisfaction of the Unit personnel

Reporting structure

The consultant will report directly to the Chief, Finance and Budget Unit.

General conditions of contracts for the service of consultants shall apply.

How to apply

All applicants are strongly encouraged to apply as soon as possible after the vacancy has been posted and well before the deadline stated in the vacancy announcement.

Expressions of interest should include a letter of motivation and Curriculum Vitae and be sent to: fbu@unitar.org with the following subject line: 

Olen huvitatud