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

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.