We are looking for a Senior Business Intelligence Developer to join our team in Cape Town. You’ll be responsible for creating and managing ETL processes that transform data from various source systems into actionable insights. Leveraging ETL tools and primarily coding in Transact-SQL, you will play a key role in designing data pipelines to populate structures that are accessible, accurate, and support informed operational, tactical, and strategic business decisions. This role requires experience with the Microsoft BI Stack and proficiency in the Ralph Kimball methodology to ensure the successful delivery of high-quality BI solutions.
What you’ll do:
- Analyze new requirements and adjust the design of existing star schemas or design new star schemas to meet query and reporting needs.
- Modify existing ETL processes or design and build new ones to meet evolving business requirements.
- Perform testing and reconciliation of warehouse data with source data to ensure data integrity.
- Follow and adhere to the company’s internal BI SDLC and development methodologies.
- Deliver a high level of customer service and support to internal and external stakeholders.
Your expertise:
- Experience: Minimum of 8+ years’ commercial Business Intelligence development experience with the Microsoft BI Stack.
- Technical Skills: Proficient in SQL and SSIS.
- Experience with SSAS, MDX, and Tabular models (advantageous).
- Methodology: Working knowledge and practical application of Ralph Kimball’s methodology.
- Environment: Previous experience in a Business Intelligence environment.
Technical stack:
- Microsoft Active Batch
- Visio / Vertabello modelling tools
- Essential technology experience: SQL, SSIS.
- Visual Studio
- Cognos / Tableau / Python
- PowerBI
Other information applicable to the opportunity:
- Permanent Position
- Location: Cape Town (Hybrid)
Why work for us?
Want to work for an organization that solves complex real-world problems with innovative software solutions? At iOCO, we believe anything is possible with modern technology, software, and development expertise. We are continuously pushing the boundaries of innovative solutions across multiple industries using an array of technologies.?
You will be part of a consultancy, working with some of the most knowledgeable minds in the industry on interesting solutions across different business domains.?
Our culture of continuous learning will ensure that you will have all the opportunities, tools, and support to hone and grow your craft.?
By joining IOCO you will have an open invitation to developer inspiring forums. A place where you will be able to connect and learn from and with your peers by sharing ideas, experiences, practices, and solutions.
Desired Skills:
- Adaptability
- Authenticity
- Partnership
- Ingenuity
- Mastery