Developer at Discovery Limited

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.