407 ETR Logo

407 ETR

Sr. Data Analyst

Reposted 11 Days Ago
Remote
Hiring Remotely in Woodbridge, ON, CAN
Senior level
Remote
Hiring Remotely in Woodbridge, ON, CAN
Senior level
Analyzes financial and operational data to support decision-making across Customer Operations and Finance. Responsibilities include maintaining IFRS 9 expected credit loss models, writing SQL queries, developing financial and trend analyses, managing data warehouses, creating Power BI dashboards, improving management reporting, supporting audits, and automating processes with scripting or programming. The role collaborates with finance, analytics, and cross-functional stakeholders to deliver accurate insights and reporting.
The summary above was generated by AI

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

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.


Similar Jobs

4 Days Ago
Easy Apply
Remote or Hybrid
Easy Apply
Senior level
Senior level
Artificial Intelligence • Marketing Tech • Software
Lead measurement, monitoring, and diagnostic reporting for AI-powered personalization models. Build scalable data pipelines in GCP and BigQuery, develop automated alerts, support A/B testing, and create Tableau visualizations. Evaluate recommender systems and propensity models using statistical and predictive analytics, integrate insights into AI products, and communicate findings to technical and non-technical stakeholders while mentoring junior team members.
Top Skills: A/B TestingAWSBigQueryData PipelinesGCPMachine Learning Model MonitoringPredictive AnalyticsPythonRedshiftSQLStatistical ModelingTableau
3 Days Ago
Remote
Canada
Senior level
Senior level
Software
Own supplier data quality through profiling, sampling, source linking, issue quantification, and quality monitoring. Partner with data engineering, product, and cross-functional teams to translate findings into technical improvements and prioritize opportunities. Build dashboards and reports to communicate data health, support automated quality gates, and apply customer insights to data and product improvements.
Top Skills: BigQueryDbtGleifLookerModeOpencorporatesS&P Capital IqSamSnowflakeSQLTableau
3 Days Ago
In-Office or Remote
ON, CAN
Senior level
Senior level
Artificial Intelligence • Analytics
Leads business intelligence and data analysis initiatives by examining scientific and operational datasets, developing KPI insights, mapping business and data processes, and conducting deep-dive analyses. Engages stakeholders, translates requirements into user stories, leads requirements workshops and UAT, validates data, creates process and data-flow diagrams, and collaborates with engineering, product, and business teams to deliver analytics solutions.
Top Skills: AgileLookerMicrostrategyPower BISQLTableau

What you need to know about the Ottawa Tech Scene

The capital city of Canada and the nation's fourth-largest urban area, Ottawa has proven a rapidly growing global tech hub. With over 1,800 tech companies, many of which are leaders in their sectors, the city's tech talent now makes up more than 13 percent of its total workforce. This growth is driven not only by the big players like UL Solutions and Dropbox, but also by a thriving startup ecosystem, as new businesses emerge to follow in the footsteps of those that came before them.

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account