Senior Business Intelligence/Data Warehouse Developer | Truworths
Job Location : Western Cape, Cape Town
Deadline : January 09, 2026
About the Role
The BI Developer drives high-RPM retail growth by managing enterprise data warehouses and ensuring 100% compliance with data governance and security standards. Utilizing Oracle for data orchestration and AWS for scalable analytics, the developer reduces operational risk in retail reporting. Their expertise leverages data-driven insights to optimize supply chain efficiency and ensures the commercial success of the group’s national retail portfolio.
Job Description
- We are looking for a dynamic individual who has a proven track record of developing enterprise level data warehouses that conform to modern Business Intelligence standards. The person in this role will work closely with stakeholders and team members to define, design and deliver actionable insights to the business in an agile environment. You will be developing robust data, ETL and reporting services that enable and support various business units. Your ability to adapt and quickly grasp new business concepts will ensure success in this role. This position is based at the Truworths head office in Cape Town.
Key Responsibilities
- Champion BI and DW Architecture.
- Champion data quality, integrity and reliability within Truworths BI
- Contribute to and grow architectural forums within Truworths BI
- Data modelling (Dimensional, multi-dimensional and Relational)
- ETL Architecture
- Process Automation and Architecture
- PL/SQL coding
- Report Development
- Promote Self-Service BI
- IT and Business Process Optimisation
- Data integration between legacy and modern systems
- Interface with users to understand and agree on specifications
- Ad-hoc scripts to facilitate user queries
- Batch support
- Batch scheduling
- Agile Documentation
- Participate in design, peer and code reviews
- Daily technical, functional and operation support for existing Business Intelligence solutions
- Contribute to the ideology and growth of moving the architecture to modern platforms, on-premise and/or cloud
Qualifications and Experience
QUALIFICATIONS
- BSc or B Com in Information Systems or IT/IS Diploma (Highly Advantageous) or substantial experience in a Data Warehousing or Business Intelligence environment.
EXPERIENCE / KNOWLEDGE
- Minimum 5 years data warehousing and/or ETL experience
- Architectural mind-set
- Data and report modelling experience
- Previous experience in retail systems an advantage
- Batch processing and scheduling experience
- Building and maintaining relationships with business users
- Documenting technical requirements from business briefs
Competencies
TECHNICAL
Essential Competencies
- Enterprise Data Warehousing (Kimbal Method)/ Data Modelling and Design
- ETL (SSIS, IBM DataStage, Informatica, ODI or similar)
- PL/SQL or T-SQL scripting and optimization
- IT/Business Process Engineering
- Report Development
- Agile experience working in SCRUM
Advantageous Competencies:
- Oracle Database 11g/12c/19c
- Oracle OBIEE, Power BI reporting services
- Control M
- Merchandise/retail/financial/CRM systems experience
- Working with large volumes of transactional data
- Microsoft SQL Server Database services
- Microsoft SQL Server Analysis Services (SSAS)
- Microsoft SQL Server Integration Services (SSIS)
- Oracle ESSBASE
- SAS Viya and CAS services
- Low Code Development (Oracle APEX, Microsoft Power Apps)
- Power Query, M Language, and DAX
- Realtime Data processing/ Data Streaming (JSON, MongoDB, Kafka)
BEHAVIOURAL:
- Excellent written and verbal communication skills
- Team Orientation
- Quick learner
- Highly self-motivated and driven
- Attention to detail
- Willingness to learn and share new technology and methodologies
Deadline:9th January,2026
Career Growth & Education
A degree in Information Systems, Statistics, or Computer Science is mandatory, with growth supported by certifications in Microsoft SQL Server or AWS Data Analytics. Career growth leads toward Head of Data Science or Chief Data Officer roles by mastering predictive modeling. Participating in specialized bootcamps in machine learning and obtaining advanced degrees provides a pathway to senior leadership in the international retail and finance sectors.
Salary & Financial Insight
Monthly salaries range from R65,000 to R115,000, reflecting the high strategic value of data engineering. High-income developers should prioritize professional tax planning and early enrollment in a diversified retirement annuity to secure their future.
Interested and Qualified candidates should Click here to Apply Now
Disclaimer: MRjobs.co.za is not an employer and does not directly offer jobs. We share available opportunities from verified sources to help job seekers. Please do your due diligence before applying. We are not responsible for any transactions, interviews, or outcomes from third-party employers.
