Senior Business Intelligence/Data Warehouse Developer – Truworths Careers

Job Description

Truworths is seeking an experienced Senior Business Intelligence/Data Warehouse Developer to join our IT team. This role focuses on designing, developing, and maintaining enterprise-level data warehouses and BI solutions that deliver actionable insights across the business. The successful candidate will work closely with stakeholders in an agile environment, developing robust ETL, reporting, and data services that support multiple business units. Adaptability and a strong understanding of business concepts are key to succeeding in this role.

Key Responsibilities

• Champion BI and Data Warehouse (DW) architecture, promoting data quality, integrity, and reliability

• Contribute to and lead architectural forums within the BI team

• Develop and maintain dimensional, multi-dimensional, and relational data models

• Design, implement, and optimize ETL processes

• Automate and optimise data processes and architecture

• Develop PL/SQL or T-SQL scripts for data integration and reporting

• Build and maintain reports and dashboards to support business decisions

• Promote self-service BI solutions across the organisation

• Optimise IT and business processes through data solutions

• Integrate data between legacy and modern systems

• Collaborate with business users to understand and document technical specifications

• Create ad-hoc scripts and manage batch processing and scheduling

• Maintain agile documentation and participate in design, peer, and code reviews

• Provide daily technical, functional, and operational support for existing BI solutions

• Contribute to modernising architecture on on-premise or cloud platforms

Qualifications and Experience

• BSc or BCom in Information Systems, IT/IS Diploma, or substantial experience in Data Warehousing or Business Intelligence

• Minimum 5 years’ experience in data warehousing and/or ETL development

• Strong architectural mindset and experience with data and report modelling

• Experience with retail systems is advantageous

• Proven experience in batch processing and scheduling

• Skilled in documenting technical requirements and building strong business relationships

Competencies

Technical Competencies:

• Enterprise Data Warehousing (Kimball methodology) and data modelling

• ETL tools: SSIS, IBM DataStage, Informatica, ODI, or similar

• PL/SQL or T-SQL scripting and optimization

• IT and business process engineering

• Report development and dashboard creation

• Agile development experience, working in SCRUM

Advantageous Competencies:

• Oracle Database (11g/12c/19c), Oracle OBIEE, Power BI

• Control-M job scheduling

• Experience with retail, merchandise, financial, or CRM systems

• Working with large volumes of transactional data

• Microsoft SQL Server services: SSAS, SSIS, and database management

• Oracle ESSBASE, SAS Viya/CAS services

• Low-code development: Oracle APEX, Microsoft Power Apps

• Power Query, M Language, DAX

• Real-time data processing and streaming: JSON, MongoDB, Kafka

Behavioural Competencies:

• Excellent written and verbal communication skills

• Team-oriented and collaborative

• Quick learner with high self-motivation and drive

• Strong attention to detail

• Willingness to learn, adapt, and share new technologies and methodologies