Data Analyst & HR Analytics Professional

Nathalie
Iredje

Lagos, Nigeria · Open to Remote

I turn workforce data, business operations, and HR systems into clear, actionable insight. 8 years building HR infrastructure at Khazcustoms — now bringing that real-world context to data analysis across HR, sales, finance, and healthcare.

View Projects LinkedIn GitHub Profile
11+
Projects Completed
8yrs
Professional Experience
5+
Tools & Technologies
5+
Industry Sectors
Power BISQLExcel HR AnalyticsGoogle Sheets RJiraTrelloData Storytelling

Projects & Case Studies

Analytics work spanning HR, sales performance, healthcare, compensation equity, and e-commerce — built during internship at 10Alytics and through independent projects.

Techtronix Dashboard 1
Techtronix Dashboard 2
Power BI
10Alytics
Techtronix Innovations: Sales Performance & Market Opportunities

4-page Power BI dashboard analysing 2023 sales for a high-tech microchip and robotics company across product categories, customer sectors, and global regions.

$252MTotal Revenue
$53MTotal Profit
501KUnits Sold
  • Microchip leads revenue at $97M (39%); Asia-Pacific is top region at $150M
  • April highest revenue ($23.2M); May lowest ($18.7M) — seasonal demand confirmed
  • Products 1315, 1469, 1100 are most profitable and also most expensive to produce
Hospital Dashboard 1
Hospital Dashboard 2
🏥
Power BI
10Alytics
City Hospital: Financial Performance Dashboard

Two-page Power BI dashboard giving hospital leadership a centralised view of financial performance across specialties, procedures, doctors, and patients.

$274KTotal Revenue
30.8%Profit Margin
81/86Doctors / Patients
  • Dermatology generated highest specialty revenue; Heart Bypass Surgery top procedure
  • Top 5 revenue-generating doctors identified for performance benchmarking
  • Patient visit trends tracked quarterly 2021–2023 to support capacity planning
TedSquare Dashboard 1
TedSquare Dashboard 2
🎯
HR AnalyticsPower BI
10Alytics
TedSquare Ltd: Recruitment Cost Analysis & Optimisation

Analysed $1.3M in recruitment spend for a company under pandemic-driven budget pressure — comparing hiring methods by cost, performance, and demographic efficiency.

$1.3MTotal Cost of Hire
$29KAvg Cost Per Hire
External vs Internal Cost
  • Agency fees alone = $600K — the single largest recruitment cost driver
  • Age 28–35 is most cost-efficient hiring group at $27K per hire
  • Recommended scaling internal hiring in Texas; reducing external reliance in Massachusetts
Aron Mart Dashboard
Click to enlarge ↗
🛒
HR AnalyticsPower BI
10Alytics
Aron Mart: Recruitment Pipeline Analysis

Tracked 1,000 applications across a retail recruitment pipeline — measuring time-to-hire, offer acceptance rates, and pipeline efficiency by department and year.

1,000Applications
33%Offer Acceptance
50 daysAvg Time to Hire
  • Logistics & Supply Chain leads offer acceptance at 38%; HR and Marketing trail at 27%
  • Applications split: Accepted (32.6%), Rejected (33.9%), Pending (33.5%)
  • Marketing has longest time-to-hire (36 days) but shortest time-to-fill (12 days)
Salford Dashboard
Click to enlarge ↗
📈
HR AnalyticsPower BI
10Alytics
Salford & Co: Employee Performance Appraisal

Quarter-over-quarter performance analysis for 753 employees — tracking performance scores, engagement levels, and training hours across departments in Power BI.

74.1%Avg Performance Score
5.5Avg Engagement Score
753Employees
  • Q1→Q2 dip (75.3% to 74.3%) flagged as potential seasonal or organisational factor
  • Exceptional performers cluster at top; significant gap in support for average performers
  • Training hours showed positive correlation with performance improvement
OptiGrowth Turnover Trends Analysis
OptiGrowth HR Cost Drivers Analysis
📊
HR AnalyticsPower BI
10Alytics
OptiGrowth Enterprises: Data-Driven Cost Optimisation

A multi-week Agile HR analyst engagement. Analysed workforce cost, productivity, attrition, and absenteeism across departments to identify HR cost drivers and recommend operational improvements for a company facing budget pressure.

19%Attrition Rate
$4.06MHR Dept Salary Spend
0.74HR Productivity Score
4.7%Absenteeism Rate
Sprint 1 & 2 Findings
Salary Structure, Turnover & HR Cost Drivers
  • High earners show 0.99 productivity & 0% attrition vs low earners at 20% attrition
  • Sales (22%) and Logistics (21%) have highest attrition — Analysts and Managers most affected
  • HR carries highest salary spend at $4.06M despite only 0.74 productivity score
  • Attrition (19%) benchmarked at 50% above industry average of 12.6%
Sprint 3 Findings
Workforce Efficiency & Optimisation Plan
  • High hours ≠ high output: HR logged 2,581 hrs with 0.74 score; Operations 2,228 hrs with 0.77
  • Recommended performance-linked incentives, hybrid work pilots, and HR digitisation
  • Freeze hiring for high-cost, low-output roles; redeploy underutilised talent internally
  • Proposed cross-skilling in Logistics and Sales to reduce role dependency
Echo Media Dashboard
Click to enlarge ↗
📉
HR AnalyticsPower BI
10Alytics
Echo Media: Unveiling Absenteeism Patterns

5-year absenteeism investigation for a media company — identifying geographic, demographic, and performance-linked absence patterns to guide targeted HR interventions.

33.4%Attrition Rate
10.2Avg Absences/Employee
311→207Total vs Active
  • Illinois and New York show highest absenteeism — flagged for location-specific interventions
  • High earners show higher absence rates — linked to travel demands and stress
  • Eligible non-citizens have highest absenteeism rate at 41.96%
Acme Corporation Dashboard
Click to enlarge ↗
🌍
HR AnalyticsPower BI
10Alytics
Acme Corporation: Diversity & Equality Analysis

Investigated pay equity, gender distribution, and attrition disparities across salary bands, education levels, and racial groups for a global energy company.

6%Attrition Rate
31Active Employees
18%High Band Attrition
  • Gender imbalance identified in high salary band — majority male in senior roles
  • High salary band has 18% attrition — significantly elevated vs other bands
  • Strong education-salary correlation — Master's holders concentrated in senior roles
LuminaTech Dashboard 1
LuminaTech Dashboard 2
💰
HR AnalyticsPower BI
10Alytics
LuminaTech: Compensation Equity & Gender Pay Gap

Comprehensive compensation analysis for 844 employees — tracking gender and ethnicity pay gaps across departments, age groups, and countries from 1990 to present.

844Employees
$113KAvg Annual Salary
7.7%Engineering Pay Gap
  • Pay gap ranges: -12.1% in Accounting (women earn more) to 7.7% in Engineering (men earn more)
  • Black women show -27% gap — earning substantially more than men in their group
  • Asian and Caucasian men earn more than women at 5.9% and 3.8% respectively
📐
Statistical Analysis · R · SQL
📐
R SQL
Mayerfeld Consulting · Data Analytics Practicum
Statistical Analysis & Inferential Methods Practicum

Intensive practicum focused on statistical analysis applied to real-world data — including the British Election Study Ethnic Minority Survey (2,787 respondents, 637 variables). Used R and SQL throughout, covering the full pipeline from data exploration to inferential testing and interpretation.

2,787Survey Respondents
637Variables Analysed
Oct 2025Certified
  • Applied Pearson, Spearman, Point-Biserial, and Phi-Coefficient correlation — selecting tests based on data type and distribution
  • Built and interpreted linear regression models — R², adjusted R², residual analysis, homoscedasticity, and confidence levels
  • Ran hypothesis tests: null vs alternative, Type I & II errors, alpha levels, and effect sizes
  • Conducted group difference tests: independent & paired t-tests, one-way & two-way ANOVA, Mann-Whitney U, Kruskal-Wallis, Chi-square
  • Completed structured SQL homework — JOINs, aggregations, HAVING, EXTRACT, subqueries across film and payment databases
  • Tested for normality using Shapiro-Wilk test and visual inspection (histograms, boxplots, scatterplots)
🗃️
SQL Capstone Project
🗃️
SQL
10Alytics
T.T Inc: Inventory Optimisation via SQL Analysis

Wrote and executed 10 structured SQL queries against consumer electronics sales data to answer business questions on inventory, demand patterns, and macroeconomic factors.

  • Electronics top-selling in November — driven by Black Friday / Cyber Monday
  • Promotions significantly boosted Home Appliance sales; minimal impact elsewhere
  • No clear inflation-to-sales correlation found — other demand factors dominate
  • Top 10 best-selling SKUs identified for priority inventory management
FlexTrade Excel Dashboard
Click to enlarge ↗
📊
Excel
10Alytics
FlexTrade: UX & Conversion Analysis for E-Commerce App

Analysed 1,000 user sessions for an e-commerce app using Pivot Tables and charts to uncover conversion patterns, bounce rate drivers, and user feedback themes.

1,000Users Analysed
50%Avg Conversion Rate
49%Avg Bounce Rate
  • Inverse relationship confirmed: conversion rises as bounce rate falls
  • 2022: highest conversion (53%) and lowest bounce rate (48%) across all years
  • 60% positive vs 40% negative feedback — checkout and search UX are biggest pain points

Skills & Tools

A combination of analytics tools, HR domain expertise, and real-world operations experience.

📊
Power BI
Interactive dashboards, DAX calculations, data modelling, KPI tracking across HR, sales, and healthcare datasets.
🗃️
SQL
Data extraction, JOINs, aggregations, CASE WHEN logic, subqueries across business analytics projects.
📗
Advanced Excel
Pivot Tables, VLOOKUP, conditional formatting, automated payroll models, dashboards, and data validation.
📋
Google Sheets
Employee tracking systems, performance records, cross-department reporting templates, and real-time data sharing.
👥
HR Analytics
Attrition, absenteeism, recruitment cost, compensation equity, performance appraisal, and workforce planning analytics.
🔄
Agile / Jira / Trello
Delivered multi-week Agile analytics projects in sprint teams with structured sprint reviews and retrospectives.
📢
Data Storytelling
Translating complex workforce and business data into clear reports and presentations for non-technical stakeholders.
📐
R & Statistical Analysis
Correlation (Pearson, Spearman), linear regression, hypothesis testing, ANOVA, t-tests, normality testing. Applied to real-world datasets.
⚙️
HR Operations
8 years building HR systems, payroll, policies, SOPs, onboarding, performance reviews, and operational documentation.

About Me

HR Professional turned Data Analyst

I spent 8 years at Khazcustoms, a Lagos-based automobile customisation workshop, building the company's entire HR and operations infrastructure from the ground up — policies, payroll systems, performance tracking tools, onboarding frameworks, and departmental data structures.

In 2024, I formalised my data analytics skills through the Master HR Analytics Professional (MHRAP) programme at 10Alytics, completing hands-on projects in Power BI, SQL, and Excel across HR, healthcare, retail, and consumer electronics sectors.

My edge is that I understand HR from the inside. That real-world context makes my analytics sharper and my recommendations more practical — I'm not just reading data, I'm reading situations I've lived.

Currently open to HR Analyst, People Operations, HR Business Partner, and Data Analyst roles in Nigeria and remotely.

Certifications

  • 🏅
    Master HR Analytics Professional (MHRAP)
    10Alytics, Canada · 2025
  • 🏅
    Professional in Human Resources – International (PHRi)
    HRCI, USA · 2022
  • 🏅
    Strategic Human Resource Management
    ISM Nigeria / SHRM · 2021
  • 🏅
    Data Entry Professional
    Accounting Hub, Nigeria · 2023
  • 🎓
    B.Sc (Ed.) Physics Education — 2nd Class Upper
    University of Ilorin · 2017

Let's Work Together

Open to HR Analyst, People Operations, HR Business Partner, and Data Analyst roles — in Nigeria or remotely.