[Hiring] PowerBI Senior Developer/Analyst @Rona

Role 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.

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.

Qualifications

• 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.

Benefits

• 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!