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!
