Business Intelligence Developer II

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.

Experience

Minimum:  

• At least 4 years’ experience implementing innovative BI solutions leading to clear business decisions and benefits, including
• At least 4 years’ experience in data analysis, including experience in and understanding of database structure design and data extraction principles (ETL). 
• At least 4 years’ experience working with any visualisation tools of which 2 years is on Power BI (DAX, M) 
• At least 4 years' experience in SQL (Postgres, MySql, MS SQL) which involved cleaning, enriching, transforming , data mapping, data aggregation, and data normalization 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.

Ideal:

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

Qualifications (Minimum)

• A relevant degree in Statistics or Finance

Qualifications (Ideal or Preferred)

• Certification in AWS Practitioner

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 both waterfall and agile development approaches
• Knowledge of SQL query language: Preferably AWS services (Redshift, Athena, DataLake, Python, PostgreSql, MySQL) or MS Technologies (Azure services, SQL, SSAS) 
• A good understanding of design and user experience principles
• Understanding of Agile 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 

Skills

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

Conditions of Employment

• Clear criminal and credit record