Intermediate Bi Etl Developer
Posted on 2025-01-31
Job Summary
Cape Town – Western Cape
- Understand the current production environment and relevant processes.
- Support the BI Team in maintaining the production environment, ensuring delivery of current information to the business on time, effectively collected, correctly transformed, audited, accurately published.
- Develop, maintain and improve ETL jobs and related data warehouse models/objects/systems using ETL tools and coding primarily in Transact-SQL.
- Work closely with the BI Architect and BI Administrator to streamline data flows between internal/external systems and the BIDW.
- Testing and reconciliation of warehouse data to source data to ensure data integrity.
- Efficient and effective resolution of production issues, and users requests for information.
- Monitor the environment to proactively engage in prevention activities and to maintain an environment that is easy to understand and troubleshoot.
- Recurring standby to support and resolve operational issues encountered in the day-to-day operations of the BIWH production environment.
- Provide a support service to users on data and information to satisfy user needs.
- Analysis of new requirements and adjusting the design of existing star schemas or designing new star schemas to meet query / reporting requirements.
- Adapt ETL processes to accommodate changes in source systems and new business user requirements.
- Relevant tertiary qualification in Information Technology or similar.
- At least 5 years commercial Business Intelligence (Microsoft Stacks) development.
- Intermediate to Advanced skill level in using MS-SQL/T-SQL and SSIS.
- SSRS, SSAS (multi-dimensional and tabular), MDX.
- Working understanding of the Ralph Kimball methodology including a good grasp of dimensional modeling and efficient ETL techniques with focus on MS SQL Server.
- ActiveBatch
- Visio / Vertabello Modelling tools
- Visual Studio
- Cognos / Tableau
- Exposure to Self-Service BI using Power-BI.
- Experience in the Business Intelligence environment in Financial Services or Retail industry.
- Exposure in working within an Agile project environment.
- Experience in a SQL Database Administrator or BI Administrator role.
- Experience using a meta-data repository to manage ETL processes and data lineage.
- Experience using Team Foundation (or a similar product) as version control system.
- Strong analytical, problem solving and conceptual thinking skills essential.
- Ability to take ownership of problems assigned and find innovative solutions.
- Attention to detail and commitment to delivery is important.
- A team player with a positive attitude.
- Must be able to work to and manage deadlines.
- Flexible, able to change focus when required.
- Excellent communication skills.
Intermediate Bi Etl Developer position available in Western Cape, Cape Town. This job position was posted by Datafin. The job has been posted as a premium ad on 2025-01-31 at 16:10:01 in the It Computer category
Click Go Apply to apply online!
You might also like these jobs in the same area.
Apply directly for this position. Please read all instructions carefully.
We do not process job applications; we simply aggregate and display job listings.
More related positions
South Africa: Intermediate Systems Developer (C# Mobile) – Cape Town (Hybrid) – Up To R800k Per Annum
A renowned beverage company, celebrated for its iconic drink enjoyed nationwide and beyond, is on the lookout for an Intermediate C# Systems Developer to join their dynamic team. With a legacy of over 40 years, this trusted brand has become a household nam
View Job
Intermediate Systems Developer (C# Mobile) – Cape Town (Hybrid) – Up To R800k Per Annum
Johannesburg: Junior – Intermediate Developer – (C# With Mobile Experience) posted by Goldman Tech
Job Description:Junior - Intermediate Developer - (C# with Mobile experience.)Position is remote. Our client is based in Johannesburg.Requirements:• Candidate must have at least 2/4 years` experience post University.• Mobile experience - Android
View Job
Junior – Intermediate Developer – (C# With Mobile Experience)
Johannesburg: Intermediate Developer – C# With Mobile Experience posted by Goldman Tech
Job Description:We have an amazing opportunity for a junior to intermediate developer with C# and mobile experience for a well established client. We require a candidate with:• C# Experience• Development knowledge• Angular, SQL, HTML, CSS, J
View Job
Intermediate Developer – C# With Mobile Experience
Cape Town: Intermediate Bi Etl Developer posted by Datafin
Intermediate BI ETL DeveloperIT - Software DevelopmentCape Town - Western CapeENVIRONMENT: BE responsible for the support, enhancement, and optimization of the current BI Data Warehouse by managing service requests from users and the support of internal d
View Job
Intermediate Bi Etl Developer
Johannesburg: Intermediate Bi Developer – Johannesburg – R800k To R950k Per Annum
An infrastructure engineering and advisory practice, that believe infrastructure has unparalleled potential to create enduring impact with the potential realized by, designing, delivering and managing infrastructure in ways that maximise its value have a p
View Job
Intermediate Bi Developer – Johannesburg – R800k To R950k Per Annum
Eastern Cape: Junior Intermediate Microsoft Power Bi Developer posted by Hire Resolve
Hire Resolve`s client is looking for a Junior Intermediate Microsoft Power BI Developer to join their team in Port Elizabeth, EC (Remote). The client is a eading business solutions (ERP) service provider since 2003. We have anesteemed client base
View Job
Junior Intermediate Microsoft Power Bi Developer