Senior Data Engineer - Contract
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
US Citizenship / Green Card status
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 Clouds 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/notnull/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.
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.
Onsite Location Options:
1. Raleigh NC,
2. Dallas TX,
3. Phoenix AZ
Recommended Jobs
Litigation Attorney (Houston)
Direct Hire Opportunity with Full Benefits. Excellent 401K matching! This Jobot Job is hosted by: Brooke Meyer Are you a fit? Easy Apply now by clicking the "Apply" button and sending us your…
Store Associate
We have an opening for a talented Aldi Store Associate to perform responsibilities as a Store Associate. Stay adaptable to changing priorities and business needs. Deliver outstanding service to custo…
Dispatcher (Automotive Parts Delivery)
Automotive parts distribution warehouse Associate Automotive parts distribution warehouse associate needed. Experience preferred. $18.00 to $20 .00 per hour depending on experience. Overtim…
Physician
Discover what's possible in your career as a Telemedicine Post Acute Physician Join a team committed to uncompromising care and collaboration. As a Telemedicine Post Acute Physician, you'll work…
Cyber SDC - Attack & Penetration - Senior - Consulting - Location OPEN
Location: Anywhere in Country At EY, we’re all in to shape your future with confidence. We’ll help you succeed in a globally connected powerhouse of diverse teams and take your career where…
Lead Data Scientist Personal Banking and Wealth Analytics Vice President
The Lead Data Scientist is a seasoned professional role. Applies in-depth disciplinary knowledge, contributing to the development of new techniques and the improvement of processes and work-flow for …
Cloud Platform Delivery Lead - AWS: Senior Manager
Specialty/Competency: Product Innovation Industry/Sector: Not Applicable Time Type: Full time Travel Requirements: Up to 60% At PwC, our people in integration and platform architecture…
Senior Software Engineer I, Data Intelligence
ICON is seeking a Senior Software Engineer I to join our Data Intelligence & Systems Architecture (DISA) team. This engineer will play a foundational role in shaping ICON’s enterprise data platform w…
Loader
Were looking for a FedEx Warehouse Loader to perform daily responsibilities with dedication. Provide excellent interactions with customers and colleagues. Ensure compliance with company and safety st…
Manufacturing Maintenance Tech
We are now hiring for a Manufacturing Maintenance Technician for a Manufacturing company in San Antonio, TX. Please submit your resume to this posting and call our office at 830-629-2525. Schedule /…