Senior Data Engineer

ConnectOne Bank is building dependable, secure data foundations to support advanced analytics and critical business decision-making. In this hybrid role based in Englewood Cliffs, NJ, the Senior Data Engineer will act as a primary architect and builder of the bank’s data infrastructure within an AWS ecosystem.

You’ll design and maintain scalable pipelines and data models, ensure data quality through testing and alerting, and help standardize engineering practices across the data team.

Role focus

• Design, develop, and maintain scalable data pipelines, robust data models, and a secure data warehouse on AWS
• Enable reliable acquisition, transformation, and storage of critical business data for analytical use

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, and providing excellent client service while helping make CNOB “A Better Place to Be”
• Architect, build, and maintain data pipelines using Apache Airflow, including seamless data movement across AWS S3 and Amazon Redshift
• Design and implement scalable data models using dbt Labs to transform raw data into clean datasets optimized for analytical querying
• Help set up new data sources by designing secure, efficient ingestion into the data lake/warehouse from third-party APIs, transactional databases, and external platforms
• Troubleshoot bottlenecks and optimize Redshift query performance by maintaining strong understanding of the underlying data model, while implementing rigorous data quality testing and alerting
• Act as a subject matter expert on data architecture, establishing best practices for code reviews, version control, and CI/CD workflows within the data engineering team

Requirements

• People First interest and ability
• Comprehensive understanding of cloud computing and cloud-native data architectures, specifically within AWS
• 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 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 analyze complex pipeline failures, identify 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 by managing time effectively and driving large-scale projects from conception to deployment with minimal oversight
• Meticulousness focused on absolute data accuracy and system reliability

Technologies

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

Compensation

• USD 160,000 - 180,000 per year

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 for

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