Data Warehouse Specialist

3 weeks ago


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

The 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 into technical solutions.

Key Responsibilities

Develop, deploy, maintain, support, and debug ETL jobs. Evaluate and monitor databases to resolve performance issues. Interpret business processes to develop data entity structures, star schemas, measures, and cubes. 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. 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.

Requirements

Bachelor's degree in a computer-related field is preferred. Minimum 2 years of experience in Microsoft Snowflake or SQL Server database administration, database monitoring and performance tuning, stored procedures, triggers, cursors, and views is required. Experience developing ETL processes loading Data Warehouses/Data Marts is essential. Experience utilizing Kimball or Inmon method of Data Warehousing is an asset. Excellent understanding of RDBM (Relationship Database Management) is necessary. Knowledge of best practices and software development process (full SDLC) is required. Experience supporting a multi-database environment is necessary. Ability to work independently with little or no supervision is required. Outstanding analytical and problem-solving skills are necessary. Strong written and verbal communication skills are required. Ability to effectively prioritize and escalate issues is necessary. Demonstrated ability to troubleshoot software/database issues independently is required. Ability to work extended hours when needed is necessary.



  • 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, 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 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

    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 Avanti Software Inc. Full time

    The OpportunityWe 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...


  • 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 Randstad Canada Full time

    About the RoleWe are seeking a reliable Warehouse Operations Specialist to join our team in Guelph. As an Order Picker - Forklift Operator, you will play a key role in the movement of materials through our indoor industrial environment.Job SummaryThis is a 1-month contract position with the potential for full-time hire. You will work closely with your team...


  • Guelph, Ontario, Canada Randstad Full time

    We are seeking a reliable and detail-oriented Warehouse Support Specialist to join our team in Guelph.About the RoleThis is a fantastic opportunity for someone looking to start or advance their career in logistics and supply chain management.In this role, you will be responsible for supporting the warehouse operations, ensuring that goods are received,...


  • Guelph, Ontario, Canada Linamar Corporation Full time

    Linamar Corporation is a dynamic and growing Canadian diversified global manufacturing company seeking an experienced Warehouse Operations Specialist.The successful candidate will play a key role in maintaining the necessary inventory levels of manufacturing supplies and tools to support production needs.This position is responsible for collecting, storing,...


  • Guelph, Ontario, Canada EMCO Corporation Full time

    Job SummaryWe are seeking a highly motivated and detail-oriented Warehouse Associate to join our team at EMCO Corporation. As a Warehouse Associate, you will be responsible for receiving and processing incoming shipments, picking and packing customer orders, and maintaining a safe and organized warehouse environment.

  • 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 Fraser Direct Full time

    We're seeking a skilled Warehouse Associate to join our team at Fraser Direct. As an Order Fulfillment Specialist, you'll play a crucial role in ensuring our customers receive their orders accurately and efficiently.Key Responsibilities:Pick and scan small items with a handheld device (RF Scanner) and place them with the correct order labelEnsure orders are...


  • Guelph, Ontario, Canada PDI Full time

    Job Summary:PDI is seeking a highly skilled and detail-oriented Warehouse Staff to join our team. As a key member of our warehouse operations, you will be responsible for ensuring the smooth and efficient flow of goods and materials.Responsibilities:Prepare shipping documents and enter shipping information into our Warehouse Management System.Prepare and...


  • Guelph, Ontario, Canada Well Full time

    About Well:We're a fast-growing, proudly Canadian essential business delivering wellness products and services to Canadians. Our goal is to provide quick, convenient, and hassle-free shopping experiences for our customers.In this role, you'll play a key part in picking, sorting, and packing orders for our customers. As a Warehouse Associate at Well, you'll...


  • Guelph, Ontario, Canada PDI Full time

    Job Summary:PDI is seeking a highly skilled and detail-oriented Warehouse Staff to join our team. As a key member of our warehouse operations, you will be responsible for ensuring the efficient and accurate processing of shipments, inventory management, and customer satisfaction.Responsibilities:Prepare shipping documents and enter shipping information into...


  • Guelph, Ontario, Canada Well Full time

    About Our CompanyWe are a fast-growing, proudly Canadian essential business providing fast home deliveries to all Canadians. With over 40,000 products and Canada's largest assortment of green & natural brands, we make it easy to make choices you can trust.Our MissionWe strive to cultivate leaders, promote work life balance, and the overall wellbeing of all...


  • Guelph, Ontario, Canada Linamar Corporation Full time

    Job SummaryWe are seeking a highly skilled Financial Data Clerk - Accounting Specialist to join our team at Linamar Corporation.


  • Guelph, Ontario, Canada Global Pharma Tek Full time

    Job DescriptionWe are seeking a highly skilled IT Infrastructure Specialist to join our team at Global Pharma Tek. This is an exciting opportunity for a seasoned professional to take on a challenging role in our Data Centre operations.


  • Guelph, Ontario, Canada Randstad Canada Full time

    We are seeking a reliable and safety-conscious Forklift Operator to join our team as an Order Picker. In this role, you will play a crucial part in the movement of materials through our indoor industrial environment. You will work closely with your team to organize and complete daily tasks while ensuring efficiency and safety.This is a 1-month contract...

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