Job Summary
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
