Senior Business Systems Analyst (ERP Integration)

• Lead analysis design and implementation of complex system integrations between Oracle ERP and legacy applications
  
• Develop functional and technical specifications for integrations enhancements and system changes
  
• Design and build database queries PL/SQL components and integration logic
  
• Analyze business requirements and translate them into technical solutions and workflows
  
• Develop and maintain data mappings transformation logic and interface specifications
  
• Support testing activities including unit system and integration testing
  
• Collaborate with developers DBAs architects and business stakeholders
  
• Participate in Agile ceremonies (scrums stand-ups status updates)
  
• Provide technical documentation and ensure compliance with SNB standards
  
• Identify risks issues and propose mitigation strategies
  

• Functional and technical specifications
  
• Data models ERDs and architectural diagrams
  
• Integration designs and implementation artifacts
  
• PL/SQL code database objects and queries
  
• Testing documentation and results
  
• Ongoing system and integration documentation
  

• M1: Minimum 10 years of IT experience
  
• M2: Minimum 5 years experience as a Programmer Analyst
  
• M3: Minimum 5 years experience as a Business Systems Analyst
  
• M4: Minimum 3 years experience supporting transformative ERP implementations in a public sector environment involving complex legacy systems
  
• M5: Demonstrated spoken and written English communication proficiency
  

• S1: 35 years analyzing business/technical requirements workflows and reporting needs
  
• S7: 35 years writing and consuming functional & technical specifications
  
• S10: 68 years strong communication skills (technical & non-technical audiences)
  

• S2: 35 years creating/consuming data models ERDs architectural diagrams
  
• S4: 35 years interpreting Oracle database structures and field specifications
  
• S5: 35 years analyzing complex database schemas
  

• S3: 23 years experience with Oracle PL/SQL (packages procedures functions)
  
• S11: 23 years experience with XML-based data integrations
  
• S12: 13 years experience in .NET technologies ( C# MS Forms) (Oracle experience prioritized)
  

• S6: 35 years designing and testing complex system integrations
  
• S9: 35 years working on ERP implementations in public sector
  

• S8: 13 years working with cross-functional distributed teams (BA Dev DBA business users)
  

• Oracle Fusion Cloud ERP (SaaS)
  
• Oracle Database PL/SQL
  
• Legacy Oracle Forms/Reports
  
• XML integrations
  
• .NET stack (C# )
  
• Data modeling and integration tools
  

• ---

  Work Environment
  
• Agile / hybrid delivery model
  
• Collaboration across multiple government departments
  
• Remote-first with occasional onsite presence in Fredericton
  

Requirements

• M1: Minimum 10 years of IT experience
  
• M2: Minimum 5 years experience as a Programmer Analyst
  
• M3: Minimum 5 years experience as a Business Systems Analyst
  
• M4: Minimum 3 years experience supporting transformative ERP implementations in a public sector environment involving complex legacy systems
  
• M5: Demonstrated spoken and written English communication proficiency
  

• S1: 35 years analyzing business/technical requirements workflows and reporting needs
  
• S7: 35 years writing and consuming functional & technical specifications
  
• S10: 68 years strong communication skills (technical & non-technical audiences)
  

• S2: 35 years creating/consuming data models ERDs architectural diagrams
  
• S4: 35 years interpreting Oracle database structures and field specifications
  
• S5: 35 years analyzing complex database schemas
  

• S3: 23 years experience with Oracle PL/SQL (packages procedures functions)
  
• S11: 23 years experience with XML-based data integrations
  
• S12: 13 years experience in .NET technologies ( C# MS Forms) (Oracle experience prioritized)
  

• S6: 35 years designing and testing complex system integrations
  
• S9: 35 years working on ERP implementations in public sector
  

• S8: 13 years working with cross-functional distributed teams (BA Dev DBA business users)