Job Description
Industry: Financial Services - Commercial Banking
Job Category: Information Technology - Other IT
With a startup spirit and 90,000+ curious and courageous minds, we have the expertise to go deep with the world’s biggest brands—and we have fun doing it. Now, we’re calling you all who see the world differently and are bold enough to reinvent it.
Transformation happens here. Come, be a part of our exciting journey!
Are you the one we are looking for?
Inviting applications for the role of Snowflake Architect and Lead.
Responsibilities
- Enhance an existing implementation in Snowflake to ingest and publish additional datasets to consumers
- Design and implement schema – tables, views – across each of the Snowflake layers and any sql based transformation that meets performance requirements for accessing data.
- Design and implement Snowflake entitlements to secure the data, through Snowflake policies and data models within the schema (row and column based entitlements, dynamic masking of columns for a specific period within the database), ensuring performance requirements are met
- Write Snowflake stored procedures and Snowflake SQLs
- Lead an offshore team, assisting them as well as required.
- Coordinate with other stakeholders like product owners and data source system owners to understand the requirements and the data
- Write SQL to test data transformation and migration
Having experience of
- Snowflake data architecture composed of four layers – Raw, Staging, Core and Consumer
- Extract, Load, Transform implementation using Snowflake data architecture
- Implementing Data Quality framework for Snowflake
- Row and Column level security in Snowflake for currently available data
- Implementing with CI/CD pipelines
- Nice to have – ETL Experience in sourcing data from REST APIs to Snowflake
- Nice to have – ETL Experience in sourcing data from databases to Snowflake
- Nice to have – Human resource data sets experience
Base Salary - USD $80,000 to $100,000
*** Never repost ***
Full-time
Benefits - Full
Relocation Assistance Available - No
Commission Compensation - No
Bonus Eligible - No
Overtime Eligible - No
Interview Travel Reimbursed - No
CANDIDATE DETAILS
7+ to 10 years experience
Seniority Level - Mid-Senior
Management Experience Required - No
Minimum Education - Bachelor's Degree
Willingness to Travel - Always
Powered by JazzHR
lfzkandRZI