ICT Senior Associate – Data Architect & Developer

The Product Management Unit at ICTS is responsible for delivering innovative, best-in-class IT products and integrated solutions to the United Nations.

Under the overall supervision of UNOPS Senior Programme Manager or an assigned person, the main role of the ICT Senior Associate – Data Architect & Developer is to work with the client in UNOG to analyze, design and develop best in class business analysis, IT products and decision support tools, as well as support those tools to increase efficiency of manual administrative process steps and facilitate timely and cost-effective process execution. 

The ICT Senior Associate – Data Architect & Developer will be responsible for the following duties:

Summary of Key Functions: 

1. Business Analysis and Data Architecture Support
2. Development and Quality Assurance Support
3. Documentation, Training, Maintenance and Support 

Expected Results:

1. Business Analysis and Data Architecture Support

• Implements and monitors projects involving feasibility studies, data and systems analysis improvement, development and implementation of data, reporting and business intelligence solutions.

• Organizes and performs unit and integrated testing, designing and utilizing test bases; assists users in acceptance testing.

• Provides guidance to clients, analyzing clients’ requirements and support in translating these into new data and analytics products; determines systems integration and linkage issues.

• Researches, analyzes and evaluates new technologies and makes suggestions to supervisor for their deployment.

• Participates in writing reports and papers on systems-related topics, system requirements, information strategy, etc.

2. Development and Quality Assurance Support 

• Develops detailed system and other functional specifications and user documentation for major systems.

• Designs and builds data models/databases, data warehouses and tools to integrate and store data from several sources. Support in designing and implementing ETL processes.

• Maintains, upgrades or enhances existing user systems; troubleshoots and provides continuing user support, to include resolving difficult problems, advising on the use of new techniques, monitoring transactions to measure performance and continued effectiveness of assigned systems, etc. 

• Develops and maintains computer programs that require integration of many interrelated systems and program elements; ensures appropriate data security and access controls considering both local and wide area issues.

• Creates visualizations and reports for requested projects using different Business Intelligence and reporting tools. 

3. Documentation, Training, Maintenance and Support 

• Develops training materials, operating and user manuals; trains staff in assigned systems prepare disaster recovery plans and ensures appropriate planning and training of those responsible.

• Provides guidance to, and may supervise, new/junior staff, consultants, etc. Other tasks and responsibilities relevant to the scope of work as assigned.

Perform other duties as may be reasonably required and in line with the incumbent’s scope of services above.

Impact of Results 

The result of the work of the ICT Senior Associate – Data Architect and Developer impacts directly on delivery of services that satisfy the requirements of the UN Office at Geneva (UNOG). It will also ensure proper processes and methodologies are followed and implemented according to the latest industry standards. The incumbent is responsible for ensuring activities for all UNOG stakeholders are in line with the overall business targets and UN policies, rules and regulations.

Monitoring and Progress Controls

Meetings with supervisor and feedback as necessary.

• Secondary school diploma (or high school equivalent) and seven (7) years of relevant experience are required OR 
• A first-level university degree (undergraduate, Bachelors, or equivalent) preferably in Information Technology, Computer Science, Engineering, Statistics or in a field related to the post description with three (3) years of relevant experience, will be considered an asset.
• ITIL certification is desirable
• PRINCE2 certification is desirable

• Relevant experience is defined as experience in the field of  planning, design, development, implementation and maintenance of computer information systems or related area.
• A minimum of four (4) years of experience in database design, development and maintenance
• A minimum of two (2) years of experience with MS SQL Server, MongoDB, MySQL or PostgreSQL and ETL design and development
• Experience in one or more visualization tools (i.e PowerBI, Qlik, Tableau, etc)

Desirable: (The following experience is optional. Candidates who do not have it are welcome to apply)

• Experience in data warehouse design
• Experience in .Net, and/or Python development
• Experience using APIs for data extraction
• Fluent in Cloud computing (AI/ML, Data solutions, DevOps, Azure, AWS, etc)

• English and French are the working languages of the United Nations Secretariat. 
• For the position advertised, fluency in English (speak, write, read) is required.