Job Description
Snowflake Database Specialist (DPS Payments Migration) Job Description
Introduction
Digital Platform Services (DPS) will be hosted as part of the Payments Migration Program. The shift of the DPS data platform from Banking to the Payments account will ensure that all DPS-related data are co-located in a single Snowflake account.
In the Snowflake Database Specialist responsibilities include, although not limited to:
- Work closely with Senior Data Architects and Senior Data Advisors to set up Snowflake components in DPS and Cards Snowflake environments.
- Create and maintain Snowflake databases, schemas, tables, and related objects.
- Administer Snowflake with limited admin privileges, including user management and security management.
- Perform Snowflake performance tuning and warehouse management, leveraging capabilities such as SnowSQL, SnowPipe, Time Travel, Fail-Safe, and cloning.
- Build and manage internal and external stages (e.g., AWS S3) and support integrations with third-party tools using available APIs, integration tools, or Python.
- Manage data migration and loading into Snowflake from multiple sources using appropriate ingestion/loading methods.
- Develop and optimize complex SQL queries to ensure performance and scalability.
- Manage code in Git repositories (e.g., GitHub) and promote it across environments (DEVL, UATL, CERT, PROD).
- Oversee change management tickets for production deployments and Snowflake-level changes.
- Support Snowflake capabilities such as data sharing, data pipelines, and data security controls.
In addition to the qualifications listed below, the ideal candidate will demonstrate the following traits:
- Strong ownership and accountability for platform stability, performance, and security.
- Detail-oriented approach to change management and production releases.
- Ability to collaborate effectively with senior technical stakeholders (architects/advisors).
- Strong problem-solving mindset and willingness to learn new integrations and tooling.
Minimum Qualifications
- Bachelor's degree in Computer Science, Engineering, or a related field.
- 45 years of experience working with Snowflake and cloud technologies (AWS or Azure).
- Hands-on experience administering Snowflake, including performance tuning and security management.
- Strong SQL skills, including writing and optimizing complex queries.
- Experience managing ETL/data migration into Snowflake from multiple sources.
- Experience creating internal/external stages (e.g., AWS S3) and integrating Snowflake with external tools via APIs or integration tooling.
- Programming experience in Python and JavaScript.
- Experience with version control and promoting code across environments using Git/GitHub.
- Snowflake certification on implementation and migration (or equivalent).
Preferred Qualifications
- Snowflake Pro Certification.
- Cloud certification in AWS or Azure.
Qualifications
BE
Range Of Year Experience-Min Year
5
Range Of Year Experience-Max Year
7
