Data Warehouse Administrator
6 months ago
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.
- 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.
- 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 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
- This position reports to the CTO
- This is a full-time 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.
-
Data Warehouse Administrator
3 months ago
Guelph, Canada Avanti Software Inc. Full timeWe provide our customers with quality products and top service to keep them riding their snowmobiles, ATVs, motorcycles, dirt bikes and more. p>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...
-
Data Warehouse Architect
6 days ago
Guelph, Ontario, Canada Avanti Software Inc. Full timeAt Avanti Software Inc., we're seeking a highly skilled Data Warehouse Architect to join our team in Guelph, Ontario.About the RoleThis is a full-time position with an estimated salary of $80,000 - $110,000 per year. The successful candidate will be responsible for designing and implementing data warehouses, data marts, and cubes using Microsoft Snowflake or...
-
Data Warehouse Specialist
1 month ago
Guelph, Ontario, Canada Avanti Software Inc. Full timeThe 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...
-
Data Warehouse Architect
3 weeks ago
Guelph, Ontario, Canada Avanti Software Inc. Full timeWe 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...
-
Data Warehouse Specialist
4 weeks ago
Guelph, Ontario, Canada Avanti Software Inc. Full timeAbout 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...
-
Warehouse Supervisor
6 months ago
Guelph, Canada RLB LLP Full timeOur Client, **Royal City Warehousing**, in **Guelph**, is looking for a **Warehouse Supervisor** to manage and oversee all warehouse activities, ensure efficient processes, and maximize warehouse productivity. Reporting to the office Bookkeeper, the warehouse Supervisor's responsibilities include supervising employees, coordinating logístical processes,...
-
Assistant Manager Warehouse
6 months ago
Guelph, 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...
-
Non-ferrous Warehouse Associate
6 months ago
Guelph, Canada Benmet Steel and Metal Full timeBenmet Steel & Metal is a leader in the Canadian scrap and recycling industry located in the heart of Guelph, ON. We are one of the most established and reputable independent scrap metal processors in Ontario. We are looking for experienced and knowledgeable individuals to join our growing team. Founded in 1956, Benmet Steel & Metal’s roots are in...
-
Non-ferrous Warehouse Associate
6 months ago
Guelph, Canada Benmet Steel and Metal Full time_**Interview, hire, train, promote.**_ **Are you interested in a lucrative and rewarding career path in the metal recycling industry?** **Are you interested in a commodity based role with worldwide reach?** **If you are driven and want a rewarding career on the front line of environmental change, then this is the company for you!** **What we do** Benmet...
-
Non-ferrous Warehouse Associate
1 month ago
Guelph, Canada Benmet Steel and Metal Full time_**Interview, hire, train, promote.**_ **Are you interested in a lucrative and rewarding career path in the metal recycling industry?** **Are you interested in a commodity based role with worldwide reach?** **If you are driven and want a rewarding career on the front line of environmental change, then this is the company for you!** **What we do** Benmet...
-
Non-ferrous Warehouse Associate
3 months ago
Guelph, Canada Benmet Steel and Metal Full time_**Interview, hire, train, promote.**_ **Are you interested in a lucrative and rewarding career path in the metal recycling industry?** **Are you interested in a commodity based role with worldwide reach?** **If you are driven and want a rewarding career on the front line of environmental change, then this is the company for you!** **What we do** Benmet...
-
Non-ferrous Warehouse Associate
6 months ago
Guelph, Canada Benmet Steel and Metal Full time_**Interview, hire, train, promote.**_ **Are you interested in a lucrative and rewarding career path in the metal recycling industry?** **Are you interested in a commodity based role with worldwide reach?** **If you are driven and want a rewarding career on the front line of environmental change, then this is the company for you!** **What we do** Benmet...
-
Counter/warehouse Associate
6 months ago
Guelph, Canada Westburne Full time**Westburne** is much more than electrical products. We are Canada’s market leader in energy solutions, renewables, lighting, wire & cable, automation and connected network solutions. We have access to the best partners in the industry and we go above and beyond to help our customers and partners grow. To learn more about **Westburne**, please visit us at...
-
Non-ferrous Warehouse Associate
6 months ago
Guelph, Canada Benmet Steel and Metal Full time_**Interview, hire, train, promote.**_ **Are you interested in a lucrative and rewarding career path in the metal recycling industry?** **Are you interested in a commodity based role with worldwide reach?** **If you are driven and want a rewarding career on the front line of environmental change, then this is the company for you!** **What we do** Benmet...
-
Warehouse Associate
6 months ago
Guelph, Canada Fraser Direct Full timeWarehouse Associate, Afternoons, Guelph, Full-time | Pay Rate $17.00-$18.00 per hour Come for a job and stay for a career! We 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...
-
Office Administrator
6 months ago
Guelph, Canada Well.ca Inc Full timeThe role of Office Administrator is responsible for all daily functions within the warehouse and office. In addition to acting as the primary liaison between the company’s departments, this role manages all administrative tasks in the Guelph location. **Location**:Guelph, ON **Responsibilities**: - Labour planning, warehouse scheduling - Order and...
-
Warehouse Associate
6 months ago
Guelph, Canada Fraser Direct Full timeWarehouse Associate, Days, Guelph, Full-time | Pay Rate $17.00-$18.50 per hour Come for a job and stay for a career! We 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...
-
Warehouse Associate
5 months ago
Guelph, Canada Fraser Direct Full timeWarehouse Associate, Afternoons, Guelph, Full-time | Pay Rate $17.00-$18.00 per hour Come for a job and stay for a career! We 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...
-
Warehouse Associate, Team Lead
3 months ago
Guelph, Canada DB Schenker Full timeAt DB Schenker, you are part of a global logistics network that connects the world. A network that allows you to shape your career by encouraging you to contribute and truly make a difference. With more than 76,000 colleagues worldwide, we welcome diversity and thrive on individual backgrounds, perspectives and skills. Together as one team, we are Here to...
-
Data and Analytics Specialist
1 month ago
Guelph, Canada The City of Guelph Full timeWhy Guelph: **What we offer** We offer competitive wages and comprehensive benefits to meet the needs of our diverse employees. Many of our positions offer: - Paid vacation days, increasing with years of service - Paid personal days; - Hybrid and flexible work arrangements; - Defined benefit pension plan with OMERS, including 100-per-cent employer...