Sr. Data Analyst

Get AI-powered advice on this job and more exclusive features. We are committed to connecting Canadians through unique partnerships, our world-class network and content Canadians love—and our innovative team is growing. We are looking for dedicated team members to join our Corporate team who have a genuine passion for making positive impacts on customers and the communities where we live and work. We have a variety of business units with exciting and meaningful work waiting for you, including Communications, HR, Legal and Corporate Affairs, Supply Chain, Finance, and Real Estate. If you are considering your next step, we have exciting opportunities waiting for you. Come build a rewarding career at Rogers and be a driving force behind our success story What You’ll Do Data Reporting and Analysis (50%) Combine and transform data from various sources (e.g., Excel, CSV, databases, APIs) using Power Query and Power Pivot. Develop and maintain robust data models in Power BI and Excel. Design and publish interactive dashboards and reports in Power BI and Excel tailored to business needs. Collaborate with stakeholders to gather reporting requirements and translate them into actionable insights. Ensure data accuracy, consistency, and performance across all reporting solutions. Automate recurring reporting tasks and improve data workflows. Monitor and troubleshoot data refreshes and report performance issues. Prepare various level management and compliance reports on key health and safety metrics, including comprehensive analysis of current and historical trends. Prepare detailed, comprehensive and integrated data reports and presentations for health and safety, wellness, and disability management/workers compensation, including benchmarking. Link data to strategic planning, specific departments/needs and when preparing business cases. Manage and maintain organization of data; incident records, audit reports, etc. Continuously analyze data and reporting processes, making improvements to enhance accuracy, efficiency and value of the reports. Participate in key health and safety projects providing high level data knowledge and advice as to how to best leverage the information available to assist in building requirements. Database/System Development and Management (40%) Contribute to system and process improvements by documenting reporting needs and translating them into clear, actionable requirements for system enhancements. Lead Rogers software solutions/IT systems for the health and safety management system. Understand and work with the vendors that operate Rogers applications in the “cloud” as well as communicate business requirements and issues effectively. Configure health and safety databases to meet Rogers requirements and updates as well as ensure that all configurations and special set ups map back to established business rules and processes. Provide ongoing support and training to the system users. Consult with internal stakeholders to ensure the health and safety system is meeting operational needs. Partner and manage relationships with vendors to ensure effective use of the IT systems and that Rogers needs are met. Health and Safety Intranet, Documentation Control and Records Management (10%) Maintain and continuously improve Rogers health and safety intranet site. Lead documentation control and management of records within the department. What You’ll Have Proven experience with Power BI, Power Query, and Power Pivot. Strong proficiency in Excel, including advanced formulas, pivot tables, and data modeling. Solid understanding of data integration, ETL processes, and DAX. Experience working with relational databases and data sources (e.g., SQL Server, SharePoint, Excel files). Ability to communicate complex data concepts clearly to non-technical stakeholders. Strong problem-solving skills and attention to detail. Post-secondary education. Five years’ experience in an analyst and database lead role, preferably in an HR, health and safety or quality environment. Strong analytics background with understanding of HR, health and safety or other related systems. Excellent analytical, problem solving, organization and data management skills. Extensive experience with database programming and configuration of rules and workflows in applications. Experience with applications that are hosted in cloud environments where requirements must be clearly communicated and tested in all software solutions. Ability to compile complex information, gathered from multiple sources, and present in an easy-to-understand format (such as Visio and/or MS PowerPoint). Expert level MS Excel and PowerPoint skills. Ability to produce reports in MS Excel using advanced techniques (such as functions, vlookups, pivot tables, and macros). What’s in it for You? We believe in investing in our people and helping them reach their potential as valuable members of our team. As part of our team, you’ll have access to a wide range of incredible resources, growth opportunities, discounts, and perks, including Discounts Enjoy up to 50% off Rogers Services and Blue Jays Tickets, 25% off TSC items, and a 20% discount on all wireless accessories sold in Rogers stores. Company matching contributions to charities you support. Growth & Development Opportunities. Self-driven career development programs (e.g. MyPath program). Rogers First priority in applying to internal roles of interest. Wellness Programs Homewood employee & family assistance program. Cognitive Behavioural Therapy (CBT) & Virtual therapy sessions. Low or no-cost fitness membership with access to virtual classes. Our Commitment to the Environment and Diversity Work for an organization committed to environmental protection. Strong commitment to diversity and inclusion with employee resource groups supporting equity-deserving groups including groups representing People of Colour, 2SLGBTQIA+, Indigenous Peoples, Persons with Disabilities and Women. To protect our people, brand and assets, a pre-employment background check will be conducted. As part of our selection process, all candidates must clear a criminal background check. Additionally, a credit check and drivers abstract may be required depending on the role. Schedule Full time Shift Day Length of Contract Not Applicable (Regular Position) Work Location 8200 Dixie Road (101), Brampton, ON Travel Requirements Up to 10% Background Check(s) Required Canadian Criminal Record Check Posting Category/Function Human Resources & Health and Safety Requisition ID #J-18808-Ljbffr