LiveMindz
LiveMindz

Senior Data Engineer with Snowflake

Charlotte, NC, US • Posted 4 hours ago • Updated 4 hours ago
Contract W2
12 Months
No Travel Required
On-site
$50 - $60/hr
Fitment

Dice Job Match Score™

🔢 Crunching numbers...

Job Details

Skills

  • Snowflake
  • dbt
  • Data Build Tool
  • Snowflake Cloud

Summary

Role: Senior Data Engineer 
Location: Charlotte, NC
 
Position Overview
We are seeking a highly skilled Senior Data Engineer with deep expertise in Snowflake and dbt (Data Build Tool) to join our enterprise cloud analytics delivery practice. In this role, you will design, build, and optimize modern, production-grade cloud data warehouses and ELT pipelines.
You will work closely with enterprise data architects, business intelligence teams, and client stakeholders to transform raw multi-source data into clean, tested, and highly performant analytical models inside the Snowflake Data Cloud.
Key Responsibilities
  • ELT Pipeline Development & Data Modeling:
    • Design, build, and maintain modular, scalable dbt models (staging, intermediate, and marts) using dbt Core or dbt Cloud.
    • Implement advanced data modeling techniques (Dimensional Modeling, Star/Snowflake Schemas, and Data Vault) optimized for Snowflake.
  • Snowflake Cloud Data Warehouse Engineering:
    • Architect, configure, and optimize Snowflake virtual warehouses, databases, schemas, internal/external stages, and tables.
    • Write complex, high-performance SQL, Snowpark scripts (Python), and leverage Snowflake capabilities like zero-copy cloning, streams, tasks, and dynamic data masking.
  • Performance Tuning & Cost Management:
    • Identify and resolve pipeline bottlenecks by optimizing dbt transformation logic, Snowflake cluster keys, materialization strategies, and query performance.
    • Monitor and optimize Snowflake compute (credits) and storage usage.
  • Data Quality, Testing & CI/CD:
    • Define and automate dbt tests (schema tests, custom data tests, packages like dbt-utils and dbt-expectations) to ensure end-to-end data integrity.
    • Embed dbt documentation, lineage, and version control (Git) into enterprise CI/CD deployment pipelines (GitHub Actions, GitLab, or Azure DevOps).
  • Cross-Functional Collaboration:
    • Partner with client business analysts, BI developers, and cloud engineering teams to translate complex business requirements into robust, automated data platforms.
Required Qualifications
  • Experience: 5+ years of hands-on data engineering experience, with at least 3+ years dedicated to Snowflake and dbt ecosystems.
  • Core Technical Stack:
    • Data Platform: Snowflake (Virtual Warehouses, Snowpark, Data Sharing, Tasks/Streams).
    • Transformation: dbt (dbt Core / dbt Cloud, Jinja, SQL, YAML configurations).
    • Languages: Advanced SQL, Python.
    • DevOps & Integration: Git, CI/CD pipelines, Airflow, Fivetran, or SnapLogic.
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: 90915265
  • Position Id: 9133190
  • Posted 4 hours ago
Contact the job poster
AS

Anusha Santhosh

Recruiter @ LiveMindz

View Profile
Create job alert
Never miss an opportunity! Create an alert based on the job you applied for.
More jobs at LiveMindz in Charlotte, NC