Senior Data Analyst

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! An exciting opportunity exists to join as a Senior Data Analyst in the Wireless Service & Equipment Finance team. This position will be responsible for creating and maintaining Tableau dashboard that including dashboard design, creation, master data file building, data mining and measuring service & equipment revenue /usage KPIs and be able to be as story teller. Candidates will work very closely with various teams to provide value-added analysis on Wireless Revenue. The Sr. Data Analyst will be based in Toronto and will provide expert data management to Wireless Service & Equipment Finance. What you'll do: Design, develop, enhance and maintain Tableau and/or Power BI dashboards supporting Wireless Service & Equipment Finance reporting and performance management. Develop and maintain master datasets and reporting data layers using Databricks, SQL and Python, including data extraction, transformation, integration and validation from multiple data sources. Build and automate weekly and monthly financial scorecards, dashboards and management reports, providing clear insights into performance trends and key business drivers. Analyze large and complex datasets across multiple source systems to evaluate wireless subscriber, revenue, equipment, usage and other financial/business KPIs. Translate business and Finance requirements into scalable data models, queries, dashboards and reporting solutions. Write and optimize SQL queries and Databricks workflows to extract, join, cleanse, transform and aggregate large datasets for financial reporting and business analysis. Use Python and SQL to automate recurring data preparation, validation, reconciliation and reporting processes. Develop visually effective dashboards that enable users to understand performance, identify trends and investigate key drivers. Perform detailed data validation and reconciliation between source systems, master datasets, financial results and reporting outputs to ensure accuracy and consistency. Investigate data discrepancies, data quality issues and potential data corruption; identify root causes and work with appropriate teams to implement solutions. Support Financial Analysis, Pricing, Commercial Strategy, Marketing and Sales teams by providing reliable datasets, analytical insights and ad-hoc reporting. Process and analyze data to support business cases, forecasting, performance measurement and ad-hoc analytical requests. Define data requirements and business rules and ensure data extracts and reporting outputs are complete, accurate and fit for purpose. Develop and automate financial and statistical analyses using tools such as Databricks, Python, SQL, Excel, Tableau and Power BI. Partner with Data, Technology and IT teams to identify appropriate source systems, databases and tables and understand upstream/downstream data dependencies. Present analytical findings to Finance and business stakeholders and translate complex data into clear business stories, key insights and actionable recommendations. What you'll bring: 3+ years’ experience in data analytics/Business Intelligence, ideally within telecommunications. Advanced Databricks and SQL skills working with large, complex datasets. Strong Python and/or PySpark programming and data manipulation experience. Adva…

View the full posting and apply