Description

Bayport Financial Services Uganda is hiring a Senior Data Analytics Officer that supports the organization by analyzing data and generating actionable insights across Credit, Collections, and Sales functions. The role is responsible for tracking portfolio performance, designing risk segmentation models, evaluating sales productivity, and processing sales and collections team commissions. This position plays a critical role in decision support, operational efficiency, risk reduction, and incentive accuracy.

Key Duties and Responsibilities:

Credit & Collections Analytics

• Develop and present monthly reports: Credit Pack, Provisioning Matrix, Risk Appetite, and NPL analysis.
• Analyze arrears trends by employer, platform (PCA vs HCM), payroll status, and vintage.
• Monitor performance across risk categories (Performing 1-2, Performing 3-4, NPL) and trigger-based transitions.
• Track impairment drivers (e.g. off-payroll, abscondment, validation) and support audit readiness.
• Integrate forensic and legal follow-up data into monthly collections dashboards.
• Track recovery efforts by Division, and client-level response status.
• Quarterly board pack input.
• Manage the retail lending portfolio by analysing the performance of existing portfolio to recommend actionable strategies on improving credit performance and operational processes to increase profitability.
• Produce useful insight and information from various sources to track and monitor portfolio performance and build regular tracking against business targets.
• Identify champion/challenger strategies or product tests, propose and execute the strategies to meet Key Business Objectives
• Own development and adoption of expert analytics and latest tools and techniques for portfolio improvement
• Liaise with group and in-country functions and managers to achieve sales, credit and operational targets.

Sales Analytics

• Monitor sales volume trends by loan term, branch, agent, and product.
• Assess branch and regional performance vs targets, highlighting underperforming areas.
• Report on SCOC submission and validation rates to identify loan origination risks.
• Provide dashboards and detailed breakdowns for weekly and monthly sales reporting.

Commissions Processing

• Prepare and validate monthly sales commission files using agent performance data.
• Match disbursements to assigned agents and ensure commission alignment with policy.
• Handle complex cases (e.g. changed agent accounts, exceptions, manual adjustments).
• Coordinate with Payroll/Finance for payout processing and resolve disputes with supporting data.
• Handle advance capture and recovery.

Technical & Strategic Support

• Automate and streamline repetitive tasks using Python, Excel Power Query, and Power BI.
• Support cross-functional teams (Credit, Sales, Legal, Forensics) with on-demand analysis.
• Maintain structured databases for historical tracking, cohort analysis, and performance forecasting using SQL.
• Participate in weekly/Daily operational meetings and strategy reviews, providing timely insights.

Qualifications, Skills and Experience:

• Bachelor’s degree in a quantitative field such as Petroleum Geoscience, Engineering, Mathematics, or a related discipline, with demonstrated strong analytical and numerical skills.
• Additional certification in Financial Engineering or related quantitative finance is an added
• Minimum 3 years’ experience in data analytics, credit operations, or incentive reporting.
• Advanced Excel, Power BI, and Python programming for automation and reporting.
• Strong knowledge of payroll deduction models, credit risk categories, and sales performance metrics.
• High attention to detail, strong integrity, and excellent problem-solving skills.
• Excellent communication and stakeholder coordination abilities.

• Develop and present monthly reports: Credit Pack, Provisioning Matrix, Risk Appetite, and NPL analysis.
• Analyze arrears trends by employer, platform (PCA vs HCM), payroll status, and vintage.
• Monitor performance across risk categories (Performing 1-2, Performing 3-4, NPL) and trigger-based transitions.
• Track impairment drivers (e.g. off-payroll, abscondment, validation) and support audit readiness.
• Integrate forensic and legal follow-up data into monthly collections dashboards.
• Track recovery efforts by Division, and client-level response status.
• Quarterly board pack input.
• Manage the retail lending portfolio by analysing the performance of existing portfolio to recommend actionable strategies on improving credit performance and operational processes to increase profitability.
• Produce useful insight and information from various sources to track and monitor portfolio performance and build regular tracking against business targets.
• Identify champion/challenger strategies or product tests, propose and execute the strategies to meet Key Business Objectives
• Own development and adoption of expert analytics and latest tools and techniques for portfolio improvement
• Liaise with group and in-country functions and managers to achieve sales, credit and operational targets.
• Monitor sales volume trends by loan term, branch, agent, and product.
• Assess branch and regional performance vs targets, highlighting underperforming areas.
• Report on SCOC submission and validation rates to identify loan origination risks.
• Provide dashboards and detailed breakdowns for weekly and monthly sales reporting.
• Prepare and validate monthly sales commission files using agent performance data.
• Match disbursements to assigned agents and ensure commission alignment with policy.
• Handle complex cases (e.g. changed agent accounts, exceptions, manual adjustments).
• Coordinate with Payroll/Finance for payout processing and resolve disputes with supporting data.
• Handle advance capture and recovery.
• Automate and streamline repetitive tasks using Python, Excel Power Query, and Power BI.
• Support cross-functional teams (Credit, Sales, Legal, Forensics) with on-demand analysis.
• Maintain structured databases for historical tracking, cohort analysis, and performance forecasting using SQL.
• Participate in weekly/Daily operational meetings and strategy reviews, providing timely insights.

• Advanced Excel
• Power BI
• Python programming for automation and reporting
• Strong knowledge of payroll deduction models
• Strong knowledge of credit risk categories
• Strong knowledge of sales performance metrics
• High attention to detail
• Strong integrity
• Excellent problem-solving skills
• Excellent communication abilities
• Excellent stakeholder coordination abilities

• Bachelor’s degree in a quantitative field such as Petroleum Geoscience, Engineering, Mathematics, or a related discipline, with demonstrated strong analytical and numerical skills.
• Additional certification in Financial Engineering or related quantitative finance is an added advantage.