Secretariat of the International Renewable Energy Agency (IRENA)
Knowledge, Policy and Finance Centre (KPFC)
Publication/Transmission Date: 18 July 2023
Deadline for Application: 17 August 2023 (at midnight, Abu Dhabi local time)
Position Title: Data Management Expert, SC-6(Service Contract – Local Recruitment)
Annual Gross Remuneration: AED 197,400.00 to AED 299,400.00
Duration of Contract: 12 months
Duty Station: Abu Dhabi, United Arab Emirates
Date for Entry on Duty: As soon as possible
The International Renewable Energy Agency (IRENA) is an inter-governmental organization headquartered in Abu Dhabi, mandated to promote the widespread and increased adoption and sustainable use of all forms of renewable energy in the pursuit of sustainable development, energy access, energy security and low-carbon economic growth and prosperity. IRENA’s mission is to play a leading role in the ongoing transformation of the global energy systems as a centre of excellence for knowledge and innovation, a global voice of renewable energy, a network hub for all stakeholders and a source of advice and support for countries. At present, IRENA has 168 Members (167 States and the European Union) that acceded to its Statute, and 16 additional States in the process of accession and actively engaged.
With its mandate that focuses primarily on renewable energy and our broad membership, IRENA plays a critical role in examining and verifying global renewable energy statistics information and building an authoritative dataset.
Working as part of the Renewable Energy Statistics team, the consultant will lead the revamp project of the existing data system for the collection, storage and dissemination of global renewable energy statistics. Additionally, the consultant will be in charge of maintaining, monitoring the performance of the database and implementing improvements as needed.
OBJECTIVE: Development, revamp and maintenance of the entire renewable energy statistics data management system and contribute to the wider data products of the statistics team as needed.
Specifically, this will involve participating in the following tasks:
Reviewing, documenting, suggesting, and implementing improvements to the current workflows related to data collection, validation, reformatting, storing and dissemination and the overall data management process.
- Design and develop new workflows based on identified priorities and functionalities including the development of new forms, sheets, access/SQL database queries, functions
- Design and development of the revamped database components including the user interface forms (frontend), and the backend including database tables, forms, queries, relationships based on identified functionalities and priorities
- Migrating the data from the current database environment into the new revamped environment
- Design and develop new questionnaires (data input forms for member states) based on requirements set by the statistics team and in accordance with the reviewed and improved workflows.
- Setting permissions for checking and validating data and the production of statistical reports on the database side and the data input forms.
- Automate routines for the collection and validation of data throughout the workflows.
- Providing support on the production of annual yearbooks of statistics, online data services and other statistical products
- Implementation of improvements to the data dissemination products including query tools, statistics web pages and other data products
- Documentation of all components related to the revamp project including new data workflows, updates made to the questionnaires and the database system (developer and user manuals)
- Contribute to the wider data products of the statistics team as needed.
Professionalism: Knowledge of data management principles and practices. Ability to research, design, develop new features to the statistical data management system including the database with minimal guidance. Ability to identify issues, formulate options and make conclusions and recommendations. Shows pride in work and in achievements; demonstrates professional competence in subject matter and pays attention to detail; is conscientious and efficient in meeting commitments, observing deadlines and achieving results; is motivated by professional rather than personal concerns; shows persistence when faced with difficult problems or challenges; remains calm in stressful situations. Takes responsibility for incorporating gender perspectives and ensuring the equal participation of women and men in all areas of work.
Communication: Speaks and writes clearly and effectively; listens to others, correctly interprets messages from others and responds appropriately; asks questions to clarify and exhibits interest in having two-way communication; tailors the language, tone, style and format to match audience; demonstrates openness in sharing information and keeping people informed.
Client Orientation: Considers all those to whom services are provided to be “clients” and seeks to see things from clients’ point of view; establishes and maintains productive partnerships with clients by gaining their trust and respect; identifies clients’ needs and matches them to appropriate solutions; monitors on going developments inside and outside the clients’ environment to keep informed and anticipate problems; keeps clients informed.
Planning and Organizing: Develops clear goals that are consistent with agreed strategies; identifies priority activities and assignments; adjusts priorities as required; allocates appropriate amount of time and resources for completing work; foresees risks and allows for contingencies when planning; monitors and adjusts plans and actions as necessary; uses time efficiently.
Accountability: Takes ownership of all responsibilities and honours commitments; delivers outputs for which one has responsibility within prescribed time, cost and quality standards; operates in compliance with organizational regulations and rules; supports subordinates, provides oversight and takes responsibility for delegated assignments; takes personal responsibility for his/her own shortcomings and those of the work unit, where applicable.
Candidates must have valid UAE residence visa and Emirates ID and currently reside within UAE.
Education: High school diploma or equivalent. University degree in computer science, information technology or similar discipline is a plus.
Experience: Several years of experience implemented and delivered in data management solutions to clients; Experience in relational databases in cloud-based environments such as MS Azure SQL database; Advanced knowledge and experience in database development and management.
Language: Fluency in oral and written English is required. Knowledge of another official United Nations language is an advantage.
Others: PowerPivot/PowerBI data modelling is a plus; Analytical skills and a high level of attention to detail; Knowledge of the energy sector is an advantage; Working knowledge of Microsoft Access is a plus; Experience in developing queries in SQL programming; Experience in developing web-based front end for databases; Excel templates/formats delivery with VBA; Advanced Excel VBA programming and formulas in Excel; Proven 5+ years of experience in ASP.NET
Qualified candidates must apply for the above-mentioned vacancy on-line, through IRENA’s recruitment platform, ORC, including a complete and comprehensive CV and a letter of interest and details of three professional references who will be contacted if their application is shortlisted.
Applications from qualified women, especially from nationals of developing countries, are highly encouraged.
Please note that only candidates under serious consideration will be contacted for an interview and will receive notice of the final outcome of the selection process.