Snowflake Data Engineer

About this role

Summary:

Responsible for developing and maintaining the Snowflake database structure that supports the bank's operations. Designs and documents database schemas, writes and debugs stored procedures, while optimizing query performance. This position requires the ability to design database systems that store and provide secure access to customer and financial information.

Qualifications:

Education: Bachelor's degree in a computer related discipline.

Experience: Five years of experience in the card payment industry in a developer role. Knowledge of Snowflake and AWS, and multiple database technologies such as mySQL and SQL Server. Experience with developing complex ETL in Data Processing environments within relational and non-relational database platforms. Or equivalent combination of education and training.

Essential Functions:

• Responsible for technical delivery review, resolution of architecture issues within Snowflake.
• Ability to create, troubleshoot, enhance complex code in Snowflake.
• Designs and develops banking solutions for data, and reporting needs.
• Experience in building data pipelines (ETL) with Snowflake cloud data platform using AWS storage layers (S3).
• Collaborates on the design of Snowflake architecture and configure databases to meet the institution's functional requirements.
• Identify, document, and communicate technical risks, issues and alternative technical solutions discovered during projects.
• Works with the Manager of Data Analytics and Operations (DAO) to ensure that the Sutton Bank database aligns with the overall needs of data stakeholders.
• Assists in test environment data requirements setup and maintenance, testing and validation.
• Assists with designing new data pipelines as part of onboarding additional payment processors, programs, and third-party data sources.
• Works with Manager DAO to investigate and resolve application and data integrity issues.
• Builds high-quality processes that adhere to the...