The expertise of a forward-thinking and highly analytical Senior BI Developer is sought by a fast-paced e-commerce platform.
Your core role, together with a team, will be to ensure that analytical applications capitalise on all available data, enabling users to make sound decisions and achieve greater business outcomes.
The ideal candidate requires a relevant 3-year IT Degree / Diploma, experience with Data Warehousing, Data Modelling, Solution Architecture & Data Integration, at least 4 years’ in a similar role with full BI SDLC knowledge, OLTP / OLAP systems, MS SQL Stack, System analysis and design skills to design and document the data extractions and transformations and have worked in an Agile project environment.
BI System Management Monitor and ensure that deployed ETL processes / jobs are completed on time and the data warehouse is available for analytics / reports.
development is only completed in the Dev environment and code deployed to QA and production through automated builds.
Measurement & Testing Use BI-On-BI reports and analytics capabilities to measure the development environment and unit test developed artefacts and ensure that developed code is running optimally and tested.
Data Integrity Ensure the quality and integrity of data in reports and analytics (unit testing system testing)
Data Warehouse Maintain and improve the data warehouse environments.
BI Systems Management Monitor and ensure that deployed ETL processes / jobs are completed on time and the data warehouse is available for analytics / reports.
User Support & Training Train new and existing users in terms of new BI capabilities.
Adhere to an Agile Project Management methodology for BI development Attendance to ceremonies are compulsory.
Ensure all BI artefacts are secured and managed using source control and work closely with the team to ensure the integrity of the build.
At times, facilitate user involvement in BI planning and projects.
REQUIREMENTS : Qualifications
Relevant 3-year IT Degree / Diploma.
Experience / Skills
Relevant Data Warehouse, Data Modelling, Solution Architecture and Data Integration.
Minimum 4 years’ Business Intelligence Business Analysis experience, full Business Intelligence SDLC.
Managing senior stakeholder engagement.
Knowledge of OLTP / OLAP systems, dimensional modelling, business rule transformations and data analysis; conventional and data warehouse modelling skills are required, to understand the various data models and to define the mappings between them.
Experience with BI application designs, architectures, and building BI and data visualisations for analytic solutions. (MS-SQL Stack).
System analysis and design skills to design and document the data extractions and transformations.
Working within in an Agile project environment.
Experience working in a Financial Services and / or Retail environment.