Oracle Fusion Specialist/Consultant

Botsford Associates; Toronto; On-site; CAD 96,000 - 193,000; Full time

Job summary

Botsford Associates seeks an adaptable Oracle Fusion Specialist to drive delivery, optimization, and scaling of our enterprise cloud environment. This role spans BA, development, or data engineering with hands-on Oracle Fusion Cloud expertise to translate processes into efficient digital workflows, integrations, and data assets.

Responsibilities include requirement mapping, extensions, ETL design, OTBI/BI Publisher usage, and security governance, with a focus on reliability and scalability

Qualifications

• Hands-on Oracle Fusion Cloud experience across ERP, HCM, SCM, or CX.
• Experience with BI Publisher, OTBI, OIC, or FBDI for data imports and reporting.
• Strong SQL/PLSQL/XML skills for backend diagnostics and data extraction.
• Ability to translate complex business processes into streamlined digital workflows and configurations.

Responsibilities

• Map business requirements and configure Fusion functionalities to align with enterprise processes.
• Develop extensions, custom reports, and orchestrate integrations using Oracle Integration Cloud (OIC).
• Design and optimize ETL/data pipelines; use OTBI/BI Publisher for reporting.
• Evaluate quarterly patch releases, perform regression testing, and ensure environment stability.
• Configure security matrices including custom roles and data governance policies.

Skills

Oracle Fusion Cloud

Reporting & Integration

SQL/PLSQL/XML

Problem solving

Tools

BI Publisher

OTBI

OIC

FBDI

Job description

We are seeking an adaptable Oracle Fusion Specialist to drive the delivery, optimization, and scaling of our enterprise cloud environment. This is a job-agnostic posting spanning business analysis, technical development, or data engineering. The core requirement is hands‑on competency within the Oracle Fusion Cloud ecosystem (including ERP, HCM, SCM, or CX modules) to help translate corporate processes into streamlined digital workflows, integrations, and data assets.

CORE COMPETENCIES & RESPONSIBILITIES

Your day‑to‑day focus will align with a blend of the following functional tracks, depending on your primary specialization:

• Business Process & Requirement Mapping (BA Focus): Partner with stakeholders to dissect complex enterprise workflows, gather requirements, perform gap analyses against out‑of‑the‑box Oracle Fusion functionalities, and manage standard configurations or functional setups.
• Technical Customization & Orchestration (Dev Focus): Build and maintain extensions, custom reports, and system behaviours. Leverage Oracle Integration Cloud (OIC) to architect end‑to‑end integration workflows connecting Oracle Fusion with external legacy and third‑party systems.
• Data Migration & Analytics Architecture (Data Eng Focus): Design, optimize, and support robust ETL/data pipelines. Author advanced queries and manage reporting layers using Oracle Transactional Business Intelligence (OTBI), BI Publisher, and Fusion Cloud data extracts.
• System Upgrades & Testing: Evaluate quarterly Oracle patch releases, assess operational impacts, and conduct end‑to‑end functional or automated regression testing to ensure environment stability.
• Security & Governance: Maintain enterprise data integrity by configuring Oracle Fusion security matrices, including custom job roles, duty roles, and data security policies.

SKILLS & QUALIFICATIONS

• Oracle Fusion Cloud Ecosystem: Strong familiarity with at least one major pillar (such as Oracle ERP Cloud, HCM Cloud, or SCM Cloud) and its underlying data architecture.
• Reporting & Integration Toolkit: Competency or exposure to essential Oracle utilities like BI Publisher, OTBI, Oracle Integration Cloud (OIC), or FBDI (File‑Based Data Import).
• Technical Literacy: Proficiency with SQL, PL/SQL, or XML data manipulation for backend diagnostics, scripting, and data extraction.
• Problem‑Solving Frameworks: A proven history of breaking down functional operational hurdles, debugging interface failures, or mapping complex business constraints into structural configurations.

Pay: USD $50–$100/hr (CAD equivalent for Canadian candidates). Final rate depends on type of role, but open to market rates.