CCAC Database Consultant (NDCs)

The selected candidate will assist in transitioning and enhancing the CCAC’s database that tracks NDCs and to develop the architecture for BTR tracking.

Responsibilities include:   

• Identifying database tool: Evaluate the structure and information currently included in the CCAC NDC database and recommend the most suitable database platform (e.g. Access) to migrate the database, considering factors such as scalability, accessibility, and ability to connect to other CCAC data sources.  

   

• Needs/User assessment: Consult with internal stakeholders to understand the current database’s strengths and weaknesses, use cases, as well as needs.  

   

• Streamlining and developing database architecture: develop a new database architecture that incorporates data from the existing database while streamlining fields and eliminating redundancies. This should involve consideration of the data structure, normalisation and efficiency of data retrieval.  

   

• Methodology: In consultation with internal stakeholders, develop clear and standardised. methodologies for collecting and entering data into the new database. This could include guidelines and protocols to ensure consistency and accuracy in data entry processes and consider the mode of data entry (e.g. a form).  

   

• Developing tools and/or dashboards for data analysis: Based on the needs assessment, create template analytical tools/reports/dashboards that enable users to effectively analyse the data within the database. This should include thinking about how the database can connect to publicly available resources on the CCAC website.

For full details and to apply click here.