Connecting...

W1siziisinrozw1lx2fzc2v0cy9wzw9wbgvzb2x2zwqvanbnl2jhbm5lci1kzwzhdwx0lmpwzyjdxq

Senior BI Developer

Senior BI Developer

Job Title: Senior BI Developer
Location: Gauteng
Industry:
Salary: 720000.00
Reference: JN -122016-7286
Job Published: October 20, 2017 11:19

Job Description

The role of a Data Analyst and Business Intelligence Developer is to transform data found inside of an organization into new information that will be used to make business decisions. We are looking for a Data Scientist that will help us discover the information hidden in vast amounts of data, and help us make smarter decisions to deliver even better products.

Key Performance Areas:

General:

  • Designing, building and deploying data warehouse solutions using Microsoft SQL Server Business Intelligence technologies while ensuring that existing adopted data warehousing methodologies, Microsoft best practices and industry best practices are followed.
  • Translating business requirements into functional and technical requirements and communicate these requirements to the business and relevant technical teams.


Technical:

  • Designing and implementing integration technology between Microsoft SQL Server Business Intelligence technologies and other business systems adhering to Microsoft and industry best practises.  
  • Designing, building and deploying, timeous, relevant and accurate management reporting, using Microsoft SQL Server Reporting Services and Microsoft Power BI.
  • Monitoring Microsoft SQL Server Business Intelligence technologies performance
  • Creating and maintaining architectural, project and operational documentation


Functional:

  • Respond to ongoing business requirements by improving the business intelligence solution through continual development, maintenance, support and enhancement
  • Conducting root-cause analysis to identify problems areas and risks in systems or application design.
  • Assisting in aligning systems strategy and roadmap with business needs
  • Designing and conducting a detailed system test plan to ensure an accurate and effective systems / application implementation
  • Performing end-user training and conduct workshops
  • Performing analysis to determine scope and objectives for business, functional and technical requirements


Qualifications and Experience:

Junior BI Developers

  • Minimum of 1 year SSIS experience.
  • Minimum of 1 year experience in building and maintaining OLAP cubes in analysis services 2005.
  • A demonstrated experience in complex reports, master reports and cube reporting.
  • 1 – 2 years experience in database design and the normalization of data structures – must have developed a star schema and facilitated a team effort.
  • 1 – 2 years experience in Database administration.
  • A passion for the industry and be willing to do self – study.


Intermediate and Senior BI Developers

  • Minimum of 2-5 years SSIS experience.
  • Minimum of 2-5 years experience in building and maintaining OLAP cubes in analysis services 2005.
  • A demonstrated experience in complex reports, master reports and cube reporting.
  • 3 – 5 years experience in database design and the normalization of data structures – must have developed a star schema and facilitated a team effort.
  • 2 – 4 years experience in Database administration.
  • A passion for the industry and be willing to do self – study.
  • Experience in application design, development and performance tuning
  • Fluent in English (speak / read / write)
  • Understanding of Software Development Lifecycle (SDLC) methodologies
  • Knowledge and Experience in SSIS, SSRS and SSAS
  • Ability to create advanced data models using computerised tools.
  • Ability to cull data and extrapolate data patterns.
  • Ability to design and implement meaningful reports and dashboards using computerised tools.


Functional Competencies:

  • SSSIS
  • Building and maintaining OLAP cubes in analysis services 2005
  • Database design
  • Database administration
  • Understanding of writing SQL statements
  • SSAS and MDX
  • Reporting services 2005
  • Microsoft office package
  • SQL, stored procedures, triggers, cursors and general scripting
  • SharePoint PerformancePoint and PowerPivot (advantageous)


Behavioural competencies:

  • Presentable.
  • Pragmatic.
  • Diligent.
  • Perseverant.
  • Proactive.
  • Planning and organising.
  • Knowledge Specialisation.
  • Must be individually driven and motivated.
  • Must be reliable and responsible.
  • Must be enthusiastic.


Skills:

  • Strong analytical and problem solving abilities
  • Clear and logical thinking
  • Team player that is easy to work with and that functions in any size team
  • Demonstrates personal motivation and a positive attitude
  • Uses initiative, shows determination and commitment to delivery
  • Copes under pressure
  • Demonstrates resilience
  • Facilitation Skills
  • Strong work ethic and drive for results
  • Values quality and produce high quality work at all times
  • Good verbal and written communication skills, including an extensive vocabulary of general language and ICT terminology
  • Reliable – ensures that if an assignment is allocated, it will be completed as agreed
  • Willing to learn other platforms
  • Demonstrates high ethics and adherence to Dimension Data values
  • Self-motivated, with a keen passion to stay ahead of the trends.
  • Risk management/risk mitigation skills.
  • Strong analytical and problem solving abilities
  • Clear and logical thinking
  • Team player that is easy to work with and that functions in any size team
  • Be able to give accurate technical estimates.
  • Be able to work in a team environment.
  • Be able to interact well with management and colleagues.
  • Be able to successfully adapt to changing demands and conditions.