Apply on Employer Site

Codebase Inc · 7 hours ago

Snowflake Data Engineer

Dallas, TX

Full-time

Onsite

Senior Level, Lead/Staff

10+ years exp

Codebase Inc is seeking a Snowflake Data Engineer to design and implement Snowflake schemas and build data ingestion pipelines. The role involves automating data processing, managing data security, and integrating Snowflake with various cloud platforms and BI tools.

Information Technology & Services

Growth Opportunities

Hiring Manager

Rahul Reddy

Responsibilities

Design and implement Snowflake schemas (star, snowflake, data vault) optimized with micro-partitioning, clustering keys, materialized views, and search optimization services

Build real-time and batch ingestion pipelines into Snowflake using Snowpipe, Kafka Connect, Fivetran, Matillion, Informatica, or dbt

Automate incremental data processing with Streams & Tasks to support CDC (Change Data Capture)

Use Zero-Copy Cloning for environment management, testing, and sandboxing

Apply Time Travel and Fail-safe features for data recovery and auditing

Develop data transformation logic in Snowpark for Python/SQL/Scala to push compute directly into Snowflake

Design integrations with cloud storage (S3, Azure ADLS, GCS) for staging and external tables

Implement data sharing and data marketplace solutions via Snowflake Secure Data Sharing and Snowflake Marketplace

Enable semi-structured data handling (JSON, Avro, Parquet, ORC, XML) using VARIANT columns and lateral flattening

Integrate Snowflake with BI tools (Power BI, Tableau) via live connections and semantic layers

Implement RBAC (Role-Based Access Control), Row Access Policies, and Dynamic Data Masking for data security

Optimize compute usage with multi-cluster warehouses, resource monitors, and query performance tuning

Manage cost optimization strategies (warehouse auto-suspend, query profiling, storage/compute separation)

Integrate with data catalog & governance platforms (Collibra, Alation, Informatica CDGC) using Snowflake metadata and APIs

Work with domain teams to deliver data products leveraging Snowflake’s data mesh-friendly features

Collaborate with architects to design a Snowflake-centric data fabric integrated with ETL/ELT and API layers

Support CI/CD automation for Snowflake code deployment using GitHub Actions, Azure DevOps, or dbt Cloud

Qualification

Snowflake Data CloudSQL optimizationData ingestionSnowpark developmentCloud platform integrationData governanceBI tool integrationCost optimizationPythonScalaJavaCI/CD practicesGitDevOps practicesSnowPro Core Certification