Senior BI ETL Developer

 

Recruiter:

Datonomy Solutions

Job Ref:

240

Date posted:

Thursday, April 1, 2021

Location:

Pinelands, South Africa

Salary:

Market related


SUMMARY:
Responsible for creating ETL processes for transforming data residing in various source systems

POSITION INFO:

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 at RCS BI: 

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

Group Finance & Commercial Manager
Location: Durban
Salary:
Do you have the commercial experience in developing, planning and implementing strategies to promote growth, coupled with the finance costing expertise working in a manufacturing environment?Our International client requires your senior experience with activity based costing, leveraging costing, integrating product pricing, accounting, and commercial functions interacting with clients entities in ...
15 days ago


Group Commercial Manager
Location: Durban
Salary:
Have you worked for an International manufacturing company and are looking for a career growth position based at Cape Town Head Office?We require your experience at group level leveraging costing, integrating product pricing, accounting, and commercial functions in order to evaluate performance and identify opportunities for business improvement.This is a critical commercial function with the grou...
16 days ago


Management Accountant & Commercial Manager
Location: Durban
Salary:
Are you a Management Accountant with experience in manufacturing and production with experience performing a commercial function integrating pricing, costs, efficiencies and profitability internationally with factories worldwide.Our International Client requires a new member to join their team who will be at group level leveraging costing, accounting, and commercial functions to evaluate group per...
17 days ago


Group Costing Commercial Manager
Location: Durban
Salary:
Are you wanting to relocate to Cape Town?We require your successful track record in a senior accounting role involving management accounting and project management  overseeing a range of commercial activities in a manufacturing/production organisation for an International organisation?Our International Client requires your costing experience to operate at a group level of responsibility lever...
17 days ago


Create a free job alert for Senior BI ETL Developer in Pinelands

Enter your email address below and we will email you similar jobs when they become available:

You can cancel at any time. We will not spam you.
By giving us your email address your agree to our Terms and Conditions