Gopolang Changa

Business Intelligence / Data Analyst with 4+ years' experience designing Power BI and Qlik Sense dashboards, automating recurring reporting, and building SQL/ETL pipelines across financial services and insurance. Known for turning messy data into reliable, decision-ready reporting and cutting manual reporting effort through automation.

Business Intelligence Analyst at PSG Financial Services (2023-11 – 2025-03)

• Gathered and translated stakeholder requirements into tailored BI solutions, integrating Snowflake SQL with Qlik Cloud and Power BI.
• Migrated legacy Power BI dashboards to Qlik SaaS/Qlik Sense and built new dashboards for operational and financial reporting.
• Built ETL pipelines and star-schema data models in T-SQL and Snowflake SQL to maintain the data warehouse.
• Automated recurring report distribution via Qlik reloads and NPrinting, cutting manual reporting effort by 25%.
• Managed user access and daily operational reporting, and performed on-demand analysis to support business decision-making.
• Gained domain exposure to asset management, fund performance, and investment reporting, including dashboards tracking risk and cash flow for insurance products.

Data Analyst at Lion of Africa Life Assurance (2021-01 – 2023-11)

Promoted to Data Analyst at the beginning of 2022, after completing a 1-year graduate programme at the company (via PBT Group). Reason for Leaving: Wanted a new challenge.

• Built production tables and dashboards in Comotion Dash and SQL to track fund performance, risk, and cash flow, distributing reports via email and SharePoint.
• Integrated external data sources through Python APIs and added automated validation checks, improving report accuracy, speed, and accessibility for upper-management reporting.
• Delivered data insights for the IFRS 17 compliance project and monitored key metrics for insurance products.
• Promoted to Data Analyst after a 1-year graduate programme, where I built end-to-end BI pipelines using SSIS, SSAS, Azure, and Power BI, and supported Agile project delivery with Python-based analysis.

Intern at Eighty20 (2019-07 – 2019-11)

Contract position. After this internship, Advanced Diploma was completed. Reason for Leaving: Contract completed successfully.

• Queried source systems with SQL for reporting validation and data monitoring.
• Cleaned data and automated Excel reports using macros and formulas, building visual dashboards to improve reporting efficiency.
• Supported Power BI and Qlik Sense dashboard development for operational and financial reporting.
• Collaborated with cross-functional teams to deliver reporting solutions across departments.

Advanced Diploma in Mathematical Statistics – Cape Peninsula University of Technology (2020)

Diploma in Mathematical Statistics – Cape Peninsula University of Technology (2016 – 2019)

Senior Certificate in Grade 12 / Matric – Tshireleco High School (2014)