Data Analyst

Aecon; Vancouver; On-site; CAD 70,000 - 90,000; Full time

Job summary

A leading construction and infrastructure firm in Metro Vancouver is seeking a Data Analyst to transform data into actionable insights. The role involves collaborating with various business units, building reports and dashboards using Power BI, and ensuring adherence to data governance practices. Candidates should have a Bachelor’s in Computer Science and 3+ years of experience in data management or analysis, with strong skills in SQL and data visualization.

Qualifications

• 3+ years experience in data management or analysis.
• Ability to organize large amounts of data effectively.
• Experience training end-users in analytics tools.

Responsibilities

• Collaborate with business units to define metrics and data-driven solutions.
• Build and maintain reports and dashboards using various tools.
• Implement data governance and security protocols.
• Conduct user training and support the adoption of analytics tools.

Skills

Analytical skills

Power Query

SQL

Data visualization

Interpersonal communication

Education

Bachelor’s Degree in Computer Science or related field

Tools

Power BI

RStudio

Python

SAP Analytics Cloud

Business Objects

Job description

Overview

What is the Opportunity?

As a Data Analyst you will play a pivotal role in transforming data into actionable insights that drive strategic decisions across the organization. You will collaborate with business units to understand challenges, design metrics, and deliver high-impact visualizations and reports. This role requires strong technical expertise, a proactive mindset, and a commitment to data governance, user training, and continuous improvement.

Responsibilities

• Collaborate with business units to identify problems, define metrics, and design data-driven solutions.
• Build and maintain reports and dashboards using Power BI, SAP Analytics Cloud (SAC), Business Objects, and Power Platform.
• Translate business requirements into technical documentation for IS teams.
• Create data visualizations tailored to executive and operational audiences.
• Conduct bespoke analysis using tools like RStudio or Jupyter.
• Lead and support predictive analytics and statistical modeling initiatives.
• Implement and uphold data governance, security protocols, and sharing procedures.
• Monitor and evaluate data systems to ensure accuracy and performance.
• Conduct user training and support adoption of analytics tools.
• Perform regular audits of user permissions and drive utilization strategies.
• Assist in developing data management strategies and improving system performance.

Qualifications

• Bachelor’s Degree in Computer Science, Computer Engineering, or related field.
• A minimum of 3+ years’ experience in data management or analysis.
• An analytical mindset and ability to decipher and organize large amounts of data.
• Awareness of and commitment to driving adherence to SDLC best practices
• Understands relational and unstructured data sources and various methods of querying and extracting data from each
• Understands data modelling, physical data structures, and logical data structures
• Experience training end-users
• Strong Power Query, SQL, and passing knowledge of ETL and data-wrangling processes
• Well versed in data visualization techniques in a range of tools, including Power BI, Excel, and R or Python packages
• Strong interpersonal and communication skills to translate complex problems clearly and in nontechnical terms
• Experience in Business Objects / SAC operational processes and systems
• Strong ability to lead and drive results