IT Developer (BI/DW)
- Cape Town, Western Cape
- Permanent
- Full-time
Reference Number TRU250822-3
Job Title IT Developer (BI/DW)
Business Area IT
Job Type Permanent
Workplace Type On-site
Location - Country South Africa
Location - Province Western Cape
Location - Town / City Cape Town
Job DescriptionWe are seeking a qualified and experienced IT Developer (BI/DW) to join our IT team. The ideal candidate is a proactive individual with extensive experience in developing, enhancing, and maintaining data warehouses that adhere to modern Business Intelligence standards.The successful candidate will collaborate closely with cross-functional teams and business units to define, design, and deliver actionable insights in an agile environment. You will be responsible for developing robust data, ETL, and reporting services that support various business units. This position is based at our head office in Cape Town.
Key Responsibilities
- Translate business requirements into technical data solutions
- Understanding and practical experience in the Data Warehouse Life Cycle.
- Participate in and contribute to architectural forums within Truworths BI
- Data modelling (Dimensional, multi-dimensional and Relational)
- ETL Architecture and implementation.
- Process Automation and Architecture.
- PL/SQL coding
- 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.
- 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 3 years data warehousing and/or ETL environment
- Data and report modelling experience
- Previous experience in retail systems is an advantage.
- Batch processing and scheduling experience
- Building and maintaining relationships with Business users
- Documenting technical requirements from business briefs
- Self-starter & self-motivated
- Good communicator
- Organized and focused
- Team player
- Ability to work to tight deadlines / work under pressure
- Deliver to a high level of code in accordance with best practices