Description

You will design, build, and maintain scalable data pipelines within the Snowflake ecosystem.

Responsibilities

• Design and build ETL/ELT pipelines using Matillion to ingest and process data from multiple sources into Snowflake.
• Develop and maintain scalable Snowflake environments, managing database design and performance tuning.
• Transform raw data using Matillion, ensuring data is cleansed, enriched, and modeled for business consumption.
• Integrate diverse data sources, including APIs and flat files, into Snowflake, ensuring security and accuracy.
• Monitor ETL pipeline performance, optimizing compute resources in Snowflake and improving query speed.

Required Skills

• 7+ years of experience as a Data Engineer.
• Expertise in Snowflake data warehouse platform, including architecture, performance tuning, and security.
• Hands-on experience with Matillion for developing scalable data pipelines.
• Advanced proficiency in SQL, including query optimization and debugging.
• Strong knowledge of dimensional and relational database modeling principles.
• Experience with cloud platforms such as AWS or Azure.
• Familiarity with integrating REST APIs and other data sources.
• Knowledge of pipeline orchestration tools (e.g., Airflow, DBT).
• Ability to troubleshoot data issues and implement solutions.

Key Skills

Education

Any Graduate