Senior Data Engineer

ConnectOne Bank is hiring a Senior Data Engineer to design and build the data infrastructure that powers reliable analytics. This hybrid role in Englewood Cliffs, NJ focuses on scalable pipelines, solid data modeling, and a secure AWS-based data warehouse.

Responsibilities

• Support the Bank’s “People First” focus and rules of engagement by maintaining a professional demeanor, serving as an active member of the CNOB team, delivering excellent service to clients, and contributing to making CNOB “A Better Place to Be”.
• Architect, develop, and maintain data pipelines using Apache Airflow, enabling seamless data movement across AWS S3 and Amazon Redshift.
• Design and implement scalable data models with dbt Labs, transforming raw inputs into cleaned datasets optimized for analytical querying.
• Enable onboarding of new data sources by designing secure, efficient ingestion architecture for third-party APIs, transactional databases, and external platforms into the data lake/warehouse.
• Troubleshoot pipeline and performance issues by using a strong understanding of the underlying data model, optimizing Redshift query performance, and applying rigorous data quality testing and alerting.
• Act as a subject matter expert for data architecture, defining best practices for code reviews, version control, and CI/CD workflows within the data engineering team.

Requirements

• Strong interest in “People First” and the ability to align with that mindset.
• Comprehensive understanding of cloud computing principles and cloud-native data architectures, specifically within the AWS ecosystem.
• Deep knowledge of modern data warehousing concepts, including schema design and data modeling methodologies.
• Understanding of data governance, data privacy regulations, and enterprise security best practices.
• Expert-level proficiency in SQL and Python.
• Hands-on mastery of dbt Labs, Apache Airflow, Amazon Redshift, and AWS S3.
• Strong proficiency with version control (Git/GitHub) and command-line interfaces.
• 7+ years of progressive, dedicated experience in Data Engineering, Data Architecture, or a heavily overlapping software engineering field.
• Ability to quickly analyze complex pipeline failures, determine root causes in underlying data, and implement permanent fixes.
• Capacity to listen to non-technical stakeholders, understand analytical needs, and translate those needs into technical data structures.
• Ability to thrive in a remote work environment, manage time effectively, and drive large-scale projects from conception to deployment with minimal oversight.
• Meticulous approach to ensure absolute data accuracy and system reliability.

Technology Stack

• Apache Airflow
• AWS S3
• Amazon Redshift
• dbt Labs
• SQL
• Python
• Git
• GitHub
• CI/CD

Benefits

• World class health, vision, and dental benefits on day one
• 401k with employer match
• Hybrid work from home (depending on role)
• Employee appreciation events (team building, softball games, food truck days, etc.)
• Employee assistance programs (EAP)
• Wellness programs (flu shot, preventive care, health programs and services discounts, etc.)
• Tuition reimbursement
• Employee Discount perks
• CNOB Community Service Events

Bonus Points

• AWS Certified Data Engineer
• AWS Certified Solutions Architect
• Official dbt certification

Location: Englewood Cliffs, NJ (hybrid)

Compensation: USD 160,000 - 180,000 per year

Minimum Experience: 7 years