Data Warehouse Specialist

3 days ago

Montréal, Canada AppTad Technologies Pvt Ltd Full time

**Job Title**:Data Warehouse Specialist
**Job Location**: Montreal, Mississauga, Ontario Canada &Montreal, Québec, Canada (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.

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

**Benefits**:

- Dental care
- Life insurance
- Paid time off

Schedule:

- Monday to Friday
- Morning shift

Ability to commute/relocate:

- Montréal, QC: reliably commute or plan to relocate before starting work (required)

**Education**:

- Secondary School (preferred)

**Experience**:

- warehouse: 4 years (required)
- Capital Market: 2 years (required)
- SQL: 3 years (required)
- ADF: 2 years (required)

Licence/Certification:

- CCDA (preferred)

  • Data Warehouse Specialist

    3 weeks ago

    Montréal, Canada Infocodec Solutions Full time

    We are looking to hire **Data Warehouse Specialist** with a financial background. Who will play a crucial role in leveraging a cloud-based data warehousing platform, to manage and analyze financial data. **Basic Qualifications**: - Overall 10+ years of experience is required. - Minimum 3 years of experience in design and implementation of large-scale data...

  • Data Warehouse

    2 weeks ago

    Montréal, Canada UST Full time

    **Data Warehouse** **Lead I - Software Engineering **Who we are**: Born digital, UST transforms lives through the power of technology. We walk alongside our clients and partners, embedding innovation and agility into everything they do. We help them create transformative experiences and human-centered solutions for a better world. UST is a mission-driven...

  • Client Production Specialist

    4 weeks ago

    Montréal, Canada Canada Data Communications Management Corp. Full time

    **Title**:Client Production Specialist **Type**:Full Time, Permanent **Location**:1500 Saint-Patrick, Montreal **Reports to**:Client Services Manager **QUALIFICATIONS** - Rsponsible for leading and providing product and service expertise during all the coordination and project management activities associated on client accounts that have been assigned on an...

  • Specialist Data Design

    2 weeks ago

    Montréal, Canada Canadian National Railway Full time

    At CN, we work together to move our company—and North America—forward. Be part of our Information & Technology (I&T) team, a critical piece of the engine that keeps us in motion. From enterprise architecture to operational technology, our teams use the agile methodology to automate and digitize our railroad ensuring our operations run optimally and...

  • Network Specialist

    2 weeks ago

    Montréal, Canada Estruxture Data Centers Full time

    **The position can be based in Calgary, Montreal, Toronto or in Vancouver / Le poste peut être basé à Calgary, Montréal, Toronto ou Vancouver.** - ** La version française suit la version anglaise **_ **We host the data. We provide the connections. We protect the information.** Everything starts with our dedicated and talented team. As an award-winning...

  • Network Specialist

    3 weeks ago

    Montréal, Canada Estruxture Data Centers Full time

    **The position can be based in Calgary, Montreal, Toronto or in Vancouver / Le poste peut être basé à Calgary, Montréal, Toronto ou **à **Vancouver.** - ** La version française suit la version anglaise **_ **We host the data. We provide the connections. We protect the information.** Everything starts with our dedicated and talented team. As an...

  • Network Specialist Spécialiste Réseau

    4 weeks ago

    Montréal, Canada Estruxture Data Centers Full time

    The position can be based in Calgary or Montreal / Le poste peut être basé à Calgary ou à Montréal. - ** La version française suit la version anglaise **_ **We host the data. We provide the connections. We protect the information.** eStruxture is more than a data center: it's THE largest Canadian data center platform. It's 15 locations across the...

  • Revenue Operations Analyst/data Specialist

    2 weeks ago

    Montréal, Canada Fresche Solutions Full time

    **Revenue Operations Analyst/Data Specialist - **REMOTE** At Fresche Solutions, we offer great work-life balance with flexible hours. You can work anywhere in North Americaeither from your home or in one of our officesthe decision is up to you. **WHY JOIN FRESCHE?** We believe in leading our industry, we believe in innovation, we believe in delighting our...

  • Data Analyst

    4 weeks ago

    Montréal, 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 Integration Specialist

    2 months ago

    Montréal, Canada International Air Transport Association (IATA) Full time

    Employment Type: Permanent Contract Duration: About the team you are joining Global Aviation Data Management (GADM) team is responsible for the development, implementation and support of data solutions needed to monitor safety, operational and capacity KPIs. These includes, without being limited to: - Managing Data Sharing Programs (IDX, FDX, MCX and...

  • Specialist Data Developer/Software Development

    4 weeks ago

    Montréal, Canada Canadian National Railway Full time

    At CN, we work together to move our company-and North America-forward. Be part of our Information & Technology (I&T) team, a critical piece of the engine that keeps us in motion. From enterprise architecture to operational technology, our teams use the agile methodology to automate and digitize our railroad ensuring our operations run optimally and safely...

  • Accounting Operations Specialist, Na

    3 weeks ago

    Montréal, 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 Analytics Sales Specialist, Google Cloud

    2 weeks ago

    Montréal, Canada Google Full time

    **Minimum qualifications**: - Bachelor's degree or equivalent practical experience. - 10 years of experience selling analytics, data warehousing, or data management software. - 7 years of experience planning, pitching, and executing a territory sales strategy. - Experience in working with developers and customer technical leads to build business cases and...

  • Data Analytics Sales Specialist, Google Cloud

    3 days ago

    Montréal, Canada Google Full time

    **Minimum qualifications**: - Bachelor's degree or equivalent practical experience. - 10 years of experience selling analytics, data warehousing, or data management software. - 7 years of experience planning, pitching, and executing a territory sales strategy. - Experience in working with developers and customer technical leads to build business cases and...

  • Invoicing Specialist

    3 weeks ago

    Montréal, Canada Estruxture Data Centers Full time

    La version française suit la version anglaise **_ **We host the data. We provide the connections. We protect the information.** Everything starts with our dedicated and talented team. As an award-winning industry leader, our data centers help our customers improve network connectivity, redundancy and uptime, scale up or down, increase cost savings, and...

  • Warehouse and Inventory Specialist

    1 week ago

    Montréal, Canada Priority Worldwide Services Full time

    **Description** Montreal (Pointe-Claire), Quebec Canada - **(English follows)**_ **Qui nous Sommes** **Nous vous offrons une opportunité passionnante de rejoindre le monde trépidant de la logistique internationale !** Priority Worldwide est un chef en pleine croissance dans le transport de fret. Nous sommes pleinement engagés dans notre responsabilité...

  • Warehouse and Inventory Specialist

    3 weeks ago

    Montréal, Canada Priority Worldwide Services Full time

    **Description** Montreal (Pointe-Claire), Quebec Canada - **(English follows)**_ **Qui nous Sommes** **Nous vous offrons une opportunité passionnante de rejoindre le monde trépidant de la logistique internationale !** Priority Worldwide est un chef en pleine croissance dans le transport de fret. Nous sommes pleinement engagés dans notre responsabilité...

  • Data Specialist

    4 days ago

    Montréal, Canada Sii 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 à...

  • Data Specialist

    4 days ago

    Montréal, 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 à...

  • Accounts Payable Specialist, Na

    4 weeks ago

    Montréal, 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...