Data Warehouse Architect

4 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

    We are Avanti Software Inc., a leading provider of innovative software solutions. Our company is committed to delivering top-notch products and services that exceed our customers' expectations.As a Data Warehouse Administrator, you will play a critical role in supporting the implementation and integration of data warehouses, data marts, and cubes. Your...


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

    The RoleThe Data Warehouse Administrator will support the implementation and integration of data warehouses, data marts, and cubes. This position involves performing data warehouse design and construction, as well as extensive testing, ETL and repository creation. The incumbent will coordinate with other team members and managers to translate business needs...


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

    About the RoleWe're seeking a highly skilled Data Warehouse Administrator to join our team at Avanti Software Inc. This is a full-time position that will play a critical role in the implementation and integration of data warehouses, data marts, and cubes.Key ResponsibilitiesDesign and construct data warehouses, data marts, and cubesDevelop, deploy, maintain,...


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

    About the RoleAt Avanti Software Inc., we are seeking a skilled Data Warehouse Specialist to support our data warehousing initiatives. This is a full-time position scheduled from Monday to Friday, with occasional extended hours when required.Key ResponsibilitiesThe successful candidate will be responsible for designing and constructing data warehouses, data...


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

    We're Avanti Software Inc., a leader in the Canadian powersports industry with 30 years of experience. Our mission is to provide top-notch products and exceptional service to our customers. We're now embarking on a new phase of growth, and we're looking for a skilled Data Warehouse Administrator to join our team.Key Responsibilities:Design and implement data...


  • Guelph, Ontario, Canada Co-operators General Insurance Company Full time

    Job Title: Business Intelligence ArchitectCo-operators General Insurance Company is seeking a highly skilled Business Intelligence Architect to lead the design and modernization of our AI/ML landscape. As a key member of our Business Intelligence team, you will play a pivotal role in shaping our AI/ML strategy, architecting robust systems, and guiding our...


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

    We're Avanti Software Inc., a leader in the Canadian powersports industry, and we've been a key player for the past 30 years. Our mission is to provide our customers with quality products and top-notch service to keep them riding their snowmobiles, ATVs, motorcycles, dirt bikes, and more. As we embark on the next phase of our growth, we're looking for a...


  • Guelph, Ontario, Canada GTT, LLC Full time

    Job Title: Senior Information ArchitectAbout the Role:We're seeking a skilled Information Architect to contribute to the development of robust information architectures that support our client's business objectives. As a Senior Information Architect, you will be responsible for designing and implementing effective information solutions that align with...

  • Warehouse Receiver

    2 weeks ago


    Guelph, Ontario, Canada Randstad Canada Full time

    Job SummaryWe are seeking a skilled Receiver to work in a highly automated warehouse environment. The ideal candidate will have previous experience in receiving and shipping, with a proven track record of inspecting products for damages or discrepancies. The Receiver will be responsible for receiving products, verifying quantities, and accurately recording...


  • Guelph, Ontario, Canada GTT, LLC Full time

    Job Title: Senior Information ArchitectAbout the Role:Our team is seeking a seasoned Information Architect to contribute to the development of robust information architectures that support our client's business objectives. As a key member of our team, you will be responsible for designing and implementing effective information solutions that align with...


  • Guelph, Ontario, Canada Foilcon Full time

    Foilcon is seeking a highly skilled Senior Salesforce Solutions Architect to join our team. This is a full-time position that offers an estimated annual salary of $120,000.Job DescriptionWe are looking for an experienced Salesforce architect with a proven track record of designing and implementing complex Salesforce solutions. As a Senior Salesforce...

  • Warehouse Receiver

    2 weeks ago


    Guelph, Ontario, Canada Randstad Canada Full time

    Job SummaryWe are seeking a skilled Warehouse Receiver to join our team at Randstad Canada. As a key member of our logistics team, you will be responsible for receiving and inspecting products, verifying quantities, and accurately documenting discrepancies. If you have previous experience in shipping and receiving, and are proficient in using RF scanners, we...


  • Guelph, Ontario, Canada LanceSoft Full time

    Company Overview:LanceSoft is a leading provider of innovative technology solutions, committed to delivering cutting-edge services that drive business success.Job Description:We are seeking an experienced Enterprise Solutions Architect Leader to join our team. As a key member of our architecture team, you will be responsible for designing and implementing...


  • Guelph, Ontario, Canada Maarut Inc Full time

    Job SummaryWe are seeking an experienced Senior Information Architect to lead our team in designing and implementing innovative information architecture solutions. As a key member of our organization, you will be responsible for providing expert guidance on information architecture principles, methods, and best practices.About the RoleThis is a critical...


  • Guelph, Ontario, Canada Maarut Inc Full time

    Job Description:Maarrut Inc is seeking an experienced Information Architect to join our team. As a key member of our I&IT organization, you will play a critical role in designing and implementing information architecture solutions that meet the needs of our clients and stakeholders.About the Role:This position requires a highly skilled and experienced...


  • Guelph, Ontario, Canada Randstad Canada Full time

    Job Summary:We are seeking a skilled Warehouse Product Inspector to join our team at Randstad Canada. In this role, you will be responsible for receiving and inspecting products, identifying any damages or discrepancies, and accurately logging information using RF systems. Your previous experience in shipping and receiving, as well as RF scanner experience,...


  • Guelph, Ontario, Canada Maarut Inc Full time

    Job SummaryWe are seeking an experienced Information Architect Senior to join our team at Maarut Inc. As a key member of our information architecture team, you will be responsible for providing professional information architecture expertise and undertaking comprehensive architecture needs assessments and complex reviews in support of systems/infrastructure...


  • Guelph, Ontario, Canada Maarut Inc Full time

    About the RoleWe are seeking an experienced Senior Information Architect to join our team at Maarut Inc. The successful candidate will be responsible for designing and implementing complex information architecture solutions for our clients.Key Responsibilities:Provide professional information architecture expertise to support clients' information...


  • Guelph, Ontario, Canada Randstad Canada Full time

    Company OverviewRandstad Canada is a leading staffing and recruitment agency committed to fostering a diverse and inclusive workforce.Job SummaryWe are seeking an experienced Receiver to join our team in a highly automated warehouse that distributes globally. This is a full-time position with potential for permanent hire, offering a competitive salary and...


  • Guelph, Ontario, Canada Foilcon Full time

    About FoilconFoilcon is a dynamic and innovative organization seeking an experienced Senior Enterprise Application Architect to join our team. As a key member of our IT department, you will be responsible for designing and implementing enterprise-level application architectures that meet the evolving needs of our business.Job SummaryWe are looking for a...