Data Warehouse Architect

3 weeks ago


Guelph, Ontario, Canada Avanti Software Inc. Full time
The Opportunity

We are seeking a highly skilled Data Warehouse Administrator to support the implementation and integration of data warehouses, data marts, and cubes. This role will involve performing data warehouse design and construction, as well as coordinating with other team members and managers to translate business needs into technical solutions.

Key Responsibilities:

  • Design and construct data warehouses, data marts, and cubes
  • Coordinate with team members and managers to translate business needs into technical solutions
  • Troubleshoot issues in cubes, ETL packages, and databases to identify and solve problems with data accuracy and performance
  • Ensure that data sources are presented to business analysts to provide key data to business stakeholders
  • Evaluate and monitor databases to resolve performance issues
  • Develop, test, and maintain Snowflake databases
  • Investigate and resolve problems of data accuracy and availability
  • Participate in internal testing to identify problems early, perform error and stress scenarios
  • 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

Requirements:

  • Bachelor's degree in computer-related field preferred
  • Minimum 2 years 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

About Avanti Software Inc.

Avanti Software Inc. is an equal opportunity employer and is committed to promoting accessible recruitment as outlined in the Accessibility for Ontarians with Disabilities Act. We are seeking a highly skilled Data Warehouse Administrator to join our team.



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

    Data Warehouse Administrator Job DescriptionWe strive to deliver exceptional products and services to our customers, ensuring they have an unparalleled experience with our snowmobiles, ATVs, motorcycles, dirt bikes, and more.The Data Warehouse Administrator will play a pivotal role in the implementation and integration of data warehouses, data marts, and...


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

    Data Warehouse Administrator Job DescriptionWe strive to deliver exceptional products and services to our customers, ensuring they have an unparalleled experience with our snowmobiles, ATVs, motorcycles, dirt bikes, and more.The Data Warehouse Administrator will play a pivotal role in the implementation and integration of data warehouses, data marts, and...


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

    Job Title: Data Warehouse AdministratorWe are seeking a highly skilled Data Warehouse Administrator to join our team at Avanti Software Inc. The successful candidate will be responsible for designing, implementing, and maintaining our data warehouses, ensuring data accuracy and performance.Key Responsibilities:Design and construct data warehouses, data...


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

    Job Title: Data Warehouse AdministratorWe are seeking a highly skilled Data Warehouse Administrator to join our team at Avanti Software Inc. The successful candidate will be responsible for designing, implementing, and maintaining our data warehouses, ensuring data accuracy and performance.Key Responsibilities:Design and construct data warehouses, data...


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

    Data Warehouse Administrator Job DescriptionWe are seeking a highly skilled Data Warehouse Administrator to join our team at Avanti Software Inc. Our company provides top-notch products and services to our customers, and we need someone to support the implementation and integration of our data warehouses, data marts, and cubes.Key Responsibilities:Design and...


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

    Data Warehouse Administrator Job DescriptionWe are seeking a highly skilled Data Warehouse Administrator to join our team at Avanti Software Inc. Our company provides top-notch products and services to our customers, and we need someone to support the implementation and integration of our data warehouses, data marts, and cubes.Key Responsibilities:Design and...


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

    Data Warehouse Administrator Job DescriptionWe are seeking a highly skilled Data Warehouse Administrator to join our team at Avanti Software Inc. Our company provides quality products and top-notch service to our customers, and we need someone to support the implementation and integration of our data warehouses, data marts, and cubes.Key...


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

    Data Warehouse Administrator Job DescriptionWe are seeking a highly skilled Data Warehouse Administrator to join our team at Avanti Software Inc. Our company provides quality products and top-notch service to our customers, and we need someone to support the implementation and integration of our data warehouses, data marts, and cubes.Key...


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

    Data Warehouse Administrator Job DescriptionWe strive to deliver exceptional products and services to our customers, ensuring they have an unparalleled experience with our snowmobiles, ATVs, motorcycles, dirt bikes, and more.The Data Warehouse Administrator will play a pivotal role in the implementation and integration of data warehouses, data marts, and...


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

    Data Warehouse Administrator Job DescriptionWe strive to deliver exceptional products and services to our customers, ensuring they have an unparalleled experience with our snowmobiles, ATVs, motorcycles, dirt bikes, and more.The Data Warehouse Administrator will play a pivotal role in the implementation and integration of data warehouses, data marts, and...


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

    Data Warehouse Administrator Job DescriptionWe strive to deliver exceptional products and services to our customers, ensuring they have an unparalleled experience with our snowmobiles, ATVs, motorcycles, dirt bikes, and more.The Data Warehouse Administrator will play a pivotal role in the implementation and integration of data warehouses, data marts, and...


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

    Data Warehouse Administrator Job DescriptionWe strive to deliver exceptional products and services to our customers, ensuring they have an unparalleled experience with our snowmobiles, ATVs, motorcycles, dirt bikes, and more.The Data Warehouse Administrator will play a pivotal role in the implementation and integration of data warehouses, data marts, and...


  • 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. in Guelph, Ontario. As a key member of our data analytics team, you will play a critical role in supporting the implementation and integration of data warehouses, data marts, and cubes.Key ResponsibilitiesDesign and construct data warehouses...


  • 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. in Guelph, Ontario. As a key member of our data analytics team, you will play a critical role in supporting the implementation and integration of data warehouses, data marts, and cubes.Key ResponsibilitiesDesign and construct data warehouses...


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

    Data Warehouse Administrator Job DescriptionWe strive to deliver exceptional products and services to our customers, ensuring they have an unparalleled experience with our snowmobiles, ATVs, motorcycles, and more.The Data Warehouse Administrator will play a pivotal role in the implementation and integration of data warehouses, data marts, and cubes. This...


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

    Data Warehouse Administrator Job DescriptionWe strive to deliver exceptional products and services to our customers, ensuring they have an unparalleled experience with our snowmobiles, ATVs, motorcycles, and more.The Data Warehouse Administrator will play a pivotal role in the implementation and integration of data warehouses, data marts, and cubes. This...


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

    Data Warehouse Administrator Job DescriptionWe strive to deliver exceptional products and services to our customers, ensuring they have an unparalleled experience with our snowmobiles, ATVs, motorcycles, and more.The Data Warehouse Administrator will play a crucial role in the implementation and integration of data warehouses, data marts, and cubes. This...


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

    Data Warehouse Administrator Job DescriptionWe strive to deliver exceptional products and services to our customers, ensuring they have an unparalleled experience with our snowmobiles, ATVs, motorcycles, and more.The Data Warehouse Administrator will play a crucial role in the implementation and integration of data warehouses, data marts, and cubes. This...


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

    Data Warehouse Administrator Job DescriptionWe are seeking a highly skilled Data Warehouse Administrator to join our team at Avanti Software Inc. Our company provides quality products and top-notch service to our customers, and we need someone to support the implementation and integration of our data warehouses, data marts, and cubes.Key...


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

    Data Warehouse Administrator Job DescriptionWe are seeking a highly skilled Data Warehouse Administrator to join our team at Avanti Software Inc. Our company provides quality products and top-notch service to our customers, and we need someone to support the implementation and integration of our data warehouses, data marts, and cubes.Key...