Senior Data Engineer
About The Position
The Senior Data Engineer is the primary architect and builder of ConnectOne Bank’s data infrastructure. The role designs, develops, and maintains scalable data pipelines, robust data models, and a secure data warehouse, primarily within the AWS ecosystem. It ensures the reliable acquisition, transformation, and storage of business data to support advanced analytics across the organization. The position supports the Bank’s People First culture and service expectations. It serves as a data architecture subject matter expert, establishing engineering practices and working with stakeholders to translate analytical needs into technical data structures. The role is suited to someone who can work effectively in a remote environment, manage projects with minimal oversight, and maintain high standards for data accuracy and system reliability.
Requirements
- Strong interest in and ability to support a People First approach.
- Comprehensive understanding of cloud computing principles and cloud-native data architectures, specifically 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 version control systems such as Git/GitHub and command-line interfaces.
- Seven or more years of progressive, dedicated experience in data engineering, data architecture, or a closely overlapping software engineering field.
- Ability to analyze complex pipeline failures, identify root causes in underlying data, and implement lasting solutions.
- Ability to listen to non-technical stakeholders and understand their analytical needs.
- Ability to thrive in a remote work environment, manage time effectively, and drive large-scale projects with minimal oversight.
- Meticulous attention to data accuracy and system reliability.
Nice To Haves
- AWS Certified Data Engineer certification.
- AWS Certified Solutions Architect certification.
- Official dbt certification.
Responsibilities
- Support the Bank’s People First focus and rules of engagement, maintain a professional demeanor, contribute as an active team member, provide excellent client service, and help make CNOB “A Better Place to Be.”
- Architect, build, and maintain data pipelines using Apache Airflow to move data across AWS S3 and Amazon Redshift.
- Design and implement scalable data models with dbt Labs, transforming raw data into clean datasets optimized for analytical queries.
- Set up new data sources and design secure, efficient ingestion architectures for third-party APIs, transactional databases, and external platforms.
- Maintain knowledge of the underlying data model to troubleshoot bottlenecks, optimize Redshift query performance, and implement data quality testing and alerting.
- Serve as a subject matter expert on data architecture and establish best practices for code reviews, version control, and CI/CD workflows within the data engineering team.
- Translate non-technical stakeholders’ analytical needs into technical data structures.
- Drive large-scale projects from conception through deployment with minimal oversight.
Benefits
- World-class health, vision, and dental benefits beginning on day one.
- 401(k) with employer match.
- Hybrid work from home, depending on role.
- Employee appreciation events, including team building, softball games, and food truck days.
- Employee assistance programs (EAP).
- Wellness programs, including flu shots, preventive care, health programs, and service discounts.
- Tuition reimbursement.
- Employee discount perks.
- Community service events.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Senior
Education Level
No Education Listed
