Role Overview
Aecon is seeking a Data Analyst to join the Urban Transportations Solutions group to support dynamic, transit projects in Canada. The Data Analyst will establish and maintain KPIs and supporting metrics to track performance, develop reporting requirements, and communicate with internal stakeholders to gather performance reporting data.
What You Will Do
The Data Analyst will support operational reporting systems, develop Power BI dashboards and data models, and analyze data from sources such as SAP, Primavera P6, and InEight (Hard Dollar) Estimating. The Data Analyst will also develop and maintain a comprehensive Performance Management Framework and drive an inclusive culture to promote equity and welcome different perspectives.
Why It Might Be a Fit
Aecon is looking for a Data Analyst with relevant experience in data analysis or business intelligence, strong interpersonal and communication skills, and hands-on Power BI experience. The ideal candidate will be able to work effectively with all levels of management and employees, be a champion of inclusion and diversity, and be willing to continuously learn and advance technical knowledge.
Requirements
- Relevant experience in data analysis or business intelligence
- Completion of a degree in Business Administration, Engineering, Science, Computer Science, Statistics, Economics, or Information Systems, or a related discipline
- Organizational skills to handle multiple tasks within a high-pressure work site environment
- Excellent interpersonal and communication skills (written and oral)
- Hands-on Power BI experience, including Power Query, DAX, and data modeling
- Practical knowledge of Microsoft Fabric and its lifecycle management across development, test, and production environments
- Strong SQL and Excel skills, with practical scripting ability in Python or PowerShell
- Working knowledge of Microsoft Azure, including data services, authentication, permissions, and cloud security fundamentals
- Familiarity with versioning, source control, testing, code review, and controlled releases
- Ability to work effectively with all levels of management and employees
- Willingness for continuous learning and advancement of technical knowledge
- Detail oriented
- Must be able to travel to projects
- Be a champion of inclusion and diversity
To apply for this job please visit jobs.aecon.com.
Follow us on social media