Data Engineer

Community Financial System, Inc. is hiring a Data Engineer for an onsite role in Syracuse, NY. This position focuses on building and maintaining reliable data pipelines and architectures, helping the Data & Analytics Department deliver data-driven initiatives with dependable performance and strong data quality. The salary range is USD 66,000 - 108,804 per year.

What You’ll Do

You will design, build, and maintain data pipelines and data infrastructure that integrate information from multiple sources and support a central data repository or data lake in Snowflake. You will work closely with data analysts to understand metrics and data needs, provide access to the right datasets and systems, and support ongoing analytics requirements.

• Design and implement ETL pipelines to extract, transform, and load data from multiple sources into a central repository or data lake (Snowflake)
• Build and maintain scalable, robust data infrastructure, including relational databases, data lakes, and distributed computing systems for large volumes of data
• Implement data validation and data cleaning processes, and monitor pipelines for errors or anomalies
• Optimize storage and retrieval to improve performance and reduce latency using techniques such as indexing, partitioning, and caching
• Implement data security and privacy measures, including encryption, access controls, and adherence to data governance policies and regulations
• Support additional key initiatives and related DA projects as needed
• Balance high-level system thinking with detailed operational workflows, processes, and requirements
• Maintain ongoing compliance with applicable laws and regulations, internal controls, policies, procedures, and training requirements
• As part of the Data & Analytics Department, assist wherever needed to help the department and the bank achieve their goals

You will also apply strong technical depth across tools and SQL environments, developing data models as required across the organization and supporting modern data transformation workflows.

Required Skills & Experience

• Bachelor’s degree in Computer Science, Information Systems, or a related field
• 3+ years as a data engineer (minimum)
• Experience with Snowflake and DBT
• Exposure to 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, preferably using tools such as DBT or DataIKU
• Working knowledge of cloud data warehousing, preferably Snowflake, Azure, or similar infrastructure
• Excellent verbal and written communication skills, with the ability to present technical information in a user-friendly way and adapt to changing priorities
• Ability to collaborate and work effectively in a team environment
• AI/ML experience is given preference, with primary responsibility to leverage advanced analytics techniques, particularly AI and machine learning (ML)
• Banking experience preferred

Technology Focus

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
• Use hands and fingers, handle or feel, reach with hands or arms, and speak and hear
• Occasionally required to lift and/or move up to 25 pounds
• Specific vision abilities required, including close vision and the ability to focus