Data Warehouse Administrator

1 week ago

Guelph, Ontario, Canada Royal Distributing Full time
About Us

We're Royal Distributing, and we've been a leader in the Canadian powersports industry for the past 30 years.

We provide our customers with quality products and top service to keep them riding their snowmobiles, ATVs, motorcycles, dirt bikes and more.

We're embarking on the next phase of our growth, and we want you to join us

The Opportunity

The Data Warehouse Administrator will support the implementation and integration of data warehouses, data marts, and cubes.

Additionally, the Data Warehouse Administrator will perform data warehouse design and construction; perform extensive testing, as well as ETL and repository creation.

This position will coordinate with other team members and managers to translate business needs into technical solutions.

This position will troubleshoot issues in cubes, ETL packages and databases to identify and solve problems with data accuracy and performance.

This position will ensure that data sources are presented to business analysts to provide key data to business stakeholders.

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.
  • Will 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.
  • Additional duties as assigned.

Qualifications:

  • Bachelors 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 multidatabase 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
Additional Information

  • This position reports to the CTO
  • This is a fulltime position scheduled from Monday to Friday, may be needed outside regular business hours when required
  • This position is located at our head office in Guelph, Ontario, can be a hybrid working arrangement


We are an equal opportunity employer and while we thank everyone for their interest, only those to be interviewed will be contacted.

Royal Distributing is committed to promoting accessible recruitment as outlined in the Accessibility for Ontarians with Disabilities Act.

Royal Distributing will attempt to accommodate persons with a disability in an appropriate and effective manner throughout all stages of the recruitment process.

Accommodations will be provided upon request.

Company

Royal Distributing

Location

Guelph - Head Office

Opening Date

May 10, 2024

  • Data Warehouse Administrator

    1 week ago

    Guelph, Ontario, Canada Avanti Software Inc. Full time

    We provide our customers with quality products and top service to keep them riding their snowmobiles, ATVs, motorcycles, dirt bikes and more. The Data Warehouse Administrator will support the implementation and integration of data warehouses, data marts, and cubes. Additionally, the Data Warehouse Administrator will perform data warehouse design and...

  • Assistant Manager Warehouse

    1 week ago

    Guelph, Ontario, Canada Sharpe Farm Supplies Full time

    Duties: Operational management fof warehouse activities Supervise and lead a team of warehouse and delivery employees, including training, performance evaluation, and scheduling. Foster a positive and productive work environment, promoting teamwork and high morale. Ensure compliance with all relevant local, provincial, and federal regulations regarding the...

  • Warehouse Associate

    1 week ago

    Guelph, Ontario, Canada Fraser Direct Full time

    Warehouse Associate, Days, Guelph, Full-time | Pay Rate $17.00-$18.50 per hourCome for a job and stay for a careerWe are a family-owned rapidly growing boutique fulfillment company that helps keep Canadian commerce growing. Come join a winning team and workplace community where having fun is a must, but safety is always first Pay rate: Starting at $17.00 per...

  • Warehouse Generalist

    1 week ago

    Guelph, Ontario, Canada Unisync Group Limited Full time

    Unisync Group Limited provides full-service, manage apparel programs for major corporations and government-related entities through operations across Canada and the United States. Our customer base includes many iconic corporate brands such as Air Canada, Westjet, Canadian Coast Guard, Purolator, Petro Canada, Home Hardware, Alaska Airlines, etc. and a broad...

  • Logistics & Warehouse Manager

    1 week ago

    Guelph, Ontario, Canada EightSix Network Inc Full time

    Logistics & Warehouse Manager (Bilingual French / English)Location: Guelph, ON or St-Hubert, QC Would you like to be a part of a revolution in agriculture in Canada? At GoodLeaf Farms we are a proud Canadian company at the forefront of innovation, striving to grow food security for communities from coast to coast. We are focused on producing ultra-fresh...

  • Administrative Assistant

    1 week ago

    Guelph, Ontario, Canada Triton Environmental Consultants Full time

    What if you could work alongside inspiring scientists, managers, and thought leaders, using state-of-the-art equipment, with diverse people working toward a common goal? Are you looking for a place where you can be you, a place where you can thrive? Triton might be just what you're looking for.THE OPPORTUNITYTriton Environmental Consultants Ltd. ("Triton")...

  • Warehouse Generalists- Day and Afternoon Shifts

    1 week ago

    Guelph, Ontario, Canada Unisync Group Limited Full time

    Unisync Group Limited provides full-service, manage apparel programs for major corporations and government-related entities through operations across Canada and the United States. Our customer base includes many iconic corporate brands such as Air Canada, Westjet, Canadian Coast Guard, Purolator, Petro Canada, Home Hardware, Alaska Airlines, etc. and a broad...

  • Business Operations Administrator

    1 week ago

    Guelph, Ontario, Canada Well Full time

    Are you ready to lead the charge in shaping the future of our warehouse operations? At , we're seeking a dynamic and visionary Director of Operations to spearhead our day-to-day activities with a focus on excellence, innovation, and safety. Lead and inspire our dedicated team of Managers, Supervisors, Team Leads, and associates, fostering a culture of...

  • Head Office Administrator and Data Input

    1 week ago

    Guelph, Ontario, Canada Patene Building Supplies Ltd Full time

    Patene Building Supplies Ltd. is a distributor of drywall, steel framing components, insulation, acoustic ceilings, shingles, masonry and other building materials for the residential and commercial construction industries. We have thirteen (13) branch locations throughout Ontario & Manitoba to serve our contractor, builder and retail customers.We are...

  • Warehouse Labourer

    1 week ago

    Guelph, Ontario, Canada Ceva Animal Health Full time

    Ceva is seeking a Warehouse Operator who is passionate about on-time delivery and providing exceptional customer service to join our teamAbout UsCeva Animal Health Canada established itself in Canada with the acquisitions of CentaurVA Animal Health and Vetech Laboratories in October 2011. Our Canadian presence expanded during 2019 when we acquired IDT...

  • Meter Data Coordinator

    1 week ago

    Guelph, Ontario, Canada The MEARIE Group Full time

    The OpportunityJob Posting Number: Position:Meter Data CoordinatorLocation:Guelph (Southgate) (Hybrid: Remote/In-office)**Reports to:Manager, AMIOBusiness Group:Customer ExperienceDivision:Network MeteringHours per Week:35Rate of Pay:$34.30/hr - $50.21/hrNumber of Openings:1Union:IBEW (Guelph)Open:June 10, 2024Close:June 21, 2024 Alectra is committed to...

  • Class 1 Data Entry

    1 week ago

    Guelph, Ontario, Canada UNITED PARCEL SERVICE Full time

    Primary Job Posting Location:Guelph, Ontario CanadaExplore your next opportunity at a Fortune Global 500 organization. Envision innovative possibilities, experience our rewarding culture, and work with talented teams that help you become better every day. We know what it takes to lead UPS into tomorrow—people with a unique combination of skill + passion....

  • Gestionnaire de la data sociale

    1 week ago

    Guelph, Ontario, Canada Skyline Group of Companies Full time

    This individual will be required to work a schedule of Tuesday to Saturday. Our Rental Applications Administrators are responsible providing administrative support to Skyline's business operations. Working as an integral component of the Skyline team, this position assists business operations through follow up, research, and analysis of rental applications,...

  • Gestionnaire de la data sociale

    1 week ago

    Guelph, Ontario, Canada Skyline Group of Companies Full time

    This individual will be required to work a schedule of Tuesday to Saturday.Our Rental Applications Administrators are responsible providing administrative support to Skyline's business operations. Working as an integral component of the Skyline team, this position assists business operations through follow up, research, and analysis of rental applications,...

  • Dba (Database Administrator)

    1 week ago

    Guelph, Ontario, Canada Compusense Inc. Full time

    Education: College/CEGEP Experience: Will train- or equivalent experienceTasks: Design, construct, modify, implement and test data models and database management systems Develop and implement data administration policy, standards and models Research and document data requirements, data collection and administration policy, and data access rules Write scripts...

  • Class 1 Data Entry

    1 week ago

    Guelph, Ontario, Canada UNITED PARCEL SERVICE Full time

    Primary Job Posting Location:Guelph, Ontario CanadaExplore your next opportunity at a Fortune Global 500 organization. Envision innovative possibilities, experience our rewarding culture, and work with talented teams that help you become better every day. We know what it takes to lead UPS into tomorrow—people with a unique combination of skill + passion....

  • Human Resources Administrator

    1 week ago

    Guelph, Ontario, Canada COMMUNITY LIVING GUELPH WELLINGTON Full time

    Human Resources AdministratorDo you like collaborating with others to come up with solutions? Do you enjoy analyzing data and improving processes? Are you customer focused and detailed orientated? If so, then we have a position for youCome work with usWe are looking for a motivated, results-oriented and enthusiastic person who sees the value in every person....

  • project administration officer

    1 week ago

    Guelph, Ontario, Canada Harrington Construction (2011) Limited Full time

    Education: College, CEGEP or other non-university certificate or diploma from a program of 1 year to 2 yearsExperience: 1 year to less than 2 years or equivalent experienceTasksImplement new administrative procedures Review and evaluate new administrative procedures Delegate work to office support staffEstablish work priorities and ensure procedures are...

  • project administration officer

    1 week ago

    Guelph, Ontario, Canada Harrington Construction (2011) Limited Full time

    Education: Expérience: EducationCollege, CEGEP or other non-university certificate or diploma from a program of 1 year to 2 years or equivalent experienceTasksImplement new administrative procedures Review and evaluate new administrative procedures Delegate work to office support staffEstablish work priorities and ensure procedures are followed and...

  • Administrative Assistant

    1 week ago

    Guelph, Ontario, Canada Royal City Nursery Full time

    Royal City Nursery's Part-Time Administration team acts as a liaison with multiple departments to ensure day to day activities and office tasks are completed. Overall responsibilities include supporting our Administrator with data entry, label creation and other administration tasks.Responsibilities Data entry, including receiving of products and inventory...