Business Intelligence Developer

Develop analytical models and Data Visualisations to provide comprehensive information support to the business for informed decision making.

Responsibilities

• Analytical Modeling

Create analytical models by translating business requirements to a framework that suits business analysis. Build data from company systems into an analytical model that provides trends and patterns relating to any short-term insurance metrics. Demonstrate functionality of built BI models to target audience as per business request.

• Operational Support

Provide operational support services and ensure server availability during operational hours. Monitor user-acceptance testing of Data Visualisation models. Administration of business intelligence management console, including task schedule and on-going monitoring and maintenance of BI solution.

• Business Requirements Identification

Collect business requirements using a variety of methods to provide suitable solutions based on the business need, developed within the architecture framework.

• Data Collection and Analysis

Conduct research using primary data sources and select information needed for the analysis of key themes and trends

• Insights and Reporting

Prepare and coordinate the completion of various data and analytics reports by identifying insight from information contained within the general BI models and present these insights to stakeholders in the business.

• Stakeholder Engagement

Build relationship's across the business and find out their needs/issues/concern and reacting to these by arranging meetings and events and drafting supporting materials to promote understanding and commitment. Ensure that business objectives and personal delivery aligns to and meets the service principles.

• Improvement / Innovation

Manage focus and priorities to keep working on the most commercially beneficial tasks for the organisation. Leverage all available information from our partners, the industry, and internally to ensure we are constantly reviewing our departmental processes, systems and protocols with a view to improve efficiencies. Analyse current performance inhibitors and finding solutions to ensure business
continuity. Develop Ideas, provide an innovative and ever evolving set of systems and processes.

• Performance Management

Manage user expectations and deliverables within work stream. Prioritise own workflow and ensure work is completed to the required standards of productivity, quality and timeliness.

• Database Specifications

Provide information and comments on suitability during approval process for database specifications to ensure all agreed standards and protocols are followed and data integrity is preserved.

• Data Management

Use data management systems to deliver prescribed outcomes with guidance from senior colleagues. This includes being responsible for operating key elements of the system.

Skills

Computer and Software skills

Support business processes by understanding and effectively using standard office equipment and standard software packages. Advanced MS Office Skills., Different database environments e.g. DB2, SQL, Informix., Strong transact SQL., Advanced Visual Basic for Applications (VBA)., Extraction, Transaction and Loading (ETL) principles., Qlikview and Qlik Sense ,Nprinting

Data Management
Provide technical guidance when required to acquire, organise, protect and process data to fulfill business objectives.
Data warehousing., Geo-Analytics.

Business Requirements Analysis
Provide technical guidance when required to analyse the business requirements that solutions must meet.

Data Collection and analysis
Provide technical guidance when required to analyse data trends for use in reports to help guide decision making. Statistical Analysis., Data modelling.

Review and Reporting
Provide technical guidance when required to review and create relevant, lucid reports

General Education

• Grade 12/ SAQA Accredited Equivalent (Essential)
• A relevant 3 year degree /diploma relating to Business Intelligence / Data Warehousing / Database Administration (Advantageous)
• Maths and Science at Grade 12 level (Advantageous)
• Qlik certifications (Advantageous)

General Experience

• 3 or more years development experience within a business intelligence environment (Essential)
• Qlik development experience (Advantageous)
• Consulting experience (Advantageous)
• Experience and knowledge of the financial insurance industry (Advantageous)