BI ETL Developer (Senior)

Recruiter:

Tower Group

Job Ref:

CPT003850/RC

Date posted:

Wednesday, May 19, 2021

Location:

Capetown, South Africa

Salary:

300 Hourly

SUMMARY:
Our client, a leader in the Financial Services Sector, is looking for a BI ETL Developer based in Cape Town. R300 - R450 p/h. 12 Month Contract.

POSITION INFO:

BI ETL Developer (Senior)

Main Purpose:

Responsible for creating ETL processes for transforming data residing in various source systems into actionable information using ETL tools and coding primarily in Transact-SQL. Interpreting user requirements and building data pipelines to populate data structures that are easily accessible and provide accurate information which supports consistent and informed operational, tactical and strategic business decisions. To be successful in this role you will need to have experience working with the Microsoft BI Stack and be well versed in the Ralph Kimball methodology.

Key Responsibilities:

Analysis of new requirements and adjusting the design of existing star schemas or designing new star schemas to meet query / reporting requirements
Adjusting existing ETL processes, or designing and building new ETL processes to accommodate new requirements
Testing and reconciliation of warehouse data to source data to ensure data integrity
Adhering to company’s internal BI SDLC and development methodologies
Provide a high-level of customer service

Key Competencies:

Strong analytical, problem solving and conceptual thinking skills essential
Attention to detail and commitment to delivery is important
Must be a team player with a positive attitude
Must be able to work to and manage deadlines
Flexible, able to change focus when required
Presentable with excellent communication skills

Qualifications and Experience:

Relevant tertiary qualification in Information Technology or similar
5+ years’ commercial Business Intelligence (Microsoft Stacks) development
Essential technology experience: SQL, SSIS.
SSRS, SSAS (multi-dimensional and tabular models), MDX, PowerBI (advantageous)
Working Understanding of Ralph Kimball methodology
Experience in Business Intelligence environment in Financial Services or Retail industry – desirable

Other technologies in use :

Active Batch
Visio / Erwin modelling tools
Visual Studio
Cognos / Tableau

NB! This job is now closed. You can apply for other jobs by uploading your CV.

Similar jobs you might be interested in:

Business Report Analyst
Location: Cape Town
Salary: 500 000 Annually
Brief Description:Are you a data-driven professional with a passion for transforming numbers into actionable business insights? We’re seeking a Business Reporting Analyst to join a dynamic finance team in Cape Town, helping guide strategic decision-making through meaningful analysis of operational and customer data.
1 day ago

Business Reporting Analyst
Location: Cape Town
Salary: 500 000 Annually
Are you a data-driven professional with a passion for transforming numbers into actionable business insights? We’re seeking a Business Reporting Analyst to join a dynamic finance team in Cape Town, helping guide strategic decision-making through meaningful analysis of operational and customer data.
7 days ago

Senior BI Developer
Location: Cape Town
Salary:
10 days ago

Data Engineer
Location: Stellenbosch
Salary: Annually
Seeking a Data Engineer with strong Google Cloud Platform (GCP) experience. The Data Engineer will be responsible for designing, building and maintaining scalable data pipelines and architecture that powers the business.
11 days ago

BI Developer
Location: Cape Town
Salary: Annually
A well-renowned company with a top-tier investigation unit (aka Business Intelligence Team) is on the lookout for a sharp-eyed bi developer. Think CSI, but instead of fingerprints, you’re tracking trends, patterns, and anomalies in data. This is a confidential mission for one of my clients — and they need a data detective like you.
63 days ago

Business Reporting Analyst
Location: Cape Town
Salary:
An exciting opportunity has become available for a skilled Business Reporting Analyst to join a leading organization in Cape Town. This role is well-suited to a detail-oriented professional with a passion for transforming complex data into clear, meaningful insights that directly support executive decision-making.Our client, a well-established company in a highly regulated and dynamic industry, is...
1 day ago

Data Analyst
Location: Cape Town
Salary: Market Related
Are you passionate about transforming data into actionable insights that drive business decisions? Do you have a sharp eye for detail, strong analytical skills, and a knack for simplifying complex information? If so, this Data Analyst role could be your next career move!A leading organisation in the entertainment and leisure sector is looking for a Data Analyst to join their dynamic Finance team b...
1 day ago

Business report analyst
Location: Cape Town
Salary:
Business Report AnalystAre you passionate about turning data into meaningful insights that drive executive decision-making? This is your opportunity to join a dynamic, fast-paced gaming and entertainment environment as a Business Reporting Analyst, where your analysis will directly impact business strategy and operations.Join a leading player in the gaming and entertainment industry, committed to ...
1 day ago

Data Tester
Location: Cape Town
Salary:
14 days ago

AWS Data Engineer
Location: Cape Town
Salary:
15 days ago

BI ETL Developer (Senior)

Similar jobs you might be interested in:

Create a free job alert for BI ETL Developer (Senior) in Capetown