SNOWFLAKE ARCHITECT AND LEAD

BOUNTY 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, were 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. Snowflake - Snowflake architect and lead. onsite role Location: NY - Need local and hybrid. Employment: FTE Hands on 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 Led 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 sqls to test data transformation and migration. Having experience of Snowflake data architecture composed of four layers Raw, Staging, Core and Consumer Extract, Load, and 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. The approximate annual base compensation range for this position is $80,000 to $100,000. The actual offer, reflecting the total compensation package plus benefits, will be determined by a number of factors which include but are not limited to the applicant's experience, knowledge, skills, and abilities; geographic location; and internal equity. Security Clearance Required: NoVisa Candidate Considered: No COMPENSATION 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 WHY WE'RE A GREAT COMPANY Our Company is an Equal Opportunity Employer and considers applicants for all positions without regard to race, color, religion or belief, sex, age, national origin, citizenship status, marital status, military/veteran status, genetic information, sexual orientation, gender identity, physical or mental disability or any other characteristic protected by applicable laws. We are committed to creating a dynamic work environment that values diversity and inclusion, respect and integrity, customer focus, and innovation. INTAKE SESSION There will not be an intake session call for this Bounty