BI Developer at DigiOutsource

Purpose Of The Role

A role exists for an Intermediate BI 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.

Duties Include, But Not Limited To

• 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

This job description is not intended to be an exhaustive list of responsibilities. The job holder may be required to complete any other reasonable duties in order to achieve business objectives.

Essential Criteria

• Matric with 3 years relevant work experience or Undergraduate degree with majors in Information Systems, Mathematics, Statistics, Engineering or similar. Alternatively at least 3 years work experience in a business intelligence role will be considered.
• 3-5 years SQL experience with specific reference to creation of stored procedures, functions, automation of jobs, performance tuning and optimization, RDBMS, error handling and logging, etc.
• 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
• 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.)
• Conceptualizing new solutions based on business requirements

Desirable Criteria

• Relevant Post Graduate degree
• SSAS (basic knowledge of multi-dimensional cubes)
• Knowledge of Kimball methodology (star schema)
• Knowledge of Agile Scrum methodology
• Change Tracking / CDC
• XML
• MDX
• Software Development background
• Python
• Kafka
• Kubernetes

Person Specifications

• Stress Tolerance
• Bottom Line Focus
• Numbers
• Problem Solving
• Organisation & Planning
• Time Management
• Interpersonal Skills
• Communication
• Adaptability / Flexibility
• Teamwork
• Please note we will apply relevance to our Talent Management and Talent Development Programme as part of our recruitment process.
• Shortlisted candidates may need to complete an assessment.