Job Description

Lactalis SA based in Stellenbosch, Cape Town is looking for a Senior BI Developer / Analyst to assist in BI Development and Data Warehouse Design delivering reports and dashboard solutions that meet the requirements of the organization. The developer must work well in a team setting and have excellent organizational, prioritization, communication, and time management skills.
Required Skills
7+ years of proven experience in Full Microsoft BI Stack Framework as a BI Developer
Relevant Information Technology Degree or Diploma.
Working knowledge on translating business needs into technical specifications.
Strong analytical, troubleshooting skills and root-cause analysis.
Advanced knowledge of Microsoft Excel (pivot tables, formulas).
Experience building business reports using Excel, Microsoft BI toolset and QlikSense
General user assistance and training as required.
Collaborate with teams to integrate systems
Will be required to perform all listed functions for Lactalis SA and Rest of Africa
SAP BW Experience an advantage
Required Competency:
Ability to work in a high pressure environment
Ability to appropriately prioritize and plan activities across multiple stakeholders
Strong coordination ability
Strong Financial Background
Duties & Responsibilities
Full BI Development Cycle (End to end implementation of DW and BI projects)
In-depth understanding of database management systems, OLAP and ETL framework
SSIS at an advanced level for Data integration
SQL database for table creation and data optimization
SSAS and Tabular services for the presentation layer
Advanced TSQL to write complex queries
Data Warehouse design (dimensional modelling, architecture, data mining)
Translate business needs to technical specifications
Designing, developing, deploy, documenting and maintaining BI solutions
Design and develop data mappings and ETL scripts
Dashboarding
Evaluate and improve existing BI systems, tools, maintenance and procedures
Designing and implementing reporting solutions
Aligning Key Performance Indicators, reporting and analytics.
Develop and Update Business & Technical documentation
Writing relational and multidimensional database queries
Debugging, monitoring and troubleshooting BI solutions
Establishing a Power BI Practice that will enable Self Service within various Business Units.

Skills Required