IDD Data & Analytics Specialist
Job Summary
Come Build Your Career at Aecon!
Aecon delivers some of the most complex and impactful infrastructure projects from transformative transportation networks to critical energy industrial and nuclear programs. The projects we build connect communities and power future generations. With deep roots in North America and a strong footprint internationally Aecon brings global expertise and proudly serves public and private sector clients through its Construction and Concessions segment.
At Aecon you can count on:
- Safety Always. Our number one core value. The safety of our people projects partners and stakeholders is our priority focus today and always.
- Integrity. We lead by example with humility and courage.
- Accountability. Were passionate about delivering on our commitments.
- Inclusion. We provide opportunities where people feel valued supported and empowered to contribute fully.
We deliver infrastructure with purpose and our people are at the heart of everything we do. Aecon employees are incredibly proud to build some of the most impactful infrastructure of this generation we call it Aecon Proud.
At Aecon we:
- Ensure you and your family receive the services and benefits needed to support your mental emotional and physical well-being.
- Are intentional when it comes to investing in your development. We help you build your career and advance your skills through our Aecon University tuition reimbursement and Leadership Programs.
- Are committed to creating work environments focused on mutual respect teamwork collaboration and new ideas through meaningful initiatives training partnerships with Veteran groups our Aecon Women in Trades and diversity programs as well as our Employee Resource Groups (ERGs) to ensure we are building with top talent and harnessing our collective strengths within every aspect of our culture.
- Operate responsibly by managing risk safety and environmental considerations across all our projects and surrounding communities.
Our success is built on the passion expertise and dedication of our people. Together we embrace strong execution innovation and continuous improvement values that come to life through the unique talents and collaborative spirit of every team member. If youre inspired to make a difference through future-building projects join our best-in-class team.
- Design develop and maintain reports scorecards dashboards and KPI tracking tools.
- Create executive-level reporting packages and management dashboards.
- Develop recurring operational project and corporate performance reports.
- Automate reporting processes to improve efficiency and data accuracy.
- Analyze large datasets to identify trends risks opportunities and performance gaps.
- Perform ad hoc analysis to support business and project initiatives.
- Interpret complex data and provide meaningful recommendations to stakeholders.
- Monitor key business metrics and produce variance analyses and forecasting reports.
- Extract transform and load data from multiple platforms and systems.
- Consolidate information from sources such as SharePoint Power BI ERP systems ACC Aconex and other enterprise applications.
- Ensure data quality consistency integrity and governance standards are maintained.
- Develop and maintain data models and reporting datasets.
- Collaborate with project teams and business leaders to gather reporting requirements.
- Translate business needs into reporting and analytical solutions.
- Present findings and recommendations to management and executive leadership.
- Provide training and support to report users and stakeholders.
- Identify opportunities to enhance reporting processes and business intelligence capabilities.
- Implement automation and analytics solutions to improve efficiency.
- Support the adoption of digital reporting and data visualization tools.
- Maintain documentation for reporting methodologies processes and data sources.
- Bachelors degree in Business Analytics Information Management Computer Science Statistics Engineering Finance or a related field.
- Experience with Power Automate Python DAX Power BI datasets and data extraction from platforms such as ACC Aconex ESRI and SharePoint is considered an asset.
- 3 years of experience in reporting analytics business intelligence project controls or data analysis.
- Experience working with large datasets and enterprise systems.
- Experience developing executive dashboards and performance reports.
- Advanced proficiency in Microsoft Excel Power BI SQL Power Query and data visualization tools to develop dashboards reports and data-driven insights.
- Experience with data modeling ETL processes database querying and enterprise information systems including SharePoint and similar platforms.
- Ability to analyze extract and transform data from multiple sources to support business reporting decision-making and process improvement initiatives.
- Strong analytical problem-solving and data storytelling skills with the ability to present complex information clearly to stakeholders.
- Excellent communication stakeholder management collaboration and time management skills with a focus on continuous improvement and business outcomes.
Aecon fosters diversity inclusion and belonging within and across our organization. We welcome all to apply including women visible minorities Indigenous peoples persons with disabilities and persons of any sexual orientation or gender identity.
We are committed to adhering to the objectives and requirements outlined in the Accessible Canada Act (ACA) and to meeting the accessibility needs of persons with disabilities in a timely manner. Through the implementation of the requirements of the ACA and its applicable regulations appropriate accommodations will be provided upon request throughout the interview and hiring process.
As part of our commitment to fair and transparent hiring practices Aecon 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 Aecons AI Usage Policy. All final decisions are made by qualified Aecon team members.
Required Experience:
IC