Job Specification Form (Senior BI/DW Developer)

JOB DESCRIPTION Cover main duties and responsibilities

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. 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

QUALIFICATION(S) 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

Job Specification Form

• Batch processing and scheduling experience

• Building and maintaining relationships with business users • Documenting technical requirements from business briefs

Technical and Behavioral 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

Job Specification Form

.

Graduate Analyst

WE SOLVE, WE AUTOMATE, SO THAT OUR CLIENTS CAN PROSPER

Your degree taught you “what”. We’ll teach you “SO what?”. If you love patterns, and problem-solving, you’ll fit right in.

We’re hiring Graduates at Business Science Corporation.

Come for the people, stay for the learning that accelerates your career.

BSC is a Boutique Consulting firm, which solves client challenges by applying science, creativity and business acumen to business decision making and execution. We enable our clients to understand the details of their operations, markets and broader environments in greater detail, helping them to unlock the full potential of their businesses.

Our teams are comprised of top data scientists, engineers, developers, actuaries and accountants who combine their in-depth diagnostic, technology and modelling skills with practical, commercial understanding, in order to deliver insight and tangible value to clients

We have mastered the application of analytics and technology to amplify enterprise performance.

We are always looking for new talent at any level.

Innovative and ambitious individuals with a keen business sense and an aspiration to provide solutions.

JOB SPECIFIC QUALIFICATIONS AND CRITERIA

• A Bachelor of Science (BSc) degree in Engineering, Statistics, Mathematics, Actuarial Science, or a related scientific discipline will be considered.

• An Honours degree is required.

• Demonstrated academic excellence and other notable achievements (supported by university transcripts and matric results).

KNOWLEDGE AND SKILLS

• Strong analytical capability and advanced problem-solving skills.

• Strong financial acumen.

• Technical competency (e.g., databases, programming, software development, or simulation modelling) is advantageous.

• Strong team orientation and ability to collaborate effectively.

• Understanding of markets and evolving business environments.

• Awareness of relevant industry trends.

*Please note that a strong mathematics background is essential.

© BUSINESS SCIENCE CORPORATION 2026 | CONFIDENTIAL | PAGE 2

As part of our commitment to a thorough and fair selection process, we use assessments to evaluate candidates’ suitability for specific roles. These assessments are designed to measure job-related behaviours and characteristics against a role benchmark, ensuring all candidates are evaluated consistently and based on overall job fit.

This process complements the review of CVs, academic transcripts, and other relevant qualifications. Assessment links will be sent to candidates via email.

To ensure your application is complete, please submit the following:

1. Uploaded CV

2. Academic transcripts

3. Matric results

4. Copy of ID

5. All required questions answered

Applications with missing information will not be considered.

We ensure that our recruitment process adheres to best practices and legal standards, respecting the privacy and rights of all applicants.