Data Warehouse Developer Mr Price Group

Job Title: Data Warehouse Developer

Our new Data Warehouse Developer will be responsible for designing, developing, and maintaining enterprise data warehouse to meet the group’s needs.

You would be part of the Mr Price Advance team which looks after data analytics, reporting, data science and RPA across the group

Responsibilities

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!

Requirements

Relevant IT Degree or Diploma 

3+ years’ experience in:

• Data warehouse design and implementation, infrastructure components and analytical tools.
• Data warehouse modelling
• Structured Query Language (SQL)
• Experience in Snowflake data warehousing
• Troubleshooting

• Building large scale databases
• Data modelling (Data Vault 2.0 and Star Schema), data management, and data transformation
• Perform ongoing monitoring, automation and refinement of implemented solutions.
• Provide analysis and issue resolution on business reported concerns.
• Participate in design to influence delivery of various 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
• 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
• 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
• Participates in testing and validation of the data model throughout the various stages of the development process.