PowerBI Developer/Analyst (PowerBI, SQL, Oracle) - Remote - Boucherville

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.

Your Role:

• Identify, evaluate, document, and validate technical, functional, and business needs to improve existing computer systems and implement new solutions that better meet the organization’s requirements.
• Design, document, and execute various tests (unit, functional, automated) to validate the quality and functionality of programs.
• Collaborate with internal development teams and external partners to deliver BI solutions.
• Apply experience in Business Intelligence (BI) to provide effective solutions.
• Understand the software development life cycle, write scripts, and review solutions implemented by other developers to identify and resolve bugs.
• Demonstrate strong analytical and communication skills.
• Organize and document work rigorously, ensuring clarity and attention to detail.
• Contribute to project management activities, including defining and estimating project effort, identifying risks, recommending mitigation strategies, and communicating project status.
• Ensure timely notification and escalation of issues to the Team Leader or Project Manager.
• Collaborate with key stakeholders to assess the impact of solutions on existing processes and systems and manage integration effectively.
• Maintain continuous communication with stakeholders throughout the project lifecycle.
• Manage your workload to deliver high-quality results and meet deadlines.
• Prioritize tasks appropriately based on project needs, deadlines, and resource availability.
• Be available to provide support outside of regular office hours, if needed.

Tools and Technologies:

• Minimum of 5 years of relevant experience in Business Intelligence, data analytics, or a related field.
• Proficiency in SQL Server and SQL language.
• Knowledge of Oracle (SQL and PL/SQL).
• Experience with Power BI and other reporting software (Looker is a plus).
• Experience with Microsoft Fabric, Gateway, and Dataflows.
• Familiarity with Azure Analysis Services and Visual Studio (Microsoft Analysis Services Project).
• Strong understanding of Relational Database Management Systems and relational model principles.
• Advanced Power BI skills, including Power Query, DAX, and Tabular Model Scripting Language for data model creation and reporting.
• Experience with Tabular Editor and DAX Studio is a plus.
• Strong SQL Server knowledge and understanding of relational modeling principles.
• Advanced Excel and VBA skills; knowledge of Access is an asset.
• Knowledge of Progress OpenEdge (SQL) is an asset.
• Experience with data warehousing platforms like Snowflake, Oracle Database or Google BigQuery.
• Proficient in working with cloud-based and on-premise data storage solutions to support large-scale data analytics and business intelligence.
• Understanding of data security, privacy policies, and governance frameworks.

Soft Skills and Collaboration :

• Ability to collaborate effectively with cross-functional teams, including IT, operations, and business stakeholders.
• Self-motivated, proactive, and able to work autonomously with a strong DIY mentality.
• Excellent problem-solving, critical thinking, and organizational skills.
• Strong business acumen and ability to understand user needs, particularly in commercial finance contexts.
• Strong communication and storytelling skills to present technical information in a way that’s easily understood by non-technical stakeholders.
• High attention to detail and accuracy in data analysis and reporting.
• Ability to adapt to changing priorities and work effectively under pressure …