Lead Data Engineer

Job Title:Lead Data Engineer

Location: ONSITE- Raleigh NC, Dallas TX, Phoenix AZ

Contract- 6 Months

Skills: Digital : Qlik Sense~Digital : Snowflake~Data Build Tool
Experience Required: 6-8

Descriptions:

You will design, build, and operate secure, audited, and cost-efficient data pipelines on Snowflake from
raw ingestion to Data Vault 2.0 models
and onward to business-friendly consumption layers (mart/semantic). You ll use Qlik/Glue/ETLs for
ingestion, dbt Cloud for modeling/testing,
MWAA/Airflow and/or dbt Cloud s orchestration for scheduling, and Terraform (with HashiCorp practices)
for infrastructure-as-code. The ideal
candidate must have hands-on experience with data ingestion frameworks and Snowflake platform
database/schema design, security, networking,
and governance that satisfy regulatory and compliance audit requirements.
Responsibilities
Modeling & Warehousing
Design and implement scalable data ingestion frameworks
Implement Raw ? DV 2.0 (Hubs/Links/Satellites) ? Consumption patterns in dbt Cloud with robust tests
(unique/not null/relationships/freshness).
Build performant Snowflake objects (tables, streams, tasks, materialized views) and optimize clustering/micro-partitioning.
Orchestration
Author and operate Airflow (MWAA) DAGs and/or dbt Cloud jobs; design idempotent, rerunnable, lineage-tracked workflows
with SLAs/SLOs.
Security & Governance
Enforce RBAC/ABAC, network policies/rules, masking/row access policies, tags, data classification, and least-privilege role
hierarchies.
Operationalize audit-ready controls (change management, approvals, runbooks, separation of duties, evidence capture).
IaC & DevOps
Use CI/CD flows, Terraform, Git branching for code promotion.
Data Quality & Observability
Bake tests into dbt; implement contract checks, reconciliations, and anomaly alerts.
Monitor with Snowflake ACCOUNT_USAGE/INFORMATION_SCHEMA, event tables, and forward logs/metrics to
SIEM/APM (e.g., Splunk, Datadog).
Cost & Performance
Right-size warehouses, configure auto-suspend/auto-resume, multi-cluster for concurrency, resource monitors, and query optimization.
Compliance
Build controls and evidence to satisfy internal audit, SOX/GLBA/FFIEC/PCI-like expectations.
Qualifications
Bachelor's Degree and 6 years of experience in Advanced data engineering, enterprise architecture, project leadership OR
High School Diploma or GED and 10 years of experience in Advanced data engineering, enterprise architecture, project leadership

MUST HAVE:

Bachelor's Degree and 6 years of experience in Advanced data engineering, enterprise architecture, project leadership OR
High School Diploma or GED and 10 years of experience in Advanced data engineering, enterprise architecture, project leadership