Senior BI ETL Developer - Star Personnel Recruitment (Pty) Ltd, Cape Town

  • Cape Town
  • Salary: Market Related
  • Job Type: Permanent
  • Sectors: Banking, Retail, Finance
  • Posted by Star Personnel Recruitment (Pty) Ltd on Tuesday, May 12, 2020
  • Reference: 1664720
  • Apply before Saturday, July 11, 2020 - 44 Days left

Vacancy Details

Employer: Star Personnel Recruitment (Pty) Ltd

You will be 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.



·         Analysis of new requirements and adjusting the design of existing star schemas or designing new star schemas to meet query / reporting requirements

·         Interpreting user requirements and building data pipelines to populate data structures that are accurate, easily accessible and support consistent and informed operational, tactical and strategic business decisions

·         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


Required Skills

  • etl developer : 5 to 6 years

Candidate Requirements

This opportunity is with a well-known, stable and successful corporate client of ours in the Financial Services sector here in Cape Town. They currently employ +/-1800 staff and have built up an enviable reputation in the marketplace for being a really great place to work. (listed as a Top Company to work for, two years in a row)

Their culture is hi-energy, fast and flexible and one that is driven by innovative change.


They offer a market related salary package with a range of corporate benefits including: Relocation allowance, Medical Aid, Provident Fund, Incentives, on-site restaurant & coffee bar, secure on-site parking. 



·         Relevant tertiary qualification in Information Technology or similar

·         5+ years’ commercial Business Intelligence (Microsoft Stacks) development 

·         Essential technology experience: SQL, SSIS. 

·         SSAS, MDX, Tabular experience - advantageous

·         Working Understanding of Ralph Kimball methodology

·         Technologies currently in use at the client: Active Batch, Visio / Erwin modelling tools, Visual Studio , Cognos  / Tableau

·         Experience in Business Intelligence environment in Financial Services or Retail industry – desirable 

·         Strong analytical, problem solving and conceptual thinking skills

·         Good communication skills

·         Attention to detail

·         Ability to manage multiple priorities and deliverables

·         Flexible with the ability to operate in a fast paced changing environment required

·         Team player

This position reports to: BI Manager Apply before Saturday, July 11, 2020 - 44 Days left Companies may expire jobs at their own discretion. If you have not received a response within two weeks, your application was most likely unsuccessful.
11 people have applied for this job. 113 people have viewed this job.

Similar Jobs

More Star Personnel Recruitment (Pty) Ltd Jobs

About Star Personnel Recruitment (Pty) Ltd

Star Personnel Recruitment was established in 1986 and has become a well respected name in the recruitment and selection of top talent for a carefully selected number of the most sought after employers in South Africa. Having a reputation for expertly matching candidates based on skills, personality and attitude while treating all applicants in a confidential and professional manner.

With one of the most sophisticated and comprehensive recruitment databases in the industry, as well as a team of Senior Consultants constantly scouring the market for stars, Star Personnel takes the guesswork out of appointing top staff.