Senior Business Intelligence/Data Warehouse Developer

Truworths; Wes-Kaap; On-site; ZAR 600,000 - 800,000; Full time

Job summary

A leading retail company based in Cape Town seeks a Senior Business Intelligence/Data Warehouse Developer. The successful candidate will champion BI and DW architecture, develop ETL and reporting services, and work closely with stakeholders. Candidates should possess a degree in Information Systems and a minimum of 5 years' experience in data warehousing. Strong communication skills and knowledge of modern business intelligence standards are essential. The company emphasizes transformation and welcomes applications from diverse backgrounds.

Qualifications

• Minimum 5 years data warehousing and/or ETL experience.
• Experience working with large volumes of transactional data.
• Ability to build and maintain relationships with business users.

Responsibilities

• Develop robust data, ETL and reporting services.
• Champion BI and DW Architecture within the organization.
• Participate in design, peer and code reviews.

Skills

Data Warehousing

ETL

Data Modeling

SQL scripting

Agile methodologies

Communication skills

Education

BSc or B Com in Information Systems

IT/IS Diploma or substantial experience

Tools

SSIS

IBM DataStage

Informatica

PL/SQL

T-SQL

Power Query

Job description

Senior Business Intelligence/Data Warehouse Developer

Truworths, City of Cape Town, Western Cape, South Africa

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).
• Process Automation and Architecture.
• 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.
• 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

• BSc or B Com in Information Systems or IT/IS Diploma (Highly Advantageous) or substantial experience in a Data Warehousing or Business Intelligence environment.
• Minimum 5 years data warehousing and/or ETL experience.
• 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.
• 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.
• Agile experience working in SCRUM.
• Working with large volumes of transactional data.
• SAS Viya and CAS services.
• Power Query, M Language, and DAX.

Behavioural

• Excellent written and verbal communication skills.
• Highly self‑motivated and driven.
• Attention to detail.
• Willingness to learn and share new technology and methodologies.

Truworths is committed to transformation and meeting objectives of the Employment Equity Act. Meeting our employment equity goals and targets will be taken into account in our recruitment decisions. People living with disabilities will be viewed favourably.