JobsData AnalystCanadaData Analyst
407 ETR
Posted 2 days ago
Data Analyst
407 ETR · Vaughan, Ontario, Canada
SAVE THIS JOB
In short
The Data Analyst will create dashboards and automated processes to provide financial and customer data insights for operational decision-making. They will integrate data from multiple systems and collaborate with stakeholders to improve profitability and reporting efficiency.
What they're looking for
MUST-HAVE SKILLS
ALSO MENTIONED
Candidates must hold a bachelor's degree in a relevant field and possess at least two years of experience in data analytics, Python, and BI reporting. Strong hands-on proficiency with Power BI and AWS data environments is required.
About the employer
407 ETR
First all-electronic open access toll highway | 108 km in the GTA | Less Traffic, More Living.
Highway 407 ETR is the world’s first all electronic toll highway spanning 108 kilometres in the Greater Toronto Area. We provide fast, safe and reliable travel for commuters, businesses and communities.
Read moreShow less
Our commitment goes beyond the road—we invest in Ontario’s economy, support local communities, and protect the environment. From traffic alerts and customer service to infrastructure innovation and social impact, we’re proud to serve the region we call home.
- INDUSTRY
- Ground Passenger Transportation
- COMPANY
- Privately Held
- FOUNDED
- 1999
- HEADQUARTERS
- Woodbridge, Ontario
- SIZE
- 201-500
- OFFICES
- 1 on LinkedIn
Is your LinkedIn profile ready for roles like this?
A free review of your profile, scored against what Data roles ask for, and what to fix first.
Questions about this role
- Is this 407 ETR role remote?
- Tagged on site.
- What does it pay?
- The posting lists CA$65,000–CA$90,000 a year.
- Does it sponsor visas?
- Listed as no visa sponsorship.
- What experience does it ask for?
- Listed as 2-5 years.
The posting, in full
Title: Data Analyst Department: Customer Operations Location: 6300 Steeles Ave West, Woodbridge Work Arrangement: On-site Total Potential Compensation: $65,000 - $90,000 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.
▶ READ THE FULL POSTING▼ CLOSE THE FULL POSTING
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.
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.
SAVE THIS JOB
Similar roles open now
Senior Game Data Analyst | Analyst.e des données de jeu sénior.e
Ludia
Montreal, QuebecHybrid
EMPLOYER'S OWN SITE
POSTED YESTERDAY
BI Developer & Data Analyst
Grizzlytrek Group
Montreal, QuebecHybrid · 3 days in office
EMPLOYER'S OWN SITE
POSTED YESTERDAY
Data Analyst, Reinsurance Operations - Reporting (4 months contract)
Munich Re
Toronto, OntarioCA$60k–CA$70kHybrid
EMPLOYER'S OWN SITE
POSTED YESTERDAY
Marketing Data Analyst, Performance & Insights
Lenovo
Markham, OntarioCA$92k–CA$141kOn site
EMPLOYER'S OWN SITE
POSTED YESTERDAY
Financial Data Analyst
Chandos
Edmonton, AlbertaCA$70k–CA$90kOn site
EMPLOYER'S OWN SITE
POSTED YESTERDAY