Oracle Technical Consultant

Base pay range CA$100,000.00/yr - CA$115,000.00/yr Location & Availability MUST BE IN ONTARIO MUST HAVE PR – travel is required Job Overview The IT Business Analyst role is to support the Business Applications team in the planning, design, development, and support of efficient business systems within core organizational functions and business processes. This includes gathering and analyzing data in support of business cases, proposed projects, and systems requirements. This role includes potential for designing, building, testing and analyzing integrations, performing application configurations and report development. The IT Business Analyst is also responsible for generating and compiling reports based on the findings, complete with probable causes and possible solutions to systems issues. Supporting and managing integrations across multiple applications as well as supporting risk management administration is a key function of this role. This individual will apply proven communication, analytical, and problem‑solving skills to help maximize the benefit of IT system investments. Responsibilities Meet with decision makers, system owners, and end users to define business, financial, and operations requirements and systems goals, and identify and resolve systems issues. Review and analyze the effectiveness and efficiency of existing systems and develop strategies for improving or further leveraging these systems. Identify and establish scope and parameters of systems analysis in order to define outcome criteria and measure‑taking actions. Collaborate in the planning, design, development, and deployment of new applications, and enhancements to existing applications. Conduct research on software and hardware products to justify recommendations and to support purchasing efforts. Perform cost‑benefit and return on investment analyses for proposed systems to aid management in making implementation decisions. Prepare and deliver reports, recommendations, or alternatives to enhance solutions that address existing and potential trouble areas in systems across the organization, proposing solutions that are feasible and scalable. Ensure compatibility and interoperability of in‑house computing systems. Review query performance and optimize where required. Assess and amend any errors in a timely fashion. Prepare status reports where required. Perform in‑depth tests for modified and new system. Work with and assist project teams on implementation or upgrades of new and existing business solutions. Configure and maintain applications at an administrative level and across multiple environments, including user security and other application configurations. Perform application data refreshes from production to development and test environments. Follow proper change management processes when performing any changes to solutions. Responsible for managing users and roles in Oracle Integration Cloud. Build, test, and maintain application security roles and business objects. Administer user access, data access requests, user categories, SSO groups, and deprovisioning following internal governance practices. Maintain BI reports and Oracle BI/OTBI security. Maintain Risk Management model and controls, including model migrations and control deployments. Administer security incident assignments and related models and controls. Maintain scheduled jobs within Oracle Fusion ERP, HCM and RMC. Work with Oracle Support for issues as applicable. Other duties as required to support the IT Business Applications team. Qualifications Education: College diploma or university degree in business administration, computer science, or management information systems and 3 years related work experience. Required: 3+ years’ experience in deployment and support of software systems implementations within a global environment (cloud, hosted and on‑premise platforms). Preferred: Oracle Risk Management Cloud, 2 years’ experience. Preferred: Oracle Integration Cloud, 2 years’ experience. In‑depth technical and administration experience supporting applications and integrations across solutions. Experience in the design, development, implementation and support of business solutions and systems. Expertise in designing and building integrations using Oracle Integration Cloud (OIC). Thorough knowledge of OIC features such as Mappings, Lookups, Connections, XSLT, Agents, Packages. Knowledge of OIC cloud adapters (REST, SOAP, FTP, HCM, ERP, ATP). Experience in operation and analysis of databases, data retrieval methodologies and importing data for use in report software, spreadsheets, graphs and flow charts. Experience with Oracle BI/OTBI report and data model development. Oracle Fusion Knowledge (technical, ERP, HCM) including basic functional knowledge of related (GL, AR, AP, PPM, SCM, OTL, Core HR, Talent, Recruitment, Absence). Knowledge and hands‑on experience in applications such as Oracle Fusion, Hyperion Financial Management, Oracle EPM, InEight Cloud, SharePoint, Intelex Safety, E‑Front LMS, PowerBi, Big Data applications is beneficial. Demonstrated project management skills; Business Analysis and Project Management Fundamentals training or PMP designation considered an asset. Personal Attributes Excellent understanding of the organization’s goals and objectives. Flexible and adaptable in learning new technologies and solutions. Excellent analytical, mathematical, and creative problem‑solving skills. Excellent written and oral communication skills. Excellent listening and interpersonal skills. Logical and efficient. Keen attention to detail. Ability to conduct research into systems issues and products as required. Ability to communicate ideas in both technical and user‑friendly language. Highly self‑motivated and directed. Ability to effectively prioritize and execute tasks in a high‑pressure environment. Experience working in a team‑oriented, collaborative environment. Benefits & Compensation Base Salary (together with other benefits, including profit share) Profit sharing program 3 weeks vacation Comprehensive benefits package for employee and family Pension match (at 5% of salary) Travel Bonus Seniority level Mid‑Senior level Employment type Full‑time Job function Information Technology Industries Staffing and Recruiting and Manufacturing #J-18808-Ljbffr