Job Description

Business Unit:

Discovery Central Services

Function:

Development (Oracle/Delphi/Magic/etc)

Date:

3 Sept 2025
Discovery- Integrated Shared Services

Oracle and Cognos Developer (Senior)

About Discovery

Discovery's core purpose is to make people healthier and to enhance and protect their lives. We seek out and invest in exceptional individuals who understand and support our core purpose, and whose own values align with those of Discovery. Our fast-paced and dynamic environment enables smart, self-driven people to be their best. As global thought leaders, Discovery is passionate about innovating in order to not only achieve financial success, but to ignite positive and meaningful change within our society.

About the role

We are seeking an experienced Senior Oracle and Cognos Developer to join our Financial Services Analytics & Reporting team. The successful candidate will design, develop, and maintain enterprise-grade data solutions and business intelligence (BI) reports for broker commission data across multiple insurance and financial product lines (e.g., Life, Health, Insurance).



The role requires deep technical expertise in Oracle database development, Cognos BI reporting, and commission data modeling, combined with strong knowledge of financial services processes and regulatory requirements. You will play a pivotal role in ensuring accurate, timely, and insightful commission reporting for stakeholders, including Sales, Finance, Compliance, and Executive Management.

Areas of responsibility may include but not limited to

Database Development & Data Management

Design, develop, and maintain Oracle PL/SQL packages, stored procedures, triggers, and functions for commission data processing. Optimize complex SQL queries for performance, scalability, and reliability in large datasets. Design and maintain data models to support commission tracking, broker hierarchy structures, and payout rules. Implement ETL processes to extract, transform, and load commission data from multiple source systems into reporting databases. Ensure data quality, validation, and reconciliation between operational systems and reporting databases.

Business Intelligence & Reporting

Develop and maintain Cognos Framework Manager models, data packages, and reports for broker commission analytics. Build dashboards, scorecards, and ad-hoc reporting solutions for business stakeholders. Apply complex business rules for calculating and presenting broker commissions, overrides, bonuses, and claw backs. Collaborate with business analysts to capture requirements and translate them into technical solutions.

Governance, Compliance & Security

Implement and maintain role-based access controls for sensitive commission data. Ensure compliance with financial regulations, data privacy laws, and internal governance policies. Document technical processes, data flows, and change logs in line with audit requirements.

Collaboration & Leadership

Act as a subject matter expert (SME) for Oracle and Cognos development within the broker commission domain. Mentor junior developers and BI analysts, providing code reviews and technical guidance. Partner with Finance, Sales, and Operations teams to ensure accurate and transparent reporting. Liaise with infrastructure teams to ensure high availability, performance tuning, and backup strategies.

Education and Experience

Qualification

BSc in Computer Sciences/ Information Systems or equivalent IT tertiary qualification? Oracle Certified Professional - Advanced PLSQL developer

Experience

5+ years of Oracle database development experience, with strong PL/SQL skills. 5+ years of Cognos BI development experience (Framework Manager, Report Studio, Active Reports). Strong background in data warehousing and dimensional modeling Experience integrating data from CRM, policy administration, and claims systems. Advanced fault-finding abilities, with a proven track record of diagnosing and resolving complex technical issues efficiently and accurately.

Technical Skills

Oracle Database (11g/12c/19c) - PL/SQL, SQL tuning, partitioning, materialized views. IBM Cognos Analytics - Framework Manager, Report Studio, Dynamic Cubes, Active Reports. ETL tools (Informatica, DataStage, SSIS, or equivalent). Understanding data security, encryption, and access control best practices. Familiarity with reporting automation and API integrations for data ingestion.

Soft Skills

Strong analytical and problem-solving skills. Excellent communication and stakeholder engagement abilities. Ability to work under pressure and deliver accurate outputs in tight timelines. Leadership mindset with a willingness to mentor and coach others.

Preferred/Desirable

Experience with Python or shell scripting for automation. Familiarity with cloud-based analytics platforms Experience in migration projects from legacy BI platforms to modern analytics stacks. Power BI experience

Key Performance Indicators (KPIs)

Accuracy and timeliness of commission reports. Query and report performance (response times, optimization). Data quality metrics (error rates, reconciliation discrepancies). Stakeholder satisfaction with reporting solutions. Reduction in manual processing and report preparation time.


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.