Recently postedTechnology

Senior Data Engineer with Snowflake

LiveMindzCharlotte, NC🇺🇸United States

Quick overview

SeniorityMid Senior

Work modeHybrid

LocationCharlotte, NC, United States

SQLGitSnowflakeAirflowGitHub ActionsPythonVaultdbtAzureCI/CDAzure DevOps

Job description

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.