Senior BI Developer - Homechoice - Southern Cape at HomeChoice Holdings Limited

• 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

Requirements

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 focused

Behaviours

Wow my customer

• Walk in my customers’ shoes
• Deliver on my promises
• Deliver insight-led solutions my customers need

treat the business as my own

• Take accountability
• Be curious, creative & explore opportunities
• Do it right & at the right time

play as a team

• Be helpful
• Be inclusive
• Find the fun