Data Analyst

407 ETR Concession Company Limited

Vaughan

On-site

CAD 65,000 - 90,000

Full time

2 days ago
Be an early applicant

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 in Woodbridge is seeking a Data Analyst to create dashboards and processes that present financial and customer data insights for decision-making and operational reporting. You will develop SQL queries, automate reports, and support monthly, quarterly, and board reporting on-site.

The role requires 2+ years in data analytics with Python and BI experience, strong Power BI skills, and familiarity with AWS data environments, including Data Lake or Redshift.

Qualifications

  • Bachelor's degree in data analytics, computer science, IT, business, or finance.
  • 2+ years in data analytics, Python, BI & reporting.
  • Strong experience building Power BI dashboards and reports.
  • Experience with AWS data environments (Data Lake / Redshift).

Responsibilities

  • Create and maintain Power BI dashboards to report KPIs and trends.
  • Consolidate data from multiple systems for reporting and analytics.
  • Prepare detailed analyses to support customer operations insights.
  • Automate reporting and reduce manual processes using SQL and Python.
  • Support monthly, quarterly, and board reporting.
  • Collaborate with IT and business partners to translate needs into datasets.

Skills

Data analytics
Python
SQL
BI & reporting

Education

Bachelor's degree in data analytics

Tools

Power BI
AWS
Amazon Redshift
MS Excel
MS Access
SAS

Job description

Title: Data Analyst Department: Customer Operations Location: 6300 Steeles Ave West, Woodbridge Work Arrangement: On-site Total Potential Compensation: $65,000 - $90,000

Position Summary

Provide support to Customer operations by creating dashboard and processes that present financial and customer data insights 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.
  • Integrate information from multiple operational systems to create consolidated datasets for reporting and analytics.
  • Prepare detailed analysis and develop links that are critical in understanding insights related to customer operations management.
  • Assess and make recommendations for Customer Operations to improve profitability, cash receipts and customer service.
  • Create and update dashboards using Power BI that enable users to analyze trends, KPIs and operational performance with minimal manual intervention.
  • Identify opportunities to replace manual Excel, file‑based and repetitive reporting processes with automated solutions.
  • Develop automated reporting and refresh processes using appropriate AWS, SQL, Python, Power BI and Microsoft automation capabilities.
  • Support monthly, quarterly and Board/management reporting requirements.
  • Work with different areas of the business analyzing drivers to reduce costs and optimize cash recoveries.
  • Work with IT, Data and business partners to understand source‑system structures and translate business requirements into reporting datasets.
  • Partner with operational stakeholders to define KPIs and reporting requirement.
  • Improve business processes by providing new or enhanced financial reporting.
  • Perform other duties as assigned.
Qualifications
  • Bachelor's degree in data Analytics, Computer Science, Information Technology, Business, Finance.
  • 2+ years of experience in data analytics, Python, BI & reporting role.
  • Strong hands‑on experience developing Power BI dashboards and reports.
  • Practical experience working with AWS data environments, particularly Data Lake and/or Amazon Redshift.
  • 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.
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.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Sr. Data Analyst
Sr. Data Analyst

407 ETR Concession Company Limited • Vaughan

On-site
CAD 80,000 - 120,000
Data Analyst
Data Analyst

407 Etr • 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
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
HCM Specialist (Workday)
HCM Specialist (Workday)

407 ETR Concession Company • Vaughan

On-site
CAD 95,000 - 115,000