DTI - BSA Technical Solutions Analyst

Service New Brunswick (SNB) requires one Senior Business Systems Analyst 3 with a background in development. In addition to demonstrated skills in documenting, verifying and consuming complex technical and functional specifications, the Senior Business Systems Analyst should have a strong development background, ideally in Oracle Forms and reports, extensive knowledge of PL/SQL components such as database packages, procedures, triggers, and functions. They should also have strong comprehension of database structures, schemas, and query building. They will be expected to write and consume complex functional specs and be able to understand, build and test complex system integrations including technologies such as XML. Experience in development in .net stacks including Forms, VB.Net C# and Visual Studio would be an asset. SNB will only consider proposals identifying one candidate to fill the requested role. If bidding multiple candidates, they MUST be submitted as separate proposals to be scored individually. DELIVERABLES The successful candidate must deliver the following to successfully complete the engagement: 1. Functional specifications: As functional solutions are approved, create functional specifications, architectural diagrams, database schemas etc for consumption by developers, DBAs, technical analysts, as required for implementation of each interface or change. 2. Problem identification and solution proposal: Analyze specifications for integrations and application modifications and propose solutions and approaches to meet requirements. 3. Solution development: Implement approved solutions to problems throughout the appropriate areas of the technology stack (ie. Database, triggers, PL/SQL and form or report). 4. Technical Documentation: Provide or update documentation per unit standards (to be provided as needed) to support integrations or implemented changes. 5. Participate in team scrums: As a member of the overall DTI / ERP implementation team, take part in team scrums and meetings to report on progress, issues etc.