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:

Supervisor
Location: Durban
Salary: Market related Monthly
The group is a market leader in roll-on/roll-off (Ro Ro) shipping and vehicle logistics, managing the distribution of cars, trucks, rolling equipment and breakbulk to customers all over the world.The company operates around 125 vessels servicing 15 trade routes to six continents, a global inland distribution network, 66 processing centers and seven marine terminals.
14 days ago


Property Service Manager
Location: Durban
Salary:
70 days ago


SQL Developer
Location: Durban
Salary: R40 000 Monthly
Our client is seeking an experienced MI SQL developer to take a key role in building, maintaining, and optimising data-driven solutions that support both internal operations and external client needs. This role centres around developing efficient SQL processes, managing etl pipelines, and producing clear, impactful reports to drive informed business decisions.
1 day ago


Data and Analytics Team Lead (Business Intelligence / Mentorship Focus) - Durban – up to R900k
Location: Durban
Salary: 900000
Data and Analytics Team Lead (Business Intelligence / Mentorship Focus) - Durban – up to R900k
15 days ago


BI Developer
Location: Durban
Salary: 600 000 Annually
Do you have a knack for transforming raw data into meaningful insights? If you’re an experienced SQL/bi developer ready to take the next step in your career, then this is your opportunity to make a real impact at a well-established customer solutions company. We're building out our strategic data capability and we’re looking for someone to lead development from the front. You'll work a...
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