Senior Data Engineer

The Senior Data Engineer is the primary architect and builder of our data infrastructure. The purpose of this position is to design, develop, and maintain highly scalable data pipelines, robust data models, and a secure data warehouse. Operating primarily within an AWS ecosystem, this role ensures the reliable acquisition, transformation, and storage of critical business data to empower advanced analytics across the organization., * Architect, build, and maintain data pipelines using Apache Airflow, ensuring seamless data movement across AWS S3 and Amazon Redshift.

• Design and implement scalable data models using dbt Labs, transforming raw data into clean datasets optimized for analytical querying.
• Facilitate the setup of new data sources, designing the architecture to securely and efficiently ingest data from third-party APIs, transactional databases, and external platforms into the data lake/warehouse.
• Maintain a deep understanding of the underlying data model to troubleshoot bottlenecks, optimize Redshift query performance, and implement rigorous data quality testing and alerting.
• Serve 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.

• Strong “People First” interest and ability.
• Comprehensive understanding of cloud computing principles and cloud-native data architectures, specifically within the Amazon Web Services (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 systems (Git/GitHub) and command-line interfaces.
• 7+ years of progressive, dedicated experience in Data Engineering, Data Architecture, or a heavily overlapping software engineering field.
• The ability to quickly dissect complex pipeline failures, identify root causes in underlying data, and implement permanent solutions.
• The aptitude to listen to non-technical stakeholders, understand their analytical needs, and translate those needs into technical data structures.
• The capacity to thrive in a remote work environment, managing time effectively, and driving large-scale projects from conception to deployment with minimal oversight.
• A natural meticulousness required to ensure absolute data accuracy and system reliability.

Bonus Points For:

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

• 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

ConnectOne Bank proves that putting people first is a better way to do business. At ConnectOne, we’re builders - of businesses, communities, and equity. Most importantly, we’re building opportunities. Our mission is to ensure our employees feel empowered to make important decisions, reach their potential and truly make an impact.

ConnectOne is a growth organization by design; it is part of our DNA and we take pride in seeing our employees grow with us. Founded in 2005 by an entrepreneur, we have grown into a high-performing commercial bank, inspiring a new model for our industry’s future. By embracing technology and all the ways it can help us become a world-class service organization, we support small business owners by fueling their mission.

People First is the blueprint for our culture. It is at the foundation of everything we do and the decisions we make. At ConnectOne, you have the opportunity to be a part of a dynamic culture and team. Develop your forward-thinking skills, thrive in an entrepreneurial setting, and succeed at “a better place to be”.

ConnectOne Bank is an Equal Housing and Equal Opportunity Lender, and a member of the Federal Deposit Insurance Corporation., * Support the Bank’s “People First” focus and rules of engagement-maintaining a professional demeanor, working as an active member of the CNOB team, providing clients excellent service, always striving to make CNOB “A Better Place to Be”