×
Register Here to Apply for Jobs or Post Jobs. X

Senior Developer Oracle Reports – Financial Systems

Remote / Online - Candidates ideally in
Old Toronto, Toronto, Ontario, M5A, Canada
Listing for: Intact Financial Corporation
Full Time, Remote/Work from Home position
Listed on 2025-12-30
Job specializations:
  • IT/Tech
    IT Consultant, Oracle Specialist/ Consultant, Database Administrator, Data Engineer
Job Description & How to Apply Below
Location: Old Toronto

About the role

We are seeking a highly skilled and experienced Senior Developer Oracle Reports to join our dynamic team. The ideal candidate will have a strong background in Oracle Financial Data Integration (FDI) report development, ERP systems and Business Intelligence Publisher (BIP) report development, as well as a solid understanding of Oracle Financial modules. You will be responsible for design and development of complex BIP and OAC reports, integrating REST and SOAP APIs, designing report security.

What you'll do here:

  • Participate actively in Oracle report design discussions to understand business needs.
  • Develop Oracle ERP BIP reports for medium to complex scenarios, ensuring data accuracy and usability.
  • Develop new subject areas, semantic layer and reports in Fusion Data Intelligence (FDI), ensuring compliance with business requirements.
  • Lead and participate in proof of concept (POC) initiatives for integrations, focusing on REST and SOAP API testing.
  • Design and implement robust report security protocols to safeguard sensitive business information.
  • What you bring to the table:

  • Bachelor’s degree in computer science, Information Systems, or a related field.
  • Must have 5+ years of experience with Oracle ERP Cloud, including report development and integration.
  • Oracle FDI Implementation Specialist with over 5+ years of experience in designing, developing, and implementing enterprise analytics solutions.
  • You have knowledge with the following tools:
    Oracle ERP Fusion Cloud, Oracle Analytics Cloud (OAC), Oracle FDI, Oracle EPM Cloud
  • Expert in PL/SQL, for complex query development.
  • Expertise with Oracle Business Intelligence Publisher (BIP), including bursting and scheduling.
  • Strong experience required in designing BIP templates for Bank Payment Formats (Cheque templates), Payment Remittance advises etc.
  • Design and develop complex reports using OTBI
  • Develop ESS job and scheduling them
  • Demonstrated experience with REST and SOAP API integration in Oracle ERP systems.
  • Good technical and functional understanding of Oracle Financial modules such as Accounts Payable (AP), General Ledger (GL), Cash Management (CM), Procurement, etc.
  • Familiarity with Oracle ERP Cloud security features and best practices.
  • Good understanding of Data Integration, Data Modeling, Database Development
  • Strong understanding of Star and Snowflake
  • Oracle Redwood experience is an asset
  • EPM freeform reporting experience is a strong asset
  • Oracle Apex report development is an asset
  • Excellent problem-solving skills and attention to detail.
  • Strong communication and collaboration skills. Ability to work independently and manage multiple priorities.
  • No Canadian work experience required however must be eligible to work in Canada.
  • #LI-Hybrid

    What we offer

    Our hybrid work model provides the balance between working from home and enjoying meaningful in-person interactions.

    Working here means you'll be empowered to be and do your best every day. Here is some of what you can expect as a permanent member of our team:

  • A financial rewards program that recognizes your success

  • An industry leading Employee Share Purchase Plan; we match 50% of net shares purchased

  • An extensive flex pension and benefits package, with access to virtual healthcare

  • Flexible work arrangements

  • Possibility to purchase up to 5 extra days off per year

  • An annual wellness account that promotes an active and healthy lifestyle

  • Access to tools and resources to support physical and mental health, embracing change and connecting with colleagues

  • A dynamic workplace learning ecosystem complete with learning journeys, interactive online content, and inspiring programs

  • Inclusive employee-led networks to educate, inspire, amplify voices, build relationships and provide development opportunities

  • Inspiring leaders and colleagues who will lift you up and help you grow

  • A Community Impact program, because what you care about is a part of what makes you different. And how you contribute to your community should be just as unique.

  • Position Requirements
    10+ Years work experience
    Note that applications are not being accepted from your jurisdiction for this job currently via this jobsite. Candidate preferences are the decision of the Employer or Recruiting Agent, and are controlled by them alone.
    To Search, View & Apply for jobs on this site that accept applications from your location or country, tap here to make a Search:
     
     
     
    Search for further Jobs Here:
    (Try combinations for better Results! Or enter less keywords for broader Results)
    Location
    Increase/decrease your Search Radius (miles)

    Job Posting Language
    Employment Category
    Education (minimum level)
    Filters
    Education Level
    Experience Level (years)
    Posted in last:
    Salary