Snowflake Data Engineer

Alpharetta, GA, US • Posted 1 hour ago • Updated 1 hour ago
Full Time
On-site
Fitment

Dice Job Match Score™

✨ Finding the perfect fit...

Job Details

Skills

  • sql
  • hadoop
  • oracle
  • Jenkins
  • Sybase
  • S3
  • CI/CD
  • Git
  • Snowflake
  • Teradata

Summary

Job Title: Snowflake Data Engineer
Location: Alpharetta, GA
Role Overview:
Build and scale cloud data products on Snowflake supporting institutional trading, risk, and regulatory reporting. This is a hands-on build role - you will own pipelines end-to-end from ingestion through curated, governed consumption layers used by front-office, risk, and control functions.
Key Responsibilities:
  • Design, develop, and optimize Snowflake data models (staging integration semantic/consumption layers) for institutional trade, position, reference, and market data.
  • Build ingestion pipelines using Snowpipe / Snowpipe Streaming, Streams & Tasks, Dynamic Tables, and external stages against S3.
  • Develop transformation logic in SQL and dbt with version control, CI/CD, and automated testing.
  • Tune performance and cost: warehouse right-sizing, clustering keys, micro-partition pruning, query profiling, result caching, resource monitors, and credit-consumption reporting.
  • Implement data security and entitlements: RBAC hierarchy, dynamic data masking, row access policies, secure views, and secure data sharing across LOBs.
  • Migrate legacy Oracle / Teradata / Sybase / Hadoop workloads to Snowflake, including reconciliation and parallel-run validation.
  • Partner with data governance on lineage, cataloging, data quality rules, and audit/regulatory evidence.
  • Support production: incident triage, root-cause analysis, SLA adherence, and on-call rotation for critical batch cycles.
  • Work in Agile squads with BAs, QA, and platform engineering; participate in design reviews and code reviews.
Required Qualifications:
  • 7+ years in data engineering; 4+ years hands-on Snowflake in a production environment.
  • Expert SQL - window functions, CTEs, complex joins, query optimization, execution plan analysis.
  • dbt (Core or Cloud) - models, macros, snapshots, tests, exposures.
  • Orchestration: Airflow, Control-M, or Autosys.
  • AWS: S3, IAM, Glue, Lambda, Secrets Manager.
  • CI/CD and IaC: Git, Jenkins/GitHub Actions, Terraform or Schema change for Snowflake object deployment.
  • Dimensional and Data Vault modeling; slowly changing dimensions; late-arriving data handling.
  • Demonstrated Snowflake cost-governance ownership (not just development).
Preferred / Differentiators:
  • SnowPro Core / Advanced Data Engineer certification.
  • Prior tier-1 investment bank or large financial-services experience.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
  • Dice Id: 10106248
  • Position Id: 2026-4320
  • Posted 1 hour ago
Create job alert
Set job alertNever miss an opportunity! Create an alert based on the job you applied for.

Similar Jobs

Alpharetta, Georgia

Today

Easy Apply

Full-time

130,000+

Remote

10d ago

Easy Apply

Full-time

Depends on Experience

Remote

Yesterday

Easy Apply

Contract

$60 - $63

Remote

8d ago

Easy Apply

Contract

Depends on Experience

Search all similar jobs