Lead​/Architect Snowflake

Lead/Architect Snowflake

Location:

Charlotte, NC-Hybrid with 2-3 /days WFH

Duration: 6+ Months

Job Description:

Must be local or ready to relocate

Major Responsibilities:

• Experience designing and developing Enterprise Data Warehouse solutions.
• Demonstrated proficiency with Data Analytics, Data Insights
• Proficient writing SQL queries and programming including stored procedures and reverse engineering existing process
• Leverage SQL, programming language (Python or similar) and/or ETL Tools (Azure Data Factory, Data Bricks, Talend and SnowSQL) to develop data pipeline solutions to ingest and exploit new and existing data sources.
• Perform code reviews to ensure fit to requirements, optimal execution patterns and adherence to established standards.

Skills:

• 5+ years - Enterprise Data Management
• 5+ years - SQL Server based development of large datasets
• 1+ years with Data Architecture
• 2+ years’ experience in Finance / Banking industry – some understanding of Securities and
• Banking products and their data footprints.
• 2+ years Python coding experience
• Proficient with Data Visualization tools
• Hands-on experience with Snowflake utilities such as SnowSQL and Snow Pipe
• Working knowledge of MS Azure configuration items with respect to Snowflake.
• Hands-on experience with Tasks, Streams, Time travel, Optimizer, Metadata Manager, data sharing
• Experience in Data warehousing - OLTP, OLAP, Dimensions, Facts, and Data modeling.