The Junior Data Analyst will write complex SQL queries, develop and maintain regular reports on key performance indicators, automate reporting processes, and ensure data accuracy through validation and quality checks. This role involves analyzing customer data, monitoring portfolio performance metrics, and designing interactive dashboards using Power BI or Tableau.

• Job Location: Lagos Mainland
• Employment Type: Full-Time
• Salary: Open to Negotiation

A commercial or microfinance bank based in Lagos Mainland is seeking a detail-oriented and analytical Junior Data Analyst to support business decision-making by extracting, analyzing, and presenting data from Oracle and SQL-based databases. The organization is committed to leveraging data to drive operational efficiency, improve customer experience, and support strategic goals.

• Write complex SQL queries (Oracle SQL, PL/SQL) to extract data from production databases.
• Develop and maintain regular reports (daily, weekly, monthly) on key performance indicators (KPIs) such as loan disbursements, repayments, portfolio quality, and customer acquisition.
• Automate recurring reporting processes to improve efficiency and reduce manual effort.
• Ensure data accuracy and completeness through regular validation and quality checks.
• Analyze customer data to identify trends, patterns, and anomalies (e.g., repayment behavior, product uptake, customer demographics).
• Perform exploratory data analysis (EDA) to understand data distributions and relationships.
• Monitor portfolio performance metrics including Portfolio at Risk (PAR), delinquency rates, and write-off trends.
• Support the Risk team by providing data for credit assessments and portfolio reviews.
• Design and maintain interactive dashboards using Power BI, Tableau, or similar tools.
• Present complex data in simple, visual formats for non-technical stakeholders.
• Ensure dashboards are updated regularly and reflect real-time or near-real-time data.
• Work closely with business units to understand their data needs and deliver relevant insights.
• Translate business questions into analytical frameworks and data queries.
• Present findings to management and cross-functional teams in clear, actionable terms.
• Collaborate with the Database Administration team to ensure data availability and integrity.

• Bachelor's degree in Data Analytics, Computer Science, Statistics, Mathematics, Economics, Finance, Business Administration, or a related field.
• Relevant certifications (e.g., Oracle SQL, Microsoft Power BI, Tableau) are a plus.
• 2 years of experience in data analysis, reporting, or a related role.
• SQL: Strong proficiency in SQL, with experience in Oracle SQL or PL/SQL (joins, subqueries, aggregate functions, stored procedures).
• Excel: Advanced Excel skills (PivotTables, VLOOKUP, Power Query, charts, formulas).
• Data Visualization: Experience with Power BI, Tableau, or equivalent BI tools.
• Python/R (Optional but a plus): Basic programming skills for data manipulation and analysis.
• Database Knowledge: Understanding of relational database concepts and data warehousing.
• Reporting: Experience creating and automating reports.

How to Apply

Interested and qualified candidates should send their applications to dect.recruitment@gmail.com.

Why This Job Might Be a Good Fit

This role is ideal for a detail-oriented data analyst with 2 years of experience who is based on Lagos Mainland and passionate about using data to drive business decisions in the banking sector. It offers the opportunity to work with complex financial data and contribute to operational efficiency and customer experience improvement.

About This Listing
This page is part of our regularly updated collection of job opportunities. Each listing is shared to help users find available roles without upfront costs. 

What You Should Know
Details such as eligibility, requirements, deadlines, and availability may change at any time. We do not control the hiring or enrollment process and are not responsible for final selections, or outcomes. 

Disclaimer
This website does not act as an employer, recruiter, or training provider. Users are advised to verify information directly from the official source before applying.

Want to see all current job openings? Browse our latest job listings to find roles that match your skills.