Data Modellers
1 week ago
Data Warehouse Engineer (Pyspark/ Python, Azure and Snowflake)
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; Python; data sharing; 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
Minimum 10 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
It would be great if you also had:
Strong analytical skills, ability to interpret business requirements and produce functional and technical design documents
to be flexible and learn quickly.
Laptop and a mobile phone
~A comprehensive insurance plan including: medical, dental, vision, life insurance, and long-/short-term disability
~ A higher education certification policy
~ Comprehensive Relocation Expense Coverage
~ Extensive training opportunities, focused on skills, substantive knowledge, and personal development
~ Cutting edge projects at the world’s leading tier-one banks, financial institutions and insurance firms
~ SYNECHRON’S DIVERSITY & INCLUSION STATEMENT
Diversity & Inclusion are fundamental to our culture, and Synechron is proud to be an equal opportunity workplace and is an affirmative action employer. Our Diversity, Equity, and Inclusion (DEI) initiative ‘Same Difference’ is committed to fostering an inclusive culture – promoting equality, diversity and an environment that is respectful to all. We empower our global workforce by offering flexible workplace arrangements, mentoring, internal mobility, learning and development programs, and more.
Développeur Intégrateur Snowflake (Pyspark/ Python, Azure and Snowflake )
Architecture, conception, mise en œuvre et opérationnalisation de solutions de données et d'analyse à grande échelle sur Snowflake Cloud Data Warehouse.
Expérience pratique du développement avec les fonctionnalités de Snowflake telles que Snow SQL, Snow Pipe, Python, Tâches, Flux, Time Travel, Clonage Zero Copy, Optimiseur, Gestionnaire de métadonnées, partage de données et procédures stockées.
Expérience en entreposage de données - OLTP, OLAP, Dimensions, Faits et modélisation des données.
Il est nécessaire d'avoir une connaissance pratique des éléments de configuration de MS Azure par rapport à Snowflake.
Développement de pipelines EL entrants et sortants de l'entrepôt de données en utilisant une combinaison de Data bricks, Python et Snow SQL.
Développement de scripts UNIX, Python, etc. pour extraire, charger et transformer les données, ainsi que d'autres fonctions utilitaires.
Fournir un support de production pour les problèmes d'entrepôt de données tels que les problèmes de chargement de données, les problèmes de traduction de transformation.
Comprendre les pipelines de données et les moyens modernes d'automatiser les pipelines de données à l'aide de tests basés sur le cloud et documenter clairement les mises en œuvre, de manière à ce que d'autres puissent facilement comprendre les exigences, la mise en œuvre et les conditions de test.
Au minimum 10 ans d'expérience dans la conception et la mise en œuvre d'une solution de données à grande échelle en production opérationnelle sur Microsoft Azure Snowflake Data Warehouse.
Expérience pratique de l'ingestion et du traitement de données en production à l'aide de Python, Data bricks, Snow SQL.
Solides compétences analytiques, capacité à interpréter les besoins commerciaux et à produire des documents de conception fonctionnelle et technique.
Un package de rémunération et d'avantages sociaux très compétitif.
~ Une organisation multinationale avec 52 bureaux dans 20 pays et la possibilité de travailler à l'étranger.
~ Un ordinateur portable et un téléphone mobile.
~Un plan d'assurance complet comprenant : assurance maladie, dentaire, vision, assurance vie, invalidité à long terme/court terme.
~ De nombreuses opportunités de formation axées sur les compétences, les connaissances substantielles et le développement personnel.
~ Projets de pointe auprès des principales banques de niveau un, des institutions financières et des compagnies d'assurance au monde.
~ DÉCLARATION DE DIVERSITÉ ET D'INCLUSION DE SYNECHRON
La diversité et l'inclusion sont fondamentales pour notre culture, et Synechron est fier d'être un lieu de travail égalitaire et un employeur pratiquant l'action positive. Notre initiative de diversité, d'équité et d'inclusion (DEI) «‘Same Difference’» s'engage à favoriser une culture inclusive - promouvoir l'égalité, la diversité et un environnement respectueux envers tous. Nous encourageons les candidats de divers horizons, qu'il s'agisse de race, d'origine ethnique, de religion, d'âge, de statut matrimonial, de genre, d'orientation sexuelle ou de handicap, à postuler. Nous autonomisons notre main-d'œuvre mondiale en proposant des arrangements de travail flexibles, du mentorat, une mobilité interne, des programmes d'apprentissage et de développement, et bien plus encore.
Toutes les décisions d'emploi chez Synechron sont basées sur les besoins de l'entreprise, les exigences du poste et les qualifications individuelles, sans tenir compte du genre, de l'identité de genre, de l'orientation sexuelle, de la race, de l'origine ethnique, du handicap ou du statut de vétéran du candidat, ou de toute autre caractéristique protégée par la loi.
-
Data Modeler
3 months ago
Montréal, QC, Canada High Tech Genesis Full timeLocation: Montreal, QC Hybrid Term: Permanent High Tech Genesis is looking for a Data Modeler to join our team. Reporting to the BI Lead, this role will play a key part in developing, implementing, and continuously evolving a best-in-class data management capability. You will leverage our extensive customer and operational data sets to drive insights,...
-
Data Modeller
6 months ago
Montréal, Canada Canadian National Railway Full timeAt 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...
-
Data Modeling Specialist
6 months ago
Montréal, Canada National Bank of Canada Full timeA career as a Data Modeler in the Data Exposure Expertise team within the Data Office at National Bank means acting as an expert in business data modeling (conceptual data models) to move the Bank towards its data management target. In particular, you'll be working with our IT and business partners, and supporting modeling experts in the Bank's business...
-
Microsoft Power BI Data Modeler
2 months ago
Montréal, QC, Canada AstraNorth Full time**Experience (Years): 4-6** **Essential Skills**: - 2+ years of hands-on experience working with Power BI in a business intelligence or data analyst role - Strong understanding of Power BI desktop, Power BI service, and Power QueryProficiency in data modeling, DAX Expressions, and visualization best practices - Experience with RLS and automated report...
-
Montréal, QC, Canada Data Sciences Full timeThe successful candidate will be responsible for designing and building dimensional models that will feed BI tools and facilitate reporting and analytics for technical and non-technical users alike. Lead interviews with technical and non-technical stakeholders in order to understand business objectives and document requirements. Work with our engineering...
-
Data Scientist, Data Valorization
2 months ago
Montréal, QC, Canada Desjardins Full timeAs a data scientist, you provide the data needed to make business decisions, develop solutions and services adapted to business issues and understand member and client behaviour. You provide guidance and support to clients for advanced analytics and artificial intelligence mandates that involve using data and developing models adapted to business needs. Your...
-
Data Scientist, Data Valorization
2 months ago
Montréal, QC, Canada Desjardins Full timeOversee data mining, evaluation, feature engineering, quality inspection and adjustment of available data, and the selection of predictors for a wide range of complex predictive modeling mandates- Analyze client and partner business needs, generate hypotheses, and lead mandates, taking into account the specifics of their operationalization and ensuring...
-
Analytics Engineer | Ingénieur Analytique
1 week ago
Montréal, QC, Canada Data Sciences Full timeSummary We are looking for an Analytics Engineer to join our diverse and rapidly growing team in Montreal. The successful candidate will be responsible for designing and building dimensional models that will feed BI tools and facilitate reporting and analytics for technical and non-technical users alike. We are looking for big picture thinkers with strong...
-
Data Scientis
2 months ago
Montréal, QC, Canada Desjardins Full timeAs a data scientist, you provide the data needed to make business decisions, develop solutions and services adapted to business issues and understand member and client behaviour. You provide guidance and support to clients for advanced analytics and artificial intelligence mandates that involve using data and developing models adapted to business needs. Your...
-
Quantitative Advisor
3 months ago
Montréal, QC, Canada Société Générale Full time**Responsibilities**: **ABOUT THE JOB**: The Risk Management Department contributes to the sustainable growth of the Societe Generale group through its expertise, understanding of risks, and risk management techniques. The department’s mission is to independently analyze, assess, manage and monitor risk-taking activities with the objective of achieving,...
-
Data Scientist
2 months ago
Montréal, QC, Canada Desjardins Full timeAs a data scientist, you provide the data needed to make business decisions, develop solutions and services adapted to business issues and understand member and client behaviour. You help diagnose problems, manipulate and analyze data, and roll out advanced analytics models. You provide opinions in accordance with the rules of your discipline and help...
-
Quantitative Advisor
3 months ago
Montréal, QC, Canada Société Générale Full time**Responsibilities**: **ABOUT THE JOB**: The Risk Management Department contributes to the sustainable growth of the Societe Generale group through its expertise, understanding of risks, and risk management techniques. The department’s mission is to independently analyze, assess, manage and monitor risk-taking activities with the objective of achieving,...
-
Lead Auditor
3 months ago
Montréal, QC, Canada Crédit Agricole CIB Full timeJob description **Business type**: Types of Jobs - General Inspection / Audit **Job title**: Lead Auditor - Model **Contract type**: Permanent Contract **Job summary**: **Summary of the position** The Lead Auditor conducts audit assignments from planning to reporting. This includes an assessment of the audited activity, the performance of tests, analysis...
-
Data Scientist, Data Valorization
4 weeks ago
Montréal, QC, Canada Desjardins Full timeOversee data mining, evaluation, feature engineering, quality inspection and adjustment of available data, and the selection of predictors for multidisciplinary and strategic predictive modeling mandates- Analyze client and partner needs, and lead mandates involving complex business issues that may lead to business positions and recommendations related to...
-
Quantitative Advisor
3 months ago
Montréal, QC, Canada Société Générale Full time**Responsibilities**: **ABOUT THE JOB**: The Risk Management Department contributes to the sustainable growth of the Societe Generale group through its expertise, understanding of risks, and risk management techniques. The department’s mission is to independently analyze, assess, manage and monitor risk-taking activities with the objective of achieving,...
-
Data Analyst
2 months ago
Montréal, QC, Canada Business Development Bank of Canada Full timeWe are banking at another level. Choosing BDC as your employer means working in a healthy, inclusive, and skilled workplace that puts forward the best conditions to bring together unique teams where employees are empowered to act. It also means being at the centre of ambitious economic and financial projects to see further and to do things differently, to...
-
Data Implementation Engineer
1 week ago
Montréal, QC, Canada Lyteflo Full timeLyteflo is at the forefront of electric vehicle (EV) insights and data-driven innovation. We are a fast-growing startup that prioritizes speed and impact in everything we do, and we’re looking for a dedicated Vehicle Data Engineer to spearhead our EV data acquisition efforts. This role is essential to our mission of enabling mass EV adoption by helping...
-
Data Ontologist
2 months ago
Montréal, QC, Canada Intellibus Full timeAre you a Data Ontologist working at a Large Financial Institution and being told by your leadership that you are too hands-on or detail-oriented or think and work like a start-up? Imagine working at **Intellibus** to engineer platforms that impact billions of lives worldwide. With your passion and focus we will accomplish great things together! We look...
-
Marketing Data Analyst
4 months ago
Montréal, QC, Canada Boutique La Vie En Rose Full timeJoin a diverse and talented team For years now, we’ve been designing lingerie and swimwear for everyday living. Why do we do what we do? Because we want women around the world to look and feel their best! Join our dynamic team to start a stimulating professional career in a committed and constantly evolving environment. We’re a proudly local company with...
-
Marketing Data Analyst
4 months ago
Montréal, QC, Canada Boutique La Vie En Rose Full timeJoin a diverse and talented team For years now, we’ve been designing lingerie and swimwear for everyday living. Why do we do what we do? Because we want women around the world to look and feel their best! Join our dynamic team to start a stimulating professional career in a committed and constantly evolving environment. We’re a proudly local company with...