Assist the BI Analysts in the Reporting team with requests coming from business. Able to assist with maintenance of the Data Warehouse.
• Assist with requests which come into the BI group mailbox. Requests will include SQL queries that need to pull data from the data warehouse and compiled into Excel.
• Confirm that daily BI tasks have been completed, which can include sending out of SMS, follow up with Call Centre to determine call lists have been loaded etc.
• Assist with data warehouse maintenance, this includes completeness of data records and mapping needed from 3rd party data.
• Monitor that the data warehouse standards are being adhered to.
• Assist with the Weekly Sprint work allocation and monitoring progress of tasks, being able to assist if need.
• 3 Year Degree (Business Science, B.Com Finance, Mathematics or IT Related).
• Experience coding in SQL, PostgreSQL or MySQL an advantage
• Knowledge of BI concepts and architecture. (Microsoft Certified Solutions Expert: BI Course)
• Microsoft Excel
• Enthusiastic, self-motivated team player.
• Able to work unsupervised
• AWS Redshift, Bash, MySQL an advantage.