Programmer/Analyst, Integrations
Energy Ottawa
Ottawa, ON
Please Note: If you are a current Energy Ottawa employee with access to Workday, apply to this job via the Workday application.

By generating and distributing power, each person at Energy Ottawa is part of empowering the lives of people in the communities we serve.

Our work means all the activities that make up our lives – at home, at work, at play – are there when we need them.

That purpose unites us and fuels our work. And if joining us in this essential work energizes you too, we may have the opportunity for you.

JOB SUMMARY

The Programmer/Analyst, Integrations is responsible for improving the efficiency of various information systems and establishing reliable communication between systems. The Programmer/Analyst, Integrations acts as the technical lead to project teams and manages various aspects of technical analysis, system modifications and integrations. The successful candidate must be a self-motivated team player with the ability and passion to see enhancement initiatives through from design to completion within prescribed time frames.

MAJOR RESPONSIBILITIES

Lead all technical activity, including working with internal and external resources, as it relates to assigned IT projects and/or ongoing operational work.
Understand and translate business requirements into detailed solution requirements to form technical scope of project.
Develop system integrations and messaging standards to support required data flows across systems while adhering to service oriented architecture (SOA) principles.
Act as a liaison between the project team and other functional groups on technical matters relevant to the project deliverables.
Participate in the architecture review process and contribute to the formation and implementation of the IT application roadmap.
Assist in leveraging technology and use knowledge of IT solutions to maximize opportunities, support business process design and drive organizational change.
Investigate and troubleshoot problems, including impact analysis of change on all systems and business areas in order to recommend appropriate remediation.
Perform both unit and integration tests to delivered solutions and monitor accordingly after implementation to ensure requirements are satisfied.
Provide direction to end users and assist in the effective and efficient resolution of issues.
Create, edit and maintain documentation, such as but not limited to, process mapping, interface mapping, entity relationship diagrams, database schemas and test cases.
Other duties as required.
EDUCATION AND EXPERIENCE

Post-secondary education in a related field such as Computer Science, Computer Engineering, Data Engineering.
Minimum 3 years’ experience in the Information Technology field.
Experience with databases such as Oracle (SQL, PL/SQL, ODA), SQLServer.
Experience with integration and extract transform load (ETL) tools (such as Oracle Data Integrator, Boomi, Jitterbit, Kafka, AWS integration solution).
Minimum 3 years’ experience integrating systems with web services and cloud based solutions such as Okta, Workday, Salesforce and other principles such as e.g. REST, API.
Experience with application development and source control.
Experience with cloud in general including cloud-based data solutions considered an asset (AWS, Oracle, Microsoft, Google).
Experience with full project lifecycle including estimating, design, and development.
Experience with web servers and middleware (e.g. Web Logic, Java, Apache ecosystem).
Experience with Linux and scripting languages (Python, Shell scripts, Perl).
Broad knowledge of technologies and applications and gathering and interpreting data.
Utility experience considered an asset.
Experience with data warehousing solutions such as AWS Redshift, Oracle Warehouse, Snowflake considered an asset.
ADDITIONAL REQUIREMENTS

English essential, both oral and written; Bilingual (English/French) considered an asset.
If this position interests you, please apply by 11:59pm the day before the job posting end date listed.

This is a management group opportunity and salary will be commensurate with qualifications.

Number of Openings:
1

Pay Range Minimum:
$64,323.00

Pay Range Maximum:
$96,484.50

Posting End date (if applicable):
April 24, 2019
Energy Ottawa is committed to establishing a qualified workforce that reflects the diverse population it serves and we encourage applications from all qualified individuals. We are also committed to preventing and removing barriers to employment for people with disabilities, and we invite you to inform us should you have any accessibility or accommodation needs.

Applicants must be legally entitled to work in Canada.