Senior Business Analyst

Intello Technologies Inc.; Toronto; On-site; CAD 90,000 - 120,000; Full time

Job summary

A leading telecommunications company in Toronto seeks a Senior Business Analyst to drive strategic process optimization and oversee monthly vendor settlements worth $45 million. The role involves documenting and optimizing critical processes, investigating payment issues, and creating reports using advanced analytical tools like SQL and Excel. The ideal candidate should have over 10 years of experience in telecom business analysis and a relevant degree.

Qualifications

• 10+ years of experience in revenue assurance process improvement, financial systems or business analysis in telecom or a similar industry.
• CPA or process improvement certifications are strong assets.
• Strong understanding of telecom revenue streams, billing systems and settlement logic.
• Strong knowledge of RA best practices and telecom business operations.
• Excellent written and verbal communication skills for cross-functional collaboration.

Responsibilities

• Document and optimize critical settlement processes at scale.
• Identify and lead implementation of automation solutions.
• Bridge strategic alignment between business and technical teams.
• Investigate payment issues and implement fixes.
• Create reports and dashboards using SQL and Excel.

Skills

SQL

Agile

Business Analysis

Data Analysis Skills

Education

Bachelor's degree in Finance, Accounting, Business, Engineering or Computer Science

Tools

Advanced Excel (Power Query, VBA)

SQL (Oracle / GCP)

Tableau / Power BI

Job description

Join our team and what well accomplish together

Drive strategic process optimization for TV vendor settlements as a Senior Business Analyst overseeing $45M in monthly transactions. This key role combines advanced analytical expertise with operational leadership to:

• Document and optimize critical settlement processes at scale
• Identify and lead implementation of innovative automation solutions
• Apply sophisticated analytical techniques to reduce revenue leakage and maximize operational efficiency
• Bridge strategic alignment between business and technical teams within a robust revenue assurance framework

Position your senior analyst expertise at the heart of digital transformation while delivering direct impact on multi-million dollar revenue streams.

What you’ll do

• Processing Monthly TV Payments: Reviewing TELUS TV contracts and customer billing data to calculate payments owed to content providers, tariff associations and key partners for the TV portfolio then preparing those payments for processing.
• Investigating Payment Issues: When vendors call with questions about their payments or when internal teams notice discrepancies digging into billing systems and contracts to identify issues and implement fixes.
• Creating Reports and Dashboards: Pulling data from various systems using SQL queries building Excel models to track payment trends and updating dashboards that leadership uses to monitor costs and payments.
• Working on Process Improvements: Identify and implement automation opportunities using SQL, Excel macros, RPA, AI tools for manual tasks that could be automated, collaborating with IT teams to streamline payment workflows, reduce repetitive tasks and helping onboard new content vendors by setting up their payment processes.
• Enhance preventive and detective controls in TV vendor settlements.
• Design and monitor controls to minimize revenue leakage over-billing and discrepancies.
• Collaborating Across Teams: Regular meetings with Product Marketing, Finance and regulatory (legal) teams to discuss and implement new TV packages into settlement process, resolve billing questions and provide insights on how content costs are impacting profitability.
• Lead the documentation of existing RA and settlement processes (Process Documentation & Standardization). Map current vs. ideal state workflows to identify inefficiencies and control gaps.

Qualifications

What you bring

• Bachelor's degree in Finance, Accounting, Business, Engineering or Computer Science.
• 10+ years of experience in revenue assurance process improvement, financial systems or business analysis in telecom or a similar industry.
• CPA or process improvement certifications are strong assets.
• Advanced Excel (Power Query, VBA), SQL (Oracle / GCP), Tableau / Power BI.
• Strong understanding of telecom revenue streams, billing systems and settlement logic.
• Familiarity with Excel macros, RPA, AI tools automation.
• Strong knowledge of RA best practices and telecom business operations.
• Excellent written and verbal communication skills for cross-functional collaboration.
• Self-driven with strong problem-solving facilitation and stakeholder management capabilities.
• Ability to manage ambiguity and drive clarity in complex high-risk initiatives.

Required Experience

Senior IC

Key Skills

SQL, Agile, Business Analysis, Visio, Waterfall, Business Process Modeling, Requirements Gathering, Business requirements, JD Edwards, SDLC, Systems Analysis, Data Analysis Skills

Employment Type: Full-Time

Experience: years

Vacancy: 1