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 mannerAncillary 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