Senior Data Engineer

ConnectOne Bank is building data capabilities that support mission-critical analytics while keeping people at the center. In this hybrid role in Englewood Cliffs, NJ, you will design and deliver a scalable AWS-based data platform that helps ensure reliable data access across the organization. You will work within the CNOB team and contribute to a culture focused on service, professionalism, and continuous improvement through “A Better Place to Be.”

What you’ll do

• Architect, build, 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 data into clean datasets optimized for analytical querying
• Support onboarding of new data sources, designing secure and efficient ingestion from third-party APIs, transactional databases, and external platforms into the data lake/warehouse
• Use deep knowledge of the underlying data model to troubleshoot bottlenecks, optimize Redshift query performance, and implement rigorous data quality testing and alerting
• Act as a subject matter expert on data architecture, setting best practices for code reviews, version control, and CI/CD workflows for the data engineering team
• Maintain professional collaboration and excellent service as part of the Bank’s “People First” focus and rules of engagement

What you bring

• People First mindset and ability
• Comprehensive understanding of cloud computing principles and cloud-native architectures, specifically AWS
• Deep knowledge of modern data warehousing, including schema design and data modeling methodologies
• Understanding of data governance, data privacy regulations, and enterprise security best practices
• Expert-level SQL and Python skills
• Hands-on mastery of dbt Labs, Apache Airflow, Amazon Redshift, and AWS S3
• Strong proficiency with 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 dissect complex pipeline failures, determine root causes in underlying data, and implement permanent solutions
• Aptitude to listen to non-technical stakeholders, understand analytical needs, and translate them into technical data structures
• Ability to thrive in a remote work environment, manage time effectively, and drive large-scale projects with minimal oversight
• Meticulous approach to ensure data accuracy and system reliability

Bonus points

• AWS Certified Data Engineer, AWS Certified Solutions Architect, or official dbt Certification (preferred, not required)

Compensation and benefits

Salary: USD 160,000 - 180,000 per year.

• 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

Technologies: Apache Airflow, AWS S3, Amazon Redshift, dbt Labs, SQL, Python, Git, GitHub, CI/CD