BI.Intermediate Business Intelligence Developer

Company DOS
Reference # JDCIBI
Published 06/11/2017
Contract Type Permanent
Salary Market Related
Location Century City, Western Cape, South Africa
A role exists for an Intermediate Business Intelligence Developer in an online organization with a good history and strong BI Team.
This role requires a motivated, energetic, inquisitive and highly numerate person who has a solid technical base but also possesses an appreciation for numbers and understands the value that can be derived from interrogating them.
Job Functions Engineering,Information Technology,Software Development
Industries Ecommerce
•Integration of new sources of data into company databases so that it can also be analysed and included in relevant reports
•Integration of data into relevant workflow processes, with the specific aim of continuously improvement and data optimisation
•Conceptualizing, defining and delivering new reports as well as improving existing ones
•Analysis of data from various sources in order to ensure that the business acts proactively on the information at its disposal
•Continually searching for new and useful ways to obtain, integrate and analyse data that is relevant to the company’s business model
•Education of report end-users so as to ensure a maximum spread of expertise around the company
•Matric with 3 years relevant work experience; or
•Undergraduate degree with majors in Information Systems, Mathematics, Statistics, Engineering or similar
•Relevant Post Graduate degree is advantageous
•3-5 years SQL experience with specific reference to creation of stored procedures, functions, automation of jobs, performance tuning
•Working knowledge of SSIS is essential, with specific reference to ETL processes, error handling, data loading
•Working knowledge of SSRS is essential, with specific reference to building parameterized reports, create subscriptions and schedules, expressions and sub reports
•SSAS is advantageous
•Undergraduate degree (or substantial progress towards one) with majors in IS / math / stats / engineering or similar. Alternatively at least 3 years work experience in a business intelligence role will be considered. A relevant post-graduate degree will be a strong plus
•3-5 years strong SQL experience (creation of stored procedures, functions, automation of jobs, performance tuning and optimization, RDBMS, error handling and logging, etc.)

•SSIS (creation of complex ETL (Extract, Transform, Load) processes, error handling, loading data from various data sources (flat files, xml), integration of new data into data warehouse, precedence constraints, parameterized connections, etc.)
•SSRS (ability to build parameterized reports, create subscriptions and schedules, expressions, sub reports, etc.)
•SSAS (basic knowledge of multi-dimensional cubes)
•Conceptualizing new solutions based on business requirements

Advantageous Requirements:
•Knowledge of Kimball methodology (star schema)
•Knowledge of Agile Scrum methodology
•Change tracking/ CDC
•Software dev background

Personal Competencies:
•Able to work under pressure
•Proactive, analytical & resourceful
•Logical & ability to solve problems
•Excellent time-management skills
•Good interpersonal & communication skills
•Ability to deal with high volumes of stress
•Ability to adapt & be flexible

¬¬¬¬¬¬¬¬¬This position requires trust and honesty it has access to customers financial details - therefore a credit and criminal record check will be conducted.
The qualifications identified herein are an inherent job requirement, therefore a qualification verification check will be done.
By applying for this role, and supplying the necessary details, you hereby grant us permission to apply for these checks. This will be done in a confidential manner, and solely for the purposes of verification.

To view all current vacancies, please visit our website,
Should you not hear from us within 2 weeks, please deem your application as unsuccessful.
Job Closing Date 30/11/2017
Share on