This list contains only the countries for which job offers have been published in the selected language (e.g., in the French version, only job offers written in French are displayed, and in the English version, only those in English).
A public sector business application service agency is seeking a Senior Business Systems Analyst III with deep technical expertise to bridge legacy infrastructure with a modern Oracle Cloud ERP (Fusion SaaS) deployment. This long-term project modernizes Human Resources, Financial Management, and Procurement systems. The successful candidate will design, build, and test highly complex backend data integrations to ensure dependent legacy applications continue to function seamlessly alongside the new enterprise SaaS solution.
Job Responsibility
Write detailed functional and technical specifications for highly complex data integrations between multi-layered legacy applications and cloud systems
Design, maintain, and debug advanced Oracle PL/SQL components, including database packages, procedures, triggers, and functions
Define, interpret, and map database table and field specifications for highly interdependent enterprise databases, managing updates to new vendor, employee, and account coding structures
Create and consume data models, entity-relationship diagrams (ERDs), database schemas, and architectural solution diagrams
Serve as a core technical resource on a distributed project delivery team, actively participating in team scrums alongside project managers, developers, DBAs, and business users
Build and execute meticulous integration test plans leveraging automated tools, parse XML data integrations, and compile thorough system documentation
Requirements
Minimum 15 years of total IT sector experience
Minimum 10 years of dedicated experience working as a Programmer Analyst
Minimum 7 years of dedicated experience working as a Business Systems Analyst
Minimum 3 years of experience working on a transformative ERP implementation project within a Canadian public service environment involving complex legacy application interdependencies
5 to 7 years of hands-on experience in Oracle development, specifically including Oracle Forms and Reports, advanced database querying, and reading complex schemas
3 to 5 years of experience working with a major Oracle Fusion implementation program
3 to 5 years of experience building and analyzing data integrations using XML
Asset: 1 to 3 years of development exposure within the Microsoft .NET stack (VB.Net, C#, MS Forms, Visual Studio)
Advanced, targeted written and verbal fluency in English
Must be legally authorized to work in Canada
Holding a current Oracle Associate or Professional Certification is highly preferred
Nice to have
1 to 3 years of development exposure within the Microsoft .NET stack (VB.Net, C#, MS Forms, Visual Studio)
Holding a current Oracle Associate or Professional Certification is highly preferred