BI Developer at Rand Merchant Bank

Job description

Purpose

To lead Business Technology in the Business Unit/Functional Area with the purpose of supporting and enabling the realisation of business strategies and objectives

Responsibilities

• Engage with the macro-environment to look for new opportunities, capabilities and trends that would add value to the required development work
• Suggest changes in executing work processes to better drive value and benefits for the business
• Prepare and share recommendations for process and systems improvements in relevant area of accountability
• Actively participate in team, cross-discipline and vendor-driven collaboration sessions or forums to increase understanding of the working environment (current and planned)
• Partner with BT and Business stakeholders to create integrated roadmaps to enable business requirements delivery
• Translate business and technical requirements into efficient sustainable BI solutions
• Consolidate and prepare solution design documentation
• Apply standards and governance in such a way as to develop the best fit solution for business
• Coordinate and apply various coding efforts
• Collate data on coding progress achieved
• Address and develop solutions to problems and risks arising from coding efforts
• Design and implement effective cross-functional business intelligence systems and processes
• Design relevant test scripts/ test cases to best determine system readiness and usability
• Provide 2nd tier support where needed

Qualifications & Experience

• Relevant Degree
• Worked in an Agile/DevOps environment (Preferred)

IN Depth Knowledge of the following

• Microsoft SQL stack (SSIS, SSRS, SSAS)
• ETL (Informatica)
• Building and Running Cubes, Analysis of structures within the DWH, etc.
• Multidimensional modelling (SSAS, MDX, DAX, Tabular)
• Data visualisation and reporting (SSRS, MS PowerBI, PowerPivot, PowerView, PowerQuery, Tibco Spotfire, etc.)
• Ability to integrate BI structures to Oracle and SQL databases (DBs). Must be able to perform SQL queries, statements, etc. and extract information directly from the DWH and interrogate the DBs.
• Relevant development frameworks
• Coding for security best practice
• Agile/DevOps principles and applications
• Corporate and investment banking domain (preferred)
• Relevant banking regulations (preferred)