Data Management Expert, SC-6

Abu Dhabi, United Arab Emirates
JOB DESCRIPTION
Vacancy Announcement
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.

Competencies:
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.

Eligibility
Candidates must have valid UAE residence visa and Emirates ID and currently
reside within UAE .

Qualifications:
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.

JOB INFO
Job Identification
SC0013
Posting Date
‎07/‎18/‎2023, ‎04:56 AM
Apply Before
‎08/‎17/‎2023, ‎02:59 PM
Locations
Abu Dhabi