In a bank, an NGO, or a commercial department, the Data Analyst goes from an Excel file received by email to a SQL query, then to a Power BI dashboard presented in committee. He is also found under the titles Data Analyst, BI Data Consultant, or Data & Business Analyst.
His job consists of making data reliable, readable, and useful for decision-making: tracking sales, understanding a collection delay, measuring a campaign, spotting an anomaly. In Libreville, Abidjan, Dakar, or Douala, he often has to deal with heterogeneous systems, field files, and sometimes costly tools.
What skills?
Techniques
- SQL: queries, joins, aggregations, controls
- Advanced Excel: Power Query, pivot tables, formulas
- Power BI, Tableau, Looker Studio, or Qlik
- Python or R for cleaning, analyzing, and automating
- Applied statistics and data visualization
- Knowledge of data warehousing, ETL, and cloud
Organizational
- Translate a business need into measurable indicators
- Prioritize truly useful analyses
- Document definitions and calculation rules
- Check quality before dissemination
- Manage reporting emergencies
Human
- Rigor and attention to detail
- Critical thinking towards numbers
- Ability to simplify
- Sense of confidentiality
- Curiosity about the organization's professions
Recent articles
Digital Workplace Consultant: profession, missions, and opportunities
Computer Engineering Profession for Finance
Career of Engineer in Natural Language Processing (NLP)
Certificate
Professional Certificate in Business Intelligence with Excel and Power BI
What is the purpose of this professional?
The Data Analyst serves to transform activity traces into decisions. A company sells, collects, delivers, recruits, serves customers, and finances projects. All these actions produce data, but they are often scattered across an integrated management software, a CRM for customer relations, a field application, Excel exports, or a SQL database. Without analysis, this data remains as files.
Their role is to ask the right questions, verify the quality of the numbers, calculate key performance indicators, and then explain what they mean. They do not limit themselves to creating beautiful graphs: they document the calculation rules, highlight the limitations, and avoid hasty conclusions.
A typical day
Example of a typical day, not an observed report.
- 9 AM Verify the requests received: commercial dashboard, stock analysis, donor indicator, or recovery tracking.
- 10 h Extract data from SQL, a CRM, an ERP, or multiple Excel files, then check for duplicates and missing values.
- 11:30 AM Clean formats, standardize labels, create joins, and document the calculation rules used.
- 2:00 PM Build or update a Power BI, Tableau, or Looker Studio report with understandable indicators.
- 4:00 PM Present the results to a business team, explain a decrease, an anomaly, or a trend, and then gather objections.
- 5:30 PM Secure the files, plan the updates, and note improvements to be addressed with the IT department.
What studies?
There is not just one path. Job offers often require a Bac+3 to Bac+5 level in data science, statistics, computer science, applied mathematics, quantitative economics, decision-making computing, or business analytics. Onisep notably cites the BUT Data Science and licenses with data science tracks. Apec also mentions master's degrees in statistics, econometrics, or decision-making computing, as well as specialized engineering schools.
Certifications can complement a profile, especially to prove tool proficiency: Microsoft Certified: Power BI Data Analyst Associate, Salesforce Certified Tableau Data Analyst, or Google Data Analytics Certificate. They do not always replace a degree when one is required, but they help to showcase a concrete portfolio: SQL queries, dashboards, documented analyses, and reproducible projects.
Where does he work?
The Data Analyst works in banks, insurance companies, microfinance institutions, fintech, and mobile money services. They are also sought after by telecoms, distributors, e-commerce companies, manufacturers, logistics providers, consulting firms, digital service companies, administrations, public agencies, NGOs, donors, and international organizations. In a small structure, they can be very versatile. In a large group, they typically work alongside a data engineer, a database administrator, a BI manager, and business teams.
- Data Analyst F/H
- Data Analyst
- Data Analyst BI
- Data Analyst / BI Consultant F/H
- Data Analyst – Business Intelligence
- Junior Data Analyst – Data Management & Governance
- Research Officer & Data Analyst
- Portfolio and Data Analyst
- Data & Business Analyst
What is the salary?
For France, Apec indicates that 80% of the gross annual salaries offered for Data Analyst F/H positions are between €33k and €53k, with an average of €43k. Robert Half publishes a national salary range for 2026 of a starting gross annual salary from €42,000 to €60,000 for Data Analysts. Onisep mentions a starting salary of €2,900 gross per month, varying by location and status.
These French ranges do not translate to Gabon, Senegal, Côte d'Ivoire, or Cameroon. For Francophone Africa, no reliable, recent, and transnational salary scale has been found in the consulted sources. There is a specific case: a Junior Data Analyst position in Abidjan published by Africa Project Management indicated a net salary of 320,000 FCFA. It should be read as a specific announcement, not as a regional average.
The realities to know
- Data is often dirty: duplicates, inconsistent formats, contradictory files, incomplete entries.
- Access to data can be slow to obtain due to silos, security, or customer sensitivity.
- The role is sometimes poorly defined: the Data Analyst is expected to also perform data engineering, BI, development, and support.
- The pressure for reporting is high before committees, audits, commercial campaigns, or donor reviews.
- Numbers can be misinterpreted if biases, sample limits, and calculation rules are not explained.
- Software licenses, connectivity, hardware, and cloud access can limit the ambition of projects.
And in Africa?
In Francophone Africa, the need is real because organizations want to better manage their sales, projects, agent networks, beneficiaries, or budgets. In banks, telecoms, and fintech, use cases focus on customer segmentation, churn, recovery, digital payments, or commercial performance. In NGOs and donor-funded projects, the Data Analyst often works with field surveys, KoboToolbox, ODK, and monitoring-evaluation dashboards.
The difference lies in the execution conditions. In Libreville, Abidjan, Dakar, or Douala, you can work on strategic data while dealing with irregular connectivity, outages, unstable VPN access, or off-site hosted databases. Many teams mix advanced Excel, Power BI, PostgreSQL, MySQL, Python, R, Looker Studio, or open-source solutions like Metabase and Apache Superset.
Remote work is credible when access is secure and privacy rules are clear. The time zone advantage with Paris helps firms, NGOs, and pan-African teams. However, on-the-ground presence remains valuable: understanding how data is collected avoids many false dashboards.
Is this job for you?
- Do you enjoy investigating why two files yield two different results?
- Can you explain a graph to someone who does not speak SQL?
- Are you willing to spend a long time cleaning data before producing a visible analysis?
- Can you say that a figure is insufficient to draw a conclusion?
- Are you ready to regularly learn new tools and methods?
If you love numbers, business questions, and clear communication, this job may suit you. If you are only looking to code without interaction, also consider development, database administration, or data engineering roles.
Related professions
- Digital Workplace Consultant: profession, missions, and opportunities
- Data Scientist: profession, missions, and opportunities in Africa
- Software Developer: profession, missions, and opportunities
- Database Administrator
- Data Governance Analyst
- Business Intelligence Analyst, BI
French 
English 