SQL/T‑SQL IT Developer (Remote – Boucherville, QC)

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.

Job Posting - SQL / T‑SQL Developer (Remote Position)

Position Summary

As an SQL / T‑SQL Developer , you will be responsible for designing, developing, maintaining, and optimizing Microsoft SQL Server databases used for our data warehouse, datamarts, and internal applications. You will play a key role in transforming and preparing data for use in Microsoft Power BI .

You will ensure adherence to best practices related to performance, security, and documentation. You will collaborate closely with the IT team and internal stakeholders to guarantee the stability, quality, and evolution of our data solutions.

Key Responsibilities

• Design, develop, and optimize:

  • Tables, views, indexes, and database structures

  • Advanced T‑SQL queries

  • Stored procedures and functions

  • ETL processes feeding data warehouses and datamarts

• Ensure database performance, consistency, and data integrity.

• Configure and maintain security parameters and access controls.

• Prepare, transform, and structure data for use in Power BI .

• Participate in testing, validation, and deployment of enhancements and new features.

• Produce and maintain clear and up‑to‑date documentation.

• Participate in an on‑call rotation: the individual may be on call to respond to urgent incidents related to databases or data flows. The on‑call period is daytime only (7:00 a.m. to 4:00 p.m.).

• Collaborate with the IT team to ensure compliance with coding standards and best practices.

Candidate Profile

• Strong mastery of T‑SQL and Microsoft SQL Server

• Solid understanding of data warehouse concepts, datamarts, and data modeling

• Ability to analyze and troubleshoot SQL performance issues

• Strong attention to detail, rigor, and autonomy

• Team player with excellent communication skills

• Experience in the retail or distribution industry is considered a strong asset

Technical Requirements

Required:

• Microsoft SQL Server

• Microsoft Power BI

• MS Excel and MS Word

Assets:

• VBA

• Microsoft Access

Education

• Bachelor’s degree in Computer Science, Software Engineering, or a related field
  OR

• Equivalent relevant experience

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.