Intermediate 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 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 processes and pushed to the ERP.
• Integration of data into relevant workflow processes, with the specific aim of continuously improvement and data optimization.
• Work with all levels of development from analysis through implementation and support.
• Designing new database structures or enhancing existing ones to cater for optimal process flow and optimal user querying.
• Develop and test issues aligned to specifications.
• Work with the project team across functional areas.
• Analysis of data from various sources to ensure that the business acts proactively on the information at its disposal.
• Continually searching for new and useful ways to obtain, integrate and analyze data that is relevant to the company’s business model.
• Identify ways to improve data reliability, efficiency, and quality.
• Performing root cause analysis on data and processes to answer specific business questions and identify opportunities for improvement.      
• Experience performing root cause analysis on data and processes to answer specific business questions and identify opportunities for improvement.
• Identify ways to improve and automate data delivery and quality in the ETL processes.
• Guide and mentor junior resources when needed.
• Education of report end-users so as to ensure a maximum spread of expertise around the company.

Essential Criteria:

• Undergraduate degree (or substantial progress towards one) with majors in IS / math / stats / engineering or similar. Alternatively, at least 2 years work experience in a business intelligence role will be considered. A relevant post-graduate degree will be a strong plus.
• 2+ 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 2 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 Power BI.
• Minimum of 2 years’ experience in front end visualization tools such as Power BI/ Qlikview /Tableau/ Grafana (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:

• Software dev background.
• Experience integrating with API Solutions.
• Experience in data analysis and reconciliation will be advantageous.
• DBA experience.
• Knowledge of event-driven programming.
• Knowledge of Accounting or ERP software.
• Minimum of 2 years’ experience with OLAP reporting tools and cube technologies, such as SSAS (creation, implementation and maintenance of multi-dimensional cubes, MDX, DAX).

Person Specifications:

• Stress Tolerance
• Numbers
• Problem Solving
• Organisation & Planning
• Innovation
• Interpersonal Skills
• Communication
• Adaptability / Flexibility