Senior Snowflake Data Engineer
⚲ Gdansk, Krakow, Warsaw, Wroclaw
Do uzgodnienia
Wymagania
- DBT
- Python
- SQL
- AWS
Opis stanowiska
The project is for one of the world's famous science and technology companies in pharmaceutical industry, supporting initiatives in AWS, AI and data engineering, with plans to launch over 20 additional initiatives in the future. Modernizing the data infrastructure through the transition to Snowflake as a priority, as it will enhance capabilities for implementing advanced AI solutions and unlock numerous opportunities for innovation and growth.
We are seeking a highly skilled Snowflake Data Engineer to design, build, and optimize scalable data pipelines and cloud-based solutions across AWS, Azure, and GCP. The ideal candidate will have strong expertise in Snowflake, ETL Tools like DBT, Python, visualization tools like Tableau and modern CI/CD practices, with a deep understanding of data governance, security, and role-based access control (RBAC). Knowledge of data modeling methodologies (OLTP, OLAP, Data Vault 2.0), data quality frameworks, Stream lit application development and SAP integration and infrastructure-as-code with Terraform is essential. Experience working with different file formats such as JSON, Parquet, CSV, and XML is highly valued.
- In-depth knowledge of Snowflake's data warehousing capabilities.
- Understanding of Snowflake's virtual warehouse architecture and how to optimize performance
and cost.
- Proficiency in using Snowflake's data sharing and integration features for seamless collaboration.
- Develop and optimize complex SQL scripts, stored procedures, and data transformations.
- Work closely with data analysts, architects, and business teams to understand requirements and
deliver reliable data solutions.
- Implement and maintain data models, dimensional modeling for data warehousing, data marts,
and star/snowflake schemas to support reporting and analytics.
- Integrate data from various sources including APIs, flat files, relational databases, and cloud
services.
- Ensure data quality, data governance, and compliance standards are met.
- Monitor and troubleshoot performance issues, errors, and pipeline failures in Snowflake and
associated tools.
- Participate in code reviews, testing, and deployment of data solutions in development and production environments.
We are seeking a highly skilled Snowflake Data Engineer to design, build, and optimize scalable data pipelines and cloud-based solutions across AWS, Azure, and GCP. The ideal candidate will have strong expertise in Snowflake, ETL Tools like DBT, Python, visualization tools like Tableau and modern CI/CD practices, with a deep understanding of data governance, security, and role-based access control (RBAC). Knowledge of data modeling methodologies (OLTP, OLAP, Data Vault 2.0), data quality frameworks, Stream lit application development and SAP integration and infrastructure-as-code with Terraform is essential. Experience working with different file formats such as JSON, Parquet, CSV, and XML is highly valued.
- In-depth knowledge of Snowflake's data warehousing capabilities.
- Understanding of Snowflake's virtual warehouse architecture and how to optimize performance
and cost.
- Proficiency in using Snowflake's data sharing and integration features for seamless collaboration.
- Develop and optimize complex SQL scripts, stored procedures, and data transformations.
- Work closely with data analysts, architects, and business teams to understand requirements and
deliver reliable data solutions.
- Implement and maintain data models, dimensional modeling for data warehousing, data marts,
and star/snowflake schemas to support reporting and analytics.
- Integrate data from various sources including APIs, flat files, relational databases, and cloud
services.
- Ensure data quality, data governance, and compliance standards are met.
- Monitor and troubleshoot performance issues, errors, and pipeline failures in Snowflake and
associated tools.
- Participate in code reviews, testing, and deployment of data solutions in development and production environments.
🔍 Dekoder Ogłoszenia
🔴
supporting initiatives in AWS, AI and data engineering, with plans to launch over 20 additional initiatives in the future
Projekt może być chaotyczny z wieloma nowymi, nie do końca zdefiniowanymi inicjatywami.
🔴
Modernizing the data infrastructure through the transition to Snowflake as a priority
Duży nacisk na migrację do Snowflake, co może oznaczać wiele pracy związanej z refaktoryzacją i rozwiązywaniem problemów migracyjnych.
🔴
The ideal candidate will have strong expertise in Snowflake, ETL Tools like DBT, Python, visualization tools like Tableau and modern CI/CD practices, with a deep understanding of data governance, security, and role-based access control (RBAC).
Oczekiwana jest bardzo szeroka wiedza i doświadczenie w wielu obszarach, co może być trudne do znalezienia u jednej osoby.
🔴
Knowledge of data modeling methodologies (OLTP, OLAP, Data Vault 2.0), data quality frameworks, Stream lit application development and SAP integration and infrastructure-as-code with Terraform is essential.
Zakres wymaganych umiejętności jest bardzo szeroki i może wykraczać poza typowe obowiązki inżyniera danych Snowflake.
🟡
Experience working with different file formats such as JSON, Parquet, CSV, and XML is highly valued.
Wymagane jest elastyczne podejście do obsługi różnorodnych formatów danych, co może oznaczać pracę z mniej standardowymi lub nieuporządkowanymi danymi.