Data Engineer

Community Financial System, Inc. offers an opportunity to build and improve the data foundations that support data-driven initiatives. This onsite role in Syracuse, NY combines hands-on engineering work with close collaboration across Data & Analytics, helping the team deliver reliable data pipelines, strong data quality, and dependable infrastructure performance.

Compensation: USD 66,000 - 108,804 per year.

What You’ll Do

• Design and implement data pipelines for ETL from multiple data sources into a central repository or data lake on Snowflake.
• Build and maintain scalable, robust data infrastructure, including relational databases, data lakes, and distributed computing systems capable of handling large data volumes.
• Partner with data analysts to understand metrics and data needs, and provide access to required datasets and data systems.
• Implement data validation and cleaning processes to ensure data quality, while monitoring pipelines for errors or anomalies.
• Optimize storage and retrieval performance to reduce latency, using techniques such as indexing, partitioning, and caching.
• Apply data security and privacy measures, including encryption, access controls, and adherence to data governance policies and relevant regulations.
• Support additional key initiatives and related DA projects within the organization.
• Use strong process thinking by balancing big-picture understanding with detailed operational workflows and requirements.
• Maintain ongoing compliance with applicable laws, internal controls, and training requirements.
• Contribute across the Data & Analytics Department to help the department and the bank meet their goals.

What We’re Looking For

• Bachelor’s Degree in Computer Science, Information Systems, or a related field.
• 3+ years of data engineering experience.
• Experience with Snowflake and DBT.
• ELT tools experience, preferably Astronomer and Apache Airflow.
• BI tools experience, preferably Power BI.
• Strong working knowledge of Python, SQL, and Git.
• Familiarity with data modeling and data warehousing concepts, including experience with tools such as DBT or DataIKU.
• Working knowledge of cloud data warehousing, preferably Snowflake or Azure.
• Excellent verbal and written communication skills, with the ability to adapt to changing priorities.
• Ability to collaborate and work effectively in a team environment.
• Prior experience/knowledge of AI/ML practices is given preference, including leveraging advanced analytics techniques, particularly AI and ML.
• Banking experience preferred.

Tools and Technologies

Snowflake, DBT, Astronomer, Apache Airflow, Power BI, Python, SQL, Git, DataIKU, Azure, ETL, ELT

Benefits

• 11 paid holidays
• Paid vacation
• Medical, Vision & Dental insurance
• 401K with generous match
• Pension
• Tuition Reimbursement
• Banking discounts

Physical Requirements

• May be required to stand, walk, or sit.
• Ability to use hands and fingers, handle or feel, reach with hands or arms, and speak and hear.
• May occasionally be required to lift and/or move up to 25 pounds.
• Specific vision abilities required, including close vision and the ability to focus.