Data Analyst Job Details | Aecon

Who We Are?

ONxpress Transportation Partners (ONxpress) were chosen by Metrolinx and Infrastructure

Ontario (IO) to enter the Development Phase of the On-Corridor Works project the largest

project in Metrolinxs GO Expansion.

Unprecedented in its scale and complexity, this multi-billion-dollar capital program will transform the GO regional rail network with electrification, more frequent service, shorter journey times and a more modernized system for the Greater Toronto and Hamilton Area.

Who We Are?

ONxpress Transportation Partners (ONxpress) were chosen by Metrolinx and Infrastructure

Ontario (IO) to enter the Development Phase of the On-Corridor Works project the largest

project in Metrolinxs GO Expansion.

Unprecedented in its scale and complexity, this multi-billion-dollar capital program will transform the GO regional rail network with electrification, more frequent service, shorter journey times and a more modernized system for the Greater Toronto and Hamilton Area.

What is the Opportunity?

ONxpress Civil Contractors Joint Venture (CJV) is looking for a Data Analyst. This position is based out of our downtown Toronto office.

What youll do:

Create data models to transform raw data into relevant insights via Power BI dashboards and automated reporting

Gather data from various sources (Excel, API, database, etc..) to store in a central database or to push to other sources

Identify pathways for automation and data efficiency

Use Power BI to run DAX queries and functions

Improve and maintain existing analytics applications and Power BI dashboards

Create, test, and deploy scripts, as well as execute efficient deep analysis

Test/QA applications and Power BI reports

Gather requirements from stakeholders/teams and help them implement best practice in data management

What You Bring:

At least 2 years of Data Analytics/Business Intelligence experience

College or University Degree

Experience with data visualization, automation, databases, ETL, data modeling, user acceptance testing (UAT), app development

Experience with Power BI (DAX), Power Automate, Power Query, APIs, and Power Apps

Familiar with Python and Databricks

Analytical thinking for converting data into insights

Expected compensation for this role is between $70,000-$85,000 annually. Base salaries are determined according to multiple factors including skills, experience and potential impact on the role. Internal and external competitiveness are also taken into consideration. In addition to base salary ONxpress also offers a comprehensive medical and dental program, RRSP with company matching and the potential to participatein our discretionary, performance based bonus program.

This role is a backfill position.

As part of our commitment to fair and transparent hiring practices, ONxpress may use artificial intelligence (AI) tools to assist in screening and reviewing candidates. These tools are applied responsibly and in accordance with applicable privacy laws and ONxpress AI Usage Policy. All final decisions are made by qualified ONxpress team members.

Connect with us! Learn more about our project here and follow us on LinkedIn for frequent updates.

This position is with ONxpress Civils (CJV aka the Design & Construction team); the project segment responsible for the modernization and modification of the key area network, including countless innovations in the way the regional rail infrastructure is built.

We value diversity and encourage all qualified individuals to apply, regardless of whether they meet 100% of the qualifications listed. If you believe you have the skills and passion to excel in this role, we welcome your application and the opportunity to consider you for the position.

We are an Equal Employer. Should you need any accommodation through the recruitment process, please contact cjv-talentacquisition@onxpress.com.