Data Warehouse Architect

6 days ago


Guelph, Ontario, Canada Avanti Software Inc. Full time
About the Role

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.
Requirements
  • 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.
What We Offer

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.



  • Guelph, Ontario, Canada Avanti Software Inc. Full time

    About 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...


  • Guelph, Ontario, Canada Avanti Software Inc. Full time

    About 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...


  • Guelph, Ontario, Canada PDI Full time

    Key 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...


  • Guelph, Ontario, Canada PDI Full time

    Key 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...


  • Guelph, Ontario, Canada Foilcon Full time

    Position 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...


  • Guelph, Ontario, Canada Foilcon Full time

    Note: 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...


  • Guelph, Ontario, Canada CB Canada Full time

    Job 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...


  • Guelph, Ontario, Canada EvenUp Full time

    About 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...


  • Guelph, Ontario, Canada EvenUp Full time

    About 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...


  • Guelph, Ontario, Canada The Garland Company, Inc. Full time

    About 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...


  • Guelph, Ontario, Canada The Garland Company, Inc. Full time

    About 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...


  • Guelph, Ontario, Canada Universal Mobile & Industrial Solutions Full time

    Job 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...


  • Guelph, Ontario, Canada Universal Mobile & Industrial Solutions Full time

    Job 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...


  • Guelph, Ontario, Canada Universal Mobile & Industrial Solutions Full time

    Job 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...


  • Guelph, Ontario, Canada Universal Mobile & Industrial Solutions Full time

    Job 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...


  • Guelph, Ontario, Canada Universal Mobile & Industrial Solutions Full time

    Job 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...


  • Guelph, Ontario, Canada Universal Mobile & Industrial Solutions Full time

    Job 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...


  • Guelph, Ontario, Canada Wellington Catholic District School Board Full time

    Job 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...


  • Guelph, Ontario, Canada Wellington Catholic District School Board Full time

    Job 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...


  • Guelph, Ontario, Canada Universal Mobile & Industrial Solutions Full time

    Job 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...