View all jobs

ERP Integration Analyst-Developer

Halifax, Nova Scotia
Reporting to the Solution Architect/Technical lead for the ERP Solution project, the Integration Analyst/developer, will design, develop, test and implement the integrations with Cayenta and other internal and external systems. 


The integration methods will include: 
  • System to system integrations using REST APIs. 
  • Database to database integrations using MS SQL Server Linked Server or similar database connections. 
  • System to system data exchange using XML or ASCII data files. 

Activities include: 
  • Work with the Cayenta system vendor to gather integration requirements, identify integration options and define integration approaches based on vendor best practices. 
  • Work with other source/target system SMEs to gather integration requirements, identify integration options and define integration approaches. 
  • Work with the solution architect to select the preferred integration approach and develop interface design specification for each integration. 
  • Facilitate the Halifax Water review and approval of the interface design specifications. 
  • Work with the source/target system SMEs to develop and unit test the integrations. 
  • Develop Halifax Water’s portion of the interface/integration. 
  • Support functional, system/integration and user acceptance testing of the integrations. 
  • Develop the interface run books and transition the operation and support of the integrations to the Halifax Water operations. 

Technical Qualifications:

This role requires hands on integration development experience. 

Desired skills include: 
  • Experience in gathering requirements from business and technical stakeholders. 
  • Experience with authoring clear and concise interface design specifications and operation run books. 
  • Experience with the development, unit testing, troubleshooting and implementation of interfaces using the above methods. 
  • Experience working with clients in the review and client approval of deliverables. 
  • Experience and advanced skills with MS SQL Server and T-SQL, and REST web services. 
  • Experience with supporting integration and user acceptance testing. 
  • Knowledge of Azure Data Centre management and administration. 
  • Experience facilitating meetings to solicit information from stakeholders. 

• Nice to have:
  • Water utility or similar domain experience. 
  • Experience with Cayenta CIS and FMS modules. 
  • Knowledge of SAP ERP systems (SAP ECC 6 EHP 5 including FICO (Financial Accounting and Controlling), MM (Material Management) and IS-U (Industry Specific Solution for the Utilities Industry)) is considered an asset. 

  • 5+ years working in the IT industry. 
  • 3+ years of demonstrated experience as integration/interface developer/analyst. 
  • Strong technical acumen - solid understanding of networked systems, security infrastructure, data architecture, solution architecture and backend supporting processes. 

Share This Job

Powered by