Lead Data Engineer

Jersey Hired is scouting for a heavy-hitting Senior Data Engineer to join a global consulting powerhouse. This isn't just about moving data from Point A to Point B, it’s about architecting a fortress.

We need a pro who can design, build, and operate secure, audited, and cost-efficient pipelines on Snowflake. You’ll be the master of the journey: taking raw ingestion through Data Vault 2.0 models and delivering it into high-impact consumption layers. If you’re a Terraform-wielding, dbt-loving, Airflow-orchestrating engineer who treats "audit-ready" as a lifestyle, we want to talk.

The Mission

• Architect & Build: Design scalable ingestion frameworks using Qlik, Glue, and ETLs.

• Model at Scale: Implement Raw DV 2.0 (Hubs/Links/Sats) Consumption patterns in dbt Cloud with obsessive testing (uniqueness, relationships, freshness).

• Snowflake Mastery: Build performant objects (tables, streams, tasks) and fine-tune clustering and micro-partitioning for peak efficiency.

• Orchestrate Excellence: Author Airflow (MWAA) DAGs and dbt Cloud jobs that are idempotent, rerunnable, and strictly tracked against SLAs.

• Secure the Perimeter: Enforce RBAC/ABAC, masking, and row-access policies. You’ll operationalize controls that make auditors smile—think change management, separation of duties, and evidence capture.

• Ops & Observability: Bake tests into dbt, monitor via ACCOUNT_USAGE, and forward metrics to Splunk/Datadog.

• FinOps: Right-size warehouses and manage multi-cluster concurrency to keep performance high and costs low.