BI Developer

QE Services IT Recruitment; Cape Town; On-site; ZAR 550,000 - 850,000; Full time

Job summary

QE Services IT Recruitment is assisting a client in Cape Town, Constantia, to hire a BI Developer on a permanent basis. The role centers on designing, developing and maintaining end-to-end BI solutions, including ETL processes, data warehousing, and dashboards.

Expect hands-on work with SQL Server, SSIS, Power BI, and Qlik Sense/QlikView, plus data modelling and collaboration with business stakeholders to drive insights and efficiency.

Qualifications

• Minimum 5 years' experience as a BI Developer / BI Analyst Developer.
• Advanced SQL development and database querying skills.
• Proven ETL development, data integration and data transformation experience.
• Strong experience with Power BI or Qlik BI tools.
• Solid understanding of data warehousing principles and dimensional modelling.
• Experience in financial services, asset management, investments, or related industries.

Responsibilities

• Gather, analyse and document business and reporting requirements from stakeholders.
• Design, develop and maintain end-to-end BI solutions across the full technology stack.
• Build and maintain robust ETL processes to extract, transform and load data from multiple source systems.
• Develop and enhance data warehouse solutions to support reporting and business intelligence initiatives.
• Create and maintain a centralised, trusted source of business data.
• Design relational and dimensional data models that support reporting and analytics requirements.
• Develop reports, dashboards and visualisations that provide meaningful business insights.
• Analyse data trends and identify opportunities to improve business processes and operational efficiency.
• Ensure data accuracy, integrity and consistency across BI platforms.
• Troubleshoot and resolve data-related issues and performance bottlenecks.
• Collaborate with technical and business teams to deliver scalable and sustainable BI solutions.
• Provide mentorship, guidance and technical support to junior team members.
• Contribute to BI strategy, continuous improvement initiatives and best practices.

Skills

SQL

ETL development

Data warehousing

Power BI

Qlik Sense / QlikView

Data modeling

Problem solving

Stakeholder communication

Education

Tertiary qualification in Information Systems/Computer Science

Tools

SSIS

SQL Server

Qlik

Cloud data platforms

Job description

My client based in Cape Town, Constantia is currently looking for a BI Developer to join their team on a permanent basis.

IT / FINANCE

Responsibilities

• Gather, analyse and document business and reporting requirements from stakeholders.
• Design, develop and maintain end-to-end BI solutions across the full technology stack.
• Build and maintain robust ETL processes to extract, transform and load data from multiple source systems.
• Develop and enhance data warehouse solutions to support reporting and business intelligence initiatives.
• Create and maintain a centralised, trusted source of business data.
• Design relational and dimensional data models that support reporting and analytics requirements.
• Develop reports, dashboards and visualisations that provide meaningful business insights.
• Analyse data trends and identify opportunities to improve business processes and operational efficiency.
• Ensure data accuracy, integrity and consistency across BI platforms.
• Troubleshoot and resolve data-related issues and performance bottlenecks.
• Collaborate with technical and business teams to deliver scalable and sustainable BI solutions.
• Provide mentorship, guidance and technical support to junior team members.
• Contribute to BI strategy, continuous improvement initiatives and best practices.

Qualifications & Experience

• Relevant tertiary qualification in Information Systems, Computer Science, Data Analytics, Mathematics, Statistics, or a related field.
• Minimum 5 years' experience as a BI Developer / BI Analyst Developer.
• Strong experience designing and developing end-to-end BI solutions.
• Advanced SQL development and database querying skills.
• Proven experience with ETL development, data integration, and data transformation processes.
• Strong understanding of data warehousing principles and dimensional modelling.
• Experience working with BI visualisation tools such as Power BI or Qlik.
• Strong analytical and numerical ability.
• Proven track record of delivering successful BI and data-related projects.
• Microsoft SQL Server and SSIS.
• Power BI.
• Qlik Sense / QlikView.
• Experience within financial services, asset management, investments, or related industries.
• Exposure to cloud-based data platforms and modern data architectures.

Competencies

• Technical Competencies
• Strong SQL and database development skills.
• Solid understanding of data warehouse architecture and ETL methodologies.
• High level of data analysis and problem-solving capability.
• Ability to translate business requirements into technical solutions.
• Strong attention to detail and commitment to data quality.
• Excellent problem-solving and troubleshooting skills.
• Ability to work effectively in complex, data-driven environments.
• Strong planning, organising and coordination skills.
• Results-oriented and solutions-driven mindset.
• Excellent verbal and written communication skills.
• Strong stakeholder engagement and relationship-building abilities.
• Ability to interact confidently across different business units and management levels.
• Strong analytical thinking and numerical aptitude.
• Self-motivated with the ability to work independently and as part of a team.
• Continuous learning mindset and passion for leveraging data to drive business decisions.

Desired Skills

• Data warehouse
• Microsoft SSIS
• Microsoft BI
• Power BI
• Development Business Intelligence