Org. Setting and ReportingThe United Nations Joint Staff Pension Fund (UNJSPF) was established in 1949 by the United Nations General Assembly to provide retirement, death, disability, and related benefits for staff of the United Nations and other member organizations of the Fund. UNJSPF administers benefits of more than 90,000 beneficiaries residing in more than 190 countries, paid in 18 currencies, and services more than 130,000 participants who work in the 25 member organizations of UNJSPF. The Fund has offices in New York (United States) and Geneva (Switzerland) and two liaison offices in Nairobi (Kenya) and Bangkok (Thailand), respectively. The United Nations Joint Staff Pension Fund-Pension Administration (UNJSPF-PA) comprises about 282 staff from diverse countries and cultures, based across four prominent duty stations (New York, Geneva, Bangkok and Nairobi). We are a career employer offering unique opportunities for growth within the United Nations system. Our office is located in the heart of Manhattan, within walking distance from the Grand Central Station hub, in a state-of-the-art facility (the One Dag Hammarskjold building). Visit www.unjspf.org for more details. This position is located in the Data Architect Unit, Information Management Systems Service of the United Nations Joint Staff Pension Fund (UNJSPF). The incumbent reports to Chief of Unit. ResponsibilitiesWithin limits of delegated authority, the Information Systems Officer may be responsible for the following duties: • Manages projects involving feasibility studies, systems analysis, design, development and implementation of new systems, and/or, participates as a member of a development team with responsibilities for major components of complex systems. • Develops detailed systems and other functional specifications, including user documentation for major systems. • Provides specialized advice to users, analyzing requirements and translating them into new applications; determines application systems integration and linkage issues. • Maintains, upgrades or enhances existing data and user systems; troubleshoots and provides continuing user support; addresses problems; suggests the use of new techniques; monitors transactions to measure performance, and ensures continued effectiveness of assigned systems. • Develops and maintains computer programs that require integration with interrelated systems and program elements; ensures appropriate data security and access controls, considering both local and wide area architectures. • Organizes and performs unit and integrated testing, designing and utilizing test bases; assists users in acceptance testing. • Research, analyze and evaluation of new technologies and makes recommendations for their implementation. • Develop and maintain modern data and integration cloud technologies such as on Microsoft Azure, Amazon Web Services, or Google Cloud. • Define and implement scalable data integration frameworks, ETL/ELT pipelines, and data ingestion processes across cloud and on-premises environments. • Develops and maintains BI reports, dashboards, and scorecards to deliver information requests and strengthen the business analytics capabilities of the Organization. • Designs, develops, tests, optimizes, and deploys SQL Server Integration Services (SSIS) packages to process data integration requirements. Ensures that design and development tasks conform to all data consolidation, data integration, data transformation, and data quality best practices. • Participates in working group activities related to data quality, metadata, and data governance. • Evaluates and recommends Cloud based data platforms and tools and methodologies for data integration and reporting. • Supports the development of policies and procedures for the collection and analysis of data. • Provides guidance to – and may supervise – new/junior staff, consultants, etc. CompetenciesProfessionalism: Knowledge of information technology/information management, particularly in systems analysis, database design and programming. Knowledge of several high level programming languages and significant exposure to, and demonstrated proficiency in, all aspects of programming and analysis, including structured/object-oriented design, relational systems, scripting and query languages, document design and management, hardware and software requirements, systems facilities and execution protocols. Strong analytical and problem-solving skills, including proficiency in the development and implementation of systems of moderate size/complexity. Knowledge of interactive systems; good knowledge of organization’s information infrastructure and IT strategy, as it relates to user area(s); ability to independently maintain assigned systems and develop innovative approaches to resolve a wide range of issues/problems. Shows pride in work and in achievements; demonstrates professional competence and mastery of subject matter; 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. Teamwork: Works collaboratively with colleagues to achieve organizational goals; solicits input by genuinely valuing others’ ideas and expertise; is willing to learn from others; places team agenda before personal agenda; supports and acts in accordance with final group decision, even when such decisions may not entirely reflect own position; shares credit for team accomplishments and accepts joint responsibility for team shortcomings. 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 ongoing developments inside and outside the clients’ environment to keep informed and anticipate problems; keeps clients informed of progress or setbacks in projects; meets timeline for delivery of products or services to client. Commitment to Continuous Learning: Keeps abreast of new developments in own occupation/profession; actively seeks to develop oneself professionally and personally; contributes to the learning of colleagues and subordinates; shows willingness to learn from others; seeks feedback to learn and improve. EducationAdvanced university degree (Master’s degree or equivalent) in computer science, information systems, mathematics, statistics or related field. A first-level university degree in combination with qualifying experience may be accepted in lieu of an advanced university degree. Job – Specific QualificationNot available. Work ExperienceA Minimum of five years of progressively responsible experience in planning, design, development, implementation and maintenance of Cloud Data Platforms and Business Intelligence solutions preferably with Pension Systems, HR and Finance areas is required. Technical work experience with cloud-native data platforms and services, including Microsoft Azure Data Factory, Azure Synapse Analytics, AWS Glue, Amazon Redshift, AWS Lake Formation, or equivalent technologies, is required. Expert-level proficiency in SQL, data modeling, and performance optimization techniques, including query tuning, indexing strategies, partitioning, and the development of complex analytical datasets and reusable semantic models, is required. Technical work experience in Data Science related advanced cloud BI technologies, writing complex Data Analysis Expressions (DAX) in Power BI & Analysis Services is required. Experience on Pension and ERP systems including Oracle Fusion, ServiceNow with HR and/or Finance is desirable. Experience in an international organization or financial institution is desirable. LanguagesEnglish and French are the working languages of the United Nations Secretariat. For this job opening, English is required. French is desirable. The table below shows the minimum required level for each skill in these languages, according to the UN Language Framework (please consult https://languages.un.org for details).