Data warehouse developer Jobs

Senior Oracle Data Warehouse Developer (PL/SQL Expert) Remote, QC
Rona —Boucherville, QC
- Full-time
- Remote
- Oracle
- Databases
- SQL
Quick apply
Software Developer
Fortinet —Burnaby, BC
- $110,000–$130,000 a year
- Full-time
- Doctoral degree
- Computer Science
- Master's degree
- Disability insurance
- Dental care
Data Engineer (Team Lead)
Apertera —Montréal, QC
- Full-time
- Hybrid work
- DevOps
- Databases
- SQL
- Dental care
- Vision care
Quick apply
5d
Senior Data Developer
Rocket Companies —Windsor, ON
- $103,250–$153,250 a year
- Full-time
- Computer Science
- DevOps
- Engineering
- Dental care
- Paid time off
Senior Data Engineer
Datatonic —Montréal, QC
- $110,000–$140,000 a year
- Full-time
- Remote
- Java
- SQL
- AWS
- Designated paid holidays
Data Engineer
Scotiabank —Toronto, ON
- Oracle
- DevOps
- Java
- Tuition reimbursement
Senior Data Developer
UniUni —Richmond, BC
- $85,000–$100,000 a year
- Full-time
- Hybrid work
- Computer Science
- Engineering
- Databases
- Dental care
- Paid time off
Quick apply
Java/Scala Developer
Recutify Inc. —Montréal, QC
- Full-time
- Java
- Databases
- SQL
Quick apply
Data Engineer (Intermediate - Senior)
KF Aerospace —Kelowna, BC
- $73,000–$111,000 a year
- Full-time
- Azure
- Computer Science
- DevOps
- Disability insurance
- Dental care
Quick apply
Data Scientist
Xsolla —Remote
- $150,000–$2,200,000 a year
- Full-time
- Remote
- SQL
- AWS
- Machine learning
- Dental care
- Paid time off
Quick apply
RQ10949 - Sr. Software Developer - ETL
Source Code —Toronto, ON
- $70.90–$85.09 an hour
- Full-time
- Azure
- Oracle
- SQL
Quick apply
13d
Senior Data Engineer (Data Governance Lead)
Xsolla —Remote
- $120,000–$170,000 a year
- Full-time
- Remote
- SQL
- APIs
- Communication skills
- Dental care
- Paid time off
Quick apply
Datastage Developer
Atlantis IT group —Toronto, ON
- Contract
- Oracle
- SQL
- Scripting
Quick apply
5d
Specialist Data Management
CPKC —Calgary, AB
- Full-time
- Computer Science
- Engineering
- Databases
5d
Dynamics 365 Developer
Joseph Ribkoff —Montréal, QC
- Full-time
- Bilingual
- System design
- English
Quick apply
6d
Sr Snowflake Engineer
Apexon —Toronto, ON
- $100,000–$140,000 a year
- Full-time
- Azure
- SQL
- AWS
Quick apply
Report Developer
Bayshore HealthCare —Mississauga, ON
- $54,000–$67,500 a year
- Full-time
- Remote
- Azure
- Microsoft Outlook
- DevOps
Senior Data Engineering Developer II
Bell —Mississauga, ON
- Full-time
- Hybrid work
- Azure
- Java
- SQL
- Dental care
1d
RQ10944 - 2 x Sr. Software Developer - ETL
Source Code —Toronto, ON
- $70.89–$85.11 an hour
- Full-time
- Azure
- Oracle
- Databases
Quick apply
13d
BI & AI Solutions Developer
Canadian Bearings Ltd —Mississauga, ON
- $60,000–$90,000 a year
- Microsoft Excel
- Oracle
- Computer Science
8d

I want to receive the latest job alerts for data warehouse developer

By signing in to your account, you agree to SimplyHired's Terms of Service and consent to our Cookie and Privacy Policy.

Explore jobs in more locations

data warehouse developer jobs near

Senior Oracle Data Warehouse Developer (PL/SQL Expert) Remote, QC

Rona -
Boucherville, QC

Quick apply

Job details

Full-time

Qualifications

French
SFTP
Statistics
Power BI
System administration
Operating systems
Oracle
XML
Database development
UNIX
Databases
SQL
Scripting
Scrum
Agile
Linux
JSON
Informatica
PL/SQL

Full job description

We require all our head office associates to be proficient in French, spoken and written.

Position is REMOTE : The selected candidate must reside within 250 km of our BOUCHERVILLE (Qc) office.

At RONA, our employees let their passion blossom every day. Our teams are driven by the desire to help people bring their projects to life and are committed to making a difference in the communities we serve.

We operate or service corporate and affiliated dealer stores. With a distinctive product and service offering and complementary store formats ranging from neighbourhood hardware stores to big box stores, our RONA+, RONA and Dick’s Lumber banners are well equipped to help meet the needs of all DIYers and contractors.

You’ve got the talent? We’ve got the tools! Here, your work and ideas will contribute to building a flourishing organization. Your voice will always be heard and valued. You’ll find career opportunities that live up to your ambitions and be able to further develop your unique set of skills.

So, if you’re looking to do what you love, we could be a perfect match.

Department: Business Intelligence (BI) & Analytics

Industry: Retail

Environment: Hybrid (Oracle 19c On-Premise & Oracle Cloud Infrastructure - OCI)

1. Mission

As a key member of the BI team, you will be the guardian of our data warehouse’s performance and reliability. Your role is to transform raw data from multiple sources (POS systems, inventory, e-commerce, loyalty programs) into optimized data structures for strategic reporting and predictive analytics.

2. Key Responsibilities

Design and Development (PL/SQL Expertise)

Design, develop, and maintain complex ETL processes using exclusively PL/SQL (Packages, Procedures, Triggers, Analytical Functions).
Develop materialized views and specific data structures for visualization tools (e.g., MicroStrategy “Strategy”, Power BI).
Develop and automate scripts for data flow management, flat file manipulation (CSV, XML, JSON), and task scheduling.

Optimization and Performance

Perform advanced SQL Tuning to ensure that critical sales reports are available every morning before store opening.
Optimize CPU/Memory resource utilization in environments.

BI Data Architecture

Collaborate with architects to define star or snowflake schemas.
Implement Change Data Capture (CDC) mechanisms and secure file transfers (SFTP/SCP) between source systems and the Data Warehouse.
Ensure data integrity and quality through automated validation scripts.

3. Required Technical Skills

Languages: Expert mastery of PL/SQL (Collections, Bulk Collect, Forall, Dynamic SQL).
Database: Oracle 12c/19c and knowledge of OCI (Autonomous DB, Object Storage).
Operating System: Familiarity with Unix/Linux (navigation, permissions management, editing via UltraEdit, log analysis).
ETL Tools & : Expertise in native scripting. Previous knowledge of AppWorx & Informatica is an asset.
Performance: Proficiency in execution plans, statistics, indexing (B-Tree, Bitmap), and partitioning.
Reporting: Understanding of data consumption requirements for BI tools.

4. Desired Profile

Experience: Minimum 7 to 10 years in Oracle SQL/PL/SQL development, specializing in Data Warehousing.
Domain Knowledge: Previous experience in the Retail industry is a major asset (inventory management, margins, POS flows, supply chain).
Adaptability: Ability to maintain robust "Legacy" systems while driving future innovation toward the Cloud. Ability to pivot easily between light system administration (Linux) and pure database development.
Team Spirit: Experience working in an Agile (Scrum) environment, collaborating with Business Analysts to translate retail needs into technical solutions.

By joining the RONA family, you’ll enjoy many benefits, such as:

A childcare centre that can accommodate up to 78 children
A cafeteria with a delicious menu prepared by a dedicated chef, healthy options, as well as FARO Roasting Houses and Tim Hortons coffee stations
Electric car charging stations
A fitness centre, sports activities, and showers
Exclusive employee discounts, plus a 10% discount on store merchandise (at all RONA locations)
Benefits: retirement savings plan, annual bonuses, student incentive program, etc.
Career growth opportunities within the company
An inclusive and safe working environment
Promotion of work-life balance
An employer that’s involved in the community
And much more!

If selected for an interview, please advise our Human Resources team if you require accommodation during the interview and assessment process and we will work with you to meet your accessibility needs.

RONA is committed to encouraging diversity and inclusion. We are pleased to consider applications from all qualified candidates, regardless of race, colour, religion, sexual orientation, gender, nationality, age, disability, or any other protected status.

Quick apply

Refine Your Search

Senior Oracle Data Warehouse Developer (PL/SQL Expert) Remote, QC

Software Developer

Data Engineer (Team Lead)

Senior Data Developer

Senior Data Engineer

Data Engineer

Senior Data Developer

Java/Scala Developer

Data Engineer (Intermediate - Senior)

Data Scientist

RQ10949 - Sr. Software Developer - ETL

Senior Data Engineer (Data Governance Lead)

Datastage Developer

Specialist Data Management

Dynamics 365 Developer

Sr Snowflake Engineer

Report Developer

Senior Data Engineering Developer II

RQ10944 - 2 x Sr. Software Developer - ETL

BI & AI Solutions Developer

I want to receive the latest job alerts for data warehouse developer

Related Searches

Explore jobs in more locations

Job seeker tools

Employer Tools

Browse

Stay Connected