Data Warehouse Specialist

1 month ago

Québec, Canada Apptad Inc Full time

**Job Title**:Data Warehouse Specialist
**Job Location**: Mississauga, ON & Montreal, QC (Need Onsite day 1 Hybrid/ 3 days from office).
**Job Duration**:Long-Term

**Technical skills -**
- Top skills: snowflake architecture, snowSQL (Strong background), data factory (ADF) - need capital market experience (equity/fixed income space) - python outbound, inbound analysis and sql part of it - financial industry experience
- Nice to haves - understanding of CI/CD pipeline, python, concepts of warehousing

**Primary Responsibilities**
- 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 features such as Snow SQL; Snow Pipe; Python; Tasks; Streams; Time travel; Zero Copy Cloning; Optimizer; Metadata Manager; data sharing; and stored procedures.
- Experience in Data warehousing - OLTP, OLAP, Dimensions, Facts, and Data modeling.
- Need to have working knowledge of MS Azure configuration items with respect to Snowflake.
- Developing EL pipelines in and out of data warehouse using combination of Data bricks, Python and Snow SQL.
- Developing scripts UNIX, Python etc. to Extract, Load and Transform data, as well as other utility functions.
- Provide production support for Data Warehouse issues such data load problems, transformation translation problems
- Translate mapping specifications to data transformation design and development strategies and code, incorporating standards and best practices for optimal execution.
- Understanding data pipelines and modern ways of automating data pipeline using cloud based testing and clearly document implementations, so others can easily understand the requirements, implementation, and test conditions.
- Perform code reviews to ensure fit to requirements, optimal execution patterns and adherence to established standards.

**Basic Qualifications**
- Minimum 4 years of designing and implementing an operational production grade large-scale data solution on Microsoft Azure Snowflake Data Warehouse.
- Including hands on experience with productionized data ingestion and processing pipelines using Python, Data bricks, Snow SQL
- Excellent understanding of Snowflake Internals and integration of Snowflake with other data processing and reporting technologies
- Excellent presentation and communication skills, both written and verbal, ability to problem solve and design in an environment with unclear requirements.

**Job Type**: Fixed term contract

**Salary**: $55.00-$60.00 per hour

Schedule:

- Monday to Friday

**Experience**:

- data warehouse: 8 years (preferred)
- ETL: 4 years (preferred)
- Python: 4 years (preferred)
- SNOWFLAKE: 3 years (preferred)

  • Warehouse & Distribution Specialist - Hybrid

    2 months ago

    Québec, Canada Ateeca Full time

    **Job Title: Warehouse & Distribution Specialist** **Location: Hybrid (Montreal, QC)** **Duration: 12+ months** - Prioritize the on-going shipping process with 3PL according to commercial needs. - Collaborate to identify potential cost efficiency opportunities for warehousing and distribution. - Actively participate in MBR & QBR and support vendor...

  • Data Warehouse Project Management Consultant

    1 month ago

    Québec City, Canada ITI Full time

    DESCRIPTION DU CLIENT Nous mettons à profit l’intelligence humaine, organisationnelle, opérationnelle, pas juste artificielle Établie depuis 1991, ITI offre des services et solutions technologiques allant du conseil stratégique en TI à l’implantation de solutions en passant par l’approvisionnement et la gestion d’infrastructure TI...

  • Data Warehouse Project Management Consultant

    5 days ago

    Québec City, Canada ITI Full time

    DESCRIPTION DU CLIENT Nous mettons à profit l’intelligence humaine, organisationnelle, opérationnelle, pas juste artificielle Établie depuis 1991, ITI offre des services et solutions technologiques allant du conseil stratégique en TI à l’implantation de solutions en passant par l’approvisionnement et la gestion d’infrastructure TI...

  • Accounts Payable Specialist, Na

    3 days ago

    Québec, Canada Vantage Data Centers Full time

    About Vantage Data Centers Vantage is committed to being a workplace of inclusion, equity, respect and acceptance. We celebrate diversity and intentionally seek out opportunities to learn from one another’s experience. Vantage Data Centers powers, cools, protects and connects the technology of the world’s well-known hyperscalers, cloud providers and...

  • Accounts Payable Specialist, Na

    2 months ago

    Québec, Canada Vantage Data Centers Full time

    About Vantage Data Centers Vantage is committed to being a workplace of inclusion, equity, respect and acceptance. We celebrate diversity and intentionally seek out opportunities to learn from one another’s experience. Vantage Data Centers powers, cools, protects and connects the technology of the world’s well-known hyperscalers, cloud providers and...

  • Data Specialist

    2 weeks ago

    Québec City, Canada LeddarTech Full time

    YOUR MISSION Improve the data lifecycle (40%) Study and assess current data infrastructure and propose a plan to integrate current systems to a desired future state based on LeddarTech business visionProvide recommendation to data engineering team to improve tools and process, and pipelineResponsible to create and update the procedure of a specific process...

  • Data Specialist

    6 days ago

    Québec City, Canada LeddarTech Full time

    YOUR MISSION Improve the data lifecycle (40%) Study and assess current data infrastructure and propose a plan to integrate current systems to a desired future state based on LeddarTech business visionProvide recommendation to data engineering team to improve tools and process, and pipelineResponsible to create and update the procedure of a specific process...

  • Network Specialist, Global

    2 months ago

    Québec City, Canada Vantage Data Centers Full time

    About Vantage Data Centers Vantage is committed to being a workplace of inclusion, equity, respect and acceptance. We celebrate diversity and intentionally seek out opportunities to learn from one another’s experience. Vantage Data Centers powers, cools, protects and connects the technology of the world’s well-known hyperscalers, cloud...

  • Commis D'entrepÔt

    2 weeks ago

    Québec, Canada Boutique Espresso Mali Full time

    **: - OFFRE D'EMPLOI / JOB POSTING --** **COMMIS D’ENTREPÔT - JOUR - TEMPS PLEIN / WAREHOUSE CLERK - DAY - FULL TIME** **Boutique Espresso Mali** **Montréal, QC.** **COMMIS D’ENTREPÔT ** _English version follows**_ Salaire : $18 - $21 de l’heure Temps Plein, Poste Permanant Horaire : 9 :00 - 17 :00 du lundi au vendredi La Boutique Espresso...

  • Warehouse Material Coordinator

    4 weeks ago

    Québec, Canada Fed Supply Full time

    Hello ! I'm Anissa, Recruitment Consultant for Fed Supply, an employment agency specializing in supply chain, logistics, transportation and customer service - offering temporary and permanent jobs in the Greater Montreal area. Our team, experts in Supply Chain and Logistics, speaks your language and evolves in your world. Bonjour ! Je suis Anissa,...

  • Data Governance Advisor

    1 month ago

    Québec, Canada BRP Full time

    BRP is seeking a Data Governance Advisor to play an active role in establishing the data governance landscape at BRP. This position will be responsible for deploying and enforcing policies and procedures that ensure data is used and maintained properly. This includes performing business process analysis, identifying gaps and inefficiencies, and proposing...

  • Data Specialist

    6 days ago

    Québec City, Canada Canadian Medical Assocation Full time

    Job Details Description Unit | Department: Advocacy Engagement & Governance l Membership Reports to: Advisor, Member Services and Support, Membership Type: Full-Time l Permanent Location Options: Ottawa, Ontario (Hybrid) or Toronto, Ontario (Hybrid) or Ontario, Canada (Remote) or Quebec, Canada (Remote) What makes you a great fit...

  • Lead Data Analyst

    2 months ago

    Québec, Canada MindGeek Careers Full time

    The Data Warehouse Services team plays a vital role in our organization. They are responsible for storing vast quantities of data from many sources and responsible for disseminating data across the organizations to various different groups. They are one of the backbones of data at our organization and they are seeking a Team Lead Data Analyst to join their...

  • Specialist Procurement

    1 month ago

    Québec, Canada Centre de production de produits biologiques (CPPB) Inc. Biologics Manufacturing Centre (BMC) Inc. Full time

    The Biologics Manufacturing Centre (BMC) Inc. is a new biomanufacturing facility whose construction was completed in June 2021. The BMC, a not-for-profit organization, supports the expansion of Canada’s biologics manufacturing capacity, ensuring that vaccines and other biologics products can be safely manufactured at home. The BMC is designed to produce...

  • Training Data Specialist

    2 months ago

    Québec, Canada SII Technologies GmbH HR-Service Full time

    Partenaire technologique des grandes entreprises depuis 1979, le Groupe SII est au cœur de l'économie de l'innovation avec 10 000 collaborateurs, une présence internationale dans 20 pays, et un chiffre d’affaires supérieur à 520 millions de dollars canadiens. SII Canada, installée à Montréal et Toronto, a pour objectif d'apporter des solutions à...

  • SEO Specialist

    2 months ago

    Québec, Canada Aylo Careers Full time

    Established in 2004, we are a tech pioneer offering world-class adult entertainment and games on some of the internet's safest and most popular platforms. With the support of an international team of dynamic and collaborative innovators, we are on a mission to enable safe user experiences and empower our communities by celebrating diversity, inclusion, and...

  • Data Governance Advisor

    2 months ago

    Québec, Canada BRP Full time

    BRP is seeking a Data Governance Advisor to play an active role in establishing the data governance landscape and its program at BRP. This position will be responsible for deploying and enforcing policies and procedures that ensure data is used and maintained properly. This includes performing business process analysis, identifying gaps and inefficiencies,...

  • Accounts Payable Specialist-spécialiste Des

    3 weeks ago

    Québec Province, Canada DAVIDsTEA Full time

    Accounts Payable Specialist-spécialiste Des - Mont-royal, Canada - DAVIDsTEA DAVIDsTEA is a leading branded retailer and growing wholesaler of specialty loose leaf tea, offering a selection of signature blends, single-origin teas, and tea-related gifts and accessories through our e-commerce platform and 18 Canadian retail stores. We're making tea...

  • Data Management Lead

    2 months ago

    Québec, QC, Canada Hitachi Automotive Systems Americas, Inc. Full time

    Customer Success specialist page is loaded Customer Success specialist Apply locations Quebec, Quebec, Canada time type Full time posted on Posted 2 Days Ago job requisition id R0043554 Location: HITACHI ENERGY CANADA INC. Communications & Corporate Affairs Job Schedule:  Full time Remote: Hitachi Energy is looking for a customer success...

  • Graduate-data Analyst

    2 weeks ago

    Québec, Canada SITA Switzerland Sarl Full time

    Overview: **_Welcome to SITA_**: Ready to redefine air travel? The journey starts here, with you at SITA. **_ ABOUT THE ROLE & TEAM:_** We specialize in making flight operations, air traffic management, and aircraft maintenance more efficient, helping our customers to improve their operations and supporting them on their sustainability goals. We are looking...