SNOWFLAKE ARCHITECT AND LEAD

StaffWorthy; New York (NY); On-site; USD 80,000 - 100,000; Full time

Benefits offered by this job

Full relocation assistance

Full-time benefits

Job summary

A financial services company in New York is seeking a Snowflake Architect and Lead. The successful candidate will enhance existing Snowflake implementations and design schema tables for optimal performance. This role requires 7-10 years of experience in Snowflake architecture, proficiency in SQL, and knowledge of data quality frameworks. The compensation for this position ranges from $80,000 to $100,000 annually and includes full-time benefits.

Qualifications

• 7+ to 10 years' experience in Snowflake architecture.
• Experience with data transformation and migration.
• Knowledge of row and column level security in Snowflake.

Responsibilities

• Enhance existing implementations in Snowflake.
• Design and implement schema tables and views.
• Write Snowflake SQLs and procedures.

Skills

Snowflake architecture

Data Quality framework

CI/CD pipeline implementation

ETL from REST APIs

SQL proficiency

Education

Bachelor's Degree

Job description

About the job SNOWFLAKE ARCHITECT AND LEAD

BOUNTY DESCRIPTIONIndustry: 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.

• 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: NoCOMPENSATION
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 - NoCANDIDATE DETAILS7+ to 10 years' experienceSeniority Level - Mid-Senior Management Experience Required - No Minimum Education - Bachelor's Degree Willingness to Travel - AlwaysWHY 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 arecommitted to creating a dynamic work environment that values diversity and inclusion, respect and integrity, customer focus, and innovation. INTAKE SESSIONThere will not be an intake session call for this Bounty