Menu Close

Cape Town: Intermediate Bi Etl Developer posted by Datafin

Date 2024-11-24
Job Title Intermediate Bi Etl Developer
Employer Datafin
More Information
Salary 0
Category It Computer
Location Western Cape
/ Cape Town

Job Summary

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

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 2024-11-24 at 16:06:21 in the It Computer category

Click Go Apply to apply online!

View Job  Cape Town: Senior Revit Technician posted by Hire Resolve

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


Johannesburg: Head Of Department – Intermediate Phase (Tembisa)

Qualifications and Skills: - Bachelor of Education (BEd) in Intermediate Phase, with SACE registration. - At least 3 years of experience in school management or a similar leadership role. - Excellent communication skills in both English and Afrikaans, able


View Job
Head Of Department – Intermediate Phase (Tembisa)

Johannesburg: Intermediate Bi Developer – Johannesburg – R600k To R800k Per Annum

An infrastructure engineering and advisory practice, that believe infrastructure has unparalleled potential to create enduring impact with the potential realized by, designing, delivering and managing infrastructure in ways that maximise its value have a p


View Job
Intermediate Bi Developer – Johannesburg – R600k To R800k Per Annum

Johannesburg: Intermediate Mobile Developer

Responsibilities: Help execute functional requirements Understand user requirements and assist in gathering requirements Ensure that testing protocols are followed Ensure that code is merged Ensure that they produce clean and efficient code Ensure that all

View Job  Cape Town: Senior Sales Ops Manager (Nightshift) posted by CallForce

View Job
Intermediate Mobile Developer

Centurion: Intermediate Cross Platform Mobile Developer

We are seeking a talented Cross Platform, Mobile Software Developer to design, develop, and modify both general and specialised software solutions. Analyse user needs and develop systems that enhance operational efficiency. Tasks: Modify software to correc


View Job
Intermediate Cross Platform Mobile Developer

Johannesburg: Grade 4 English Teacher Â?? Intermediate Phase (Tembisa)

Qualifications and Skills: - Bachelor of Education (BEd) in Foundation Phase. - SACE registered. - Strong English communication skills. - Ability to collaborate and build positive relationships with team members. - Proficient in using educational technolog


View Job
Grade 4 English Teacher Â?? Intermediate Phase (Tembisa)

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

Johannesburg: Intermediate Mobile Developer posted by Datafin

Intermediate Mobile DeveloperIT - Software DevelopmentJohannesburg - GautengENVIRONMENT: Our client, a reputable Johannesburg-based company, is dedicated to consistently delivering high-quality software to their clients. They are currently seeking an Inter


View Job
Intermediate Mobile Developer

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)

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  Cape Town: Operations Manager posted by Goldman Tech

View Job
Intermediate Bi Etl Developer

Centurion: Intermediate Cross Platform Mobile Developer posted by Pillango Placements

We are seeking a talented Software Developer to design, develop, and modify both general and specialised software solutions. Analyse user needs and develop systems that enhance operational efficiency.Tasks:Modify software to correct errors, adapt to new ha


View Job
Intermediate Cross Platform Mobile Developer

Johannesburg North: Intermediate Bi Developer posted by Network Finance

Key Responsibilities:Develop and maintain Business Intelligence solutions, focusing on data analytics and reporting for financial services applications.Build and optimize data pipelines and dashboards using SQL and visualization tools such as Power BI and


View Job
Intermediate Bi Developer

Johannesburg North: Intermediate Bi Developer posted by Network Finance

The successful incumbent will require close collaboration with the team, engaging in hands-on development, and a true passion for building solutions.Requirements:2-3 years’ experience in building data solutions, with a focus on BI/Data programs.IT De


View Job
Intermediate Bi Developer

Johannesburg: Intermediate Bi Developer

Key Responsibilities: Develop and maintain Business Intelligence solutions, focusing on data analytics and reporting for financial services applications. Build and optimize data pipelines and dashboards using SQL and visualization tools such as Power BI an


View Job
Intermediate Bi Developer

Johannesburg: Intermediate Bi Developer

The successful incumbent will require close collaboration with the team, engaging in hands-on development, and a true passion for building solutions. Requirements: 2-3 years experience in building data solutions, with a focus on BI/Data programs. IT Degree


View Job
Intermediate 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