Menu Close

Cape Town: Intermediate BI ETL Developer posted by Datafin

Cape Town: Intermediate BI ETL Developer posted by Datafin

Posted on 2025-04-30 00:00:00

Employer Datafin
Category Development
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

View Job  Johannesburg: Senior Java Developer posted by Goldman Tech

Click Go Apply to apply online!


Get Similar Job Alerts
Enter your WhatsApp number (e.g., +27740908132)
You'll receive alerts for new jobs in

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


Cape Town: Property Practitioner posted by Harcourts Dunn

Are you a persuasive communicator with a knack for sales? Do you thrive on making connections and closing deals? Join our dynamic real estate team as a Cold...


View Job
Property Practitioner

Cape Town: Google Ads Manager – Urgent Hire posted by Imatik Ltd

? Job Opportunity Google Ads Specialist Retainer Extra Income Can work around a FT existing role ?Are you a skilled Google Ads expert with 1-2 years of...


View Job
Google Ads Manager – Urgent Hire

Cape Town: Junior Consultant posted by Acquirely

Junior Consultant Remote - Sales Appointment SettingSalary R23,000 commissionOTE R30,000 R50,000month 2.5 per saleLocation Remote Work for a U.S....


View Job
Junior Consultant

Cape Town: Customer Support Manager – Entry Level posted by Right Kareer

Youll be the voice of our brand, communicating with customers, identifying their needs, and delivering a top-notch experience. Youll be the superhero they...

View Job  Cape Town: Pr Architect - CPT posted by Hire Resolve

View Job
Customer Support Manager – Entry Level

Cape Town: Sales Rep posted by Alifurn Outdoor Furniture

Looking for a Sales Rep Furniture IndustryWere looking for a dynamic and driven sales representative to join our team! The role is based at our showroom in...


View Job
Sales Rep

Cape Town: DevOps Engineer (Support) posted by Construct Executive Search

Applicants must have the following requirementsMust have a Matric Certificate.Must have 6-8 years of experience as a DevOps Engineer in a software...


View Job
DevOps Engineer (Support)

Cape Town: New Vehicle Sales Executive posted by Intercon Recruitment

Dealership in Cape Town is looking for an experienced New Vehicle Sales Executive, with previous Motor Dealership New Vehicle Sales Experience. Salary Basic...


View Job
New Vehicle Sales Executive

Cape Town: National Key Accounts Sales Manager posted by The Individual Touch CC

Generate new additional businessGrow the national customer baseManaging analyzing the national customer baseAnalyzing price decreases suspended business...


View Job
National Key Accounts Sales Manager

Northern Suburbs: BOILERMAKERS – Based In Cape Town posted by Tom Nel Recruitment

Leading Progressive Manufacturing company seeks a number of Boilermakers urgently for six month contracts.Key experience of 3-5 Years post apprenticeship...


View Job
BOILERMAKERS – Based In Cape Town

Cape Town: Vehicle Chip Repair Technician posted by Chip Magic Technologies (Pty) Ltd

Company DescriptionChip Magic Technologies Pty Ltd are experts in vehicle paint chip repairs and automotive vehicle aesthetic restoration specialists.We...


View Job
Vehicle Chip Repair Technician

Cape Town: Junior Accountant posted by Africa Thinking Management Solutions

Job Advertisement Junior AccountantLocation Cape Town -Observatory Company Africa Thinking Management SolutionsAfrica Thinking Management Solutions is...


View Job
Junior Accountant

Cape Town: Intermediate Financial Administrator posted by Construct Executive Search

Applicants must have the following requirementsMust have a Diploma in Accounting or Bookkeeping.Must have 3-5 years of experience as a Financial...


View Job
Intermediate Financial Administrator

Cape Town: Roof sheeter – Urgently Needed posted by Batt Master Roofing and Guttering

Roof sheeter needed Must be able to remove and install roof sheets etc and waterproofing for maintenance company Work in fascias as wellWork experience a...


View Job
Roof sheeter – Urgently Needed

Cape Town: Litigation Secretary posted by Marais Muller Hendricks Attorneys

Marais Muller Hendricks Inc., a leading law firm in Cape Town, is seeking to appoint an experienced and highly organised Litigation Secretary to join our...


View Job
Litigation Secretary

Cape Town: Bookkeeper – Restaurant Industry (Salt River) posted by The Vocation Station

About the RoleWere looking for a detail-oriented Bookkeeper to join our clients team and support the financial operations of four businesses under one roof....

View Job  Durban: C# Developer posted by Goldman Tech

View Job
Bookkeeper – Restaurant Industry (Salt River)

Cape Town: Litigation Secretary posted by Cora O’Neil Recruitment Agency

Cape Town City Centre LITIGATION SECRETARY Minimum Requirements-Well presentable and professional preferably female-Excellent verbal communication skills-2...


View Job
Litigation Secretary

Cape Town: Sales Administrator – IT Industry posted by The Vocation Station

Are you a proactive and detail-oriented professional with a knack for client service and relationship management in the IT Distribution space? Were looking...


View Job
Sales Administrator – IT Industry

Cape Town: Junior System Support Engineer posted by The Vocation Station

Are you an enthusiastic IT professional with a passion for delivering top-notch support to diverse customers? Our client is looking for a Remote Support...


View Job
Junior System Support Engineer

Cape Town: Electrical Engineer – Building Services posted by Business Recruitment Services

This role requires collaboration with multidisciplinary teams and clients to deliver fit-for-purpose solutions that surpass industry best practices and...


View Job
Electrical Engineer – Building Services

Cape Town: Intermediate SHERQ Officer posted by Construct Executive Search

Applicants must have the following requirementsMust have a Bachelors Degree or National Diploma in Safety Management or Occupational Health and Safety. Must...


View Job
Intermediate SHERQ Officer

Cape Town: Financial Accountant posted by Executive Placings

Travel Management Company is looking for an Accountant to be based in Cape Town. This is a hybrid role.The main purpose of this role is to ensure accuracy...


View Job
Financial Accountant

Cape Town: Regional Manager in Built-in Furniture Manufacturing Industry posted by Home Concept

Home Concept is looking for an experienced Regional Manager to join our team. In this role, youll lead sales, manage operations, and support teams to ensure...


View Job
Regional Manager in Built-in Furniture Manufacturing Industry

Cape Town: Car Rental Agent – Urgent posted by Vogue Personnel

Join Our Team as a Car Rental Agent! Were looking for a dedicated and organized Car Rental Agent to join our dynamic team and play a key role in ensuring...


View Job
Car Rental Agent – Urgent

Cape Town: New Business Consultant posted by Intercon Recruitment

Company based in Cape Town is looking for a Senior New Business Consultant Sales Increase and drive new business with a focus on quality and...


View Job
New Business Consultant

Cape Town: New Vehicle Sales Executive posted by Intercon Recruitment

Dealership in Cape Town is looking for an experienced New Vehicle Sales Executive with previous Motor Dealership New Vehicle Sales Experience. Salary Basic...


View Job
New Vehicle Sales Executive

Share this to someone who needs a job:
Posted in Jobs in Cape Town, Jobs in South Africa, Jobs in Western Cape

More Jobs in Your Area