BI Analyst Developer at Discovery Limited

Key Purpose
The role will specifically be focused on working with various stakeholders in order to build data assets and provide analytics for anti-fraud initiatives. The role will also provide support for certain servicing initiatives from time to time. The individual will need to be able to quickly grasp business requirements, take their own initiative to investigate potential areas of fraud, and be able to present the findings. The Business Intelligence (BI) Analyst Developer is responsible for conceptualizing, designing, implementing, and supporting the BI solutions in the anti-fraud space. The right individual will have experience in all stages of BI delivery including requirements analysis, data model design, ETL Development, data testing and dashboard development. The BI analyst developer should have a firm grasp of BI implementation methodologies in order to ensure BI solutions are robust and scalable.

Areas of responsibility may include but not limited to

• Conceptualise, plan and execute end-to-end BI solution delivery
• Interact with our business leads and other stakeholders to establish information needs
• Owns and leads the BI delivery on projects
• Conduct data analysis and data profiling on various source systems with the ability to pick up data anomalies and define rules to solve these anomalies
• Design and document logical and physical data models using dimension modelling techniques as well as relational modelling techniques
• Review data models with functional and technical teams via walkthroughs of the planned solution
• Build ETL solutions within the Microsoft stack (SSIS and TSQL) to populate the designed data model
• Analyse data across data domains to provide business with detailed data insights that meet business strategic and operational requirements
• Build PowerBI and SSRS dashboards/reports to present data insights in a meaningful way to the business
• Interact with systems architects to discuss solutions, challenges and enhancements
• Establish, maintain, and ensure compliance with data modelling and data integration standards
• Lead the creation, enhancement and implementation of newer BI standards and processes

Personal Attributes and Skills

• Good understanding of ODS, data warehouse, data mart, cube, and database technologies.
• Strong analytical and problem solving skills.
• Must be able to navigate ambiguity and complexity around business products and benefits and how they tie into data.
• Sees data challenges and complexity as a positive challenge instead of an impediment to solution delivery
• Solid experience in writing functional and technical specifications, process flows and source-to-target mappings
• Experience working with BI front-end tools to develop prototype solutions (Power BI, Excel)
• Strong SQL query writing ability (across database environments)
• Strong experience in logical and physical data modelling using a variety of techniques including Kimball.
• Strong understanding of Master Data management (MDM), Metadata Management and Data Governance (DG)
• Excellent oral and written communication skills.
• Must be able to present solutions and data storylines.
• Solid experience in gathering requirements for reporting solutions and data analytics.

Education and Experience

• Minimum Bachelor’s degree in either Computer Science or Informatics
• Microsoft Business Intelligence certifications will be advantageous
• Minimum 3 years’ experience in BI with experience in implementing complete BI solutions at an enterprise level.
• Experience in emerging Big Data technologies and the implementation in the BI domain will be an added advantage

Employment Equity
The Company’s approved Employment Equity Plan and Targets will be considered as part of the recruitment process. As an Equal Opportunities employer, we actively encourage and welcome people with various disabilities to apply.