Senior Data Engineer

Senior Data Engineer

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.

In This Role You Will

• 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"
• 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.

Must Haves

• 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.

Additional Information

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

…and much, much more!

Studies have shown that individuals from underrepresented groups, may only apply to roles if they meet 100% of the qualifications. Roles evolve over time, especially with innovation, and you may be just the person we need. We hope you're open to learning new skills and growing with us. We encourage you to apply to continue making us "a better place to be!"

ConnectOne Bank is an equal opportunity employer and does not discriminate with respect to any term, condition or privilege of employment based on race, color, religion, sex, sexual orientation, gender identity or expression, age, disability, military or veteran status, marital status, or status of an individual in any group or class protected by applicable federal, state, or local law.

ConnectOne Bank also provides reasonable accommodations for qualified individuals with disabilities in accordance with the Americans with Disabilities Act and applicable state and local laws. If an accommodation is needed to participate in the job application or interview process, please contact Talent Acquisition.