407 etr concession company

Sr. Data Analyst

20/01/2025
full-time
Apply Now
Deadline date:

Job Description

Position Summary:
This role centers on analyzing financial data, developing and maintaining ECL models, and providing
valuable insights to drive informed business decisions. This position requires the development of SQL queries to extract large data, preparation of complex financial models and automation of operational reports and processes. This position will be collaborating with other staff members and business units to complete the required duties.
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 Tableau.
  • Assist the Senior Manager of Finance 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.
Requirements:
  • 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.
  • Outstanding interpersonal, collaboration, and written and verbal communication skills in a team setting to present results.
Our Offer
  • 407 ETR usage (taxable benefit)
  • Competitive salary, bonus structure
  • Competitive vacation package
  • Community culture
  • Continued education budget
  • Expect excellence: Collaborative team, learn, and grow with a high-performance team
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:
  • Canada Pension Plan Investment Board (CPP Investments) through indirectly-owned subsidiaries (50.01%);
  • Cintra Global S.E. which is a wholly-owned subsidiary of Ferrovial S.A. (43.23%); and
  • AtkinsRéalis, formerly known as SNC-Lavalin (6.76%).
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.

Related Jobs