Sql developer Jobs in Richmond Hill, ON

SUMMARY

The Team

The Corporate IT Development & Delivery department is a software development, support and information delivery department within BGIS’ IT Solution Support area. The team provides hosted and cloud Oracle ERP technical solutions for Finance, HR, Project Accounting and Procurement. Also develops other departmental software to support corporate business processes.

This is a dynamic team working in a fast-paced environment. Based on our company values of Unwavering Integrity, Passion for Innovation, Living Sustainability, Customer Experience, and team member engagement, we believe in engineering effective business processes first before delivering solutions for efficiency. We believe in team transparency and promote healthy technical discussion and debate. We promote self-learning alongside corporate funded training and personal career growth.

The Position

Reporting to Director, Corporate IT Development and Delivery, the Systems Analyst / Developer position analyzes, programs, and implements user requirements. Apart from programming complex programs, this role requires business knowledge on areas related to our deliverables in BGIS.

With respect to Enterprise Corporate Software, this position analyzes user requirements and documents the technical system design in a highly complex, tightly integrated environment, which includes a few cloud-based SaaS applications, internal operational application data integration, external banks, Taxation Services and client data delivery integrations. This position prepares technical design documents, programming the new functionality or modifications to existing program units, designs reports and extensions for Corporate Software including Oracle HRMS, OTL, G / L, A / P, A / R, P / O and Project Accounting modules and provides data integration services for all related interfaces. This position maintains and supports the existing customizations / extensions and changes within the production environment according to Oracle EBS Development Standard. In addition to excellent technical skills, strong functional knowledge is an advantage, especially for human resource, finance, procurement, project accounting, etc. and corporate related processes within Oracle EBS.

For corporate departmental related software, this position will also deliver development cycle tasks to support corporate departmental software needs using Oracle APEX technology.

For integration services, this position also uses Snaplogic service to build, deploy and support required integration services. Provide code enhancements and bug fixes according to the RFC management process.

KEY DUTIES AND RESPONSIBILITIES

• Business Solution : Analyze, engineer and document complex technical solutions to meet the needs of an assigned project. Document the design; perform programming and unit test the solution according to relevant development standards.
• Program Modules, Data Interfaces and System Integration : Analyze, engineer and document technical program units to meet the needs of IT’s internal clients (., Corporate Accounting, Client Accounting, Procurement and HR). Develop the BI Publisher and Concurrent program units according to Oracle EBS development standards. Understand any integration task source and destinations, using Snaplogic or related SFTP tools to perform system integrations. Utilize Oracle APEX development platform for BGIS internal program units and ERP UI development.
• System Support : Support production environment (including all existing extensions, interfaces, modifications, and BI Publisher reports) analyze urgent problems that occur at a module level. Deal with one-time data requests. Be able to occasionally work out-of-office hours for urgent support needs.
• Upgraded Functions : Evaluate new technical functions available from upgrades, patches, or new software. Determine the applicability of new functionality to BGIS business and the impact to existing customizations, extensions and reports.
• New Technology and Process : Actively Maintain and upgrade related knowledge and keep current on a wider range of technical platforms, approaches, and processes in the market.

KNOWLEDGE AND SKILLS

General

Technical Knowledge and Skills

This is a regular, full-time position with a salary range of $73,600 - $92,000 per annum. The starting salary will be based on the successful candidate’s competencies, including but not limited to experience, education, professional designations and performance related to this role.

#LI-Onsite