Developer

Oracle and Cognos Developer (Senior) Business Unit: Discovery Central Services Function: Development (Oracle/Delphi/Magic/etc) Discovery- Integrated Shared Services 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. 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 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. 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). 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. #J-18808-Ljbffr