The posting
The BI Developer is responsible for end to end BI development, support, monitoring and maintenance within the BI and Data Warehouse environment/s, as well as general BI functions to assist the BI team in day-to-day operations and ad hoc tasks when required.
Duties and responsibilities:
Coding and Scripting:
- SQL, C#, VB / .NET, DAX, MDX
- General BI Coding and Scripting (any other required language or platform)
Development and Maintenance:
- ETL, SSIS, Stored Procedures, Views, SSRS, SSAS
- Reports and Dashboards
- PowerBI
- Data Science and Machine Learning
- Semantic and Analytical layers
- General BI Development and Maintenance (any other required tool or platform)
Support and Analysis:
- Data, Data Models
- ETL
- Packages
- Cubes and Tabular Models
- Reports and Dashboards
- Scripts and Code
- Stored Procedures and Views
- Requirements
- Predictive Analytics
- Data Science and Machine Learning
- Solution / System
- General BI Support and Analysis (any other required tool, platform or area)
Scheduling and Monitoring:
- Data and Data Files
- FTPs
- Data Quality
- General BI Monitoring and Scheduling
Database Management:
- Table Management
- Data Management
- User Management
- Backups and log files
- Restore and Recovery
- Data Access
- Indexing
- General Database Management and Administration
General BI:
- Infrastructure management
- User Management
- Security Management
- Schedule and Monitoring
- BI Methodologies
- Best Practice
- Dimensional Modelling
- FTP Management
- Master Data Management
- Data Quality Management
- Metadata Management
- Technology Management
- Automation
- General BI Knowledge
Qualifications and experience:
- Matric
- Degree or Diploma in IT / IS or related field
- MS certification advantageous
- MS BI certification advantageous
- Minimum of 4 years overall in SQL development
- Minimum of 2 years in end to end BI tools
- Strong data processing skills
- Strong data analysis skills
- Sound knowledge and experience in Microsoft Business Intelligence Tools
- Exceptional coding skills (SQL, C#, other)
- Advanced skills in Report and Dashboarding tool/s and techniques
- Knowledgeable in BI tools, techniques and methodologies
- Database management



