Data Warehouse Architect

23 hours ago

Canada Winland Foods, Inc. Full time
Job Title: Data Warehouse Architect

The Data Warehouse Architect plays a pivotal role in driving and coordinating the technical execution of enterprise data warehouse solutions and services. This involves understanding business requirements, solution design, data extraction, transformation, and integration architecture, development, testing, deployment, and ongoing operational support.

Key Responsibilities:
  • Investigate, analyze, and understand data contents of source data systems.
  • Apply dimensional modeling techniques for data warehouse design.
  • Define and improve coding standards, adhering to departmental and organizational guidelines.
  • Collaborate with project teams, business process experts, and IT leadership to understand requirements for data warehouse development projects.
  • Design data architecture for DW components, drive UAT activities, and lead DW/BI initiatives from ideation to completion.
  • Ensure standard data elements are maintained across all data structures in DW and define, develop, and lead implementation of long-term strategy and roadmap for Data Warehousing, Data Science, and ML.
  • Develop and test ETL processes using tools like SSIS, Azure Data Factory, Talend, or future technologies based on the roadmap.
  • Apply SQL Server/Snowflake query and DDL/DML scripting skills, as well as SAP Business Object Data Services understanding and configuration.
  • Utilize Unix/Linux shell scripting and have some Power BI understanding.
Requirements:
  • Bachelor's degree in Information Technology, Computer Science, or a related field.
  • At least 9 years of full Software Development Life Cycle experience.
  • 7+ years of practical experience with any ETL tool, including complex transformation business rules implementation.
  • 3+ years of experience with SSIS or ADF, Talend.
  • 3+ years of practical experience with writing SQL queries, including complex queries.
  • 5+ years of practical experience working on data warehouse projects using dimensional modeling.
  • Ability to analyze existing SSIS code for improvements, enhancements, conversion, and problem-solving.
  • Ability to execute data warehouse tasks in a timely manner without guidance.
  • Project Management and SDLC understanding is required.
  • Experience with Data Warehouse Design/Development in Manufacturing companies and experience in using SAP ERP as a source system.
  • Experience in Cloud DW – Snowflake and Azure Cloud Platform using Azure Data Factory, Talend, Fivetran/dbt, or Matillion.

Winland Foods, Inc. is an equal opportunity employer committed to diversity and inclusion. We seek to recruit, develop, and retain the most talented people from a diverse candidate pool.

  • Data Warehouse Architect

    9 hours ago

    Canada Winland Foods, Inc. Full time

    Job Title: Data Warehouse ArchitectWinland Foods, Inc. is seeking a highly skilled Data Warehouse Architect to drive and coordinate the technical execution of enterprise data warehouse solutions and services. The successful candidate will have a strong understanding of business requirements, solution design, data extraction, transformation, and integration...

  • Data Warehouse Architect

    5 days ago

    Canada Winland Foods, Inc. Full time

    Job Title: Data Warehouse ArchitectWinland Foods, Inc. is seeking a highly skilled Data Warehouse Architect to drive and coordinate the technical execution of enterprise data warehouse solutions and services. The successful candidate will have a strong understanding of business requirements, solution design, data extraction, transformation, and integration...

  • Data Warehouse Architect

    5 days ago

    Canada Winland Foods, Inc. Full time

    Job Title: Data Warehouse ArchitectWinland Foods, Inc. is seeking a highly skilled Data Warehouse Architect to drive and coordinate the technical execution of enterprise data warehouse solutions and services. The successful candidate will have a strong understanding of business requirements, solution design, data extraction, transformation, and integration...

  • Data Warehouse Architect

    1 day ago

    Canada Winland Foods, Inc. Full time

    Job Title: Data Warehouse ArchitectWinland Foods, Inc. is seeking a highly skilled Data Warehouse Architect to drive and coordinate the technical execution of enterprise data warehouse solutions and services. The successful candidate will have a strong understanding of business requirements, solution design, data extraction, transformation, and integration...

  • Data Warehouse Architect

    1 day ago

    Canada Winland Foods, Inc. Full time

    Job Title: Data Warehouse ArchitectWinland Foods, Inc. is seeking a highly skilled Data Warehouse Architect to drive and coordinate the technical execution of enterprise data warehouse solutions and services. The successful candidate will have a strong understanding of business requirements, solution design, data extraction, transformation, and integration...

  • Data Warehouse Architect

    4 days ago

    Canada Winland Foods, Inc. Full time

    Job Title: Data Warehouse ArchitectWinland Foods, Inc. is seeking a highly skilled Data Warehouse Architect to drive and coordinate the technical execution of enterprise data warehouse solutions and services. The successful candidate will have a strong understanding of business requirements, solution design, data extraction, transformation, and integration...

  • Data Warehouse Architect

    4 days ago

    Canada Winland Foods, Inc. Full time

    Job Title: Data Warehouse ArchitectWinland Foods, Inc. is seeking a highly skilled Data Warehouse Architect to drive and coordinate the technical execution of enterprise data warehouse solutions and services. The successful candidate will have a strong understanding of business requirements, solution design, data extraction, transformation, and integration...

  • Data Warehouse Architect

    4 days ago

    Canada Winland Foods, Inc. Full time

    Data Warehouse Architect Job DescriptionThe Data Warehouse Architect plays a pivotal role in driving and coordinating the technical execution of enterprise data warehouse solutions and services. This involves understanding business requirements, solution design, data extraction, transformation, and integration architecture, development, testing, deployment,...

  • Data Warehouse Architect

    4 days ago

    Canada Winland Foods, Inc. Full time

    Data Warehouse Architect Job DescriptionThe Data Warehouse Architect plays a pivotal role in driving and coordinating the technical execution of enterprise data warehouse solutions and services. This involves understanding business requirements, solution design, data extraction, transformation, and integration architecture, development, testing, deployment,...

  • Data Warehouse Architect

    9 hours ago

    Canada Winland Foods, Inc. Full time

    Data Warehouse Architect Job DescriptionThe Data Warehouse Architect plays a pivotal role in driving the technical execution of enterprise data warehouse solutions and services. This involves understanding business requirements, solution design, data extraction, transformation, and integration architecture, development, testing, deployment, and ongoing...

  • Data Warehouse Architect

    5 days ago

    Canada Winland Foods, Inc. Full time

    Data Warehouse Architect Job DescriptionThe Data Warehouse Architect plays a pivotal role in driving and coordinating the technical execution of enterprise data warehouse solutions and services. This involves understanding business requirements, solution design, data extraction, transformation, and integration architecture, development, testing, deployment,...

  • Data Warehouse Architect

    5 days ago

    Canada Winland Foods, Inc. Full time

    Data Warehouse Architect Job DescriptionThe Data Warehouse Architect plays a pivotal role in driving and coordinating the technical execution of enterprise data warehouse solutions and services. This involves understanding business requirements, solution design, data extraction, transformation, and integration architecture, development, testing, deployment,...

  • Data Warehouse Snowflake Solution Architect

    2 days ago

    Canada KTek Resourcing Full time

    Data Warehouse Snowflake Solution ArchitectWe are seeking a highly skilled Data Warehouse Snowflake Solution Architect to join our team at KTek Resourcing. As a key member of our team, you will be responsible for designing and implementing data warehouses using Snowflake.Key Responsibilities:Design and Implement Data Warehouses: Develop entity relationship...

  • Data Warehouse Snowflake Solution Architect

    2 days ago

    Canada KTek Resourcing Full time

    Data Warehouse Snowflake Solution ArchitectWe are seeking a highly skilled Data Warehouse Snowflake Solution Architect to join our team at KTek Resourcing. As a key member of our team, you will be responsible for designing and implementing data warehouses using Snowflake.Key Responsibilities:Design and Implement Data Warehouses: Develop entity relationship...

  • Data Architect

    23 hours ago

    Canada Bronson Technical Search Full time

    About the RoleWe are seeking a highly skilled Data Architect to play a key role in our e-Tolling project and IT operations. As a Data Architect, you will design and implement a future-proof data architecture for e-Tolling, Traffic Management Systems, and internal platforms.ResponsibilitiesDesign data models for e-Tolling, Traffic Management Systems, and...

  • Data Architect

    1 day ago

    Canada Bronson Technical Search Full time

    About the RoleWe are seeking a highly skilled Data Architect to play a key role in our e-Tolling project and IT operations. As a Data Architect, you will design and implement a future-proof data architecture for e-Tolling, Traffic Management Systems, and internal platforms.ResponsibilitiesDesign data models for e-Tolling, Traffic Management Systems, and...

  • Data Architect

    1 week ago

    Canada People Force Consulting Inc Full time

    Data Architect - AzureThis is a full-time role with one of our financial clients.Position:Data Architect - AzureType:PermanentLocation:Hybrid (3 days onsite per week in Mississauga or Downtown Toronto)You will be part of our Data Strategy and Engineering team to architect large-scale data-driven engagements and provide direction as the subject matter expert...

  • Data Architect

    1 week ago

    Canada People Force Consulting Inc Full time

    Data Architect - AzureThis is a full-time role with one of our financial clients.Position:Data Architect - AzureType:PermanentLocation:Hybrid (3 days onsite per week in Mississauga or Downtown Toronto)You will be part of our Data Strategy and Engineering team to architect large-scale data-driven engagements and provide direction as the subject matter expert...

  • Data Architect

    4 days ago

    Canada Flextravelsolutions Full time

    Python ETL DeveloperWe are seeking a skilled Python ETL Developer to join our team at Flex Travel Solutions. As a technology-first company, we're committed to innovation and collaboration.Key Responsibilities:Design, develop, and implement efficient ETL processes using Python.Manage and optimize data flow within our business.Communicate effectively with...

  • Data Architect

    4 days ago

    Canada Flextravelsolutions Full time

    Python ETL DeveloperWe are seeking a skilled Python ETL Developer to join our team at Flex Travel Solutions. As a technology-first company, we're committed to innovation and collaboration.Key Responsibilities:Design, develop, and implement efficient ETL processes using Python.Manage and optimize data flow within our business.Communicate effectively with...