Sql analyst Jobs in Hamilton, ON

At Stantec, we have some of the world’s leading professionals passionate about enabling our business to be its best. Our business teams include finance, procurement, human resources, information technology, marketing, corporate development, HSSE, real estate, legal, and practice services. We bring diverse backgrounds, skills, and expertise and create a caring culture where everyone can thrive. Through teamwork and collaboration, we’re building a stronger, more resilient Stantec every day.

Your Opportunity

We are looking for an Oracle EBS Functional Developer to be part of the evolution and enhancement of our Oracle E-Business Suite modules, with particularly strong skills and application knowledge in the Oracle Projects module realm [costing, billing, management], to meet the needs of our business.

As an EBS Functional Developer, you will collaborate with the business analysts and technical development teams to gain a deep understanding of requirements; perform functional analysis & design; and collaboratively involve themselves in producing the functional solution design, configurations and inputs to extensions to meet the requirements following our solution delivery framework.

This role will primarily oversee, configure and design functional solutions as the functional expert in Oracle Projects. The Functional Developer will provide an interactive gateway with end user groups on helping align business processes with Oracle ERP Projects Suite, adopt best practices and keep abreast of Oracle relevant module enhancements, direction and updates.

Your Key Responsibilities

• Recommend Oracle EBS functionality and capabilities to help meet new business requirements, improve existing business processes and/or address application problems.

• Be part of a team responsible for recommending solution designs to the business based on Oracle best practices leveraging out-of-the-box functionality and extensions, where appropriate, to address gaps.

• Develop impact analysis and implement strategies to manage change for large new system implementations or small functionality changes.

• Develop functional design documents in collaboration with developers and other analysts.

• Contribute to the end-to-end delivery of E-Business solutions along with developers, testers, database administrators, and application support analysts.

• Monitor, analyze, and advise on testing of application patches/upgrades.

• Configure application to meet requirements.

• Work closely with developers on extensions and custom applications to translate business requirements into detailed system requirements and design.

• Work closely with quality assurance analysts to develop and execute appropriate test strategies/plans.

• Work closely with Business Analysts to understand business requirements and present/discuss application solutions with the business.

• Monitor patch releases from Oracle and provide impact assessments to management.

• Provide post-implementation support and direction to assist the Operations Support Teams.

• Work collaboratively with the management team to assist them in managing priorities, resources and cross project dependencies.

Your Capabilities and Credentials

• Experience in a systems analyst, software development and/or system implementation role.

• Involvement in one or more major upgrades and/or module implementation projects.

• Creative problem solver with good understanding of Projects and Financial business processes.

• Strong written and oral communication skills.

• Highly self-motivated and directed.

• Keen attention to detail.

• Strong customer service orientation.

• Experience working in a team-oriented, collaborative environment.

• Functional experience with Oracle EBS R12.2.

• Exposure or experience with Oracle Cloud Project Financial Management is an asset.

Education and Experience

• Post-secondary degree/diploma in business, information systems or related field, or equivalent experience.

• Minimum of 7 years of relevant work experience, including experience configuring and/or developing extensions for Oracle e-Business.

Pay Range:

• Locations Outside of Lower Mainland - BC & Various locations in Ontario-$89,200.00 - $129,300.00 Annually

• Locations in Lower Mainland - BC, GTA & Ottawa Ontario-$94,600.00 - $137,100.00 Annually

Pay Transparency: In compliance with pay transparency laws, pay ranges are provided for positions in locations where required. Please note, the final agreed upon compensation is based on individual education, qualifications, experience, and work location. At Stantec certain roles are bonus eligible. Actual compensation for part-time roles will be pro-rated based on the agreed number of working hours per week.

Benefits Summary: Regular full-time and part-time employees (working at least 20 hours per week) will have access to health, dental, and vision plans, a wellness program, health care spending account, wellness spending account, group registered retirement savings plan, employee stock purchase program, group tax-free savings account, life and accidental death & dismemberment (AD&D) insurance, short-term/long-term disability plans, emergency travel benefits, tuition reimbursement, professional membership fee coverage, and paid time off.

Temporary/casual employees will have access to group registered retirement savings plan, employee stock purchase program, and group tax-free savings account.

The benefits information listed above may not apply to union positions because benefits for such positions are governed by applicable collective bargaining agreements.

Primary Location: Canada | AB | Edmonton
Organization: BC-1374 IT Services-CA Corporate
Employee Status: Regular
Business Justification: New Position
Travel: No
Schedule: Full time
Job Posting: 13/05/2026 04:05:26
Req ID: 1005772