Jobs
>
Toronto

    Solution Architect, Data - Toronto, Canada - Air Canada

    Air Canada
    Air Canada background
    Full time
    Description

    Job Description

    Description

    Being part of Air Canada is to become part of an iconic Canadian symbol, recently ranked the best Airline in North America. Let your career take flight by joining our diverse and vibrant team at the leading edge of passenger aviation.

    This position may be located in Toronto or Montreal

    Are you looking to travel the world, work with amazing colleagues, in a positive work environment that promotes a learning culture?

    The Solution Architect - Data & Analytics will lead the Data engineering, ETL/ELT and BI team in translation of business strategies and requirements into specific technical solutions, data assets, process designs and identify associated functional requirements. You will play an integral role in the solution definition for analytics solutions and/or project deliveries and assume the overall responsibility for all technical aspects of solution delivery, from inception through design to implementation (including all aspects related to development, infrastructure, data and configuration management perspectives).

    Responsibilities:

  • Create detailed solution design and reviews across relevant stakeholders to ensure alignment to the overall business needs including architecture overview, detailed solution architecture and whenever necessary the architecture decisions and performance testing documents.
  • Analyze, document, and optimize the overall solution architecture by developing design principles, models, plans, internal standards, budgets, and processes aligned to industry best practices.
  • Provide technical oversight and recommendations on data infrastructure (on-premises and Cloud), Data Engineering and BI tool configuration to project teams.
  • Participate in the selection of relevant technologies and products when solicited.
  • Present and socialize proposed solutions to technical boards during review sessions as well as articulate and communicate designs to audiences with limited expertise related to the selected technology.
  • Support the delivery of the solution by providing insights to the development teams and project managers that plan and execute delivery activities.
  • Support implementation processes in association with internal and external development teams, participate in project-related activities and enforces guidelines and standards that production teams use to help guide their work.
  • Assume responsibility for the quality of the implemented solution and its adherence to technology strategies, standards and best practices defined by the enterprise architecture team.
  • Provide architectural leadership to development teams, and serve as the primary architect resource, and provide technical guidance and leadership to all internal and external teams involved in the implementation process.
  • Create solution architecture documents that describe and explain solutions attributes and associated benefits and maintain documentation in collaboration with enterprise architects as well as others solution architects.
  • Support the identification of opportunities for continuous improvement of solution management methodologies, including obtaining feedback after the solution has been implemented.
  • Build standard solution templates for different business use cases.
  • Qualifications

  • Bachelor's degree in Information Technology or related field. An advanced degree in a related area, an asset.
  • Minimum of 10 years of IT experience, of which minimum 5 as a solution experience working with integrated Enterprise systems
  • Effective organizational skills with strong attention to detail for production of high-quality deliverables
  • Strong Knowledge of ETL/ELT frameworks using Talend, Azure Data Factory, Databricks Notebooks(Pyspark).
  • Strong knowledge in warehousing concepts and Snowflake based Enterprise Warehouse.
  • Strong knowledge of Azure based architecture and services such as RBAC, AAD, VM, ADLS, Azure DevOps, Events hub.
  • Highly advanced expertise with data manipulation and visualization tools such as Power BI, Tableau or other.
  • Must have some experience in at least one of the following RDBMS environments: MS SQL Server, Oracle.
  • Expert knowledge of SQL and demonstrated ability to apply SQL creatively to a wide variety of business requirements.
  • Strong Knowledge of ETL/ELT tools such as Talend, Informatica, SSIS, or other as well as standards and best practices for ETL development.
  • Knowledge on designing and implementing real time ingestion and processing framework.
  • Proficient in building secure architecture using: Encryption, azure key vault, Access control, Network security, Advanced data security.
  • Organizing and maintaining data processes to meet ongoing data warehouse lifecycle needs.
  • Knowledge of Dimensional Data Modelling, Data marts, Data Vault 2.0 modeling.
  • Knowledge of Master Data and Reference Data concepts and solutions
  • Knowledge of Big Data concepts, Cloud Solutions such as Azure, AWS or GCP.
  • Good knowledge of Data Governance principles & tools such as Collibra.62Strong analytical, decision-making skills and demonstrated ability to learn new tools and systems.
  • Knowledge in APIs, web services concepts, standards and JSON, XML, XML Schema.
  • Experience in designing and implementing large server software with particular attention to security, scalability, and high performance.
  • Ability to work across multiple technical teams to set direction and priority.
  • Ability to work independently and as part of a team while demonstrating initiative and using good business acumen.
  • Ability to motivate and integrate team members, Team player with effective interpersonal skills.
  • Experience working within multidisciplinary and collaborative environments.
  • Conditions of Employment:

  • Candidates must be eligible to work in the country of interest, at the time any offer of employment is made and seeking any required work permits/visas or other authorizations which may be required is the sole responsibility of the candidates applying for this position.
  • Linguistic Requirements

    Based on equal qualifications, preference will be given to bilingual candidates.

    Diversity and Inclusion

    Air Canada is strongly committed to Diversity and Inclusion and aims to create a healthy, accessible and rewarding work environment which highlights employees' unique contributions to our company's success.

    As an equal opportunity employer, we welcome applications from all to help us build a diverse workforce which reflects the diversity of our customers, and communities, in which we live and serve.

    Air Canada thanks all candidates for their interest; however only those selected to continue in the process will be contacted.



  • Maarut Inc Toronto, Canada

    Resource Profile · This requirement is for a cloud data solution architect with proven experience designing, and implementing complex large scale Data Warehouse, Data Lake, and Lakehouse and supporting Data Migration and Conversion initiatives in a fast-paced environment. · This ...

  • Quantum World Technologies Inc.

    Data Architect

    2 weeks ago


    Quantum World Technologies Inc. Toronto, Canada

    Relevant experience: Overall 10+ years of experience in SAP data management, data quality assurance, data extraction from legacy systems. · Job Description: · 1. Hands-on Data Architect - to provide guidance to the team - does design, coding or configuring tools as required. Also ...

  • Randstad Canada

    Data Architect

    6 hours ago


    Randstad Canada Toronto, Canada

    Role: Data Architect (AWS) · Duration: 6+ Months Contract · Location: Toronto, ON --- HYBRID · ********************************************************************************************************************* · Candidates MUST be located in Toronto, ON / GTA --- This is a HYB ...

  • Project X Ltd.

    Data Architect

    1 week ago


    Project X Ltd. Toronto, Canada Full time

    Role Summary · As a Data Architect at Project X Ltd., you will be providing our clients with your knowledge and experience in making sense of messy, unstructured data. The Data Architect will be responsible for designing, implementing, and overseeing end-to-end solutions that add ...

  • Trinity Infotech Inc.

    Data Architect

    1 week ago


    Trinity Infotech Inc. Toronto, Canada

    Position: Data Architect · Location: Toronto, ON (Hybrid onsite from day 1) · Duration: Contract · Mandatory Skills: AWS Glue, Kafka, Redshift/Postgres, RDBMS/Datawarehousing · Primary Skills: Power BI, REST APIs · Relevant experience: Overall 10+ years of experience in SAP dat ...

  • Net2Source Inc.

    Data Architect

    1 week ago


    Net2Source Inc. Toronto, Canada

    Job Title: Data Architect · Location: Toronto, ON (Hybrid onsite from day 1) · Type: Contract · PRIMARY SKILL: AWS Glue, Kafka, Redshift/Postgres, RDBMS/Data warehousing · SECONDARY SKILL: Power BI, REST APIs · Relevant experience: Overall 10+ years of experience in SAP data m ...

  • Tech Mahindra

    Data Architect

    1 day ago


    Tech Mahindra Toronto, Canada

    Job Title : Data Architect · Location : Toronto, ON, Canada · Job Type : Permanent · Data Architect - Data Architect / Visualization Prime - Responsible for analysis of data, linkage across tables, and developing complex queries to model customer requirements. · Strong understan ...

  • Société Financière Manuvie

    Lead data architect

    1 week ago


    Société Financière Manuvie Toronto, ON, Canada

    Nous sommes un fournisseur de services financiers qui s'emploie à faciliter les décisions de nos clients et de nos collègues partout dans le monde et à les aider à vivre mieux. De nos initiatives environnementales à nos investissements dans la collectivité, nous montrons la voie ...

  • Leading Fintech Co

    Data Architect

    6 hours ago


    Leading Fintech Co Toronto, Canada

    7 + Years Proven experience as a Data Architect · Experience with designing the vision and blueprint of the organization's data framework · Airflow · PySpark · AWS (EMR, Athena, Iceberg) · Python · Hudi or Redshift (Hudi preferred) · ...

  • Randstad Digital

    Data Architect

    1 week ago


    Randstad Digital Toronto, Canada

    Data Solution Architect (Contract Position) · Number of Positions: 1 Duration: 7 months initial contract · Location: Toronto, ON, CA · Must be eligible to work in Canada · Hybrid position, 2-3days /week onsite in Toronto · Roles and responsibilities: · Be part of a high-profile t ...

  • Altis Technology

    Data Architect

    1 week ago


    Altis Technology Ontario, Canada

    Client: Altis Technology & Recruitment (Internal) · Duration: Permanent Full Time · Salary: $130 – 160K annually · Location: Remote-by-choice with offices located in Ottawa, Toronto, & Vancouver · The successful candidate will take on a pivotal role, responsible for seamlessly ...

  • Kumaran Systems

    Data Architect

    1 week ago


    Kumaran Systems Toronto, Canada

    We are looking for a Data Architect to build, optimize and maintain conceptual and logical database models. · Must Have · 10+ years with data warehouses (working in the data space) · 2+ years working with Apache Spark / Scala. · 2+ Years working experience on Azure DataBricks, Da ...

  • Project X Ltd.

    Data Architect

    1 week ago


    Project X Ltd. Toronto, Canada Full time

    Role Summary · As a Data Architect at Project X Ltd., you will be providing clients with your knowledge and experience in making sense of messy, unstructured data. The Data Architect will be responsible for designing, implementing, and overseeing end-to-end solutions that address ...

  • Trinity Infotech Inc.

    Data Architect

    5 days ago


    Trinity Infotech Inc. Toronto, Canada

    Position: Data ArchitectLocation: Toronto, ON (Hybrid onsite from day 1)Duration: Contract Mandatory Skills: AWS Glue, Kafka, Redshift/Postgres, RDBMS/Datawarehousing Primary Skills: Power BI, REST APIs Relevant experience: Overall 10+ years of experience in SAP data management, ...

  • Tech Mahindra

    Data Architect

    5 days ago


    Tech Mahindra Toronto, Canada

    Job Title : Data ArchitectLocation : Toronto, ON, CanadaJob Type : PermanentData Architect - Data Architect / Visualization Prime - Responsible for analysis of data, linkage across tables, and developing complex queries to model customer requirements. Strong understanding of Bell ...

  • Trinity Infotech Inc.

    Data Architect

    1 week ago


    Trinity Infotech Inc. Toronto, Canada

    Position: Data ArchitectLocation: Toronto, ON (Hybrid onsite from day 1)Duration: Contract · Mandatory Skills: · AWS Glue, Kafka, Redshift/Postgres, RDBMS/DatawarehousingPrimary Skills: · Power BI, REST APIs · Relevant experience: · Overall 10+ years of experience in SAP data man ...

  • Kumaran Systems

    Data Architect

    5 days ago


    Kumaran Systems Toronto, Canada

    We are looking for a Data Architect to build, optimize and maintain conceptual and logical database models. Must Have10+ years with data warehouses (working in the data space)2+ years working with Apache Spark / Scala.2+ Years working experience on Azure DataBricks, Data Lake / D ...

  • Net2Source Inc.

    Data Architect

    1 week ago


    Net2Source Inc. Toronto, Canada

    Job Title: Data ArchitectLocation: Toronto, ON (Hybrid onsite from day 1)Type: Contract · PRIMARY SKILL: · AWS Glue, Kafka, Redshift/Postgres, RDBMS/Data warehousingSECONDARY SKILL: · Power BI, REST APIs · Relevant experience: · Overall 10+ years of experience in SAP data managem ...

  • Miipe Quality Solutions

    Data Architect

    1 week ago


    Miipe Quality Solutions Toronto, Canada

    Miipe is a dynamic organization that fosters creativity and growth. We offer opportunities to learn and challenge yourself in a fast paced software consulting firm, working alongside large Fortune 500 clients in a myriad of industries, such as banking, telecommunications, insuran ...

  • Fossbytes Media Pvt Ltd

    Data architect

    1 week ago


    Fossbytes Media Pvt Ltd Toronto, ON, Canada

    Data Architect - Generative AI Architect · Technology sales at IBM is evolving its way of working to break beyond boundaries with innovative approaches. tell', Client Engineering co-creates with prospective customers, in real-time, on solutions to their hardest business challeng ...