Senior BI Developer Southern Suburbs (Cape) at HomeChoice Holdings Limited

Description

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

Support of Information Delivery production environment

• Understanding the current product environment and maintaining it
• Contribute to Standby roster to ensure ongoing 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

Deliver 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

User Support

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

Requirements

What you'll need to do this role

Qualifications & Accreditations

• Relevant 3-year degree/diploma 

Experience & Skills

• 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

• Excellent problem-solving and analytical abilities
• Energetic and focused individual
• Ability to work well under pressure
• Team player who can also work
• Ability to take ownership of problems assigned and find innovative solutions
• Strong communicator (written and verbal)
• Strong desire and initiative to develop self