Sr. Data Analyst

407 ETR Concession Company Limited

Vaughan

On-site

CAD 80,000 - 120,000

Full time

14 days+

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

407 ETR Concession Company Limited is seeking a Senior Data Analyst in Woodbridge. You will analyze financial and operational data to deliver insights and reporting that drive data-driven decisions across Customer Operations and Finance.

Responsibilities include SQL query development, financial modeling, dashboarding with Power BI, and data warehouse maintenance. Strong SQL and MS Office skills are required, with experience in SAP/PeopleSoft for large datasets.

Qualifications

  • Bachelor's degree in Accounting, Finance or Computer Engineering.
  • Finance/Accounting designation (CPA/CFA) is an asset.
  • Minimum 5 years in financial reporting or analytics.
  • Advanced proficiency in SQL and database/cloud platforms.
  • Experience with large data sets, Peoplesoft, SAP, Salesforce and SAS.
  • Strong MS Office skills: Access, Excel, Outlook, Word, PowerPoint.
  • Experience with Python, DBeaver, Tableau and Power BI is an asset.
  • Ability to work independently with strong organization and deadlines.
  • Strong interpersonal and communication skills.

Responsibilities

  • Enhance and maintain the IFRS 9 ECL financial model and analyze results.
  • Develop SQL queries to extract data for financial models and reporting.
  • Prepare trend analyses and link accounts receivable, revenue, cash receipts, and collections.
  • Develop and maintain data warehouses with data integrity.
  • Support finance leadership with ad-hoc analyses and audits.
  • Create and update finance dashboards using Power BI.
  • Improve monthly/quarterly reporting for management and board.
  • Automate manual processes using scripting or programming.
  • Perform other duties as assigned.

Skills

SQL
Python
Excel
Power BI
Tableau
Communication skills

Education

Bachelor's Degree – Accounting, Finance or Computer Engineering
Finance/Accounting Designation (CPA or CFA) asset

Tools

Peoplesoft
SAP
Salesforce
SAS
DBeaver
Power BI
Tableau

Job description

Title: Sr. Data Analyst Department: Customer Operations Location: 6300 Steeles Ave West, Woodbridge Total Potential Compensation: $80,000 - $120,000

Position Summary: The Senior Data Analyst is responsible for leveraging data from multiple sources to deliver actionable insights, analysis, and reporting that support data-driven decision-making across the Customer Operations & Finance department and the broader organization. This role focuses on analyzing financial and operational data, developing and maintaining models, and providing business intelligence to drive operational improvements and strategic initiatives.

Responsibilities include developing SQL queries to extract and analyze large datasets, building complex financial models, automating reports and business processes, and translating data into meaningful recommendations for stakeholders. The position requires close collaboration with cross-functional teams and business units to deliver analytical solutions, improve reporting capabilities, and support informed business decisions.

Duties and Responsibilities:

  • Enhance and maintain the current financial model for the determination of the Expected Credit Losses (ECL) for Financial Reporting under IFRS 9, analyzing periodic results.
  • Develop queries in SQL to extract data from various data warehouses to be used as inputs for financial models as well as for ad-hoc reporting.
  • Prepare detailed trend analysis, business models, and develop links that are critical in understanding accounts receivable, revenue, cash receipts and collections; report findings to management to support the decision-making process.
  • Develop, monitor and maintain data warehouses including updating, adding new data requirements and ensuring data integrity.
  • Support the Senior Manager of Finance in providing ad-hoc as well as audit requirements within tight timeline.
  • Create and update finance dashboards using visualization tools like Power BI.
  • Collaborate and assist the Senior Manager of Analytics & Reporting in enhancing monthly and quarterly reporting for management, audit committee, and board of directors for better efficiencies, explanations, and presentation of information.
  • Automate manual processes by leveraging scripting or programming languages to improve efficiency and accuracy.
  • Perform other duties as assigned.
Qualifications:
  • Bachelor's Degree – Accounting , Finance or Computer Engineering
  • Finance/Accounting Designation (e.g. CPA or CFA) is an asset
  • Minimum 5 years of experience in financial reporting or analytics role
  • Advanced proficiency in SQL, database systems and cloud platform is required, preferably on financial and customer data.
  • Experience with large data sets, Peoplesoft, SAP, Salesforce, and SAS is considered an asset.
  • Sound Experience in financial analysis, accounting,, and understanding business operations, analyzing both qualitative, and quantitative results
  • Exceptional working knowledge of MS applications including Access, Excel, Outlook, Word, and PowerPoint
  • Experience with various software including , Python, Dbeaver, Tableau, Power BI, is considered an asset
  • Ability to work independently, great organizational and time management skills; planning and project management, and ability to meet multiple deadlines
  • Strong interpersonal, collaborative and communication skills. Ability to create presentations and present information and data in a group setting.

We are actively seeking to fill this role as it is a current vacancy.

About 407 ETR

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.

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%)

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Analyst
Data Analyst

407 ETR Concession Company Limited • Vaughan

On-site
CAD 65,000 - 90,000
Senior Director, Customer Operations Delivery
Senior Director, Customer Operations Delivery

407 Etr • Canada

On-site
CAD 180,000 - 240,000
IT Audit Manager
IT Audit Manager

407 Etr • Canada

Hybrid
CAD 110,000 - 145,000
Senior Salesforce Marketing Cloud Engineer
Senior Salesforce Marketing Cloud Engineer

407 ETR Concession Company Limited • Vaughan

On-site
CAD 130,000 - 170,000
Sr. Advisor, Health, Safety & Environment
Sr. Advisor, Health, Safety & Environment

407 ETR Concession Company Limited • Vaughan

On-site
CAD 95,000 - 120,000
Director, Highway Operations
Director, Highway Operations

407 ETR Concession Company Limited • Vaughan

On-site
CAD 180,000 - 230,000
Data Analyst
Data Analyst

407 Etr • Vaughan

On-site
CAD 65,000 - 90,000
HCM Specialist (Workday)
HCM Specialist (Workday)

407 ETR Concession Company Limited • Vaughan

On-site
CAD 95,000 - 115,000
Field Operations Patroller
Field Operations Patroller

407 Etr • Canada

Hybrid
CAD 63,000 - 85,000
Manager, Structures
Manager, Structures

407 Etr • Canada

On-site
CAD 125,000 - 155,000