The Department
Enterprise Risk Support owns a diverse set of products with multiple capabilities. To effectively support these products, our teams require a diverse set of software development skills and strong product knowledge geared for delivery.
We build market leading platforms and software to support out the box configuration of our brands and markets. Be part of building a robust, and bespoke platform that supports loosely coupled off the shelf components that can be easily added, configured, or removed as required.
As part of the Data Team, 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. This candidate will report to the Team Lead in the Data Team.
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. This candidate will report to the Team Lead in the Data Team.
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 companys 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
- 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 PowerBI / Grafana (creation, implementation and maintenance of analytical dashboards and visualisations).
- Advanced skills in MS Excel.
- Experience in building a data warehouse.
- 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.
- 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.
- Software dev background.
- Experience integrating with API Solutions.
- Experience in data analysis and reconciliation will be advantageous.
- DBA experience.
- Knowledge of event-driven programming.
- Minimum of 2 years experience with OLAP reporting tools and cube technologies, such as SSAS Tabular (creation, implementation and maintenance of multi-dimensional cubes, MDX, DAX).
- Stress Tolerance
- Numbers
- Problem Solving
- Organisation & Planning
- Innovation
- Interpersonal Skills
- Communication
- Adaptability / Flexibility
To view all current vacancies, please visit our website, www.digioutsource.com
Should you not hear from us within 2 weeks, please deem your application as unsuccessful.
The perfect place to work, play and grow!