Data Warehouse Architect
1 day ago
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 standards.
- 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.
- Develop and maintain complex SQL queries, including DDL and DML scripting, and have a strong understanding of SAP Business Object Data Services and Unix/Linux Shell Scripting.
- Some experience with Power BI is also required.
- 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, with 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 and welcomes applications from diverse candidates. We are committed to providing an environment of mutual respect where equal employment opportunities are available to all applicants and teammates without regard to race, color, religion, sex, pregnancy, national origin, age, physical and mental disability, marital status, sexual orientation, gender identity, gender expression, genetic information, military and veteran status, and any other characteristic protected by applicable law.
-
Data Warehouse Architect
2 days ago
Canada Winland Foods, Inc. Full timeJob 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
2 days ago
Canada Winland Foods, Inc. Full timeJob 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 timeJob 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
23 hours ago
Canada Winland Foods, Inc. Full timeJob 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
2 days ago
Canada Winland Foods, Inc. Full timeData 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
2 days ago
Canada Winland Foods, Inc. Full timeData 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 Architect
6 days ago
Canada People Force Consulting Inc Full timeData 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
6 days ago
Canada People Force Consulting Inc Full timeData 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 day ago
Canada Flextravelsolutions Full timePython 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
1 day ago
Canada Flextravelsolutions Full timePython 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
6 days ago
Canada People Force Consulting Inc Full timeData Architect - AzureThis is a full-time role with one of our financial clientsPosition: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
6 days ago
Canada People Force Consulting Inc Full timeData Architect - AzureThis is a full-time role with one of our financial clientsPosition: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
2 days ago
Canada People Force Consulting Inc Full timeData 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...
-
Data Architect
2 days ago
Canada People Force Consulting Inc Full timeData 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...
-
Data Architect
2 weeks ago
Canada Flextravelsolutions Full timeAbout Flex Travel SolutionsWe are a dynamic and innovative travel technology company that fosters a culture of passion, collaboration, and growth. Our team is dedicated to delivering exceptional solutions that empower our customers to succeed.The RoleWe are seeking a highly skilled Data Architect to join our team as a Python ETL Developer. As a key member of...
-
Data Architect
2 weeks ago
Canada Flextravelsolutions Full timeAbout Flex Travel SolutionsWe are a dynamic and innovative travel technology company that fosters a culture of passion, collaboration, and growth. Our team is dedicated to delivering exceptional solutions that empower our customers to succeed.The RoleWe are seeking a highly skilled Data Architect to join our team as a Python ETL Developer. As a key member of...
-
Data Architect
22 hours ago
Canada Flextravelsolutions Full timePython ETL DeveloperAt Flex Travel Solutions, we're committed to innovation and collaboration. As a technology-first company, we're seeking a skilled Python ETL Developer to join our team.Key ResponsibilitiesDesign, develop, and implement efficient ETL processes using Python.Manage and optimize data flow within our business.Communicate effectively with...
-
Data Architect
1 day ago
Canada Flextravelsolutions Full timePython ETL DeveloperAt Flex Travel Solutions, we're committed to innovation and collaboration. As a technology-first company, we're seeking a skilled Python ETL Developer to join our team.Key ResponsibilitiesDesign, develop, and implement efficient ETL processes using Python.Manage and optimize data flow within our business.Communicate effectively with...
-
Data Warehouse Architect
2 weeks ago
Canada Winland Foods, Inc. Full timeJob Description**Job Summary**We are seeking a highly skilled Data Warehouse Architect to join our team at Winland Foods, Inc. as a key member of our Business Intelligence team. The successful candidate will be responsible for designing, developing, and implementing enterprise data warehouse solutions that meet the business needs of our organization.Key...
-
Data Warehouse Architect
2 weeks ago
Canada Winland Foods, Inc. Full timeJob Description**Job Summary**We are seeking a highly skilled Data Warehouse Architect to join our team at Winland Foods, Inc. as a key member of our Business Intelligence team. The successful candidate will be responsible for designing, developing, and implementing enterprise data warehouse solutions that meet the business needs of our organization.Key...
