Data Warehouse Architect
6 days ago
We are seeking a highly skilled Data Warehouse Administrator to join our team at Avanti Software Inc. as we embark on the next phase of our growth.
Key Responsibilities- Design and implement data warehouses, data marts, and cubes to support business intelligence initiatives.
- Develop and maintain ETL processes to load data into data warehouses and data marts.
- Perform data warehouse design and construction, including data modeling and data architecture.
- Troubleshoot issues in cubes, ETL packages, and databases to ensure data accuracy and performance.
- Collaborate with business analysts and stakeholders to translate business needs into technical solutions.
- Develop and maintain Snowflake databases, including data modeling and data architecture.
- Investigate and resolve problems of data accuracy and availability.
- Participate in internal testing to identify problems early and perform error and stress scenarios.
- Work with business analysts to aid in the design of the system.
- Identify architectural issues and propose alternative solutions.
- Install upgrades and patches to existing databases.
- Develop and maintain data warehouse environment documentation.
- Manage multiple tasks and projects to schedule, ensuring requirements are met.
- Report on progress weekly and measure against goals/initiatives to management for meeting project objectives.
- Assist with creating and maintaining documentation standards, coach others on developing high-quality documentation.
- Bachelor's degree in computer science or related field.
- Minimum 2 years of experience in Microsoft Snowflake or SQL Server database administration, database monitoring and performance tuning, stored procedures, triggers, cursors, and views.
- Experience developing ETL processes loading data warehouses/data marts required.
- Experience utilizing Kimball or Inmon method of data warehousing a plus.
- Excellent understanding of RDBM (Relationship Database Management).
- Knowledge of best practices and software development process (full SDLC).
- Experience supporting a multi-database environment.
- Ability to work independently with little or no supervision.
- Outstanding analytical and problem-solving skills.
- Strong written and verbal communication skills.
- Ability to effectively prioritize and escalate issues.
- Demonstrated ability to troubleshoot software/database issues independently.
- Ability to work extended hours when needed.
We offer a competitive salary and benefits package, as well as opportunities for professional growth and development.
We are an equal opportunity employer and are committed to diversity and inclusion in the workplace.
-
Warehouse Data Administrator
5 days ago
Guelph, Ontario, Canada Avanti Software Inc. Full timeAbout the RoleWe are seeking a highly skilled Data Warehouse Administrator to join our team at Avanti Software Inc. as a key member of our Business Intelligence department.Key ResponsibilitiesDesign, implement, and maintain data warehouses, data marts, and cubes to support business intelligence initiatives.Develop and maintain Snowflake databases, ensuring...
-
Warehouse Data Administrator
5 days ago
Guelph, Ontario, Canada Avanti Software Inc. Full timeAbout the RoleWe are seeking a highly skilled Data Warehouse Administrator to join our team at Avanti Software Inc. as a key member of our Business Intelligence department.Key ResponsibilitiesDesign, implement, and maintain data warehouses, data marts, and cubes to support business intelligence initiatives.Develop and maintain Snowflake databases, ensuring...
-
Logistics Warehouse Associate
4 weeks ago
Guelph, Ontario, Canada PDI Full timeKey Responsibilities:Prepare documentation for shipmentsInput shipping data into the Warehouse Management SystemProcess and finalize orders for dispatch or collection in accordance with timelines (load, pack, wrap, label, ship)Coordinate the collection and delivery of incoming and outgoing freightManage inventory control processesRegularly update...
-
Logistics Warehouse Associate
4 weeks ago
Guelph, Ontario, Canada PDI Full timeKey Responsibilities: Prepare and manage shipping documentation Input shipping data into the Warehouse Management System Organize and finalize orders for delivery or collection in accordance with the schedule (load, pack, wrap, label, ship) Coordinate the pickup and delivery of incoming and outgoing freight Oversee inventory management Regularly update...
-
Senior Solutions Architect
4 weeks ago
Guelph, Ontario, Canada Foilcon Full timePosition Overview:This hybrid role requires in-office presence bi-weekly at the discretion of management. Role Summary: The Senior Solutions Architect is responsible for designing, recommending, and overseeing the implementation of the technical framework (including hardware, software, databases, and communication systems) utilized across various...
-
Senior Solutions Architect
4 weeks ago
Guelph, Ontario, Canada Foilcon Full timeNote: This hybrid position requires in-office attendance bi-weekly at the discretion of management.Overview: As a Senior Solutions Architect, you will be responsible for designing, proposing, executing, and overseeing the technical framework (including hardware, software, databases, and communication systems) utilized across various applications within a...
-
Machine Learning Solutions Architect
1 week ago
Guelph, Ontario, Canada CB Canada Full timeJob DescriptionJob Title: Development Project LeadJob Summary:The Development Project Lead will oversee the development of projects in machine learning and vision systems using Microsoft Azure Cognitive services. This individual will conduct root cause analysis and troubleshoot programming issues, working closely with System Analysts and other IT staff. This...
-
Software Architect, Integration Specialist
5 days ago
Guelph, Ontario, Canada EvenUp Full timeAbout the RoleWe are seeking a highly skilled and experienced Fullstack Software Engineer to join our Client Portal Integrations team at EvenUp. As a key member of our engineering squad, you will play a crucial role in architecting cutting-edge software integrations and revolutionizing the user experience for our customers.Key ResponsibilitiesFull Project...
-
Software Architect, Integration Specialist
5 days ago
Guelph, Ontario, Canada EvenUp Full timeAbout the RoleWe are seeking a highly skilled and experienced Fullstack Software Engineer to join our Client Portal Integrations team at EvenUp. As a key member of our engineering squad, you will play a crucial role in architecting cutting-edge software integrations and revolutionizing the user experience for our customers.Key ResponsibilitiesFull Project...
-
Regional Sales Director
3 days ago
Guelph, Ontario, Canada The Garland Company, Inc. Full timeAbout The Garland Company, Inc.We are a leading provider of innovative building solutions, with a rich history spanning over 100 years. Our commitment to excellence has driven us to develop unique product and service offerings that meet the evolving needs of our customers worldwide.Key ResponsibilitiesDevelop and execute sales strategies to expand our...
-
Regional Sales Director
3 days ago
Guelph, Ontario, Canada The Garland Company, Inc. Full timeAbout The Garland Company, Inc.We are a leading provider of innovative building solutions, with a rich history spanning over 100 years. Our commitment to excellence has driven us to develop unique product and service offerings that meet the evolving needs of our customers worldwide.Key ResponsibilitiesDevelop and execute sales strategies to expand our...
-
Production Coordinator
7 days ago
Guelph, Ontario, Canada Universal Mobile & Industrial Solutions Full timeJob SummaryWe are seeking a highly organized and detail-oriented Production Coordinator to join our team at Universal Mobile & Industrial Solutions. As a key member of our operations team, you will be responsible for coordinating activities with other work units or departments, performing routine clerical duties, and ensuring the smooth operation of our...
-
Production Coordinator
7 days ago
Guelph, Ontario, Canada Universal Mobile & Industrial Solutions Full timeJob SummaryWe are seeking a highly organized and detail-oriented Production Coordinator to join our team at Universal Mobile & Industrial Solutions. As a key member of our operations team, you will be responsible for coordinating activities with other work units or departments, performing routine clerical duties, and ensuring the smooth operation of our...
-
Production Operations Coordinator
16 hours ago
Guelph, Ontario, Canada Universal Mobile & Industrial Solutions Full timeJob SummaryWe are seeking a highly organized and detail-oriented Production Coordinator to join our team at Universal Mobile & Industrial Solutions. As a key member of our operations team, you will be responsible for coordinating activities with other work units or departments, performing routine clerical duties, and ensuring the smooth operation of our...
-
Production Operations Coordinator
13 hours ago
Guelph, Ontario, Canada Universal Mobile & Industrial Solutions Full timeJob SummaryWe are seeking a highly organized and detail-oriented Production Coordinator to join our team at Universal Mobile & Industrial Solutions. As a key member of our operations team, you will be responsible for coordinating activities with other work units or departments, performing routine clerical duties, and ensuring the smooth operation of our...
-
Production Coordinator
3 days ago
Guelph, Ontario, Canada Universal Mobile & Industrial Solutions Full timeJob SummaryWe are seeking a highly organized and detail-oriented Production Coordinator to join our team at Universal Mobile & Industrial Solutions. As a key member of our operations team, you will be responsible for coordinating activities with other work units or departments, performing routine clerical duties, and ensuring the smooth operation of our...
-
Production Coordinator
4 days ago
Guelph, Ontario, Canada Universal Mobile & Industrial Solutions Full timeJob SummaryWe are seeking a highly organized and detail-oriented Production Coordinator to join our team at Universal Mobile & Industrial Solutions. As a key member of our operations team, you will be responsible for coordinating activities with other work units or departments, performing routine clerical duties, and ensuring the smooth operation of our...
-
Business Systems Analyst
5 days ago
Guelph, Ontario, Canada Wellington Catholic District School Board Full timeJob SummaryWe are seeking a highly skilled Business Systems Analyst to join our team at the Wellington Catholic District School Board. As a Business Systems Analyst, you will play a key role in supporting the school board's business departments, including Finance, IT, and Program departments.Key ResponsibilitiesBusiness Process Analysis: Partner with...
-
Business Systems Analyst
5 days ago
Guelph, Ontario, Canada Wellington Catholic District School Board Full timeJob SummaryWe are seeking a highly skilled Business Systems Analyst to join our team at the Wellington Catholic District School Board. As a Business Systems Analyst, you will play a key role in supporting the school board's business departments, including Finance, IT, and Program departments.Key ResponsibilitiesBusiness Process Analysis: Partner with...
-
Production Coordinator
6 days ago
Guelph, Ontario, Canada Universal Mobile & Industrial Solutions Full timeJob SummaryWe are seeking a highly organized and detail-oriented Production Coordinator to join our team at Universal Mobile & Industrial Solutions. As a key member of our operations team, you will be responsible for coordinating activities with other work units or departments, performing routine clerical duties, and ensuring the smooth operation of our...