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

What you will love doing in this role

Support of Information Delivery production environment

• Understanding the current product environment and maintaining it
• Contribute to the 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 on 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 we will love about you

• Excellent problem-solving/analytical abilities,
• Project management skills
• Highest programming logic
• Ability to work under pressure
• Team player who can also work alone
• Able to multi-task
• Able to work in conditions of change
• Take ownership of problems assigned
• Delivery Focused

What you'll need to do this role

• A relevant 3-year degree/diploma
• 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