Data Analyst

Position Summary :

Provide support to Customer Operations by creating dashboard and business models that present financial and customer data in order to facilitate effective decision-making and operational reporting. This position requires the preparation of dashboard, reports and analysis, development of SQL queries and automation of operational reports and processes.

Duties and Responsibilities :

• Assisting the Team Manager of Analytics in updating and enhancing monthly and quarterly management reports and board slides
• Develop new and refactor existing queries to extract information needed to support departmental and adhoc reports
• Prepare detailed trend analysis, business models, and develop links that are critical in understanding accounts receivable, revenue, operating expenses, cash receipts and collections
• Assess and make recommendations for Customer Operations to improve profitability, cash receipts and customer service
• Develop and deliver automated operations reports and maintain or update as required
• Perform and report on sensitivity and financial analysis to monitor and evaluate the financial performance of proposed cash receipt improvement and commercial account management strategies
• Assist with the preparation of future oriented financial information (i.e. annual budget / forecasts) including Financial Operations costs, Revenue Reserves and Cash Receipts
• Understand and analyze potential opportunities and risks and provide recommendations to management
• Work with different areas of the business analyzing drivers and identifying upcoming financial issues or opportunities
• Create and update dashboards using Tableau or Power BI
• Identify areas of opportunity to make operations efficient through automation where possible
• Improve business processes by providing new or enhanced financial reporting
• Perform other duties as assigned

Qualifications :

About 407 ETR

Highway 407 ETR is an all-electronic open-access toll highway located in the Greater Toronto Area in Ontario, Canada. The highway spans 108 kilometres from Burlington in the west to Pickering in the east.

407 International Inc. is the sole shareholder of 407 ETR and is owned by :

Cintra Global S.E. which is a wholly owned subsidiary of Ferrovial S.A. (48.29%);

Canada Pension Plan Investment Board (CPP Investments) and other institutional investors (44.20%); and

Public Sector Pension Investment Board (PSP Investments) (7.51%)

Learn more at

Note :