Business Intelligence (BI) Developer

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