Senior Data Engineer

ConnectOne Bank; Englewood Cliffs (NJ); Ibrido; USD 160.000 - 180.000; Tempo pieno

Vantaggi offerti da questo lavoro

Health benefits on day one

401k with employer match

Hybrid work from home

Employee appreciation events

Tuition reimbursement

Employee discounts

Descrizione del lavoro

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.” You’ll architect data pipelines using Apache

Competenze

• 7+ years of progressive experience in Data Engineering or related field.
• Expert-level SQL and Python skills with data modeling expertise.
• Hands-on experience with dbt, Airflow, Redshift, and AWS services.
• Strong understanding of data governance, security, and privacy practices.
• Ability to design scalable data architectures and resolve complex bottlenecks.

Mansioni

• Architect, build, and maintain data pipelines using Airflow across AWS S3 and Redshift.
• Design scalable data models with dbt Labs for analytical querying.
• Ingest data from APIs and databases into the lake/warehouse and ensure data quality.
• Troubleshoot bottlenecks, optimize Redshift performance, and implement testing.
• Set best practices for code reviews, version control, and CI/CD for the data team.

Conoscenze

People First mindset

Advanced SQL

Python

Airflow

dbt Labs

AWS

Redshift

Data modeling

Git/GitHub

CI/CD

Data governance

Strumenti

dbt Labs

Apache Airflow

Amazon Redshift

AWS S3

Git

GitHub

CLI

Descrizione del lavoro

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