SNOWFLAKE ARCHITECT AND LEAD
Staffworthy - New York City, NY
Apply NowJob Description
About the job SNOWFLAKE ARCHITECT AND LEAD BOUNTY DESCRIPTION Industry: Financial Services - Commercial Banking Job Category: Information Technology - Other ITWith 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 roleLocation: NY - Need local and hybrid.Employment: FTEHands on Snowflake architect and lead.ResponsibilitiesEnhance 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 metWrite Snowflake stored procedures and Snowflake SQLsLed 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 ofSnowflake data architecture composed of four layers Raw, Staging, Core and ConsumerExtract, Load, and Transform implementation using Snowflake data architecture.Implementing Data Quality framework for SnowflakeRow and Column level security in Snowflake for currently available dataImplementing with CICD pipelinesNice to have ETL Experience in sourcing data from REST APIs to SnowflakeNice to have ETL Experience in sourcing data from databases to SnowflakeNice 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 COMPENSATIONBase 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 DETAILS7+ 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 COMPANYOur 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, militaryveteran 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
Created: 2025-02-17