Menu Close

Cape Town: Intermediate Bi Etl Developer posted by Datafin

Intermediate Bi Etl Developer

Posted on 2025-03-08

Employer Datafin
Salary 0
Category It Computer
Location Western Cape  /  Cape Town

Job Summary

Intermediate BI ETL DeveloperIT – Software Development
Cape Town – Western Cape – South Africa

ENVIRONMENT:
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 data management tasks as the next Intermediate BI ETL Developer sought by a dynamic Financial Services Group. You will develop, maintain & improve ETL jobs and related data warehouse models/objects/systems using ETL tools and coding primarily in Transact-SQL. You will also provide a support service to users. The ideal candidate requires a suitable IT tertiary qualification or similar, a minimum of 5 years commercial Business Intelligence (Microsoft Stacks) development with Advanced proficiency in SQL, T-SQL & SSIS. Your other tech tools should include SSRS, SSAS, MDX and the Ralph Kimball methodology.
DUTIES:
Offer support to information delivery production environment
  • 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.
User Support
  • 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.
REQUIREMENTS:
Qualifications –
  • Relevant tertiary qualification in Information Technology or similar.
Experience/Skills
  • 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.
Other technologies utilised in the BI Division:
    • ActiveBatch
    • Visio / Vertabello Modelling tools
    • Visual Studio
    • Cognos / Tableau
Advantageous
  • 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.
ATTRIBUTES:
  • 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.
Apply for this Job

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-03-08 at 16:09:59 in the It Computer category

Click Go Apply to apply online!

View Job  Western Cape: Key Account Specialist posted by GAP Consulting

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


Johannesburg: Head Of Department Â?? Intermediate Phase (Tembisa, Gauteng)

Key Requirements: Professional & Educational Qualifications. Fully SACE registered. Minimum of 4 years experience in a similar role. School management experience. Computer literacy and strong time management skills. Excellent interpersonal and people manag


View Job
Head Of Department Â?? Intermediate Phase (Tembisa, Gauteng)

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

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)

Cape Town: Intermediate Bi Etl Developer posted by Datafin

Intermediate BI ETL DeveloperIT - Software DevelopmentCape Town - Western Cape - South AfricaENVIRONMENT: BE responsible for the support, enhancement, and optimization of the current BI Data Warehouse by managing service requests from users and the suppor

View Job  Western Cape: Digital Marketing Coordinator posted by Communicate Finance

View Job
Intermediate Bi Etl Developer

Gauteng: Head Of Department €“ Intermediate Phase (Tembisa, Gauteng) posted by MPRTC Recruitment

Key Requirements:Professional & Educational Qualifications.Fully SACE registered.Minimum of 4 years’ experience in a similar role.School management experience.Computer literacy and strong time management skills.Excellent interpersonal and people


View Job
Head Of Department €“ Intermediate Phase (Tembisa, Gauteng)

Cape Town: Intermediate Bi Reporting Analyst posted by Hire Resolve

Hire Resolve`s client is seeking a BI Reporting Analyst who will act as the critical interface between non-data business users and the data ecosystem. This role focuses on translating business needs into actionable data queries, delivering ad hoc


View Job
Intermediate Bi Reporting Analyst

Cape Town: Intermediate Bi Reporting Analyst posted by Hire Resolve

Hire Resolves client is looking for an Intermediate BI Reporting Analyst to serve as the vital link between business stakeholders and the data ecosystem. This team is based in Cape Town and this is a hybrid role. This role focuses on translating business n


View Job
Intermediate Bi Reporting Analyst

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

Error making API request.
Share this to someone who needs a job:
Posted in Jobs in Cape Town, Jobs in Western Cape

More Jobs in Your Area