Senior Data Engineer: Airflow, dbt & Cloud Data Pipelines

hyrusinc; Jersey City (NJ); On-site; USD 140,000 - 190,000; Full time

Job summary

hyrusinc in Jersey City, NJ is seeking a Senior Data Engineer with 8+ years of hands-on experience in data engineering, Apache Airflow, dbt Core, and cloud-native platforms to build and optimize scalable data pipelines for financial and accounting workloads. You will design complex Airflow DAGs, implement dbt models, and manage Kubernetes/OpenShift deployments, ensuring high availability and performance in production environments.

Strong Python, SQL, and collaboration skills are required.

Qualifications

• Expert-level Apache Airflow (DAG design, scheduling, performance tuning).
• Expert-level DBT Core (data modeling, testing, macros, implementation).
• Strong Python for data engineering and automation.
• Deep understanding of Kubernetes and/or OpenShift in production environments.
• Extensive experience with distributed workload management and performance optimization.
• Strong SQL skills for complex transformations and analytics.

Responsibilities

• Design, develop, and maintain complex Airflow DAGs for batch and event-driven data pipelines
• Implement best practices for DAG performance, dependency management, retries, SLA monitoring, and alerting
• Optimize Airflow scheduler, executor, and worker configurations for high-concurrency workloads
• Lead dbt Core implementation, including project structure, environments, and CI/CD integration
• Design and maintain robust dbt models (staging, intermediate, marts) following analytics engineering best practices
• Implement dbt tests, documentation, macros, and incremental models to ensure data quality and performance
• Optimize dbt query performance for large-scale datasets and downstream reporting needs
• Deploy and manage data workloads on Kubernetes / OpenShift platforms
• Design strategies for workload distribution, horizontal scaling, and resource optimization
• Configure CPU/memory requests and limits, autoscaling, and pod scheduling for data workloads
• Troubleshoot container-level performance issues and resource contention
• Monitor and tune end-to-end pipeline performance across Airflow, dbt, and data platforms
• Identify bottlenecks in query execution, orchestration, and infrastructure
• Implement observability solutions (logs, metrics, alerts) for proactive issue detection
• Ensure high availability, fault tolerance, and resiliency of data pipelines
• Work closely with data architects, platform engineers, and business stakeholders
• Support financial reporting, accounting, and regulatory data use cases
• Enforce data engineering standards, security best practices, and governance policies

Skills

Python

Apache Airflow

DBT Core

Kubernetes

OpenShift

SQL

Performance optimization

Communication

Cloud platforms

Data modeling

Job description

hyrusinc in Jersey City, NJ is seeking a Senior Data Engineer with 8+ years of hands-on experience in data engineering, Apache Airflow, dbt Core, and cloud-native platforms to build and optimize scalable data pipelines for financial and accounting workloads. You will design complex Airflow DAGs, implement dbt models, and manage Kubernetes/OpenShift deployments, ensuring high availability and performance in production environments.

Strong Python, SQL, and collaboration skills are required.