407 ETR Logo

407 ETR

Data Analyst

Posted 2 Hours Ago
Be an Early Applicant
Remote
Hiring Remotely in Woodbridge, ON
Junior
Remote
Hiring Remotely in Woodbridge, ON
Junior
The Data Analyst supports Customer Operations by integrating financial and customer data, developing Power BI dashboards, producing management and board reports, and creating SQL- and AWS-based automated reporting processes. The role analyzes operational drivers, profitability, cash recoveries, customer service, and KPIs; consolidates data from multiple systems; translates business requirements into reporting datasets; and recommends process improvements and automation opportunities.
The summary above was generated by AI


Title:
Data Analyst

Department: Customer Operations

Location: 6300 Steeles Ave West, Woodbridge

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, 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, 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.


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
In-Office or Remote
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
14 Days Ago
Remote
United Kingdom
Entry level
Entry level
Artificial Intelligence • Healthtech • Pet • Software
Own marketing analytics, funnel reporting, dashboards, attribution, cohort analysis, and conversion rate optimization. Analyze customer journeys from acquisition through retention, identify funnel losses, and design and evaluate A/B and multivariate experiments across landing pages, signup, onboarding, and email. Partner with marketing, product, engineering, RevOps, sales, and leadership to improve measurement, define trusted metrics, and translate findings into prioritized growth recommendations.
Top Skills: BigQueryHubspotLookerLooker StudioOptimizelyPythonRSQLTableauVwo

What you need to know about the Belfast Tech Scene

If asked to name the birthplace of the RMS Titanic, you might not say Belfast. Similarly, if asked to name Europe's leading destination for foreign direct investment in new software development, Belfast might not come to mind. Yet, both are true. The city has emerged as a tech powerhouse, recently ranked among the best in the U.K. for tech careers — especially for software developers. It also leads the U.K. with the highest percentage of software development jobs advertised.

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account