Business Intelligence Developer (Stellenbosch) needed at Capitec Bank

Purpose Statement

• To design, develop and deploy reporting and analytical solutions to support and enhance business decisions through processing and converting data into actionable insights, delivered in report form, using the Capitec reporting and analytical tools (software) of choice.

Qualifications (Minimum)

• A relevant tertiary qualification
• Grade 12 National Certificate / Vocational

Qualifications (Ideal or Preferred)

• Certification in AWS Practitioner
• A relevant degree in Information Technology – Computer Science or Statistics

Experience

Minimum:  

• At least 3-4 years’ experience implementing innovative BI solutions leading to clear business decisions and benefits
• At least 3-4 years’ experience in data analysis, including experience in and understanding of database structure design and data extraction principles (ETL)
• At least 3-4 years’ experience working with any visualisation tools of which at least 2 years is on Power BI (DAX, M)
• At least 3-4 years’ experience in SQL (Postgres, MySql, MS SQL) which involved cleaning, enriching, transforming , data mapping, data aggregation, and data normalisation that is suitable for data analysis
• Working with product development life cycle and Agile frameworks
• Experience managing projects own work and initiatives from start to finish, including planning, scoping, budgeting, and timeline management
• Must understand data and relational databases, and be able to build proper reports and dashboards

Ideal:

• Data analysis methodologies or BI development in a various industries (i.e., financial/banking environment including financial, insurance, telecommunications and risk industries)
• Solid experience with data and Power BI

Knowledge

Minimum: 

• Overall good understanding and application of BI and Data Warehousing best practice
• Overall good understanding in Python or R (or any other relevant programming language)
• Expert in the field of BI development (reports, dashboards, data visualisation, etc.)
• Extensive knowledge of BI/reporting and analytical tools
• In depth knowledge of BI environments, solutions and implementations (end-to-end BI architecture and technologies)
• In depth knowledge in the field of data analysis methodologies (Descriptive-,Diagnostic-,Predictive-,Prescriptive Analytics)
• Knowledge of SQL query language
• A good understanding of design and user experience principles

Ideal:

• Extensive knowledge of Power BI services (including Advanced AI and ML, and Cognitive services within the Power Platform)
• Working knowledge of the AWS ecosystem and services
• Analysis/report development in a financial/banking environment 
• Knowledge of SQL query language: Preferably AWS services (Redshift, Athena, DataLake, Python, PostgreSql, MySQL) or MS Technologies (Azure services, SQL, SSAS) 
• Understanding of Agile principles, and knowledge of both Waterfall and Agile development approaches

Skills

• Analytical Skills
• Attention to Detail
• Communications Skills
• Problem solving skills
• SQL Skills