Apply now »

It has come to our attention that various international organizations or individuals have been offering false employment opportunities at Aecon Group Inc. Aecon Group Inc. employment policies and processes involve interviews, and candidates who seek employment are never required to pay us any sum of money. To do so would be contrary to our business conduct guidelines and ethical practices. We also do not extend formal offers of employment or execute employment agreements through social media or social chat platforms.

We take this matter extremely seriously and are working with the appropriate authorities to shut down such fraudulent schemes. Please remain vigilant on this matter and report any suspicious outreach to your local authorities and email any concerns to

Date:  Jul 6, 2024

Toronto, ON, CA

Operating Sector:  Information Services

Position Title:  Architect, Data

Come Build Your Career at Aecon!

As a Canadian leader in infrastructure development, Aecon is safely and sustainably building what matters for future generations to thrive! We lead some of the most impactful infrastructure projects of our generation, at the forefront of transformational change in transportation and energy, and partnering every day to build, connect, power, and strengthen our communities.

At Aecon, you can count on:

  • Safety Always. Our number one core value. If we can’t do it safely, we don’t do it at all.
  • Integrity. We lead by example, with humility and courage.
  • Accountability. We’re passionate about delivering on our commitments.
  • Inclusion. We provide equitable opportunities for everyone.


We lead the infrastructure industry with purpose, and our people are at the heart of everything we do. So, we invest in our people, just like they invest in us! 


At Aecon we:

  • Ensure you and your family receive the services needed to support your mental, emotional, and physical well-being
  • Believe in helping you build your career through our Aecon University and Leadership Programs
  • Are committed to supporting and investing in inclusive work environments, through initiatives like Equity, Diversity & Inclusion training, our Aecon Women in Trades and Aecon Diversity in Trades programs, and our Employee Resource Groups (ERGs) to ensure we are building inclusion into every aspect of our culture at Aecon.
  • Are a leader in sustainable construction. With a strong commitment to operating responsibility by minimizing our impact on the environment and surrounding communities.


Our business success relies on strong execution and continuous improvement – driven by the diversity, expertise and teamwork of our people. We’re always searching the globe for innovative, collaborative minds to join our best-in-class Aecon community!


The Opportunity


The Data Architect’s role is to plan, coordinate, architect, and supervise all activities related to the integration of software programs, applications, and third-party solutions as required to meet the business requirements of Aecon. Conduct workshops with customer's business and IT teams and capture, document and summarize the business requirements, prioritize business use cases, and define implementation roadmap, Provide solutions for variety of Data and Analytics requirements from customers, such as Greenfield EDW, Data Lake Implementation, Data Estate Modernization, Tools / Technology comparison and selection, etc. Create Architecture and high-level design for data & analytics solutions, provide effort estimates for large EDW / Data Lake implementations, guide technical team of deliverables, and get the solution implemented, conduct proof of concepts and create differentiating assets, conduct trainings and workshops on new technologies and trends.


What You Will Do Here:


Strategy & Planning

  • Develop and maintain enterprise data architecture strategy for the organization.
  • Orchestrate Data and Analytics Solutions projects and corresponding strategies between business units and development teams.
  • Ensure that planning and practices are aligned with strategic business goals and the company’s overall strategic vision.
  • Develop standards and processes to support and facilitate data and analytics projects and initiatives.
  • Develop and lead innovations related to Enterprise Data Architecture and frameworks, supporting Aecon’s Enterprise Data Architecture strategy.


Acquisition & Deployment

  • Research and make recommendations on products and services in support of procurement and development efforts.
  • Collaborate with analysts, business users, and functional users in the testing of Data and Analytics solutions.
  • Lead architecture, implementation and testing phase of Enterprise Data Architecture projects in order to identify and remedy potential problem areas.
  • Build relationships with BPMO, Data Analysts, Business Analysts, end users and functional teams to gain an understanding of architectures and required functionality.
  • Build relationships with vendors of application software deployed in the organization’s IT environment to learn about and provide feedback on their technical integration capabilities.


Operational Management

  • Ensure the collection and coherent interpretation of the various business processes affected by Enterprise Solutions efforts.
  • Work diligently to enhance or improve business processes or, as necessary, minimize the impact of Enterprise Data Architecture Solutions projects on those processes.
  • Evaluate results of Enterprise Solutions projects, then report and make recommendations based on findings.
  • Where necessary, provide guidance to junior members of the team.


What you Bring to the Team

  • 10+ years of overall experience in architecting and building data and analytics solutions, including Azure Data platform implementation.
  • Proven experience in overseeing the linking of cross-functional applications between disparate business units and systems.
  • Deep understanding of ETL, reporting, data modeling concepts and data warehouse architecture
  • Experienced in analysis, design, data modelling and effort estimation.
  • Experience in working with SAP, SAP BW, SAP HANA as sources and data extraction from SAP sources to EDW/Azure.
  • Hands on experience of working with Azure cloud components like Azure Data Factory, Azure Stream Analytics, EventHub, Azure Synapse (SQL Data Warehouse), Azure Data Lake Storage (ADLS) and DataBricks
  • Experience with relational databases, such as SAP HANA, Oracle, SQL Server, or MySQL, and non-relational databases, such as MongoDB or Cassandra
  • Proficiency in SQL, python, and data analysis tools
  • Experience working with Experience with AI/ML solutions will be preferred
  • Experience with data archival and data retention across the organization
  • Experience with data governance and regulatory compliance
  • Strong leadership and communication skills, with the ability to collaborate with cross-functional teams and provide technical guidance to the data architecture team.
  • Experience with change management with respect to people, processes, and technologies
  • Excellent communication, presentation, and interpersonal skills
  • Experienced in working in a customer facing role.


Necessary Competencies

  • Decision Making:
    • Makes sound decisions involving the most complex information and dynamic situations.
    • Balances the long-term (“big picture”) and short-term implications of individual decisions and organization goals. 
  • Analytical Thinking:
    • Able to breakdown raw information and undefined problems into specific, workable components that in-turn clearly identifies the issues at hand.
    • Makes logical conclusions, anticipates obstacles and considers different approaches that are relevant to the decision-making process.
    • Estimates the financial impact of EA alternatives and applies multiple solutions to business problems. 
  • Business Requirements Analysis:
    • Ability to understand a customer's business needs and translate needs into IS specific requirements.
    • Applies knowledge of the customer's functions and processes to develop business case and business requirement documents.
    • Assesses the benefits of recommended solutions.
  • Communications for Results:
    • Expresses technical and business concepts, ideas, feelings, opinions, and conclusions orally and in writing.
    • Listens attentively and reinforces words through empathetic body language and tone.
  • Problem Solving:
    • Anticipates, identifies, and defines problems.
    • Seeks root causes.
    • Develops and implements practical and timely solutions.
    • Ready to think, behave and act in an innovative consulting manner to drive the organization’s digital business strategies. 
  • Character
    • Integrity, Humility, Transparency
    • Courage, Drive
    • Energy, Passion
    • Self-motivated
    • Collaborative
    • Innovative
    • Leadership


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. If you require accommodation under the ACA during any step of the application process please click here.

Apply now »