| Date | 2024-07-07 |
|---|---|
| Job Title | Intermediate Bi Etl Developer |
| Employer | Datafin More Information |
| Salary | 0 |
| Category | It Computer |
| Location |
Western Cape / Cape Town |
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 2024-07-07 at 16:00:55 in the It Computer category
Click Go Apply to apply online!
You might also like to look at the available jobs in the same area.
Apply directly on jobmail for this position
Some posts have contact information included with other instructions. All applicants are urged to read the instructions carefully.
We will list jobs at the bottom of each job, so feel free to scroll down and continue your search.
We do not accept any job applications and merely offer the service of daily jobs being mined and displayed on our job portal.
Each job post has a link to take you directly to the original post to apply on their website or the original website where the post came from.
Here are some more related positions
Cape Town: Intermediate Bi Developer posted by IOCO
We are looking for an Intermediate to Senior Developer. Overview This is a senior development role including design of specifications, coding, implementation, testing, data conversion and documentation and system enhancements. The incumbent is individually
View Job
Intermediate Bi Developer
Cape Town: Intermediate Bi Developer posted by IOCO
We are looking for an Intermediate to Senior Developer. Overview This is a senior development role including design of specifications, coding, implementation, testing, data conversion and documentation and system enhancements. The incumbent is individually
View Job
Intermediate Bi Developer
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
South Africa: Intermediate Mobile Software Developer – Permanent Cape Town / Hybrid R480k Pa posted by E-Merge
An opportunity has been made available for an Intermediate Mobile Software Developer to join an environment that empowers salesforce to reach every customer, through an ecosystem of digital and financial services.This is a development role where you are ac
View Job
Intermediate Mobile Software Developer – Permanent Cape Town / Hybrid R480k Pa
South Africa: Intermediate-Senior Mobile Applications Developer (Flutter) (Pta Hybrid) posted by Datafin
Intermediate-Senior Mobile Applications Developer (Flutter) (PTA Hybrid)IT - Software DevelopmentPretoria/Centurion - GautengENVIRONMENT: AN Intermediate-Senior Mobile Applications Developer (Flutter) who is passionate about building seamless & user-friend
View Job
Intermediate-Senior Mobile Applications Developer (Flutter) (Pta Hybrid)
Johannesburg: Intermediate Senior Bi Analyst (Jhb Hybrid) posted by Datafin
Intermediate - Senior BI Analyst (JHB Hybrid)IT - Software DevelopmentJohannesburg - GautengENVIRONMENT: PLAY a pivotal role in driving data-driven decision-making within the organisation of a dynamic Tech Company in Joburg seeking your analytical expertis
View Job
Intermediate Senior Bi Analyst (Jhb Hybrid)
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