Luyolo Nxele

Luyolo Nxele

Data Analyst | SQL, Python, Power BI | Turning data into decisions
Cape Town, South Africa
English, Afrikaans

About Me

Data Analyst with a strong foundation in SQL, Python, predictive analytics, and data
visualization. Experienced in transforming complex data into actionable
insights. Skilled in dashboard design, KPI reporting, and cross…

Experience

DATA MODELLING ANALYST

Flash, Cape Town, Western Cape
Sep 2024 - Present · 1 year 10 months

Build and maintain interactive dashboards and reports using SQL, Power BI, and Excel to support business decisions.
Design and implement scalable data models and pipelines for efficient analysis and reporting.
Query, transform, and integrate large datasets using SQL and Power Query; apply Python for data extraction, cleaning, and automation.
Perform statistical analysis and forecasting in Python to uncover trends and support planning.
Ensure data quality through validation, cleansing, and performance tuning for accuracy and consistency.
Collaborate with stakeholders to translate business needs into actionable insights and reporting solutions.
Conduct agent/trader performance analysis using historical data and market trends to inform growth strategies.
Lead the BI reporting function for the division, managing deployed data models and analytical outputs.
Provide team coaching, conduct performance reviews, and support change adoption and staff development.

DATA MODELLING ANALYST

Flash
Sep 2024 - Present · 1 year 10 months

Build and maintain interactive dashboards and reports using SQL, Power BI, and Excel to support business decisions.Design and implement scalable data models and pipelines for efficient analysis and reporting.Query, transform, and integrate large datasets using SQL and Power Query; apply Python for data extraction, cleaning, and automation.Perform statistical analysis and forecasting in Python to uncover trends and support planning.Ensure data quality through validation, cleansing, and performance tuning for accuracy and consistency.Collaborate with stakeholders to translate business needs into actionable insights and reporting solutions.Conduct agent/trader performance analysis using historical data and market trends to inform growth strategies.Lead the BI reporting function for the division, managing deployed data models and analytical outputs.Provide team coaching, conduct performance reviews, and support change adoption and staff development.

PAYMENTS DATA ANALYST

rain, Cape Town, Western Cape
Aug 2022 - Aug 2024 · 2 years

Analyzed user behavior, feature adoption, and churn patterns to guide product improvements and retention strategies.
Performed cohort, segmentation, and funnel analyses to uncover drop-off points and enhance engagement metrics.
Built real-time dashboards using Power BI, AWS QuickSight, Grafana, and Looker to monitor payment trends and product usage.
Extracted, transformed, and modeled large datasets using SQL (PostgreSQL, Presto), Python, and Power Query for reporting and automation.
Applied predictive modeling to forecast payment trends, churn, and customer behavior.
Investigated and resolved payment discrepancies, gateway failures, and fraud patterns through root cause analysis and reconciliation.
Delivered detailed reports on payment performance, customer KPIs, and operational risks to stakeholders.
Collaborated with Data Engineering to maintain secure, consistent data pipelines across cloud and on-prem systems.
Ensured data accuracy through validation, cleansing, and cross-system consistency checks across billing and website inputs.

PAYMENTS DATA ANALYST

rain
Aug 2022 - Aug 2024 · 2 years

Analyzed user behavior, feature adoption, and churn patterns to guide product improvements and retention strategies.Performed cohort, segmentation, and funnel analyses to uncover drop-off points and enhance engagement metrics.Built real-time dashboards using Power BI, AWS QuickSight, Grafana, and Looker to monitor payment trends and product usage.Extracted, transformed, and modeled large datasets using SQL, Python, and Power Query for reporting and automation.Applied predictive modeling to forecast payment trends, churn, and customer behavior.

BUSINESS ANALYST

Boxfusion, Centurion
Feb 2019 - Aug 2022 · 3 years 6 months

Led stakeholder workshops to gather business requirements in Agile/Scrum environments for web and mobile product initiatives.
Developed user stories, mockups, and conversation paths for chatbot features and customer service automation.
Compiled detailed business and functional specifications, process maps, and key data definitions to guide developers.
Acted as a liaison between cross-functional teams to ensure shared understanding of requirements and delivery goals.
Identified workflow inefficiencies and recommended data-informed process optimizations.
Built and maintained dashboards and business reports using Power BI and Tableau to track performance and reduce turnaround times.
Validated and cleansed datasets regularly to maintain accuracy across internal systems and databases.
Transitioned into analyzing large datasets to generate insights, forecasts, and decision support using SQL and statistical techniques.
Coordinated the end-to-end flow of business intelligence data between systems, ensuring data availability for all stakeholders.

BUSINESS ANALYST

Boxfusion
Feb 2019 - Aug 2022 · 3 years 6 months

Led stakeholder workshops to gather business requirements in Agile/Scrum environments for web and mobile product initiatives.Developed user stories, mockups, and conversation paths for chatbot features and customer service automation.Compiled detailed business and functional specifications, process maps, and key data definitions to guide developers.Acted as a liaison between cross-functional teams to ensure shared understanding of requirements and delivery goals.Identified workflow inefficiencies and recommended data-informed process optimizations.Built and maintained dashboards and business reports using Power BI and Tableau to track performance and reduce turnaround times.Validated and cleansed datasets regularly to maintain accuracy across internal systems and databases.Transitioned into analyzing large datasets to generate insights, forecasts, and decision support using SQL and statistical techniques.Coordinated the end-to-end flow of business intelligence data between systems, ensuring data availability for all stakeholders.

Skills

Data Mining Data Management Structured Query Language (SQL) Data Extraction Data Visualization Tableau Data Analysis and Reporting Data Analytics Python Dashboard Design KPI Reporting Cross-functional Collaboration CTEs Indexing Strategies Partitioning Window Functions MySQL PostgreSQL T-SQL Dimensional Modeling Star Schema Snowflake Schema AWS Redshift Athena Glue Data Modeling Data Preparation Data Transformation Power Query Data Cleaning Feature Engineering ETL NumPy SciPy StatsModels dplyr tidyr ggplot2 Business Intelligence Power BI AWS QuickSight Grafana Looker Excel Data Storytelling UX Design scikit-learn Machine Learning Classification Models Regression Analysis Time-series Forecasting A/B Testing User Segmentation Funnel Analysis
Report this Profile?