Database Specialist at Education Development Center (EDC)

Essential Job Functions:

Primary Responsibilities:

• Develops a project database to house all project-related data.
• Provides continuous maintenance of the database including regular scheduled back-ups, tests of data integrity, periodic recovery tests, etc.
• Develops standard operating procedures for administering database.
• Works with project team members and partners in numerous field locations throughout the country to ensure the database functionality meets their needs.
• Creates and enforces project-wide data processing protocols, including manuals and reference guides, for proper use of the project database and related functions.
• Trains project and partner staff on proper use of the database and data processing protocols.
• Works with project staff to find and implement technological solutions to data-related challenges.
• Ensures data cleanliness, quality and security.
• Ensures seamless integration between numerous systems in order to reduce unnecessary redundancies.
• Produces regular reports according to the guidelines determined by project management
• Researches hardware and operating system problems and determines proper solutions, arranging and coordinating for hardware and software repairs when necessary.
• Recommends changes to improve data systems and network configurations, and determines hardware or software requirements related to such changes.

Performs other duties as assigned.

Skills and Experience

• Candidates for this position must have at least 3 years of experience developing and maintaining complex databases, preferably with a USAID-funded education projects. Experience in a multi-unit,
• geographically diverse organization strongly preferred.
• Candidates must demonstrate knowledge of the following computer languages and systems.
• Excel – ability to use advanced formulas, functions, and calculations to analyze data. Create and update database through connected worksheets. Should be able to clean, transform, and relate data from multiple sources.
• Excel + Power Query – ability to create Excel connected to SQL database report templates. Should be capable of using Power Query to clean, merge, pivot/un-pivot, and transform data.
• Structured Query Language (SQL) – Understands T-SQL to build complex queries and sub-queries as well as how to filter, group, join, and sort the results. Uses SQL Server Management Studio (SSMS) and other query tools to connect, query, and manage databases. Familiar with SQL database structures (not Access), can build SQL queries using SELECT statements from one or many different related tables to output data from SQL databases. Understands database fields and properties, database relationships, primary and foreign keys, can read a database ER Diagram.
• SQL Databases - Can create relational database structures, tables, fields and properties, primary and foreign keys, and indexes. Creates complex SQL queries, Store Procedures, and Functions. Preferable experience in Microsoft SQL Server databases.
• Power BI – Ability to create basic Power BI dashboards and data visualizations connecting to external data sources like Excel to analyze data. Understands the different types of Charts, Graphs, and tables to visualize data. Creates filters, measures, and columns using DAX formulas. Can publish, update, and share dashboards and reports
• In addition, candidates should have experience with databases for monitoring program implementation and in data collection, processing and analysis systems.
• Candidates must demonstrate the ability to balance work within a team environment while working with minimal supervision; strong organizational, communication and interpersonal skills; good technical writing skills.
• Candidates must be willing to travel  to Bauchi, Sokoto and other States in Northern Nigeria and to work effectively with diverse stakeholders.

Education:

The candidate must have a minimum of Bachelor’s degree preferably in computer science, information systems / technology, or other related fields.