Data Architect at Aig-Imoukhuede Foundation

As part of its work to facilitate the transformation of the Nigerian public sector, the Measuring Performance Thematic Working Group (MPTG) of Governance and Institutions Policy Commission (GIPC) of the Nigerian Economic Summit Group (NESG) in conjunction with the Aig-Imoukhuede Foundation, seeks to create a Nigerian public sector index.
Public sector activities influence a country’s performance via two means - directly, through the level and changes of productivity within the public sector, and indirectly, by enabling enhanced productivity in the private sector. Public sector activities therefore have a direct influence on a country’s key economic and social indicators with research establishing a positive causal relationship between the efficiency of a country’s public sector and its economic and social development (OECD, 2001).
One of the ways increased efficiency in a country’s public sector can be facilitated is via the provision of information about public sector activities to stakeholders. Access to the right data can inform policy, stimulate research, and encourage informed debate. Indicator reports and indices are indispensable tools in information dissemination as they can present complex data in an accessible format, and they are useful in identifying trends in performance and policies and drawing attention to issues (OECD, 2008).

This role is a short-term consultancy to provide to build, optimize and maintain conceptual and logical database models for the Aig-Imoukhuede Public Sector Index.
Under the supervision of the Research Manager, the successful candidate be responsible for data modelling and analysis; data loading and delivery security for the index. and data delivery. The ideal candidate should be familiar with predictive analysis and data visualization techniques using relevant tools (e.g. Tableau, D3.js and R.)

Overall Responsibilities

• Support the Research Manager in the design and development of the research design, methodology, data collection and analysis tools to be best employed for the construction of the index.
• Assist in defining the scope and the sampling size as it relates to MDA coverage necessary for the attainment of the goals and objectives of the performance index.
• Work with the Research Manager to coordinate primary and secondary research methods in data collection activities while working with the project team and volunteers to ensure timely and robust data collection and in line with international best practices.
• Design and implement effective database solutions and models to legally acquire (collect) primary and secondary data.
• Design a digital infrastructure/platform to store and retain data obtained through surveys and other data collection methods.
• Build a data dictionary using extract, transform and load (ETL) techniques to curate the index.
• Design and implement effective database solutions to store and secure repository to hold the aggregated data.
• Conduct the data analysis by using data science techniques to generate reports and visualisations.
• Conduct expert review of data to provide insights that will guide economic policies and decisions.
• Monitor the system performance by performing regular tests, troubleshooting, and integrating new features in line with the index project objectives.
• Recommend solutions to improve new and existing database systems.
• Offer support by responding to system problems in a timely manner.
• The Data Architect will carry out this assignment using the hybrid work model. Travel, accommodation, and other incidental expenses incurred exclusively for the project will be reimbursed.

The Data Architect must be a qualified expert, with a demonstrated track record in policy research, public policy analysis, understanding of governance and public administration issues, construction of index methodologies, survey design, data analysis and index development with strong ability to translate raw data into index scores and ranking.
In addition to this, the Data Architect will be expected to meet the minimum requirements described below (please demonstrate qualifications by means of CVs, cover letter, references, and work samples):

• Demonstrated experience in data modeling and design.
• Design and implement effective database solutions and models to store and retrieve company data.
• Proven work experience as a Data Architect, Data Scientist, Data Analyst or similar role
• In-depth understanding of database structure principles
• Experience gathering and analyzing system requirements
• Knowledge of data mining and segmentation techniques
• Expertise in SQL and Oracle
• Proficiency in MS Excel  Familiarity with data visualization tools (e.g. Tableau, Power BI, D3.js and R)
• Proven analytical skills
• Problem-solving attitude
• BSc in Computer Science or relevant field with a minimum of 4 years’ experience as a data analyst or architect.

The selected candidate must be available to commence work from late January 2022.

The successful candidate will be expected to work for up to 80 days from January 2022 to December 2022 when the final project is validated based on the approved Research Manager’s work plan. The selected candidate will be paid a daily rate based on a schedule that will be agreed upon hiring.

Interested candidates should submit the following:
a. Cover letter with the applicant’s current contact information including how the candidate’s previous experience matches the project objectives as well as their interest for the position (no longer than two pages).
b. CV with professional references.
c. Samples of recent similar assignments- online portfolios and links.

Applications not meeting the above criteria and not including all the above information will not be reviewed. Only short-listed candidates will be contacted.

Interested parties must submit, their applications to kachi.nwachukwu@aigafrica.org copying olowookere.afolabi@aigafrica.org and jeremiah.enoch@aigafrica.org no later than 21st January 2022.