Senior Business Intelligence/Data Warehouse Developer at Truworths

• We are seeking an experienced Senior BI/DW Developer with a strong history of building enterprise-level data warehouses aligned with modern Business Intelligence standards. In this role, you will work closely with stakeholders and team members to define, design, and deliver actionable business insights. You will develop robust data, ETL, and reporting services to enable and support multiple business units.
• We are looking for someoneeager to deepen their BI/DW technical expertise and business understanding, who enjoys engaging with stakeholders and partnering with business teams to develop and deliver effective data solutions.
• This role suits individuals who value personal accountability and commitment to building excellence over time. Growth in this role comes from depth, reliability and sustained performance.

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
• Contributes to the ideology and growth of moving the architecture to modern platforms, on-premises and/or cloud
• Mentorship of mid-level and junior developers.

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:8th June,2026