Business Intelligence (BI) Developer

Purpose:

The BI Developer is responsible for end to end BI development, support, monitoring, analysis 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
• ETL
• Packages
• Cubes and Tabular Models
• Reports and dashboards
• 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

Planning and Design:

• Output
• Tasks
• Integration
• Packages
• Cubes and Tabular Models
• Reports and dashboards
• FTPs
• Data Quality
• General BI Planning and Design

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 IS / IT 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