Current jobs related to Data Warehouse Administrator - Guelph Ontario LE, Durham region - Avanti Software Inc.

  • Compensation Consultant

    1 week ago

    Guelph, Ontario, L1E, Durham region, Canada University of Guelph Full time

    Department: HR Services This position is represented by the agreement between the Professional Staff Association and the University of Guelph Temporary full-time from 11/25/2024 to 11/25/2025 Join the compensation team and contribute to meeting an increasing demand for in-depth quantitative and qualitative analysis of the University’s compensation...

  • Assistant Coach, Women's Hockey

    1 week ago

    Guelph, Ontario, L1E, Durham region, Canada University of Guelph Full time

    Department: Athletics This position is represented by the agreement between the Professional Staff Association and the University of Guelph Temporary full-time from 11/04/2024 to 11/03/2026 General Purpose Reporting to the Head Coach, Women’s Hockey, the Assistant Coach of the Gryphon Women’s Hockey Program helps to lead one of the Department’s...

  • Senior Software Engineer, Payments

    4 days ago

    Bowmanville, Ontario, L1E, Durham region, Canada Ripple Labs Full time

    At Ripple, we're building a world where value moves like information does today. It's big, it's bold, and we're already doing it. Through our crypto solutions for financial institutions, businesses, governments and developers, we are improving the global financial system and creating greater economic fairness and opportunity for more people,...

  • Warehouse Manager

    1 week ago

    Mississauga, Ontario, Peel region, Canada Conerstone Part time

    You are expected to play a very important role as a warehouse Manager in our Organization Cornerstone Industries. It is such a Vital Role because it is crucial to our daily operations as a manufacturing and supply incorporation.Your Duty is to supervise the receipt, dispatching, and storage of a company's incoming and outgoing goods and supplies. This...

  • Data Engineer

    1 week ago

    Concord, Ontario, L0A, Durham region, Canada Magna International Full time

    Job Number: 69510 Group: Magna Exteriors Division: Co-Ex-Tec Job Type: Permanent/Regular Location: CONCORD Work Style: About us We see a future where everyone can live and move without limitations. That’s why we are developing technologies, systems and concepts that make vehicles safer and cleaner, while serving our communities, the planet and,...

  • Azure Data Architect

    1 week ago

    Mississauga, Ontario, Peel region, Canada PEOPLE FORCE CONSULTING INC Full time

    Job Title : Data Architect - AzureLocation: Mississauga/Downtown Toronto (Onsite Hybrid -three days onsite per week)Duration : Full TimeMandatory skills:- AzureAzure Data LakeAzure Data BricksAzure Data FactoryData ArchitectData background- Data Modeler/Data engineerJob Description :-You will be part of our Data Strategy and Engineering team to architect...

  • Warehouse Supervisor

    1 week ago

    Vaughan, Ontario, York region, Canada Pivotal Integrated HR Solutions Full time

    Warehouse Operations SupervisorOur client a growing 3PL is currently searching for a Warehouse Operations Supervisor for their new facility in the Vaughan area.Responsibilities:Oversee daily warehouse operations, including receiving, inventory management, and shipping activities.Develop and implement standard operating procedures (SOPs) to enhance...

  • Data Engineer

    2 months ago

    Mississauga, Ontario, Peel region, Canada Synechron Full time

    Role: Datawarehouse SpecialistLocation: Mississauga, ON ( 3 days Hybrid)Experience:8+yearsJob Type: FulltimeResponsibilities:Strong understanding or Snowflake on Azure Architecture, design, implementation and operationalization of large-scale data and analytics solutions on Snowflake Cloud Data Warehouse.Hands-on development experience with Snowflake...

  • Data Architect

    1 month ago

    Mississauga, Ontario, Peel region, Canada Quantum Technology Recruiting Inc. Full time

    Position: Data ArchitectType: Fulltime Perm (Flexible Salary)Location: Hybrid (three days onsite per week, between the Mississauga and downtown Toronto office)You will be part of our Data Strategy and Engineering team to architect large scale data driven engagements and provide direction as the subject matter expert in Azure, AWS and SQL Server Data...

  • Senior Data Engineer

    2 days ago

    Mississauga, Ontario, Peel region, Canada RAPS Consulting Inc Full time

    Role: Senior Data Engineer We are seeking an experienced Data Engineer with a strong background in Snowflake and SQL to join our technology team. The ideal candidate will be responsible for developing, optimizing, and maintaining our Snowflake data warehouse environment to support financial data analysis and reporting needs. The role requires a deep...

  • Data Engineer with Python

    2 months ago

    Mississauga, Ontario, Peel region, Canada Synechron Full time

    Role: Python Data Engineer(Databricks/Pyspark, SQL, Azure)Mississauga, ON (hybrid/3 days in a week)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 extraction, transformation...

  • Data Engineer

    1 week ago

    Mississauga, Ontario, Peel region, Canada Synechron Full time

    Position : Data EngineerLocation : Mississauga, ONExperience : 8 plus yearsType : Hybrid (2-3 days from office)Job Description: We are seeking an experienced Data Engineer with a strong background in Snowflake and SQL to join our technology team. The ideal candidate will be responsible for developing, optimizing, and maintaining our Snowflake data warehouse...

  • Data Engineer

    1 week ago

    Markham, Ontario, York region, Canada Compunnel Inc. Full time

    Data EngineerMarkham ON3 Days Onsite / WeekFulltime / ContractWhat you’ll bringEducation: Bachelor's in computer engineering or computer science.Experience: Over 8 years of experience in designing solutions for data lakes, data integrations, and data warehouses/marts.Technical Skills: Proficient with data technologies and tools such as Hadoop,...

  • Warehouse Supervisor

    4 days ago

    Brampton, Ontario, Peel region, Canada Skjodt-Barrett Foods Full time

    Who we areSkjodt-Barrett is a world-class manufacturer of food solutions and custom ingredients for North America's most beloved and trusted brands. We take pride in working closely with our customers to understand their unique needs and create innovative, individualized solutions that deliver joy to their customers.A family-founded company started over...

  • Application Database Administrator

    1 week ago

    North Bay, Ontario, Nipissing region, Canada Resonaite Full time

    Our client in the social services industry is looking for a Database Admin/Management Location: Primarily remote, with occasional team meeting in North BayResponsibilitiesProvide in-depth operational support and participate in the architecture, deployment, and management of on premise and cloud-based databases, systems, and services in a geographically...

  • Data Engineer

    1 week ago

    Mississauga, Ontario, Peel region, Canada Synechron Full time

    We 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,...

  • Warehouse Supervisor

    1 month ago

    Penetanguishene, Ontario, L4R, Simcoe region, Canada Magna International Full time

    About us We see a future where everyone can live and move without limitations. That’s why we are developing technologies, systems and concepts that make vehicles safer and cleaner, while serving our communities, the planet and, above all, people. Forward. For all. Group Summary The Mechatronics, Mirrors and Lighting group specializes in automotive...

  • Human Resource Associate

    1 week ago

    Whitby, Ontario, L1B, Durham region, Canada Durham District School Board Full time

    Human Resource Associate Employee Information ManagementJob Purpose Employee records administration, while ensuring compliance with DDSB policies, procedures, legislation and up to fifteen (15) collective or employee agreements. Provide front-line customer service to employee and management queries and requests for information. Responsible for providing...

  • Bilingual Data Analyst

    14 hours ago

    Markham, Ontario, York region, Canada Altis Technology Full time

    Our leading non-profit client is looking for a Bilingual Data Analyst (French/English) to join their team! This will be a full-time permanent position (35 hours/week) with one day a week on site.The Data Analyst is responsible for managing and maintaining data within the organization. This role supports various departments by ensuring data is accurate,...

  • Human Resources Supervisor- Nights

    1 month ago

    Concord, Ontario, L0A, Durham region, Canada Magna International Full time

    Job Number: 68521 Group: Magna Exteriors Division: Co-Ex-Tec Job Type: Permanent/Regular Location: CONCORD Work Style: About us We see a future where everyone can live and move without limitations. That’s why we are developing technologies, systems and concepts that make vehicles safer and cleaner, while serving our communities, the planet and,...

Data Warehouse Administrator

3 months ago

Guelph Ontario LE, Durham region, Canada Avanti Software Inc. Full time

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

Additional Information

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

#J-18808-Ljbffr