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
#J-18808-Ljbffr