Data Engineer - Snowflake DB

NP : Immediate 15 days (Serving)

Snowflake Data EngineerRole Summary :

We are seeking a Snowflake Data Engineer to build, optimize, and maintain modern cloud data pipelines on Snowflake. This is a hands-on, build-focused role to deliver production-grade ingestion, transformation, and AI-enabled data products.

You will write and optimize the code, tests, and pipelines that turn raw source data into reliable, well-modeled, consumption-ready datasets.

The ideal candidate is hands-on across the modern Snowflake ecosystem: Fivetran for ingestion, dbt for transformation and modeling, Snowflake Cortex for AI and LLM-driven features, and Snowflake's native streaming capabilities for real-time data movement.

Key Responsibilities :

• Build and maintain end-to-end ELT pipelines on Snowflake, from ingestion through transformation to consumption-ready datasets.

• Implement data models that conform to established standards (e.g., medallion / layered architectures, dimensional and/or Data Vault patterns).

• Develop managed ingestion using Fivetran (connector setup, configuration, and monitoring) and transformation logic using dbt (models, tests, macros, documentation).

• Build real-time and near-real-time data flows using Snowflake streaming capabilities, including Snowpipe Streaming, Streams (change data capture), and Dynamic Tables.

• Implement AI-enabled features using Snowflake Cortex Cortex LLM functions, Cortex Analyst, Cortex Search, and document/text processing workflows.

• Write performant, maintainable SQL and tune queries, warehouses, and pipelines for cost and performance.

• Implement data quality testing, monitoring, alerting, and documentation across pipelines.

• Apply security and governance controls in implementation: role-based access, masking and row-level policies, and secure data sharing.

• Follow Git-based version control and CI/CD practices for deploying across dev/test/prod environments.

• Collaborate with architects, analysts, and stakeholders to deliver against requirements and troubleshoot issues.

Required Qualifications:

• Proven hands-on experience building and maintaining production data pipelines on Snowflake.

• SnowPro Core Certification (required).

• Hands-on, production-level experience with dbt (modeling, testing, macros, project structure, and deployment).

• Hands-on experience with Fivetran for managed data ingestion and connector management.

• Hands-on experience with Snowflake data streaming including Snowpipe Streaming, Streams (CDC), and/or Dynamic Tables for real-time and near-real-time pipelines.

• Working experience with Snowflake Cortex (Cortex AI / LLM functions, Cortex Analyst, Cortex Search, or comparable Cortex capabilities).

• Strong SQL skills and solid data modeling fundamentals.

• Understanding of Snowflake performance tuning, cost awareness, and security/access control basics.

• Experience with version control (Git) and CI/CD for data pipelines.

• Clear communication skills and the ability to collaborate across technical and analytics teams.

Preferred Qualifications :

• SnowPro Advanced: Data Engineer Certification (strongly preferred).

• Experience with Python and/or Snowpark for data engineering workloads.

• Familiarity integrating Snowflake with Salesforce.

• Experience with orchestration tooling and metadata-driven pipeline frameworks.

• Familiarity with cloud platforms (Azure, AWS, or GCP) and their integration points with Snowflake.

• Experience operating in a consulting or client-facing environment.

• Exposure to broader AI/ML or RAG patterns built on top of Snowflake data.

• Experience implementing data quality, lineage, and observability tooling.