Business Intelligence (BI) Developer

A great opportunity to work for a reputable healthcare company as a BI Developer.

Main Purpose of Job

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.

Key Performance Areas:

1

Coding and Scripting:

• SQL
• C#
• VB / .NET
• DAX
• MDX
• General BI Coding and Scripting (any other required language or platform)

2

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)

3

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)

4

Scheduling and Monitoring:

• Data and Data Files
• ETL
• Packages
• Cubes and Tabular Models
• Reports and dashboards
• FTP’s
• Data Quality
• General BI Monitoring and Scheduling

5

Database Management:

• Table Management
• Data Management
• User Management
• Backups and log files
• Restore and Recovery
• Data Access
• Indexing
• General Database Management and Administration

6

Planning and Design:

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

7

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

Role Complexity:

Working with internal and external data and data suppliers.

Minimum Requirements:

EDUCATION

Matric

Degree or Diploma in IT / IS or related field

MS certification advantageous

MS BI certification advantageous

EXPERIENCE.

Minimum of 4 years overall in SQL development

Minimum of 2 years in end to end BI tools

SKILLS/PHYSICAL COMPETENCIES

• 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

BEHAVIOURAL QUALITIES

• Ability to work under pressure
• Target and goal Driven

• Flexibility and willingness to learn
• Passion for data and coding
• Ability to work accurately, with attention to detail
• Logical and Analytical thinking
• Problem solving
• Self motivated
• Planning and Organizing
• Ability to prioritise and adapt to changing priorities
• High level of confidentiality
• Ability to work independently
• Good interpersonal skills

DESIRABLE SKILLS & EXPERIENCE:

• Information Systems / Information technology or related Degree / Diploma
• MS Certification
• End to End Business Intelligence Experience