Job Title

Join to apply for the Sr. Data Analyst & Systems Administrator role at Rogers Communications . We are committed to connecting Canadians through unique partnerships, our world-class network and content Canadians loveand 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. The Sr. Data Analyst & Systems Administrator will be based in Brampton/GTA and report to the Senior Manager, Corporate Safety. Responsibilities 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. Lead data validation process for both internal and external audits. Build Rogers data and reporting metrics as the health and safety management system evolves, lagging to leading and other industry leading indicators. 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. Qualifications 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 problemsolving skills and attention to detail. Postsecondary 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, problemsolving, 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 easytounderstand 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). Benefits Discounts up to 50% off Rogers Services and Blue Jays Tickets, 25% off TSC items, and 20% discount on all wireless accessories sold in Rogers stores. Company matching contributions to charities you support. Growth & Development Opportunities. Selfdriven 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 nocost fitness membership with access to virtual classes. Work Location: 8200 Dixie Road (101), Brampton, ON. Shift: Day. Schedule: Full time. Travel Requirements: Up to 10%. Background Check(s) Required: Canadian Criminal Record Check. To protect our people, brand and assets, a preemployment 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. #J-18808-Ljbffr