BI Developer - HomeChoice

HomeChoice is a leading omnichannel retailer, delighting our customers with an innovative range of curated products on personalized terms. Our aim is to provide multiple, convenient and easy retail shopping channels to guarantee that we meet all our customer expectations. 

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

Here’s what you can expect to be doing in the role

Support of Information Delivery production environment

• Understanding the current production 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

Qualifications & Accreditations

• Relevant 3 years IT degree/diploma 

Experience & Skills

• 4-5 Years’ DTS experience and have worked with the new SSIS
• Advanced or expert level in SQL, writing stored procedures and general scripting
• Experience building and maintaining OLAP cubes in Analysis Services 2005 and 2008
• Experience in reporting services 2005 and have developed reports
• Experience of data warehouse design
• Test Methodologies
• Data warehousing skills
• Retail experience preferred