About the role
NTT DATA strives to hire exceptional, innovative and passionate individuals who want to grow with us. If you want to be part of an inclusive, adaptable, and forward-thinking organization, apply now.
We are currently seeking a Senior Snowflake Engineer to join our team in Montreal, Quebec (CA-QC), Canada (CA).
Job Description:
As a Senior Cloud Data Warehouse Engineer, you will be a member of the C3 Data Warehouse team with a focus on building our next-gen data platform used for sourcing and storing data from different technology systems across the firm into a centralized data platform that empowers various reporting and analytics solutions for the Technology Risk functions within Brokerage.
In this role you will be primarily responsible for contributing to the development of our Cloud Data Warehouse utilizing Snowflake and Python-based tooling. You will also be responsible for the design and development of our data warehouse utilizing Snowflake capabilities such as data sharing, time travel, Snow Park, workload optimization across analytic and AI use-cases, and the ingestion and storage of structured and unstructured data.
You will also work on the integration of our Snowflake data warehouse with existing internal platforms for data quality, data cataloging, data discovery, incident logging, and metric generation. You will be working closely with data warehousing leads, data analysts, ETL developers, infrastructure engineers, and data analytics teams to facilitate the implementation of this data platform and data pipeline framework.
Key Responsibilities:
• To design, develop, and manage our Snowflake data warehouse.
• To contribute towards the establishment of best practices for the optimal and efficient usage of Snowflake with tooling like Airflow, DBT and Spark.
• To assist with the testing and deployment of our data pipeline framework utilizing standard testing frameworks and CI/CD tooling.
• To monitor the performance of queries and data loads and perform tuning as necessary.
• To provide assistance and guidance during the QA & UAT phases to quickly confirm the validity of potential issues and to determine the root cause and best resolution of verified issues.
Skills / Qualifications:
• Bachelor's degree in Computer Science, Software Engineering, Information Technology, or related field required.
• At least 10 years of experience in data development and solutions in highly complex data environments with large data volumes.
• At least 7 years of SQL / PLSQL experience with the ability to write ad-hoc and complex queries to perform data analysis.
• At least 5 years of experience with developing data solutions on Snowflake.
• At least 3 years of data pipelines and data warehousing solutions using Python and libraries such as Pandas, NumPy, PySpark, etc.
• At least 3 years of experience developing solutions in a hybrid data environment (on-Prem and Cloud)
• Hands on experience with Python a must.
• Hands on experience with Airflow (or similar tools like Dagster) a must.
• Snowflake SnowPro Core a must
• Snowflake Snow
Minimum Skills Required:
• At least 10 years of experience in data development and solutions in highly complex data environments with large data volumes.
• At least 7 years of SQL / PLSQL experience with the ability to write ad-hoc and complex queries to perform data analysis.
• At least 5 years of experience with developing data solutions on Snowflake.
• At least 3 years of data pipelines and data warehousing solutions using Python and libraries such as Pandas, NumPy, PySpark, etc.
• At least 3 years of experience developing solutions in a hybrid data environment (on-Prem and Cloud)
• Hands on experience with Python a must.
• Hands on experience with Airflow (or similar tools like Dagster) a must.
• Snowflake SnowPro Core a must
• Snowflake SnowPro Advanced Architect and Advanced Data Engineer a plus.
• Hands on experience with DBT a plus.
• Experience with performance tuning SQL queries, Spark job, and stored procedures.
• An understanding of E-R data models (conceptual, logical, and physical).
• Understanding of advanced data warehouse concepts (Factless Fact Tables, Temporal \ Bi-Temporal models, etc.) a plus.
• Strong analytical skills, including a thorough understanding of how to interpret custom
NTT DATA - Ingénieur Senior Snowflake (Montréal, QC, Canada) Description du poste :
En tant qu'ingénieur senior en entrepôt de données cloud, vous ferez partie de l'équipe C3 Data Warehouse, avec pour mission de construire notre plateforme de données de nouvelle génération. Cette plateforme sert à collecter et stocker des données provenant de différents systèmes technologiques à travers l'entreprise, dans un entrepôt centralisé qui facilite diverses solutions de reporting et d'analyse pour les fonctions de gestion des risques technologiques en courtage.
Dans ce rôle, vous serez principalement responsable du développement de notre entrepôt de données cloud utilisant Snowflake et des outils Clientés sur Python. Vous concevrez et développerez également notre entrepôt de données en exploitant les capacités de Snowflake telles que le partage de données, la récupération temporelle (time travel), Snowpark, l'optimisation des charges de travail pour les cas d'usage analytiques et d'IA, ainsi que l'ingestion et le stockage des données structurées et non structurées.
Vous intégrerez aussi notre entrepôt Snowflake avec les plateformes internes existantes pour la qualité des données, le catalogage, la découverte, la gestion des incidents et la génération de métriques. Vous collaborerez étroitement avec les responsables d'entrepôt de données, les analystes, les développeurs ETL, les ingénieurs d'infrastructure et les équipes d'analytique pour faciliter la mise en œuvre de cette plateforme et du cadre de pipelines de données.
Responsabilités principales :
- Concevoir, développer et gérer notre entrepôt de données Snowflake.
- Contribuer à l'établissement des meilleures pratiques pour une utilisation optimale et efficace de Snowflake avec des outils comme Airflow, DBT et Spark.
- Assister aux phases de test et de déploiement des pipelines de données en utilisant des frameworks de test standard et des outils CI/CD.
- Surveiller les performances des requêtes et des chargements de données et effectuer des optimisations si nécessaire.
- Fournir assistance et conseils pendant les phases QA & UAT pour confirmer rapidement la validité des problèmes potentiels, en identifier la cause racine et proposer les meilleures solutions.
Compétences / Qualifications :
- Diplôme universitaire en informatique, génie logiciel, technologies de l'information ou domaine similaire requis.
- Minimum 10 ans d'expérience en développement et solutions de données dans des environnements complexes avec de grands volumes.
- Au moins 7 ans d'expérience en SQL / PLSQL, capable de rédiger des requêtes complexes et ad hoc pour l'analyse des données.
- Minimum 5 ans d'expérience dans le développement de solutions sur Snowflake.
- Au moins 3 ans d'expérience avec des pipelines et entrepôts de données utilisant Python et des bibliothèques comme Pandas, NumPy, PySpark.
- Minimum 3 ans d'expérience en environnement hybride (sur site et cloud).
- Expérience pratique en Python indispensable.
- Expérience pratique avec Airflow (ou outils similaires comme Dagster) indispensable.
- Certification Snowflake SnowPro Core obligatoire.
- Certifications Snowflake SnowPro Advanced Architect et Advanced Data Engineer sont un plus.
- Expérience avec DBT est un plus.
- Expérience en optimisation des performances des requêtes SQL, des jobs Spark et procédures stockées.
- Compréhension des modèles de données E-R (conceptuel, logique et physique).
- Connaissance des concepts avancés d'entrepôt de données (tables factuelles sans faits, modèles temporels et bi-temporels) est un plus.
- Forte capacité analytique, y compris compréhension approfondie de l'interprétation des données personnalisées.
Si tu souhaites, je peux t'aider à adapter un CV ou une lettre de motivation en français pour ce poste, ou préparer des questions d'entretien spécifiques à ce rôle. Client-moi ce que tu préfères !
About NTT DATA:
NTT DATA is a $30 billion trusted global innovator of business and technology services. We serve 75% of the Fortune Global 100 and are committed to helping clients innovate, optimize and transform for long term success. As a Global Top Employer, we have diverse experts in more than 50 countries and a robust partner ecosystem of established and start-up companies. Our services include business and technology consulting, data and artificial intelligence, industry solutions, as well as the development, implementation and management of applications, infrastructure and connectivity. We are one of the leading providers of digital and AI infrastructure in the world. NTT DATA is a part of NTT Group, which invests over $3.6 billion each year in R&D to help organizations and society move confidently and sustainably into the digital future. Visit us at us.nttdata.com
NTT DATA endeavors to make https://us.nttdata.com accessible to any and all users. If you would like to contact us regarding the accessibility of our website or need assistance completing the application process, please contact us at https://us.nttdata.com/en/contact-us. This contact information is for accommodation requests only and cannot be used to inquire about the status of applications. NTT DATA is an equal opportunity employer. Qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability or protected veteran status. For our EEO Policy Statement, please click here. If you'd like more information on your EEO rights under the law, please click here. For Pay Transparency information, please click here.
About NTT DATA North America
NTT DATA, Inc. is a trusted global innovator of business and technology services. We're committed to helping clients innovate, optimize and transform for long-term success. Our R&D investments help organizations and society move confidently and sustainably into the digital future. As a Global Top Employer, we have diverse experts in more than 50 countries and a robust partner ecosystem of established and start-up companies. Our services include business and technology consulting, data and artificial intelligence, industry solutions, as well as the development, implementation and management of applications, infrastructure, and connectivity.
About the role
NTT DATA strives to hire exceptional, innovative and passionate individuals who want to grow with us. If you want to be part of an inclusive, adaptable, and forward-thinking organization, apply now.
We are currently seeking a Senior Snowflake Engineer to join our team in Montreal, Quebec (CA-QC), Canada (CA).
Job Description:
As a Senior Cloud Data Warehouse Engineer, you will be a member of the C3 Data Warehouse team with a focus on building our next-gen data platform used for sourcing and storing data from different technology systems across the firm into a centralized data platform that empowers various reporting and analytics solutions for the Technology Risk functions within Brokerage.
In this role you will be primarily responsible for contributing to the development of our Cloud Data Warehouse utilizing Snowflake and Python-based tooling. You will also be responsible for the design and development of our data warehouse utilizing Snowflake capabilities such as data sharing, time travel, Snow Park, workload optimization across analytic and AI use-cases, and the ingestion and storage of structured and unstructured data.
You will also work on the integration of our Snowflake data warehouse with existing internal platforms for data quality, data cataloging, data discovery, incident logging, and metric generation. You will be working closely with data warehousing leads, data analysts, ETL developers, infrastructure engineers, and data analytics teams to facilitate the implementation of this data platform and data pipeline framework.
Key Responsibilities:
• To design, develop, and manage our Snowflake data warehouse.
• To contribute towards the establishment of best practices for the optimal and efficient usage of Snowflake with tooling like Airflow, DBT and Spark.
• To assist with the testing and deployment of our data pipeline framework utilizing standard testing frameworks and CI/CD tooling.
• To monitor the performance of queries and data loads and perform tuning as necessary.
• To provide assistance and guidance during the QA & UAT phases to quickly confirm the validity of potential issues and to determine the root cause and best resolution of verified issues.
Skills / Qualifications:
• Bachelor's degree in Computer Science, Software Engineering, Information Technology, or related field required.
• At least 10 years of experience in data development and solutions in highly complex data environments with large data volumes.
• At least 7 years of SQL / PLSQL experience with the ability to write ad-hoc and complex queries to perform data analysis.
• At least 5 years of experience with developing data solutions on Snowflake.
• At least 3 years of data pipelines and data warehousing solutions using Python and libraries such as Pandas, NumPy, PySpark, etc.
• At least 3 years of experience developing solutions in a hybrid data environment (on-Prem and Cloud)
• Hands on experience with Python a must.
• Hands on experience with Airflow (or similar tools like Dagster) a must.
• Snowflake SnowPro Core a must
• Snowflake Snow
Minimum Skills Required:
• At least 10 years of experience in data development and solutions in highly complex data environments with large data volumes.
• At least 7 years of SQL / PLSQL experience with the ability to write ad-hoc and complex queries to perform data analysis.
• At least 5 years of experience with developing data solutions on Snowflake.
• At least 3 years of data pipelines and data warehousing solutions using Python and libraries such as Pandas, NumPy, PySpark, etc.
• At least 3 years of experience developing solutions in a hybrid data environment (on-Prem and Cloud)
• Hands on experience with Python a must.
• Hands on experience with Airflow (or similar tools like Dagster) a must.
• Snowflake SnowPro Core a must
• Snowflake SnowPro Advanced Architect and Advanced Data Engineer a plus.
• Hands on experience with DBT a plus.
• Experience with performance tuning SQL queries, Spark job, and stored procedures.
• An understanding of E-R data models (conceptual, logical, and physical).
• Understanding of advanced data warehouse concepts (Factless Fact Tables, Temporal \ Bi-Temporal models, etc.) a plus.
• Strong analytical skills, including a thorough understanding of how to interpret custom
NTT DATA - Ingénieur Senior Snowflake (Montréal, QC, Canada) Description du poste :
En tant qu'ingénieur senior en entrepôt de données cloud, vous ferez partie de l'équipe C3 Data Warehouse, avec pour mission de construire notre plateforme de données de nouvelle génération. Cette plateforme sert à collecter et stocker des données provenant de différents systèmes technologiques à travers l'entreprise, dans un entrepôt centralisé qui facilite diverses solutions de reporting et d'analyse pour les fonctions de gestion des risques technologiques en courtage.
Dans ce rôle, vous serez principalement responsable du développement de notre entrepôt de données cloud utilisant Snowflake et des outils Clientés sur Python. Vous concevrez et développerez également notre entrepôt de données en exploitant les capacités de Snowflake telles que le partage de données, la récupération temporelle (time travel), Snowpark, l'optimisation des charges de travail pour les cas d'usage analytiques et d'IA, ainsi que l'ingestion et le stockage des données structurées et non structurées.
Vous intégrerez aussi notre entrepôt Snowflake avec les plateformes internes existantes pour la qualité des données, le catalogage, la découverte, la gestion des incidents et la génération de métriques. Vous collaborerez étroitement avec les responsables d'entrepôt de données, les analystes, les développeurs ETL, les ingénieurs d'infrastructure et les équipes d'analytique pour faciliter la mise en œuvre de cette plateforme et du cadre de pipelines de données.
Responsabilités principales :
- Concevoir, développer et gérer notre entrepôt de données Snowflake.
- Contribuer à l'établissement des meilleures pratiques pour une utilisation optimale et efficace de Snowflake avec des outils comme Airflow, DBT et Spark.
- Assister aux phases de test et de déploiement des pipelines de données en utilisant des frameworks de test standard et des outils CI/CD.
- Surveiller les performances des requêtes et des chargements de données et effectuer des optimisations si nécessaire.
- Fournir assistance et conseils pendant les phases QA & UAT pour confirmer rapidement la validité des problèmes potentiels, en identifier la cause racine et proposer les meilleures solutions.
Compétences / Qualifications :
- Diplôme universitaire en informatique, génie logiciel, technologies de l'information ou domaine similaire requis.
- Minimum 10 ans d'expérience en développement et solutions de données dans des environnements complexes avec de grands volumes.
- Au moins 7 ans d'expérience en SQL / PLSQL, capable de rédiger des requêtes complexes et ad hoc pour l'analyse des données.
- Minimum 5 ans d'expérience dans le développement de solutions sur Snowflake.
- Au moins 3 ans d'expérience avec des pipelines et entrepôts de données utilisant Python et des bibliothèques comme Pandas, NumPy, PySpark.
- Minimum 3 ans d'expérience en environnement hybride (sur site et cloud).
- Expérience pratique en Python indispensable.
- Expérience pratique avec Airflow (ou outils similaires comme Dagster) indispensable.
- Certification Snowflake SnowPro Core obligatoire.
- Certifications Snowflake SnowPro Advanced Architect et Advanced Data Engineer sont un plus.
- Expérience avec DBT est un plus.
- Expérience en optimisation des performances des requêtes SQL, des jobs Spark et procédures stockées.
- Compréhension des modèles de données E-R (conceptuel, logique et physique).
- Connaissance des concepts avancés d'entrepôt de données (tables factuelles sans faits, modèles temporels et bi-temporels) est un plus.
- Forte capacité analytique, y compris compréhension approfondie de l'interprétation des données personnalisées.
Si tu souhaites, je peux t'aider à adapter un CV ou une lettre de motivation en français pour ce poste, ou préparer des questions d'entretien spécifiques à ce rôle. Client-moi ce que tu préfères !
About NTT DATA:
NTT DATA is a $30 billion trusted global innovator of business and technology services. We serve 75% of the Fortune Global 100 and are committed to helping clients innovate, optimize and transform for long term success. As a Global Top Employer, we have diverse experts in more than 50 countries and a robust partner ecosystem of established and start-up companies. Our services include business and technology consulting, data and artificial intelligence, industry solutions, as well as the development, implementation and management of applications, infrastructure and connectivity. We are one of the leading providers of digital and AI infrastructure in the world. NTT DATA is a part of NTT Group, which invests over $3.6 billion each year in R&D to help organizations and society move confidently and sustainably into the digital future. Visit us at us.nttdata.com
NTT DATA endeavors to make https://us.nttdata.com accessible to any and all users. If you would like to contact us regarding the accessibility of our website or need assistance completing the application process, please contact us at https://us.nttdata.com/en/contact-us. This contact information is for accommodation requests only and cannot be used to inquire about the status of applications. NTT DATA is an equal opportunity employer. Qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability or protected veteran status. For our EEO Policy Statement, please click here. If you'd like more information on your EEO rights under the law, please click here. For Pay Transparency information, please click here.
About NTT DATA North America
NTT DATA, Inc. is a trusted global innovator of business and technology services. We're committed to helping clients innovate, optimize and transform for long-term success. Our R&D investments help organizations and society move confidently and sustainably into the digital future. As a Global Top Employer, we have diverse experts in more than 50 countries and a robust partner ecosystem of established and start-up companies. Our services include business and technology consulting, data and artificial intelligence, industry solutions, as well as the development, implementation and management of applications, infrastructure, and connectivity.