The project involves designing, developing, and enhancing ETL pipelines both within the Snowflake environment and across external systems. Responsibilities include scripting data ingestion, transformation, and extraction processes using technologies such as Python, Unix shell, or similar tools. Additionally, the role encompasses the creation and maintenance of database objects in Snowflake, including views, stored procedures, and other reusable components to support efficient data workflows.
responsibilities :
design and build efficient, scalable data pipelines and ELT workflows using Snowflake
oversee and maintain cloud environments to ensure high availability and top performance,
utilize Snowflake capabilities like Snowpipe, Streams, Tasks, and Time Travel to support data operations,
create and maintain database structures, data models, and stored procedures using Snowflake SQL,
optimize performance in Snowflake, including query tuning and adjusting virtual warehouse configurations,
administer security and access management through roles and permissions within the Snowflake platform,
automate data loading from multiple sources using Snowflake integrations and external staging areas,
partner with data architects and analysts to ensure high-quality, reliable, and consistent datasets,
apply data governance and compliance standards to maintain control and transparency in the Snowflake environment,
requirements-expected :
advanced proficiency in Snowflake SQL for data modeling, transformation, and optimization,
experience with Snowpipe, Streams, Tasks, and Time Travel features,
strong understanding of data warehousing concepts and ELT architecture,
expertise in performance tuning (query optimization, warehouse sizing, clustering),
knowledge of role-based access control (RBAC) and data security in Snowflake,
familiarity with external stages, file formats, and data ingestion from cloud storage,
experience with Snowflake connectors (Python, Spark, Kafka, etc.),
proficiency in automation and orchestration using tools like Informatica,
very good knowledge of English.
offered :
contract of Employment or a B2B contract,
for the contract of employment: extensive benefits package - Multisport Card, Lux Med medical healthcare including dental care, life insurance, cafeteria benefits,
hybrid work model,
training and continuous learning and certification opportunities.
