![Avanti Software Inc.](https://media.trabajo.org/img/noimg.jpg)
Data Warehouse Administrator
3 weeks 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 OpportunityThe 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.
- 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
-
Data Warehouse Administrator
1 week ago
Guelph, Canada Royal Distributing Full timeAbout 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
3 weeks ago
Guelph, Canada Avanti Software Inc. Full timeWe'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...
-
Data Warehouse Administrator
3 weeks ago
Guelph, Canada Avanti Software Inc. Full timeWe'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...
-
Data Warehouse Administrator
3 weeks ago
Guelph, Canada Avanti Software Inc. Full timeWe'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...
-
Data Warehouse Administrator
2 weeks ago
Guelph, Canada Avanti Software Inc. Full timeWe'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...
-
Data Warehouse Administrator
2 weeks ago
Guelph, Canada Avanti Software Inc. Full timeWe'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...
-
Data Warehouse Architect
1 month ago
, ON, Canada 2i Solutions, Inc Full timeThere is a 6 months contract opportunity for Data Warehouse Architect in Hamilton, Ontario. Candidate must be enthusiastic about system architecture, big-data processing, data modelling, advanced quantitative data-driven models, data visualization, and performance optimization in large scale databases. Develop conceptual, logical, and physical data models as...
-
Data Warehouse Architect
13 hours ago
, ON, Canada 2i Solutions, Inc Full timeThere is a 6 months contract opportunity for Data Warehouse Architect in Hamilton, Ontario. Candidate must be enthusiastic about system architecture, big-data processing, data modelling, advanced quantitative data-driven models, data visualization, and performance optimization in large scale databases. Develop conceptual, logical, and physical data models as...
-
Data Warehouse Specialist
3 weeks ago
Toronto, ON, Canada Synechron Full timeWe are At Synechron, we believe in the power of digital to transform businesses for the better. Our global consulting firm combines creativity and innovative technology to deliver industry-leading digital solutions. Synechron’s progressive technologies and optimization strategies span end-to-end Artificial Intelligence, Consulting, Digital, Cloud &...
-
Data Warehouse Specialist
3 weeks ago
Toronto, ON, Canada Synechron Full timeWe are At Synechron, we believe in the power of digital to transform businesses for the better. Our global consulting firm combines creativity and innovative technology to deliver industry-leading digital solutions. Synechron’s progressive technologies and optimization strategies span end-to-end Artificial Intelligence, Consulting, Digital, Cloud &...
-
Data Warehouse Specialist
4 weeks ago
Toronto, ON, Canada Synechron Full timeWe areAt Synechron, we believe in the power of digital to transform businesses for the better. Our global consulting firm combines creativity and innovative technology to deliver industry-leading digital solutions. Synechron’s progressive technologies and optimization strategies span end-to-end Artificial Intelligence, Consulting, Digital, Cloud & DevOps,...
-
Data Warehouse Specialist
4 weeks ago
Toronto, ON, Canada Synechron Full timeWe areAt Synechron, we believe in the power of digital to transform businesses for the better. Our global consulting firm combines creativity and innovative technology to deliver industry-leading digital solutions. Synechron’s progressive technologies and optimization strategies span end-to-end Artificial Intelligence, Consulting, Digital, Cloud & DevOps,...
-
Data Warehouse Engineer
4 weeks ago
Mississauga, ON, Canada Synechron Full timeRole: Python Data Engineer(Databricks/Python/Pyspark, Azure) Mississauga, ON (hybrid/3 days in a week) - In Person Interview Overview: Looking for an Integration engineer responsible for daily support and project based development of credit risk management systems. ETL developers are responsible for designing and creating the data warehouse and all...
-
Data Warehouse Architect
2 weeks ago
, ON, Canada 2i Solutions, Inc Full timeThere is a 6 months contract opportunity for Data Warehouse Architect in Hamilton, Ontario. Candidate must be enthusiastic about system architecture, big-data processing, data modelling, advanced quantitative data-driven models, data visualization, and performance optimization in large scale databas
-
Data Warehouse Engineer
4 weeks ago
Mississauga, ON, Canada Synechron Full timeRole: Python Data Engineer(Databricks/Python/Pyspark, Azure)Mississauga, ON (hybrid/3 days in a week) - In Person Interview Overview:Looking for an Integration engineer responsible for daily support and project based development of credit risk management systems. ETL developers are responsible for designing and creating the data warehouse and all related...
-
Data Warehouse Engineer
4 weeks ago
Mississauga, ON, Canada Synechron Full timeRole: Python Data Engineer(Databricks/Python/Pyspark, Azure)Mississauga, ON (hybrid/3 days in a week) - In Person Interview Overview:Looking for an Integration engineer responsible for daily support and project based development of credit risk management systems. ETL developers are responsible for designing and creating the data warehouse and all related...
-
Data Warehouse Engineer
2 weeks ago
Mississauga, ON, Canada Synechron Full timeRole: Python Data Engineer(Databricks/Python/Pyspark, Azure)Mississauga, ON (hybrid/3 days in a week) - In Person Interview Overview:Looking for an Integration engineer responsible for daily support and project based development of credit risk management systems. ETL developers are responsible for designing and creating the data warehouse and all related...
-
Data Warehouse Engineer
2 weeks ago
Mississauga, ON, Canada Synechron Full timeRole: Python Data Engineer(Databricks/Python/Pyspark, Azure)Mississauga, ON (hybrid/3 days in a week) - In Person Interview Overview:Looking for an Integration engineer responsible for daily support and project based development of credit risk management systems. ETL developers are responsible for designing and creating the data warehouse and all related...
-
Data Warehouse Engineer
2 weeks ago
Mississauga, ON, Canada Synechron Full timeRole: Python Data Engineer(Databricks/Python/Pyspark, Azure)Mississauga, ON (hybrid/3 days in a week) - In Person Interview Overview:Looking for an Integration engineer responsible for daily support and project based development of credit risk management systems. ETL developers are responsible for designing and creating the data warehouse and all related...
-
Warehouse Supervisor
4 days 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,...