Job Opening at Mr Price Group

About Job

Why you should join this team?

You’ll be involved in projects involving BI and Analytics across multiple data disciplines: SQL and Big Data.

We’re also in the process of migrating the current data warehouses and reporting from on premise solutions to the cloud which means the opportunities for technical growth are endless!

what experience we’re looking for?

• Diploma or University Degree in Computer Science or equivalent.

• 3+ years’ experience in:

  • Data warehouse technical architecture, infrastructure components, ETL and analytical tools.

  • ETL processes, data warehouse modelling

  • Experience in cloud data warehousing

  • Integrating with BI Reporting Tools

  • MS SQL Server

  • Normalised and denormalised database design

  • Design and implementation of objects within the data warehouse environment

a day in your life?

• Building large scale databases

• Data modelling (Data Vault 2.0 and Star Schema), data management, ETL and BI

• Perform ongoing monitoring, automation and refinement of BI solutions.

• Work with BI Management to identify and resolve data related issues.

• Work with business departmental teams to help them define and document business requirements for new metrics and reports.

• Provide analysis and issue resolution on business reported concerns.

• Participate in design to influence delivery of dashboards and various self-service business intelligence solutions.

• Contributes to the designs and plans for the integration for all data warehouse technical components.

• Contributes to the design, automation, and acquisition, transformation and data loading processes in a high volume, high availability data warehouse environment

• Manages the automation and operations of the data warehousing loading process

• Contributes to the design of the data warehouse architecture

• Provides production support to solve immediate problems and keeps databases in production

• Analyses information requirements of customers and supports teams and contributes to the design of the best technical solutions

• Collaborates with business and technical partners to understand and evaluate their needs for data from the data warehouse.

• Technical implementation of the data warehouse

• Participates in testing of the data design, tool design, data extracts

• Optimisation, support and maintenance of the data warehouse environment

go to method of application »

About Job

We’re looking for a passionate, experienced backend focused Software Developer to bring their mad skills into our Mr Price technology family!

This role falls into our Retail project team and consists of an amazing group of individuals that come with a wealth of experience. They are focused on developing and improving our internal retail and merchandising systems, that will take The Mr Price Group into the future.

what experience we’re looking for?

• Relevant IT Qualification

• 2- 5 years’ experience in Database Development with specific experience in:

• A mainstream tech stack (ideally C#, JavaScript, Microsoft SQL)

• Data interchange formats such as XML and JSON, and technologies related to processing, transformation and validation of them (i.e. XSD and XSLT)

• Business Intelligence Tools e.g. Microsoft SSIS/SSAS/SSRS

• API Integration Code Development

• Understanding of integration principles & patterns

• Implementing integration solutions using a middleware technology

• React.js skills would be an advantage

a day in your life?

• Liaising with business and across IT teams to determine requirements, expanding on these requirements, designing appropriate software and database solutions and documenting these in a specification

• Develop, implement, and manage standard operating processes for database administration

• Develop, enhance, and maintain applications that conform to user requirements and specified architectural design with little supervision in well designed and efficient code

• Ensuring that risk to data integrity is minimised through a thorough understanding of the impact of changes to systems and databases.

• To gain a comprehensive understanding of the transactional systems and integration landscape and assess impact of new projects and business requirements on this environment.

• To understand and assess the development standards and frameworks in place to ensure continued suitability to achieve objectives and meet requirements and suggest and implement changes where applicable

• Complete and maintain relevant documentation and version control disciplines to maintain source code