Data Engineer

Overview

At Community Financial System, Inc. (CFSI), we are dedicated to providing our customers with friendly, personalized, high-quality financial services and products. Our retail division, Community Bank, N.A., operates more than 200 customer facilities across Upstate New York, Northeastern Pennsylvania, Vermont and Western Massachusetts.

Beyond retail banking, we also offer commercial banking, wealth management, investment management, insurance and risk management, and benefit plan administration. Just as our employees are committed to helping our customers manage their finances, we’re committed to our employees. After all, they make it happen for our customers every day.

To ensure our people can enjoy long and successful careers here at CFSI, we offer competitive compensation, great benefits, and professional development and advancement opportunities. As an equal-opportunity workplace and affirmative-action employer, we celebrate and support a diverse workplace for the benefit of all: our employees, customers and communities.

Responsibilities

This position is responsible for designing, building, and maintaining data pipelines and architectures. Ability to work independently on strategic, high-level data modeling projects along with the senior Data Architect on the team.

Responsibilities

include, but are not limited to, integrating data from different sources and ensuring data quality, developing and implementing database solutions for data storage and retrieval, collaborating with data analysts to support data-driven initiatives as well as monitoring data infrastructure performance and optimizing data processing.

Essential Duties

Designing and implementing data pipelines to efficiently extract, transform, and load (ETL) from various data sources into a central repository or data lake (Snowflake) Building and maintaining scalable and robust data infrastructure, including relational databases, data lakes, and distributed computing systems that are equipped to handle large volumes of data Collaborating with data analysts to understand metrics and data requirements and to provide them with access to the necessary data sets and data systems Implementing data validation and cleaning processes to ensure data quality and monitoring data pipelines for errors or anomalies Optimizing data storage and retrieval processes to enhance performance and reduce latency, particularly through techniques such as indexing, partitioning, and caching Implementing data security and privacy measures, including data encryption, access controls, and compliance with data governance policies and regulations Assist with other key initiatives and other related DA projects Ability to understand and maintain a view of the big picture while creating detailed, operation level processes, workflows, and requirements.

Deep understanding and functional knowledge of various development tools and SQL flavors. Ability to design, develop and implement various data model as required by projects across the organization. Maintain proficient knowledge of, and demonstrate ongoing compliance with all laws and regulations applicable to this position, ensure ongoing adherence to policies, procedures, and internal controls, and meet all training requirements in a timely manner Ancillary Duties: As an integral member of the Data & Analytics Department, this position is responsible to provide assistance wherever necessary to help the department and the bank in achieving their goals Qualifications Education, Training and Requirements: Bachelor’s Degree in Computer Science, Information Systems, or other related field.

Skills: 3+ years as data engineer Experience with Snowflake and DBT; ELT tools, preferably Astronomer and Apache Airflow. Experience with BI tools, preferably Power BI Strong working knowledge of Python, SQL, and Git. Familiarity with data modeling and data warehousing concepts, preferably with experience using modeling tools like DBT or DataIKU.

Working knowledge with cloud data warehousing, preferably in Snowflake, Azure or similar cloud infrastructure Excellent verbal and written communication skills in technical and user-friendly manner, adaptability to changing priorities. Must have the ability to collaborate and work in a team environment. Any prior experience/knowledge of AI/ML practices will be given high preference, primarily responsible for leveraging advanced analytics techniques, particularly in artificial intelligence (AI) and machine learning (ML).

Experience: Minimum 3 years of proven experience in a data engineering role. Banking experience preferred. Other Job Information Compensation: Commensurate with experience plus potential for annual merit increase. In addition to your competitive salary, you will be rewarded benefits including: 11 paid holidays, paid vacation, Medical, Vision & Dental insurance, 401K with generous match, Pension, Tuition Reimbursement, Banking discounts and the list goes on!

Physical Requirements: The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. While performing the duties of this job, the employee may be required to stand, walk or sit.

Use hands and fingers, handle or feel, reach with hands or arms, and speak and hear. The employee may occasionally be required to lift and or move up to 25 pounds. Specific vision abilities required by this job include close vision, and the ability to focus. The Company is an Affirmative Action, Equal Opportunity Employer.

All qualified applicants will receive consideration for employment without regard to race, color, religion, sex (including pregnancy, sexual orientation and gender identity), national origin, citizenship status, age, disability, genetic information, veteran status, or any other characteristic protected by applicable federal, state or local law.

The Company will make reasonable accommodations for qualified individuals with a disability. If you have a physical or mental impairment and would like to request an accommodation with respect to the application process, please contact the Human Resources Department. Minimum USD $66,000.00/Yr. Maximum USD $108,804.00/Yr.

This position is responsible for designing, building, and maintaining data pipelines and architectures. Ability to work independently on strategic, high-level data modeling projects along with the senior Data Architect on the team.

Responsibilities

include, but are not limited to, integrating data from different sources and ensuring data quality, developing and implementing database solutions for data storage and retrieval, collaborating with data analysts to support data-driven initiatives as well as monitoring data infrastructure performance and optimizing data processing.

Essential Duties

Designing and implementing data pipelines to efficiently extract, transform, and load (ETL) from various data sources into a central repository or data lake (Snowflake) Building and maintaining scalable and robust data infrastructure, including relational databases, data lakes, and distributed computing systems that are equipped to handle large volumes of data Collaborating with data analysts to understand metrics and data requirements and to provide them with access to the necessary data sets and data systems Implementing data validation and cleaning processes to ensure data quality and monitoring data pipelines for errors or anomalies Optimizing data storage and retrieval processes to enhance performance and reduce latency, particularly through techniques such as indexing, partitioning, and caching Implementing data security and privacy measures, including data encryption, access controls, and compliance with data governance policies and regulations Assist with other key initiatives and other related DA projects Ability to understand and maintain a view of the big picture while creating detailed, operation level processes, workflows, and requirements.

Deep understanding and functional knowledge of various development tools and SQL flavors. Ability to design, develop and implement various data model as required by projects across the organization. Maintain proficient knowledge of, and demonstrate ongoing compliance with all laws and regulations applicable to this position, ensure ongoing adherence to policies, procedures, and internal controls, and meet all training requirements in a timely manner Ancillary Duties: As an integral member of the Data & Analytics Department, this position is responsible to provide assistance wherever necessary to help the department and the bank in achieving their goals Education, Training and Requirements: Bachelor’s Degree in Computer Science, Information Systems, or other related field.

Skills: 3+ years as data engineer Experience with Snowflake and DBT; ELT tools, preferably Astronomer and Apache Airflow. Experience with BI tools, preferably Power BI Strong working knowledge of Python, SQL, and Git. Familiarity with data modeling and data warehousing concepts, preferably with experience using modeling tools like DBT or DataIKU.

Working knowledge with cloud data warehousing, preferably in Snowflake, Azure or similar cloud infrastructure Excellent verbal and written communication skills in technical and user-friendly manner, adaptability to changing priorities. Must have the ability to collaborate and work in a team environment. Any prior experience/knowledge of AI/ML practices will be given high preference, primarily responsible for leveraging advanced analytics techniques, particularly in artificial intelligence (AI) and machine learning (ML).

Experience: Minimum 3 years of proven experience in a data engineering role. Banking experience preferred.