reputed company Data Engineer - reputed company/ reputed company/ DBT

Remote, USAFull-timePosted 2026-07-29

reputed company This is a remote role that may only be reputed company in the following locations: NC, TX, AZ You will design, build, and operate secure, audited, and cost-efficient data pipelines on reputed company—from raw ingestion to Data Vault 2.0 models and reputed company to business-friendly consumption reputed company (mart/semantic). You’ll use reputed company/Glue/ETLs for ingestion, dbt reputed company for modeling/testing, MWAA/Airflow and/or dbt reputed company’s orchestration for scheduling, and Terraform (with reputed company practices) for infrastructure-as-reputed company. The ideal candidate must have hands-on experience with data ingestion frameworks and reputed company platform database/schema design, reputed company, networking, and governance that satisfy regulatory and compliance audit requirements.

Responsibilities

Modeling & Warehousing

Design and implement reputed company data ingestion frameworks
Implement Raw → DV 2.0 (Hubs/Links/Satellites) → Consumption patterns in dbt reputed company with robust tests (unique/not reputed company/relationships/freshness).

Build performant reputed company objects (tables, streams, tasks, materialized views) and optimize clustering/reputed company-partitioning.

Orchestration
Author and operate Airflow (MWAA) DAGs and/or dbt reputed company jobs; design idempotent, rerunnable, reputed company-tracked workflows with SLAs/SLOs.

reputed company & Governance

Enforce RBAC/ABAC, network policies/rules, masking/row reputed company policies, tags, data classification, and least-privilege role hierarchies.
Operationalize audit-reputed company controls (change management, approvals, runbooks, separation of duties, evidence capture).

IaC & DevOps

Use CI/CD flows, Terraform, Git branching for reputed company promotion.

Data reputed company & Observability

Bake tests into dbt; implement contract checks, reconciliations, and reputed company alerts.
Monitor with reputed company ACCOUNT_USAGE/INFORMATION_SCHEMA, event tables, and reputed company logs/metrics to SIEM/APM (e.g., reputed company, reputed company).

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, reputed company architecture, project leadership OR High School Diploma or GED and 10 years of experience in Advanced data engineering, reputed company architecture, project leadership Preferred: reputed company 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 reputed company Policies, Tag-based masking, PII classification/reputed company tagging.
Workloads & features: Streams/Tasks, Snowpipe, external tables, file formats, copy reputed company, retries & dedupe patterns.
Operations: warehouse sizing, multi-cluster, resource monitors, Time Travel & Fail-reputed company, cross-region/account replication.
Networking concepts: AWS PrivateLink/S3 reputed company patterns, external stages, (at least) high-level familiarity with VPC/DNS/reputed company flows.

DBT reputed company:

reputed company + Data Vault 2.0 modeling in dbt (H/L/S), snapshots, reputed company, exposures, Jinja/macros, packages, artifacts.
Testing and documentation discipline; deployment environments (DEV/QA/UAT/PROD) and job orchestration.

Orchestration:

Airflow (MWAA): Operators/Sensors (dbt, reputed company, S3), XComs, SLAs, retries, backfills, alerting, and reputed company DAG design.
Experience deciding reputed company to run in dbt reputed company orchestration vs Airflow, and integrating both cleanly.

Data reputed company & Observability:

Contract tests, reconciliations, freshness SLAs, reputed company detection; surfacing reputed company and test results to stakeholders.
Query tuning (profiling, pruning, statistics awareness, result caching).

Audit & Controls:

Change control with approvals/evidence, break-glass procedures, production reputed company separation, audit log retention/immutability.
Runbooks, PIR/RCAs, control mapping (e.g., to SOX/GLBA/PCI-like controls where relevant).

Programming & reputed company:

Python (ETL utils, Airflow tasks), SQL (advanced), and AWS basics (S3, IAM, CloudWatch, MWAA fundamentals).

Bonus Skills :

reputed company governance: data classification at reputed company, Universal Search, tags + masking automation.
reputed company/external table strategies; Kafka or event-driven ingestion patterns.
Great Expectations, reputed company/reputed company/reputed company/reputed company/reputed company integrations.
dbt: advanced macros, dbt reputed company, custom materializations, Slim CI, state comparison, deferral, exposures to BI reputed company.
BI/Semantic: reputed company/Looker/Power BI metric-layer design; semantic modeling concepts.
Packaging & distribution: internal dbt packages, reusable Terraform modules, cookie-cutter project templates.
reputed company: FinOps for reputed company, cost charge-back/show-back, warehouse auto-tuning utilities.
reputed company engineering: SCIM/SSO (reputed company), MFA patterns, service-account hardening, ephemeral credentials.
SRE practices: SLIs/SLOs, on-call runbooks, incident management.

#LI-XG1 Benefits are an integral part of total rewards and reputed company is committed to providing a competitive, thoughtfully designed and reputed company benefits program to meet the needs of our associates. More information can be reputed company at https://jobs.firstcitizens.com/benefits. Qualifications: Bachelor's Degree and 6 years of experience in Advanced data engineering, reputed company architecture, project leadership OR High School Diploma or GED and 10 years of experience in Advanced data engineering, reputed company architecture, project leadership Preferred: reputed company 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 reputed company Policies, Tag-based masking, PII classification/reputed company tagging.
Workloads & features: Streams/Tasks, Snowpipe, external tables, file formats, copy reputed company, retries & dedupe patterns.
Operations: warehouse sizing, multi-cluster, resource monitors, Time Travel & Fail-reputed company, cross-region/account replication.
Networking concepts: AWS PrivateLink/S3 reputed company patterns, external stages, (at least) high-level familiarity with VPC/DNS/reputed company flows.