Hi,
The following requirement is open with our client.
WarehousingTitle : Lead Data Engineer
Location : Raleigh NC, Dallas TX, Phoenix AZ
Duration : 6+ Months
Relevant Experience (in Yrs.): 10+
Rate - $80/hr on W2
Detailed Job Description:
1. Modeling & Warehousing
a. Design and implement scalable data ingestion frameworks
b. Implement Raw → DV 2.0 (Hubs/Links/Satellites) → Consumption patterns in dbt Cloud with robust tests
c. (unique/not null/relationships/freshness).
2. Build performant Snowflake objects (tables, streams, tasks, materialized views) and optimize clustering/micro-partitioning.
a. Orchestration
b. Author and operate Airflow (MWAA) DAGs and/or dbt Cloud jobs; design idempotent, rerunnable, lineage-tracked workflows
c. with SLAs/SLOs.
3. Security & Governance
a. Enforce RBAC/ABAC, network policies/rules, masking/row access policies, tags, data classification, and least-privilege role
b. hierarchies.
c. Operationalize audit-ready controls (change management, approvals, runbooks, separation of duties, evidence capture).
4. IaC & DevOps
a. Use CI/CD flows, Terraform, Git branching for code promotion.
5. Data Quality & Observability
a. Bake tests into dbt; implement contract checks, reconciliations, and anomaly alerts.
b. Monitor with Snowflake ACCOUNT_USAGE/INFORMATION_SCHEMA, event tables, and forward logs/metrics to
c. SIEM/APM (e.g., Splunk, Datadog).
6. Cost & Performance
a. Right-size warehouses, configure auto-suspend/auto-resume, multi-cluster for concurrency, resource monitors, and query optimization.
7. Compliance
a. Build controls and evidence to satisfy internal audit, SOX/GLBA/FFIEC/PCI-like expectations.
Thanks & regards,
Vamsi Billa
Technical Recruiter
==
ASCII Group, LLC
Mobile:
Email: | Website:
==
Never miss an opportunity! Create an alert based on the job you applied for.
