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
Cape Town – Western Cape – South Africa
- 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.
Click Go Apply to apply online!
Get Similar Job Alerts
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
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
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