Djohra Bellili
Business Analyst/ Data Analyst
Calgary,Canada
Summary
Bilingual Business Intelligence and Data Analyst with over 10 years of experience in government pension programs. Skilled in Power BI, SQL, KPI development, ETL pipelines, data modeling, and predictive analytics. Strong background in actuarial science and financial risk assessment, with a proven ability to improve reporting accuracy, forecast liabilities, and support policy reforms. Experienced in stakeholder engagement, requirements gathering, and cross-functional collaboration to deliver dashboards and insights that enhance operational efficiency and decision-making. Fluent in Arabic, French, and English.
Prudent Business Intelligence Analyst with 4 years providing employers with valuable and actionable data to drive profit growth. Practiced at filtering information to find and highlight vital metrics and revelatory findings. Keen support business growth by leveraging intelligence assets to predict and reveal optimal business strategies.
Overview
12
12
years of professional experience
1
1
Certification
Work History
Business Intelligence Analyst
Algerian Government Pension Fund
03.2021 - 04.2024
- Aligned BI initiatives with the Fund’s strategic objectives, ensuring analytics supported long-term sustainability and operational efficiency.
- Established key performance indicators (KPIs) and performance metrics, and integrated data from multiple structured and unstructured sources.
- Developed and maintained ETL pipelines and data models to ensure accurate aggregation, transformation, and consistency of pension and financial data.
- Coordinated deployment tests with regional agencies to eliminate data gaps, validate accuracy, and improve trust in reporting systems.
- Designed and delivered interactive dashboards and visual reports, providing executives and decision-makers with accessible insights for timely policy and operational decisions.
- Key Achievements
- Implemented a BI solution that enhanced data-driven decision-making, improving reporting efficiency across the Government Pension Fund’s 58 regional agencies.
- Led the implementation of a BI solution, enabling executives at the Government Pension Fund to access real-time dashboards and reduce reporting delays by 30%.
- Deployed a BI solution for the Government Pension Fund, integrating structured and unstructured data sources to increase forecast accuracy and support policy reforms.
Operations Performance Analyst
Algerian Government Pension Fund
05.2019 - 03.2021
- Developed statistical frameworks to analyze expenditures and operational efficiency, producing forecasts to optimize resource allocation.
- Conducted demographic and financial risk assessments each quarter, modeling long-term liabilities to support sustainable performance planning.
- Delivered monthly technical performance reports and presented data-driven recommendations to leadership, improving decision-making processes.
- Collaborated with cross-functional teams, ensuring accuracy and consistency in operational and financial data analysis.
- Key Achievements
- Created quarterly risk assessment models that informed policy reforms adopted by senior leadership.
- Strengthened operational planning by delivering forecasts that improved resource allocation across 58 regional agencies.
- Provided scenario analyses that helped leadership evaluate the long-term impact of demographic shifts on pension sustainability.
Actuary – Machine Learning
Algerian Government Pension Fund
10.2017 - 05.2019
- Conducted in-depth actuarial analysis of social insurance programs, focusing on identifying and mitigating financial risks.
- Developed advanced actuarial models and conducted financial projections for national social security programs, including pension and healthcare schemes.
- Developed projections and forecasts to assess future expenditures for pension and social security systems.
- Key Achievements
- Designed actuarial models that predicted long-term pension liabilities with >90% accuracy.
- Advised on pension management strategies by analyzing economic and demographic trends, influencing reforms to strengthen the long-term sustainability of national social security programs.
Financial Analyst
Government of Algeria – Ministry of Finance, Prospective Department
05.2012 - 10.2017
- Contributed to the Financial Governance Committee for Algeria Vision 2035, in collaboration with the World Bank.
- Conducted analysis and monitoring of developments in the monetary and financial sectors.
- Undertook quantitative and prospective analyses on retirement-related issues.
- Prepared projections for monetary aggregates to inform policy decisions.
- Key Achievements
- Contributed to Algeria Vision 2035 reforms, collaborating with the World Bank on governance and pension sustainability.
- Produced financial risk assessments that guided government decisions on retirement system funding.
Education
Master’s Degree - Actuarial Science (Social Security)
Graduate School of Social Security
Master’s Degree - Quantitative Finance
National School of Statistics and Applied Economics
Bachelor’s Degree - Planning and Statistics
National School of Statistics and Applied Economics
Post Graduate Certificate - Business Intelligence, Data Analytics and Reporting
SAIT Calgary
Calgary, AB08.2025
Skills
- Data Modeling
- Macroeconomic Analysis
- Microsoft Visio, Miro
- Actuarial Analysis
- Billingual
- Predictive Analysis
- Cloud Services
- Data Architecture & Process Mapping
- Power Query & Dax
- Microsoft Fabric
- Gap analysis
- Power BI
- KPI tracking
Languages
English
Native or Bilingual
French
Native or Bilingual
Arabic
Native or Bilingual
Certification
Financial Programming & Policies: Macroeconomic Accounts & Analysis – International Monetary Fund (IMF)| Washington DC, USA
Summer Program in Quantitative Methods of Social Research – University of Michigan| Michigan, USA
Research Residency for Young Francophone Researchers |Observatoire de la Francophonie, Montreal University | Montreal, QC
Timeline
Business Intelligence Analyst
Algerian Government Pension Fund
03.2021 - 04.2024
Operations Performance Analyst
Algerian Government Pension Fund
05.2019 - 03.2021
Actuary – Machine Learning
Algerian Government Pension Fund
10.2017 - 05.2019
Financial Analyst
Government of Algeria – Ministry of Finance, Prospective Department
05.2012 - 10.2017
Master’s Degree - Quantitative Finance
National School of Statistics and Applied Economics
Bachelor’s Degree - Planning and Statistics
National School of Statistics and Applied Economics
Post Graduate Certificate - Business Intelligence, Data Analytics and Reporting
SAIT Calgary
Master’s Degree - Actuarial Science (Social Security)
Graduate School of Social Security
Training
- Financial Programming & Policies: Macroeconomic Accounts & Analysis – International Monetary Fund (IMF)| Washington DC, USA
- Summer Program in Quantitative Methods of Social Research – University of Michigan | Michigan, USA
- Research Residency for Young Francophone Researchers |Observatoire de la Francophonie, Montreal University | Montreal, QC
Similar Profiles
Keamogetswe PhofediKeamogetswe Phofedi
Receptionist Tamp at Government Employees Pension FundReceptionist Tamp at Government Employees Pension Fund
Gisela Nampasita NarisGisela Nampasita Naris
Procurement Officer at Government Institutions Pension Fund Ltd (GIPF)Procurement Officer at Government Institutions Pension Fund Ltd (GIPF)
Leevi Jordan JshooparaLeevi Jordan Jshoopara
Manager: Listed Investments at Government Institutions Pension Fund (GIPF)Manager: Listed Investments at Government Institutions Pension Fund (GIPF)
Craig DicksonCraig Dickson
Heavy Equipment Technician at Element Technical ServicesHeavy Equipment Technician at Element Technical Services
Alla OhanjanyanAlla Ohanjanyan
Administration Assistant at ClaimsProAdministration Assistant at ClaimsPro