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

RONA; Boucherville; Remote; CAD 90,000 - 120,000; Full time

Benefits offered by this job

Childcare centre

Cafeteria on-site

Electric car charging

Gym & showers

Employee discounts

Retirement plan

Telemedicine access

Career growth

Job summary

RONA in Montérégie, near Boucherville, is seeking a senior BI professional to lead data analytics initiatives, translate business needs into BI solutions, and collaborate with IT and business teams.

You will design tests, ensure data quality, and deliver actionable insights to senior management using Power BI, Looker, SQL Server, and cloud data warehouses, while driving data governance and stakeholder communication.

Qualifications

• Minimum 5 years of BI/analytics experience.
• Strong SQL experience with SQL Server and Oracle.
• Advanced Power BI skills with DAX and data modeling.
• Experience with cloud data warehousing platforms.
• Ability to communicate with non-technical stakeholders.

Responsibilities

• Translate business needs into BI solutions and collaborate with IT and business teams.
• Design tests to validate data quality and reporting accuracy.
• Deliver actionable insights to senior management using BI tooling.
• Support data governance and stakeholder communications.

Skills

BI/Analytics

SQL

Power BI

Looker

Data modeling

Data warehousing

Cloud data storage

Excel VBA

DAX

Tools

SQL Server

Oracle SQL

Power BI

Looker

Microsoft Fabric

Azure Analysis Services

Dataflows

Tabular Editor

DAX Studio

Snowflake

BigQuery

Job description

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 to meet deadlines.

Performance and Reporting:

• Track and measure BI system performance and effectiveness.
• Present actionable insights to senior management to drive decision-making.
• Deliver clear and concise reports that provide value to both technical and non-technical stakeholders.

Certifications and Professional Development:

• A commitment to ongoing learning and professional development in the BI space.
• Interest in staying up-to-date with the latest trends, tools, and technologies in Business Intelligence and Analytics.

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.
• Access to the GreenShield+ telemedicine platform, including virtual consultations with healthcare professionals and pharmacy services
• 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.