Senior Snowflake Engineer
NTT DATA North America
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 - Inge nieur Senior Snowflake (Montre al, QC, Canada)**
**Description du poste :**
En tant qu'inge nieur senior en entrepo t de donne es cloud, vous ferez partie de l'e quipe C3 Data Warehouse, avec pour mission de construire notre plateforme de donne es de nouvelle ge ne ration. Cette plateforme sert a collecter et stocker des donne es provenant de diffe rents syste mes technologiques a travers l'entreprise, dans un entrepo t centralise qui facilite diverses solutions de reporting et d'analyse pour les fonctions de gestion des risques technologiques en courtage.
Dans ce ro le, vous serez principalement responsable du de veloppement de notre entrepo t de donne es cloud utilisant Snowflake et des outils Cliente s sur Python. Vous concevrez et de velopperez e galement notre entrepo t de donne es en exploitant les capacite s de Snowflake telles que le partage de donne es, la re cupe 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 donne es structure es et non structure es.
Vous inte grerez aussi notre entrepo t Snowflake avec les plateformes internes existantes pour la qualite des donne es, le catalogage, la de couverte, la gestion des incidents et la ge ne ration de me triques. Vous collaborerez e troitement avec les responsables d'entrepo t de donne es, les analystes, les de veloppeurs ETL, les inge nieurs d'infrastructure et les e quipes d'analytique pour faciliter la mise en uvre de cette plateforme et du cadre de pipelines de donne es.
**Responsabilite s principales :**
+ Concevoir, de velopper et ge rer notre entrepo t de donne es Snowflake.
+ Contribuer a l'e 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 de ploiement des pipelines de donne es en utilisant des frameworks de test standard et des outils CI/CD.
+ Surveiller les performances des reque tes et des chargements de donne es et effectuer des optimisations si ne cessaire.
+ Fournir assistance et conseils pendant les phases QA & UAT pour confirmer rapidement la validite des proble mes potentiels, en identifier la cause racine et proposer les meilleures solutions.
**Compe tences / Qualifications :**
+ Diplo me universitaire en informatique, ge nie logiciel, technologies de l'information ou domaine similaire requis.
+ Minimum 10 ans d'expe rience en de veloppement et solutions de donne es dans des environnements complexes avec de grands volumes.
+ Au moins 7 ans d'expe rience en SQL / PLSQL, capable de re diger des reque tes complexes et ad hoc pour l'analyse des donne es.
+ Minimum 5 ans d'expe rience dans le de veloppement de solutions sur Snowflake.
+ Au moins 3 ans d'expe rience avec des pipelines et entrepo ts de donne es utilisant Python et des bibliothe ques comme Pandas, NumPy, PySpark.
+ Minimum 3 ans d'expe rience en environnement hybride (sur site et cloud).
+ Expe rience pratique en Python indispensable.
+ Expe 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.
+ Expe rience avec DBT est un plus.
+ Expe rience en optimisation des performances des reque tes SQL, des jobs Spark et proce dures stocke es.
+ Compre hension des mode les de donne es E-R (conceptuel, logique et physique).
+ Connaissance des concepts avance s d'entrepo t de donne es (tables factuelles sans faits, mode les temporels et bi-temporels) est un plus.
+ Forte capacite analytique, y compris compre hension approfondie de l'interpre tation des donne es personnalise es.
Si tu souhaites, je peux t'aider a adapter un CV ou une lettre de motivation en franc ais pour ce poste, ou pre parer des questions d'entretien spe cifiques a ce ro le. Client-moi ce que tu pre fe res !
\#LI-NorthAmerica
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.
Confirmar seu email: Enviar Email
Todos os Empregos de NTT DATA North America