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.
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 Power Point
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
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:
- Cintr…
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).