Job title: Lead Data Engineer
Location: ONSITE- Raleigh NC, Dallas TX, Phoenix AZ
Duration: 6 months
Job Description:
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
Preferred :
Snowflake Platform (hands-on, production):
Secure account setup: databases/schemas/stages, RBAC/ABAC role design, grants, network policies/rules, storage integrations.
Data protection: Dynamic Data Masking, Row Access Policies, Tag-based masking, PII classification/lineage tagging.
Workloads & features: Streams/Tasks, Snowpipe, external tables, file formats, copy options, retries & dedupe patterns.
Operations: warehouse sizing, multi-cluster, resource monitors, Time Travel & Fail-safe, cross-region/account replication.
Networking concepts: AWS PrivateLink/S3 access patterns, external stages, (at least) high-level familiarity with VPC/DNS/
endpoint flows.
DBT Cloud:
Dimensional + Data Vault 2.0 modeling in dbt (H/L/S), snapshots, seeds, exposures, Jinja/macros, packages, artifacts.
Testing and documentation discipline; deployment environments (DEV/QA/UAT/PROD) and job orchestration.
Orchestration:
Airflow (MWAA): Operators/Sensors (dbt, Snowflake, S3), XComs, SLAs, retries, backfills, alerting, and modular DAG design.
Experience deciding when to run in dbt Cloud orchestration vs Airflow, and integrating both cleanly.
Data Quality & Observability:
Contract tests, reconciliations, freshness SLAs, anomaly detection; surfacing lineage and test results to stakeholders.
Query tuning (profiling, pruning, statistics awareness, result caching).
Audit & Controls:
Change control with approvals/evidence, break-glass procedures, production access separation, audit log retention/immutability.
Runbooks, PIR/RCAs, control mapping (e.g., to SOX/GLBA/PCI-like controls where relevant).
Programming & Cloud:
Python (ETL utils, Airflow tasks), SQL (advanced), and AWS basics (S3, IAM, CloudWatch, MWAA fundamentals).
Bonus Skills :
Snowflake governance: data classification at scale, Universal Search, tags + masking automation.
Iceberg/external table strategies; Kafka or event-driven ingestion patterns.
Great Expectations, Monte Carlo/Anomalo/Atlan/Collibra/BigID integrations.
dbt: advanced macros, dbt mesh, custom materializations, Slim CI, state comparison, deferral, exposures to BI lineage.
BI/Semantic: ThoughtSpot/Looker/Power BI metric-layer design; semantic modeling concepts.
Packaging & distribution: internal dbt packages, reusable Terraform modules, cookie-cutter project templates.
Platform engineering: FinOps for Snowflake, cost charge-back/show-back, warehouse auto-tuning utilities.
Security engineering: SCIM/SSO (Okta), MFA patterns, service-account hardening, ephemeral credentials.
SRE practices: SLIs/SLOs, on-call runbooks, incident management.
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
...Plus, 100% of our team works remotely with the support of time tracking... ...WordPress, extending and developing plugins and themes. Working... ...create images optimized for the web. Working with version... ...aren't met. Apply for this Front-End Developer (Remote, Full-Time)...
Now Accepting 2026 Summer Retail Merchandise Intern Applications The Merchandising Internship provides college students with the opportunity to learn about fashion andmerchandising in a hands-on setting, offering a variety of merchandising experiencerelated to our diverse...
...work experience in in high-end, residential construction who are motivated, dependable, and detail-oriented. In this role, you will help execute complex, high-performance designs that bridge the gap between construction and finished craft. You will work on homes that require...
...Job Posting Summary Baptist Health is currently looking for a Medical Lab Scientist II to join our team at Baptist Emergency Department... ..., the Baptist/Wolfson Children's emergency center is a true hospital ER, staffed 24/7 by board-certified emergency medicine...
...Avant Tech is expanding its network of Sales & Recruitment Partnersentrepreneurial professionals ready to build their own recruiting business with the backing of a premier staffing brand. If youre a driven sales or recruiting professional with an existing network...