Data Clerk Advanced Excel Specialist

Job Description

Connect With Us

Are you an expert in Microsoft Excel with strong data management skills? A reputable company in Lagos is seeking a Data Clerk Advanced Excel Specialist to manage large datasets, ensure data quality, and generate structured reports for program monitoring. This full time onsite role is ideal for candidates who are highly analytical, detail-oriented, and capable of independently handling Excel-based tasks.

The successful candidate will play a critical role in maintaining accurate data, producing actionable insights, and supporting program reporting needs.

About the Company

This reputable company in Lagos operates across multiple sectors, delivering programs that rely heavily on accurate data collection, management, and reporting. The organization values precision, efficiency, and strong analytical expertise to support decision-making and program performance monitoring.

Job Summary

The Data Clerk – Advanced Excel Specialist involves maintaining and analyzing program data using advanced Excel techniques. The role requires meticulous attention to detail, the ability to work independently, and the capability to create structured reports and dashboards to support monitoring, evaluation, and program management activities.

Key Responsibilities

Data Management

• Enter, update, and maintain accurate program data in Excel databases
• Organize and manage large datasets to ensure consistency and reliability
• Clean, validate, and reconcile data to detect errors or inconsistencies
• Maintain secure and well-organized digital records

Excel Data Analysis and Reporting

• Develop and maintain advanced Excel spreadsheets and reporting templates
• Analyze datasets and generate routine and ad-hoc reports
• Create charts, dashboards, and data summaries for program monitoring
• Use advanced Excel functions such as Pivot Tables, Pivot Charts, VLOOKUP/XLOOKUP, INDEX & MATCH, nested formulas, conditional formatting, and data validation

Data Quality Assurance

• Conduct routine data quality checks and verification
• Reconcile discrepancies between datasets and reporting systems
• Ensure compliance with internal data management standards

Program Support

• Provide timely and accurate data reports to program staff
• Support monitoring and evaluation activities through structured data tracking
• Assist in preparing reports for management and stakeholders

Requirements and Qualifications

• Diploma or Bachelor’s degree in Statistics, Computer Science, Information Management, Public Health, Business Administration, or related field
• Minimum of 3 years’ experience in data entry, data management, or reporting
• Demonstrated experience managing large datasets in Excel
• Expert-level proficiency in Microsoft Excel, including Pivot Tables, Pivot Charts, VLOOKUP/XLOOKUP, INDEX & MATCH, nested formulas, conditional formatting, data validation, and dashboard creation
• Ability to independently create and manage complex Excel spreadsheets without supervision

Optional/Additional Qualifications

• Experience with monitoring and evaluation systems
• Familiarity with Power BI, KoboToolBox, DHIS2, CommTB, or similar data platforms
• Experience working in health programs, NGOs, or donor-funded projects

Note: This position is strictly for candidates with strong Microsoft Excel expertise. IT specialists, software developers, and web specialists should not apply.

Key Skills and Competencies

• Advanced Excel and spreadsheet management
• Strong analytical and problem-solving skills
• Attention to detail and data accuracy
• Time management and ability to meet deadlines
• Independent working capability

Job Location

Lagos State, Nigeria

Salary

Competitive salary based on experience and qualifications

How to Apply

Interested and qualified candidates should apply through the official recruitment portal using the Apply Now button provided by the employer.