Data Analytics Consultant - HR Studio (Pty) Ltd, Johannesburg

  • Johannesburg
  • Salary: Market Related
  • Job Type: Permanent
  • Sectors: General
  • Posted by HR Studio (Pty) Ltd on Tuesday, February 12, 2019
  • Reference: 1523309
  • Apply before Saturday, April 13, 2019 -

Vacancy Details

Employer: HR Studio (Pty) Ltd

We’re looking for…

A Data Analytics Consultant to join a highly experienced and growing team.

Who are you?

Excellent presentation skills (customers at all levels of the organisation – including CxO level)

Ability to interpret and develop against business requirement specifications, technical designs documents

Should be involved and seen as an influencer in the SQL/BI community

Good project and time management skills

Ability to work with people at all levels of the organisation and good people management skills

Ability to assist, train and mentor fellow or junior team members


What’s the role?

You will be responsible for:

  • Transforming data into business value and insight
  • Data analysis and presentation
  • Advanced SQL querying skills
  • Advanced Excel skills
  • Data Analytics Architecture and concepts
  • Business Intelligence and Decision Support concepts
  • Architecting Report and dashboard solutions
  • Managing projects and tasks, as well as executing tasks within specified timelines across the teams

Boxes to Tick…

  • Matric
  • MCSE (Business Intelligence SQL 2012/2014/2016)
  • Microsoft Azure Cloud Certification (Data Analytics)
  • MSc Computer Science / BSc Statistics / BCom Informatics or Information Systems (Preferred / Advantage) or Equivalent Experience.
  • Minimum of 2 years or more solid experience in developing and maintaining Data Analytics (Business Intelligence) solutions
  • Minimum of 2 year or more experience in the Microsoft SQL Business Intelligence suite (SSIS, SSAS and SSRS)
  • A solid understanding of Microsoft SQL Server
  • A solid understanding of Dimensional Modelling and Data Warehouse design (Kimball)
  • Experience with the build of ETL processes in SSIS or Azure Data Factory
  • Experience with SSAS Multi-Dimensional and Tabular Models
  • Experience with MDX or DAX query languages
  • Experience building Solutions with Power BI
  • Experience with Report and Dashboard delivery
  • Exposure to Microsoft Power BI and Power BI Integration with On-Premise Solutions
  • Exposure to Microsoft Azure Services for Data Analytics and Data Platform (Microsoft Cortana Analytics)
  • Microsoft SQL Business Intelligence suite

Candidate Requirements

You have good knowledge in the following:

  • Data Warehouse (Dimensional Model) design and principals based on Ralph Kimball methodologies
  • Knowledge and understanding of data warehousing in within cloud environments (Azure Data Warehouse)
  • Designing and implementing Data Analytics and Business Intelligence solutions using the
  • Software development lifecycle and different project delivery methodologies (waterfall, agile, etc.)
  • ETL solutions using SSIS or ADF
  • Building Power BI reports and dashboards


You’re someone who…

  • Keen interest to learn new technologies and methodologies
  • Ability to mentor, lead and inspire members of the team
  • Research and development orientated
  • Problem solver
  • Information gathering
  • Structured delivery approach
  • Applying Professional / Specialist / Technical Expertise
  • Creative and innovative
  • Quality and attention to detail
  • Planning and organising
  • Eager to Learn, Build and Deploy latest Microsoft On-Premise or Cloud Technologies
Apply before Saturday, April 13, 2019 - Companies may expire jobs at their own discretion. If you have not received a response within two weeks, your application was most likely unsuccessful.
Hot Job 47 people have applied for this job. 305 people have viewed this job.

Similar Jobs

More HR Studio (Pty) Ltd Jobs

About HR Studio (Pty) Ltd


HR Studio was created to connect extra-ordinary talent with dynamic brands using best HR standards and practises.


Founded in 2015, HR Studio is a bespoke consultancy for small to medium sized businesses who need the same quality HR services as a large corporate but an HR solution that can be tailored to their size and budget.

HR Studio offers specialist Human Resources services across various industries. A group of specialists that pride themselves on becoming subject matter experts in your business, the HR Studio team merges seamlessly with your organisation and culture. With people being your business’s most critical asset, HR Studio is committed to ensuring your employees achieve their full potential, work efficiently and most importantly provide value to your business.

HR Studio’s immersive approach ensures support and continuity throughout the employment lifecycle, leaving you to do what you do best and grow your business exponentially.  

We aim to enable SMEs to build exceptional work environments that source and incubate talent to ensure higher productivity, quality results and low employee turnover.