Design, build, and maintain data pipelines and data infrastructure for data-driven initiatives in Syracuse, NY.

Design and implement data pipelines to extract, transform, and load (ETL) 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 data volumes
Collaborate with data analysts to understand metrics and data needs, providing access to required datasets and data systems
Implement data validation and cleaning processes to maintain data quality and monitor pipelines for errors or anomalies
Optimize data storage and retrieval for improved performance and reduced latency using methods such as indexing, partitioning, and caching
Apply data security and privacy measures, including encryption, access controls, and compliance with data governance policies and regulations
Support additional key initiatives and related Data & Analytics projects as needed
Maintain big-picture understanding while producing detailed operational workflows, processes, and requirements
Develop and implement data models and support data modeling and warehousing requirements across the organization
Demonstrate ongoing compliance with applicable laws, regulations, policies, procedures, internal controls, and required training
Serve as an integral member of the Data & Analytics Department by providing assistance wherever needed to help the department and the bank achieve goals

Bachelor’s Degree in Computer Science, Information Systems, or another related field
3+ years as a data engineer (minimum 3 years of proven experience)
Experience with Snowflake and DBT
Experience with 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 modeling tools such as DBT or DataIKU
Working knowledge of cloud data warehousing, preferably Snowflake, Azure, or similar cloud infrastructure
Excellent verbal and written communication skills in a technical and user-friendly manner; 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 using AI and ML
Banking experience preferred

May be required to stand, walk, or sit
May require use of hands and fingers, handle or feel, reach with hands or arms, and speak and hear
Occasionally may be required to lift or move up to 25 pounds
Specific vision abilities required: close vision and the ability to focus

Location: Syracuse, NY (onsite)

Data Engineer

Job Description