Water Data Management Specialist

environmental services information technology/GIS
Location: City of Cambridge, ON
Email: careers@grandriver.ca
Website: http://www.grandriver.ca
Type: full-time
Posted On: May 10, 2019
Closing Date: May 31, 2019
Internal/External Job Posting
Regular Full Time Non-Union Position
Water Data Management Specialist

The Grand River Conservation Authority (GRCA) has an international reputation for excellence in managing the natural resources of the largest inland river system in southern Ontario. Encompassing approximately 6,800 square kilometres, the Grand River watershed has a population of almost one million people in 39 municipalities and two First Nations. Designated as a Canadian Heritage River, the Grand River and its major tributaries boast many outstanding human heritage features and excellent recreational opportunities. The GRCA is committed to environmental protection by delivering services that ensure the well-being of the environment and its inhabitants.


General Accountabilities
The Water Data Management Specialist is responsible to the Supervisor of Information Technology to implement, manage and administer the Water Information Management System and related data holdings; to implement, manage and support SCADA hardware, software and solutions; to work with staff and partners to collect and disseminate data; and provide technical expertise, guidance and support to staff.
Specific Accountabilities
Water Information Development and Administration:
  1. Work with Supervisor of IT and Engineering staff to architect, implement and support Kisters suite of water information management tools including WISKI, KiWQM, SKED, KiWIS, and KiECO in a Microsoft SQL database environment
  2. Design and implement time series data build-ups including QA/QC and data merge agents
  3. Develop and implement data import solutions using both automated QA and manual data validation procedures
  4. Work with Engineering staff and water data custodians to implement data management best practices including metadata
  5. Integrate water information data with other applications including GAWSER, GRIFS, GRSM, Groundwater Models and US Army Corps of Engineers Hydrologic Engineering Center (HEC) suite of tools
  6. Use data visualization tools and techniques to communicate monitoring data to the public and partners.
  7. Make data available to others through web services and data download tools


Supervisory Control and Data Acquisition (SCADA) software Implementation and Administration:


  1. Coordinate data logger deployments/replacements, programming/configuration and data acquisition and telemetry
  2. Work with Supervisor of IT to design and implement SCADA operator interfaces using Ignition Human Machine Interface (HMI) software
  3. Develop and implement Ignition gateway and HMI screens at GRCA dams to support dam operations and reporting
  4. Design and implement alarming and notification pipelines in Ignition for advanced alarming and alarm acknowledgement
  5. Implement, program and manage Emerson ControlWave Remote Terminal Unit (RTU) / Programmable Logic Controller (PLC) for data collection and process control


Secondary Duties:


  1. Areas included in secondary responsibilities are primarily for the purpose of cross training and backup coverage. This includes system administration responsibilities that may necessitate dealing with confidential information related to Human Resources and Finance.
  2. Provide a supporting role in working with agencies and organizations with respect to data collection, data sharing, data maintenance and cooperative projects.
  3. Provide general direction and guidance for students and contractors.
Technical Accountabilities
  1. Honours University degree in Environmental Science, Computer Science, Engineering or a related discipline with training in database development and management.
  2. Extensive knowledge of Water Information Management Systems and management of Sensor Data (five years minimum). Minimum three years applied data management experience and proficient in best practices related to the components and architecture of the WISKI database.
  3. Significant working experience with Kisters WISKI product suite [(WISKI, KiWQM (Water Quality data management), SKED, KiWIS (web data services), and KiECO (Ecological Data Management)], Microsoft SQL technology, and Ignition SCADA software. Proficiency with Python, Microsoft Office Suite, HTML and JavaScript.
  4. Experience with the development and use of water data standards and metadata.
  5. Demonstrated skill in data management, and quality assurance.
  6. A basic understanding of the principles of hydrology, hydraulics, water quality and meteorology.
  7. Experience working with municipal, provincial, and federal data assets.
  8. Knowledge of RS232/485, SDI, 4-20 mA, Modbus, Ethernet and Cellular data communications technologies pertaining to sensor communication and configuration.
  9. Experience in Systems Administration including Active Directory, SQL Server, Microsoft Hyper-V failover cluster and server virtualization is an asset.
  10. Excellent oral and written communication skills and ability to gather and document requirements.
  11. Strong analytical, documentation, and organizational skills.
  12. Must have good attention to detail and demonstrate analytical, problem solving and technical skills.
  13. Ability to complete complex data analysis projects. Ability to transfer knowledge to others and to deliver technical training.
Competencies and Abilities
Professional Judgement: Demonstrated ability in the area of critical thinking, analysis and assessment of implications, making connections of underlying issues and the ownership of the outcome. Sound judgement resulting in fair, efficient and effective decision making, bringing clarity and resolution to complex and ambiguous situations.
Integrity/Ethics: The willingness to hold oneself and others accountable for acting in ways that are consistent with stated values, principles and professional standards.
Team Work: Interacts with people effectively. Able and willing to share and receive information. Proven ability to communicate information clearly and professionally to both internal and external groups. The ability to gather facts and pertinent information to gain an understanding before drawing conclusions or taking action. Demonstrated ability to build partnerships and alliances with peers, partners and staff.
Goal /Action Oriented: The ability to work in a team or independently with limited supervision and maintain a high level of self-direction, work productivity, quality, and professionalism. Effective problem solving and collaboration skills. Seizes opportunities; takes initiative and is self-motivated. Organizes work, plans activities and sets priorities in a manner that meets competing needs and timely resolution of matters. Demonstrated experience in Project Management with the ability to work under pressure and handle multiple tasks simultaneously with changing priorities.
Customer Focus: Dedicated to meeting the expectations and requirements of internal and external customers. Develops and maintains effective relationships and ensures good communications with stakeholders.
Leadership: A high level of personal and professional excellence including the ability to align personal and organizational values. Demonstrated ability to be innovative, flexible and entrepreneurial.
The annual salary range for this position is Job Level H $67,287 to $81,865 and hours of work are 35 per week.
Approximate Start Date: June 2019
To Apply: Please send a resume and covering letter to careers@grandriver.ca in MS Word or PDF format and quote “Water Data Management Specialist" in the subject line.
Deadline for Applications: 4:00 pm Friday, May 31, 2019
We thank you for your interest, however, only candidates under consideration will be contacted.
Accessibility accommodations are available for all parts of the recruitment process. Applicants need to make their needs known in advance