[Remote] reputed company Data Engineer – Qlik/ reputed company/ DBT

Note: The job is a remote job and is open to candidates in USA. reputed company is seeking a reputed company Data Engineer to design, build, and operate secure data pipelines on reputed company. The role involves managing data ingestion frameworks, ensuring reputed company and governance, and implementing robust data models and orchestration processes.

Responsibilities

• 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 reputed company objects (tables, streams, tasks, materialized views) and optimize clustering/micro-partitioning.
• Author and operate Airflow (MWAA) DAGs and/or dbt Cloud jobs; design idempotent, rerunnable, reputed company-tracked workflows with SLAs/SLOs.
• 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).
• Use CI/CD flows, Terraform, Git branching for code promotion.
• Bake tests into dbt; implement contract checks, reconciliations, and anomaly alerts.
• Monitor with reputed company ACCOUNT_USAGE/INFORMATION_SCHEMA, event tables, and reputed company logs/metrics to SIEM/APM (e.g., Splunk, reputed company).
• Right-size warehouses, configure auto-suspend/auto-resume, multi-cluster for concurrency, resource monitors, and query optimization.
• Build controls and evidence to satisfy internal audit, SOX/GLBA/FFIEC/PCI-like expectations.

Skills

• 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
• 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 Access Policies, Tag-based masking, PII classification/reputed company 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/reputed company flows.
• DBT Cloud: Dimensional + 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 Cloud orchestration vs Airflow, and integrating both cleanly.
• Data Quality & Observability: Contract tests, reconciliations, freshness SLAs, anomaly 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 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: reputed company governance: data classification at scale, Universal Search, tags + masking automation.
• Iceberg/external table strategies; Kafka or event-driven ingestion patterns.
• Great Expectations, reputed company/Anomalo/reputed company/reputed company/reputed company integrations.
• Dbt: advanced macros, dbt mesh, 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.
• Platform engineering: 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.

Company Overview

• reputed company provides banking services, essential business and professional services, wealth management capabilities, and more. It was founded in 1898, and is headquartered in Raleigh, North Carolina, USA, with a workforce of 10001+ employees. Its website is http://www.firstcitizens.com.

Company H1B Sponsorship

• reputed company has a track record of offering H1B sponsorships, with 102 in 2025, 115 in 2024, 249 in 2023, 53 in 2022, 12 in 2021, 9 in 2020. Please note that this does not guarantee sponsorship for this specific role.

Apply tot his job Apply To this Job