Power BI and data analytics shape this Business Analyst role in Hamilton, Ontario, supporting project reporting and infrastructure performance insights.Aecon seeks a Business Analyst for its Finance sector and Hamilton LRT Civil & Utilities Works project. The role translates stakeholder needs into reporting solutions using Power BI, Excel, SQL, Power Query, and DAX. It supports project teams with accurate information for cost, schedule, resource, and operational metrics.Key Responsibilities:Gather reporting requirements from project teams and stakeholdersDevelop dashboards, reports, and visualizations for project performanceAnalyze trends, risks, variances, opportunities,



and key indicatorsValidate data across project systems and business applicationsImprove reporting processes and automate manual activitiesRequirements:One to three years in reporting, analytics, or project controlsPost-secondary education in analytics, business, engineering, or related disciplinesPower BI, Excel, data modeling, Power Query, DAX, and SQL knowledgeExperience translating stakeholder needs into reporting solutionsStrong analytical, communication, organizational, and data-quality skillsApply business analysis, Power BI, and data modeling skills to support Aecon's Hamilton LRT infrastructure reporting.

📌 Business Intelligence Analyst Power Bi (Hamilton)
🏢 Aecon
📍 Hamilton