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 Sr. Data Analyst in the Wireless Planning & Perf Management team. This position will be responsible for data mining, extraction and measuring service & equipment revenue /usage KPIs and be able to be as storyteller. Candidates will work very closely with various teams to provide value-added analysis on Wireless Revenue and Hardware cost.
The Sr. Data Analyst will be based in Toronto and will provide expert data management to the Wireless Planning & Perf Management team.
What you'll do:
- Responsible for finance reporting, tracking delivery, creating insightful performance reports.
- Has strong analytical skills, excellent communication and presentation skills and strong attention to detail.
- Use advanced analytics tools (SAS, SQL, Databricks, Python,Pyspark) and methodologies to analyze data from different sources and provide key insights on tight schedules often within an ambiguous environment.
- Design and perform weekly and monthly financial score cards visually (Tableau) for wireless service & equipment finance, including insights of key drivers.
- Provide standard reporting support, which includes the ability to extract and analyze large and complex data sets from various source systems and data stores by performing coding and system parameter setting
- Responsible for writing queries, filtering and transforming data into meaningful reports for financial analysis and Pricing, Commercial strategy and Sales teams.
- Process and analyze data to support business case analysis and ad-hoc requests. Define data requirements and ensure accuracy of data pulls
- Perform ad-hoc queries and develop / automate financial / statistical models using a variety of software applications (Excel, SAS/SQL, databricks, Python, Tableau); provide recommendations and insights
- Perform and Monitor Machine learning process for revenue prediction
- Investigate and help resolve possible data corruption and discrepancies
- Liaise with IT to understand best sources of data and tables
- Lead special projects / ad-hoc assignments as required
What you'll have:
- Must be insights-driven leader, patient, flexible, enjoy a fast-paced environment, dedicated to customer satisfaction and team oriented
- Advanced experience in designing and creating Tableau dashboard or other BI tools
- Advanced experience in PL SQL, SAS, Python, Microsoft Office including Excel
- Experience in Machine learning practical experience
- Experience in working with financial/marketing information including business cases, KPIs
- Hands-on experience in analytical techniques such as attribution modeling, testing, reporting design of experiment
- Knowledge of database architecture fundamentals and best practices
- Strong interpersonal and communication skills (both written and oral) to interact effectively with senior leadership
- Ability to tell a story from the data
- University degree in Computer science, Mathematics, or related field.
- 3+ years experience dealing with data analytics and business intelligence, preferably in the telecommunications industry
- 3+ years programming skills with advanced knowledge of SAS, SQL, Python, data mining software
- 3+ years experience in BI tools such as Tableau.
- Ability to construct datasets, ensure data quality and perform quantitative / basic statistical analysis.
- 3+ years experience with oracle & cloud environment.
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:
• Competitive salary & annual bonus
• Competitive & flexible health and dental benefits, pension plan, RRSP, TFSA, and Stock matching programs.
• 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.
• Paid time off for volunteering
• Company matching contributions to charities you support
• Growth & Development Opportunities:
o Self-driven career development programs (E.g. MyPath program)
o Rogers First: priority in applying to internal roles of interest
• Wellness Programs:
o Homewood employee & family assistance program
o Cognitive Behavioural Therapy (CBT) & Virtual therapy sessions
o Low or no-cost fitness membership with access to virtual classes
• Our commitment to the environment and diversity:
o Work for an organization committed to environmental protection
o 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. We all bring something different, and we know what makes us different makes us great.
This is a hybrid work position and will require you to be in office three days per week. You can choose which days in office work best for you!
If you are selected to move forward in the recruitment process, here is what you can expect:
• 15-minute phone screen with your recruiter, 1-hour virtual interview with Hiring Manager, 30-minute final round virtual interview with Director of the team. Best of luck!
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: 333 Bloor Street East (012), Toronto, ON
Travel Requirements: Up to 10%
Posting Category/Function: Finance & Accounting & Financial Planning and Analysis
Requisition ID: 317369
At Rogers, we believe the key to a strong business, is a diverse workforce where equity and inclusion are core to making everyone feel like they belong. We do this by embracing our diversity, celebrating our different perspectives, and working towards creating environments that empower our people to bring their whole selves to work. Everyone who applies for a job will be considered. We recognize the business value in creating a workplace where each team member has the tools to reach their full potential by removing any barriers for equal participation. We work with our candidates who are experiencing a disability throughout the recruitment process to ensure that they have what they need to be at their best. Please reach out to our recruiters and hiring managers to begin a conversation about how we can ensure that you deliver your best work. You matter to us! For any questions, please visit the Recruitment Process FAQ.
Posting Notes: Corporate
Toronto, ON, CA
Job Segment:
ERP, Data Analyst, Cloud, Network, Telecom, Technology, Data