Data Warehouse Developer Kzn

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.