Data Analyst
About the role
Title: Data Analyst
Department: Customer Operations
Location: 6300 Steeles Ave West, Woodbridge
Total Potential Compensation: $65,000 - $90,000
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
- 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:
- Bachelor's Degree and/or Finance/Accounting Designation (or equivalent work experience) preferred (minimum 2 years of experience)
- Relevant experience in a BI & reporting role
- Additional courses in basic programming, SQL is considered an asset
- An understanding of Accounting and Billing Systems and their related database structure
- Proficiency in quantitative analysis
- Work with different areas of the business analyzing drivers and identifying upcoming financial issues or opportunities
- Commitment to personal growth and development
- Good organization and leadership skills
- In depth understanding of database analytics and related software and applications including BI Tools, MS Access, SQL Programming, and SAS data mining. Other Applications People Soft, MS Excel, PowerPoint, Word, Report Writing Software
We are actively seeking to fill this role as it is a current vacancy.
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., a subsidiary of Ferrovial S.A. (48.29%)
- Canada Pension Plan Investment Board (CPP Investments) and other institutional investors with non-controlling interests (44.20%)
- Public Sector Pension Investment Board (PSP Investments) (7.51%)
Learn more at
407etr.com
Note: At 407 ETR, we are committed to fostering a diverse, equitable, and inclusive work environment. We value the unique perspectives and backgrounds of all individuals, and we firmly believe that our individual differences make us stronger as a whole.
Our commitment to inclusion extends beyond recruitment and encompasses an inclusive workplace culture through raising awareness, ongoing training, and encouraging feedback. We aim to create a safe and supportive environment where all employees can thrive.
Accommodation for disabilities or other grounds protected by human rights legislation are available upon request for candidates taking part in all aspects of the employment selection process.
About 407 ETR Concession Company
407 ETR is the world’s first all-electronic, barrier-free toll highway, stretching 108 km from Burlington (in the west) to Pickering (in the east).
Save Time: Taking 407 ETR across the GTA means avoiding congestion. Transit providers and businesses rely on 407 ETR to move people and good quickly across the region.
Safety is our priority: With 24/7 Highway Safety Patrols and Highway Monitoring, we do our best to ensure that help is never far away if you need it. Our partnership with the Ontario Provincial Police helps keep traffic moving safely.
Customer Experience: We're focused on serving you well, both on and off the road. Discovering the latest promotions/offers or planning the cost of an upcoming trip using the toll calculator are just a few reasons to add www.407etr.com as one of your favourites…and you can visit on any device! Log into your web account (or sign up in minutes) to leverage your one-stop shop for many helpful account options like switching to paperless billing or pre-authorized billing, viewing past bills or to pay your current bill.
Caring for your car: Driving at a safe and consistent speed on an excellent and well-maintained highway helps to keep your car efficient and gives you better fuel economy, saving you money on gas and maintenance.
Drive More Save More: Customers are automatically enrolled in ETR Rewards when they drive a certain number of transponder kilometres. The more you drive, the greater your savings. Check out the ETR Rewards page to see how you can get in and what benefits you can receive!
We invite you to explore our website to learn more about our online services, investments to improve traffic flow, interesting facts about the highway, real-life stories from the road and more. Thank you for taking the time to learn about 407 ETR!
Data Analyst
About the role
Title: Data Analyst
Department: Customer Operations
Location: 6300 Steeles Ave West, Woodbridge
Total Potential Compensation: $65,000 - $90,000
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
- 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:
- Bachelor's Degree and/or Finance/Accounting Designation (or equivalent work experience) preferred (minimum 2 years of experience)
- Relevant experience in a BI & reporting role
- Additional courses in basic programming, SQL is considered an asset
- An understanding of Accounting and Billing Systems and their related database structure
- Proficiency in quantitative analysis
- Work with different areas of the business analyzing drivers and identifying upcoming financial issues or opportunities
- Commitment to personal growth and development
- Good organization and leadership skills
- In depth understanding of database analytics and related software and applications including BI Tools, MS Access, SQL Programming, and SAS data mining. Other Applications People Soft, MS Excel, PowerPoint, Word, Report Writing Software
We are actively seeking to fill this role as it is a current vacancy.
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., a subsidiary of Ferrovial S.A. (48.29%)
- Canada Pension Plan Investment Board (CPP Investments) and other institutional investors with non-controlling interests (44.20%)
- Public Sector Pension Investment Board (PSP Investments) (7.51%)
Learn more at
407etr.com
Note: At 407 ETR, we are committed to fostering a diverse, equitable, and inclusive work environment. We value the unique perspectives and backgrounds of all individuals, and we firmly believe that our individual differences make us stronger as a whole.
Our commitment to inclusion extends beyond recruitment and encompasses an inclusive workplace culture through raising awareness, ongoing training, and encouraging feedback. We aim to create a safe and supportive environment where all employees can thrive.
Accommodation for disabilities or other grounds protected by human rights legislation are available upon request for candidates taking part in all aspects of the employment selection process.
About 407 ETR Concession Company
407 ETR is the world’s first all-electronic, barrier-free toll highway, stretching 108 km from Burlington (in the west) to Pickering (in the east).
Save Time: Taking 407 ETR across the GTA means avoiding congestion. Transit providers and businesses rely on 407 ETR to move people and good quickly across the region.
Safety is our priority: With 24/7 Highway Safety Patrols and Highway Monitoring, we do our best to ensure that help is never far away if you need it. Our partnership with the Ontario Provincial Police helps keep traffic moving safely.
Customer Experience: We're focused on serving you well, both on and off the road. Discovering the latest promotions/offers or planning the cost of an upcoming trip using the toll calculator are just a few reasons to add www.407etr.com as one of your favourites…and you can visit on any device! Log into your web account (or sign up in minutes) to leverage your one-stop shop for many helpful account options like switching to paperless billing or pre-authorized billing, viewing past bills or to pay your current bill.
Caring for your car: Driving at a safe and consistent speed on an excellent and well-maintained highway helps to keep your car efficient and gives you better fuel economy, saving you money on gas and maintenance.
Drive More Save More: Customers are automatically enrolled in ETR Rewards when they drive a certain number of transponder kilometres. The more you drive, the greater your savings. Check out the ETR Rewards page to see how you can get in and what benefits you can receive!
We invite you to explore our website to learn more about our online services, investments to improve traffic flow, interesting facts about the highway, real-life stories from the road and more. Thank you for taking the time to learn about 407 ETR!