JOB PURPOSE
- The SQL - BI Developer is responsible for designing, developing, and maintaining the data infrastructure that supports reporting, analytics, collections strategies, operational decision-making, and future predictive modelling initiatives.
- This role ensures data accuracy, integrity, reliability, automation, and scalability of data reporting solutions across the business through SQL development, data engineering, BI enablement, data integration, and analytical support.
QUALIFICATIONS & EXPERIENCE REQUIRED
- Matric plus degree in Information Systems, Computer Science, Data Science, or a related field.
- Minimum 3–5 years' experience in SQL development, database administration, and data engineering.
- Experience designing, developing, and maintaining relational databases.
- Experience building and managing ETL processes, data transformation pipelines, and data integrations.
- Experience working with large and complex datasets from multiple operational systems.
- Advanced Microsoft Office skills, particularly Excel, with a minimum of 2 years' practical experience.
- Experience with Power BI, Power Apps and Power Automate.
- Experience developing and maintaining data structures that support reporting, analytics, modelling, and business decision-making.
- Understanding of collections strategies, collections systems, and collections methodologies.
- Exposure to debt collections, financial services, or contact centre environments will be advantageous.
KEY RESPONSIBILITIES
- Design, develop, maintain, and optimise SQL databases, queries, stored procedures, views, and data integration processes. Build and maintain structured, scalable, and reusable datasets to support reporting, analytics, collections strategies, and business decision-making.
- Integrate and consolidate data from collections systems, payment platforms, bureau data sources, and other operational systems.
- Ensure data accuracy, integrity, governance, and compliance through validation controls, reconciliations, data quality monitoring, and documentation.
- Develop and maintain reporting data structures, data marts, and automated data feeds to support business intelligence and management reporting.
- Support the development, optimisation, and automation of dashboards, reports, and recurring reporting processes.
- Monitor and improve database performance, SQL efficiency, and data pipeline reliability.
- Collaborate with Data Analysts, Business Analysts, and business stakeholders to deliver reliable data solutions, reporting capability, and actionable insights.
- Troubleshoot data-related issues and provide technical support and guidance to business users.
- Maintain technical documentation, data dictionaries, and governance standards to support audit, compliance, and operational requirements.
COMPETENCIES AND SKILLS REQUIRED
- Advanced SQL development, data engineering, and data modelling skills.
- Proficiency in Power BI, Power Apps, and Power Automate.
- Strong analytical and problem-solving skills, with the ability to interpret and interrogate data to identify trends and support business strategy.
- Strong business and commercial acumen.
- Ability to manage multiple priorities and perform under pressure.
- High attention to detail and data accuracy.
- Strong communication (verbal & written), reporting, and presentation skills.
- Strong stakeholder engagement and relationship-building skills.
- Collaborative, professional, and accountable team player.
- Strong values of curiosity, collaboration, entrepreneurial spirit, passion for winning and trustworthiness.
NB: If you have not been contacted within 2 weeks, please consider your application as unsuccessful.
Job Type: Full-time
Application Question(s):
- What is your current/most recent remuneration package
Experience:
- SQL development: 3 years (Required)
- developing and maintaining data structures : 2 years (Required)
Work Location: In person
