Senior Business Systems Analyst III – Oracle ERP Integration
Job Location:
Fredericton - Canada
Monthly Salary:
Experience Required:
Posted:
Application Deadline:
Vacancies:
Job Summary
- Minimum 15 years of overall Information Technology experience
- Minimum 10 years of experience as a Programmer Analyst
- Minimum 7 years of experience as a Business Systems Analyst
- Minimum 3 years of demonstrated experience supporting a transformative ERP implementation project within a Canadian public sector environment involving complex legacy applications
- Experience must include enterprise ERP platforms such as:
- Oracle Fusion Cloud ERP
- Oracle EBS
- SAP
- Microsoft Dynamics
- Public sector experience must be within Federal Provincial or Municipal government departments/agencies
- Strong spoken and written English communication skills
- Legally authorized to work in Canada
- 57 years of experience analyzing business and technical requirements to identify:
- Information requirements
- Procedures
- Decision flows
- Reporting requirements
- 57 years of experience creating and consuming:
- Data models
- Entity Relationship Diagrams (ERDs)
- Solution architecture diagrams
- 57 years of hands-on experience in Oracle PL/SQL including:
- Advanced packages
- Procedures
- Functions
- Debugging and maintenance activities
- 57 years of experience interpreting and defining:
- Oracle database tables
- Field specifications
- Complex system interdependencies
- 57 years of experience reading and analyzing complex database schemas
- 57 years of experience analyzing designing and testing complex integrations between:
- Multiple applications
- Data sources
- Enterprise systems
- 57 years of experience writing and consuming:
- Functional specifications
- Technical specifications
- Integration documentation for highly complex systems
- 35 years of experience working within distributed multidisciplinary teams including:
- Business Analysts
- DBAs
- Developers
- Technical Analysts
- End Users
- 35 years of experience working on major Oracle Fusion implementation projects in a public sector environment
- 68 years of demonstrated verbal and written communication skills with the ability to communicate effectively with:
- Technical audiences
- Non-technical stakeholders
- Executive leadership
- 35 years of experience designing and developing complex XML-based integrations between enterprise solutions
- 13 years of experience with technologies including:
- C#
- MS Forms
- Visual Studio
- Stronger weighting will be given to Oracle-focused experience
- Oracle Associate or Professional Certification is considered an asset
- Analyzing business and technical requirements related to ERP integrations
- Creating functional specifications technical specifications and architectural documentation
- Designing and implementing integrations between Oracle Fusion SaaS and legacy applications
- Developing and maintaining Oracle PL/SQL components including:
- Packages
- Procedures
- Functions
- Triggers
- Designing and testing XML-based integrations
- Analyzing and interpreting complex Oracle database schemas
- Supporting APIs database integrations Oracle Forms and reports
- Collaborating with project managers developers DBAs and technical analysts
- Participating in Agile scrums project meetings and status reporting activities
- Providing technical documentation and implementation support
- Supporting solution testing troubleshooting and deployment activities
- Oracle Fusion Cloud ERP
- Oracle EBS
- Oracle PL/SQL
- Oracle Forms & Reports
- Database packages procedures functions and triggers
- XML integrations
- Oracle database schema analysis
- Functional and technical specification writing
- Enterprise system integrations
- Data modeling and ERDs
- SQL query development
- Complex database structures
- Integration testing
- Public sector ERP modernization projects
- C#
- Microsoft Forms
- Visual Studio
- API integration development
- Experience with large-scale government ERP programs
- Experience with distributed Agile delivery teams
- Oracle Certifications
- Functional specifications and technical documentation
- Architectural diagrams and database schema documentation
- Integration analysis and solution recommendations
- Developed and tested integration components
- Technical implementation support
- Updated system documentation
- Participation in project scrums and stakeholder meetings
- Remote work within Canada is permitted
- Occasional onsite presence may be required in Fredericton NB
- Work must be performed during Atlantic Standard Time business hours
- Candidate must comply with Government of New Brunswick security and workplace policies
Required Skills:
Mandatory Requirements (M1 M6) The proposed candidate must clearly demonstrate the following mandatory qualifications: M1 Years of IT Experience Minimum 15 years of overall Information Technology experience M2 Experience as a Programmer Analyst Minimum 10 years of experience as a Programmer Analyst M3 Experience as a Business Systems Analyst Minimum 7 years of experience as a Business Systems Analyst M4 ERP Implementation Experience Minimum 3 years of demonstrated experience supporting a transformative ERP implementation project within a Canadian public sector environment involving complex legacy applications Experience must include enterprise ERP platforms such as: Oracle Fusion Cloud ERP Oracle EBS SAP Microsoft Dynamics Public sector experience must be within Federal Provincial or Municipal government departments/agencies M5 Communication Skills Strong spoken and written English communication skills M6 Work Authorization Legally authorized to work in Canada Scored Requirements (S1 S13) The candidate should demonstrate the following scored qualifications: S1 Business & Technical Analysis 57 years of experience analyzing business and technical requirements to identify: Information requirements Procedures Decision flows Reporting requirements S2 Data Modeling & Architecture 57 years of experience creating and consuming: Data models Entity Relationship Diagrams (ERDs) Solution architecture diagrams S3 Oracle PL/SQL Development 57 years of hands-on experience in Oracle PL/SQL including: Advanced packages Procedures Functions Debugging and maintenance activities S4 Oracle Database Specifications 57 years of experience interpreting and defining: Oracle database tables Field specifications Complex system interdependencies S5 Database Schema Analysis 57 years of experience reading and analyzing complex database schemas S6 System Integrations 57 years of experience analyzing designing and testing complex integrations between: Multiple applications Data sources Enterprise systems S7 Functional & Technical Specifications 57 years of experience writing and consuming: Functional specifications Technical specifications Integration documentation for highly complex systems S8 Distributed Team Collaboration 35 years of experience working within distributed multidisciplinary teams including: Business Analysts DBAs Developers Technical Analysts End Users S9 Oracle Fusion Public Sector Experience 35 years of experience working on major Oracle Fusion implementation projects in a public sector environment S10 Communication & Stakeholder Engagement 68 years of demonstrated verbal and written communication skills with the ability to communicate effectively with: Technical audiences Non-technical stakeholders Executive leadership S11 XML Integration Experience 35 years of experience designing and developing complex XML-based integrations between enterprise solutions Development Experience 13 years of experience with technologies including: C# MS Forms Visual Studio Stronger weighting will be given to Oracle-focused experience S13 Oracle Certification Oracle Associate or Professional Certification is considered an asset
Required Education:
University Degree or Post-Secondary Diploma in Information Technology Computer Science Business Analysis or an equivalent program.
