Menu Close

Cape Town: Intermediate Bi Etl Developer posted by Datafin

Date 2024-12-25
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-12-25 at 16:09:12 in the It Computer category

Click Go Apply to apply online!

View Job  Cape Town: Wage Administrator posted by Dymaxa Recruitment

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: Intermediate Bi Developer – Johannesburg – R450k To R650k Per Annum

A company specialising in information technology services while offering strategic consulting to leading- edge technologies and enable experiences that transform organisations for success while shaping a better society have an opening for an Intermediate B


View Job
Intermediate Bi Developer – Johannesburg – R450k To R650k Per Annum

Johannesburg: Intermediate Bi Developer

The successful incumbent will be required to closely collaborate with the team, engaging in hands-on development, and have a true passion for building solutions. Requirements: 2-3 yearsâ?? experience in building data solutions, with a focus on BI/data prog


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  Cape Town: Forwarding Controller posted by Goldman Tech

View Job
Intermediate Bi Developer

Johannesburg: Intermediate Mobile App Developer

Experience Required: 3 years of experience in mobile app development. Strong expertise in mobile frameworks such as Ionic and Flutter, as well as experience with Firebase, Cordova, and .NET Core. Solid understanding of RESTful APIs, Play Store/App Store de


View Job
Intermediate Mobile App Developer

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: 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 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

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

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  Western Cape: Finance Administrator posted by University of Cape Town Lung Institute (Pty) Ltd

View Job
Intermediate Bi Developer

Johannesburg North: Intermediate Mobile App Developer posted by Network Finance

Experience Required:3+ years of experience in mobile app development.Strong expertise in mobile frameworks such as Ionic and Flutter, as well as experience with Firebase, Cordova, and .NET Core.Solid understanding of RESTful APIs, Play Store/App Store depl


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