Lactalis South AfricaSenior BI Manager/Developer
May. 2022 - Aug. 2022Stellenbosch, Western Cape, South AfricaSummary: This role encompassed the entire Business Intelligence (BI) development cycle, including Data Warehouse (DW) and BI project implementation. It requires a deep understanding of database management systems, OLAP (Online Analytical Processing), and ETL (Extract, Transform, Load) frameworks. Key skills include advanced SSIS for data integration, SQL for table creation and data optimization, SSAS and Tabular services for the presentation layer, and advanced T-SQL for complex query writing. The role also involved data warehouse design, dimensional modeling, architecture, and data mining. Responsibilities included translating business requirements into technical specifications, designing, developing, deploying, documenting, and maintaining BI solutions. This role also included creating data mappings and ETL scripts, building dashboards, and business reports using tools like Excel, Power BI, and QlikSense. Additionally, it involved evaluating and enhancing existing BI systems, tools, maintenance, and procedures, aligning Key Performance Indicators with reporting and analytics, and writing both business and technical documentation. Debugging, monitoring, and troubleshooting BI solutions was also part of the role.