Cape Town: Intermediate BI ETL Developer posted by Datafin
Posted on 2025-05-21 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: 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
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
Eastern Cape: Town Planner (JB5167) posted by Kontak Recruitment
Town Planner JB5167 Chintsa, Eastern CapeCompensation Range R40 45 000 CTC per month Negotiable Category EngineeringLead zoning, rezoning, and land use...
View Job
Town Planner (JB5167)
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: 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: 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: 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 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: Tour Operator – Urgent posted by Vogue Personnel
Exciting Career Opportunity in Southern Africa Travel!Are you passionate about travel and adventure? Do you have the skills and drive to make unforgettable...
View Job
Tour Operator – Urgent
Cape Town: Senior Construction Contracts Manager posted by Construct Executive Search
Applicants must have the following requirementsMust have a Bachelors Degree or Diploma in Building or Civil Engineering.Must be registered with SACPCMP as a...
View Job
Senior Construction Contracts Manager
Cape Town: Business Development Manager – Urgently Needed posted by One Source ICT
One Source ICT is an innovative technology company specializing in Information and Communication Technology ICT solutions. With a focus on excellence and...
View Job
Business Development Manager – Urgently Needed
Cape Town: Sales Representative | New Business Consultant posted by Intercon Recruitment
Company based in Cape Town is looking for a Sales Representative New Business Consultant to Increase Sales and drive new business with a focus on quality...
View Job
Sales Representative | New Business Consultant
Cape Town: SALES MANAGER posted by The Recruitment Guy
Title SALES MANAGERArea Cape Town PE HubsIndustry Rental Hire Working of height machinery and equipment Trade Desk Ref No. TRG 2303Salary TCT R71...
View Job
SALES MANAGER
Cape Town: IT Manager – Urgently needed posted by Edelson & Associates
IT Manager Cape Town R45000 NEG Working Knowledge of Microsoft Admin Centres and Licensing. Knowledge of SQL database Management. Also on site...
View Job
IT Manager – Urgently needed
Cape Town: SITE AGENT posted by Furipoint pty,ltd
Furipoint is excited to announce that we are currently expanding our team and are looking for highly motivated and skilled professionals to fill the Site...
View Job
SITE AGENT
Cape Town: QUANTITY SURVEYORS posted by Furipoint pty,ltd
Furipoint is excited to announce that we are currently expanding our team and are looking for highly motivated and skilled professionals to fill the...
View Job
QUANTITY SURVEYORS
Cape Town: Quality control inspector – PLEASE READ BEFORE APPLYING posted by Prokon
Position Quality Control Inspector Fresh Fruits Vegetables? Location Epping Private Market, Cape Town You need to reside in the Western Cape? Starting Date...
View Job
Quality control inspector – PLEASE READ BEFORE APPLYING
Cape Town City Centre: Accounts Payable Specialist
Key Responsibilities Process and verify invoices, expense reports, and payment requests Reconcile vendor statements and resolve discrepancies Maintain...
View Job
Accounts Payable Specialist