Business Systems Delivery (BSD)

JOB DESCRIPTION

The IT Business Systems Delivery (BSD) Customer Engagement department supports, manages and implements a portfolio of IT system capital initiatives with our Energy Management business partners. This IT team supports each initiative from conception to implementation and provides the necessary IT support required to either enhance existing systems, create or enhance interfaces and or design, develop, test and implement new applications.

The Customer Engagement Capital Portfolio Team is looking for a senior backend developer with strong communications skills, to work with our existing IT delivery team to design, document, develop, test and implement key functional enhancements based on business requirements from our product owners and regulators. The ideal candidate has strong communication and problem-solving skills, can help foster relationships, facilitate and coordinate standard project operations and support and drive excellence.

Role & Responsibilities

Develop data transformations using C# with inputs / outputs to JSON, XML, CSV, and fixed-width

Designing and developing C# APIs : Create APIs or use third-party APIs to manage data between back end systems.

Creating and consuming C# API calls with JSON, and XML formatted payloads

Creation and execution of C# based batch processes

SQL Programming, DDL and DML including creation of complex MS SQL Stored Procedures

Designing, developing, and maintaining C# console applications

Itron Temetra (System Integration) is a big plus

Enterprise use of GitHub (e.g. Pull Requests)

Technical writing, producing technical specifications, which include data mapping (e.g. ETLs)

Testing and fixing bugs or other coding issues : Responsible for routine testing and debugging in back-end processes.

Stay current with technological developments and trends in the fields

Collaborating with cross-functional teams : will work with other team members such as UX designers, business analysts, and project managers, to ensure the project meets the desired goals.

Implementing security and data protection solutions : will ensure the secure handling of sensitive information and implement necessary security measures. Comply to corporate best practices.

Documenting development processes, including commenting code and keeping user manuals up-to-date : This helps future developers understand the project history and the reasoning behind certain coding decisions.

Design, develop and modify process to deploy code from one environment to another

Execute, plan, document and coordinate code deployment and system cutover to production.

Required Skillset All below require senior level proficiency

Creation and consuming API calls using CSharp with JSON, and XML formatted payloads

Deriving CSharp data transformations with inputs / outputs to JSON, XML, CSV, and fixed-width

Creation and execution of C# based batch processes

SQL Programming, DDL and DML including creation of complex MS SQL Stored Procedures

Understanding of MS SQL Server Architecture

Itron Temetra (System Integration) is a big plus

Enterprise use of GitHub (e.g. Pull Requests)

Technical writing producing technical specifications, which cover data mapping (e.g. ETLs)

TECHNICAL SKILLS Must Have

3+ years of experience with API / REST web services and data sources

3+ years of experience with creating stored procedures in SQL

Ability to intrepid, modify and write scripts and SQL queries

C#.NET

Data ETL

Develop ETL interfaces