Description:
- Aggregate large sets of data from heterogeneous sources into a data warehouse that is used extensively across the organisation.
- Write relational and multidimensional queries, whilst creating and deploying reports.
- Create high-quality datasets for business analysts’ consumption.
- Author reports for operational use.
- Extend the data warehouse model with additional dimensions and facts.
- Integrate new data sources.
- Closely work with the BI operations team to rectify identified issues.
- Recommend improvements, participate in daily stand-ups and assist in task planning.
- 5 years’ experience in a similar role, relevant degree (preferably in Computer Science or BigData).
- Excellent SQL knowledge.
- Very good ETL and ELT knowledge (such as Microsoft SSIS, Microsoft Polybase, Google Cloud Dataflow).
- Very good understanding of data models and associated best practices.
- Experience with Microsoft SSRS, SSAS, PowerBI, Excel.
- Preferably experience with cloud columnar databases (such as Google BigQuery).
- Basic Microsoft SQL server administration knowledge.
- Experience with data quality techniques and best practices for the verification and accuracy of data.
- Use of Project tracking software (such as JIRA).
- A collaborative approach and worked in Agile teams.
- A continuous improvement mind-set.
- Excellent Microsoft SQL Server Reporting, Analysis and Integration Services experience.
- Knowledge of at least 1 data visualisation tool
- Able to communicate effectively at all levels in a collaborative style
- Very good written and spoken English
- Self-starter, fast learner and able to work with minimal supervision
- Effective team player
- Strong problem solving and analytical skills and attention to detail