Analyst, Data

What is the Opportunity? Aecon Civil is a market leader with a self-perform competitive advantage and core local strength in key markets. We’re proud of our work helping to expand and improve Canada’s infrastructure and transportation networks, and we’re ready to build the future of our country. We are currently seeking a Data Analyst to join our head office. What You'll Do Here: Establish and maintain KPIs and supporting metrics to be used across the project to track performance Develop reporting requirements with functional leads and utilize a standardized approach to performance reporting Communicate with internal stakeholders to gather performance reporting data and share updates relevant to performance reporting and its processes Support the use of reporting, cost, scheduling, and financial and other operational systems; develop reporting dashboards to inform performance of the project; and enable fast, easy, meaningful operational and business insights Support the implementation and continuous improvement Develop and maintain a comprehensive Performance Management Framework, including development of dashboards to monitor and analyze performance trends Analyze, measure, and report on project goals and objectives, engineering and design performance, construction progress, schedule, financial performance, and other essential KPIs and metrics Develop periodic and ad hoc performance reporting packages Contribute to evidence-based decision-making to maximize the performance of the project Analyze data from different sources (including SAP, Primavera P6, InEight (Hard Dollar) Estimating, Designers, Subcontractors, Aconex, etc.) to identify our challenges and opportunities Experience with various data platforms such as Microsoft Power BI, Databricks, Apache Spark, Snowflake Familiarity with data integration, ETL, visualization tools and technologies Strong understanding of data governance, data quality and security best practices Strong analytical and problem-solving skills, with the ability to troubleshoot complex issues Ability to work in a fast-paced environment and managed multiple tasks simultaneously What You Bring to the Team: Minimum of six (6) years’ related experience; or equivalent combination of education and experience in construction projects, including performance monitoring; information systems, financial systems, other construction performance management systems Completion of a degree in Business Administration, Engineering, Science, Computer Science, Statistics, Economics, or Information Systems, or a related discipline, or a combination of education, training and experience deemed equivalent Organizational skills to handle multiple tasks within a high-pressure work site environment Excellent interpersonal and communication skills (written and oral) Minimum 4 years experience with Power BI, Tableau, Qlik Sense Experience with SQL, DAX, Python, R, SAP Webi, or other reporting and data analytics tools, an asset Knowledge of Earned Value Management (EVM) Industry best practices: PMI, AACEI, etc. Effective inter-personal communication and presentation skills to communicate effectively with stakeholders across different business units 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 Must possess valid G driver's license and have access to a vehicle What Makes us Aecon Proud: Engaging and agile workplace culture, collaborative and inclusive teams Commitment to and to becoming a net-zero company by 2050 Investing in our people through a variety of programs such as Aecon University, BluePrint leadership program, and Project Management Academy Variety of wellness benefits, access to virtual health care, 100% employer-paid health and dental premiums, Employee Assistance Program, Best Doctors Program, and more. Tuition reimbursement opportunities Recognition and rewards through Aecon Accolades, Aecon Achievement Awards and more Employee Stock Options, Short Term Incentive Program, Retirement Savings and Pension Plan