Senior Business Systems Analyst III

Advantages
Remote Work Environment: Enjoys the convenience of remote work flexibility from any residential office within Canada, coordinated under local Atlantic Standard Time operating hours.
Provisioned Tooling: The organization completely coordinates and distributes all necessary physical or virtual computing devices and secure network access structures. Architectural Influence: Step away from standard business analysis into a highly technical engineering role with significant design authority over integration APIs and cloud schemas.
Stable Public Portfolio: Gain top-tier, long-term exposure to a massive 5 to 6-year multi-phase government modernization effort.

Responsibilities
Integration Engineering: Write detailed functional and technical specifications for highly complex data integrations between multi-layered legacy applications and cloud systems.
Database & Query Development: Design, maintain, and debug advanced Oracle PL/SQL components, including database packages, procedures, triggers, and functions.
System Mapping: Define, interpret, and map database table and field specifications for highly interdependent enterprise databases, managing updates to new vendor, employee, and account coding structures.
Architectural Modeling: Create and consume data models, entity-relationship diagrams (ERDs), database schemas, and architectural solution diagrams.
Cross-Functional Collaboration: 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.
Documentation & Testing: Build and execute meticulous integration test plans leveraging automated tools, parse XML data integrations, and compile thorough system documentation.

Qualifications
Core Experience Baseline: * 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.

Domain Expertise (Mandatory): Minimum 3 years of experience working on a transformative ERP implementation project within a Canadian public service environment involving complex legacy application interdependencies.

Technical Stack Depth (Scored Criteria):

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).

Language & Authorization: Advanced, targeted written and verbal fluency in English. Must be legally authorized to work in Canada.

Certifications (Asset): Holding a current Oracle Associate or Professional Certification is highly preferred.

Summary
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.

Randstad Canada is committed to fostering a workforce reflective of all peoples of Canada. As a result, we are committed to developing and implementing strategies to increase the equity, diversity and inclusion within the workplace by examining our internal policies, practices, and systems throughout the entire lifecycle of our workforce, including its recruitment, retention and advancement for all employees. In addition to our deep commitment to respecting human rights, we are dedicated to positive actions to affect change to ensure everyone has full participation in the workforce free from any barriers, systemic or otherwise, especially equity-seeking groups who are usually underrepresented in Canada's workforce, including those who identify as women or non-binary/gender non-conforming; Indigenous or Aboriginal Peoples; persons with disabilities (visible or invisible) and; members of visible minorities, racialized groups and the LGBTQ2+ community.

Randstad Canada is committed to creating and maintaining an inclusive and accessible workplace for all its candidates and employees by supporting their accessibility and accommodation needs throughout the employment lifecycle. We ask that all job applications please identify any accommodation requirements by sending an email to accessibility@randstad.ca to ensure their ability to fully participate in the interview process.