Homechoice Senior BI Developer

Homechoice invites young unemployed people who meet necessary requirements to apply for the senior BI developer position

homechoice is a leading South African homeware retailer. For over 35 years we’ve helped our customers create beautiful homes they love with an innovative range of quality products they can afford. 

The ideal candidate for this role will further develop Data Warehouse and reporting solutions.

What you will love doing in this role 

You love supporting of Information Delivery production environment

  • Understanding the current product environment and maintaining it
  • Contribute to Standby roster to ensure on-going delivery of current information to the business on time
  • Effectively collecting & sourcing information and then correctly transforming & auditing this information
  • Accurately publishing the information
  • Appropriate resolution of production issues to ensure that information is delivered according to user expectations
  • Continuously identifying and improving processes & procedures to minimise negative impact to data and business reporting
  • Monitoring of the environment to proactively engage in preventative activities and to maintain an environment that is easy to understand and troubleshoot

You love delivering data & information (projects, quick wins)

  • Understanding business data and information requirements
  • Delivering data and information to the business in line with business priorities, according to quality standards, within the agreed time constraints and according to departmental coding practice & standards
  • Being involved in the process of populating new data within the Data Warehouse
  • Logical and Physical design of fact and dimensions and transformation processes
  • Taking over information delivery tasks from other areas of the business

You love User Support

  • Provide support service to users on data and information to satisfy user needs


What you’ll need to do this role

  • Relevant 3-year degree/diploma 
  • 5 Years + experience
  • Advanced SSIS experience (ETL Development)
  • Advanced or expert level in SQL, writing stored procedures, and general scripting
  • Experience building and maintaining Tabular Models in Analysis Services 2012 
  • Experience with Datawarehouse design methodologies (Kimball)
  • Strong experience with debugging and issue resolution
  • Proficient in creating DAX queries (SSAS)
  • Working knowledge of SSRS
  • Experience using Power BI to build and maintain dashboards
  • Test Methodologies
  • Advantageous skills: VB, C# (SSIS)
  • Working knowledge of MDS
  • Exposure to Agile methodologies
  • Retail experience preferred

What we will love about you

  • We love your excellent problem-solving/analytical abilities
  • We love your project management skills
  • We love you high programming logic
  • We love your ability to work under pressure
  • We love that you are a team player who can also work alone
  • We love your multi-tasking skills
  • We love that you are able to work in conditions of change
  • We love that you are delivery focuse

Click here to apply online for the homechoice senior BI developer