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