Senior BI Developer at DigiOutsource

About the Job

The Department

• As DigiOutsource’s Business Intelligence (BI) department, we deliver information to the company that is timely, accurate, reliable and relevant. Our information is utilised across the entire business from front facing customer hosts through to executives. Data originates from a multitude of external sources, and is then warehoused and processed into meaningful information. Ongoing analysis and evaluation of results is a daily function. All information systems are designed to provide ease of access, to be extracted on a self-service basis by all users.

Purpose Of The Role

• A role exists for a Senior BI Developer in an online organization with a good history and strong Data 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
• Designing new database structures or enhancing existing ones to cater for optimal process flow and optimal user querying
• 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
• Debugging, monitoring and troubleshooting current solutions
• Work with Project Managers and Product Owners in developing and executing project plans or development tasks within assigned schedule and timeline.
• Guide and mentor junior resources when needed
• 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

• 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.
• 6+ years strong SQL experience (creation of stored procedures, functions, automation of jobs, performance tuning and optimization, RDBMS, error handling and logging, incremental data loading, change tracking/cdc. etc.).
• Minimum 4 years SSIS experience (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.)
• Ability to build reports in Excel and reporting tools such as SSRS.
• Minimum of 4 years’ experience with OLAP reporting tools and cube technologies, such as SSAS/Cognos (creation, implementation and maintenance of multi-dimensional cubes, MDX, DAX)
• Minimum of 4 years’ experience in front end visualisation tools such as Power BI/ Qlikview /Tableau/ Cognos (creation, implementation and maintenance of analytical dashboards and visualisations).
• Advanced skills in MS Excel.
• Be able to give accurate technical estimates.
• Driving new solutions based on business requirements.
• Strong communication skills, ability to mentor others.
• Demonstrates consistent behavior aligned to the Combiined F and Organizational Culture.

Desirable Criteria

• DBA experience
• Software dev background
• XML
• Knowledge of event-driven programming
• Service broker queue
• 1 year of project management experience

Person Specifications

• Stress Tolerance
• Bottom Line Focus
• Numbers
• Problem Solving
• Organisation & Planning
• Innovation
• 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.