Cloud Data Engineer/Snowflake

Role: Cloud Data Engineer/ Snowflake

Location: NYC / NJ (hybrid)

Duration: 6+ Months

Job Description:

In person interview is mandatory

This position is for a Cloud Data / Reporting engineer with a background in SQL and data warehousing for enterprise level systems. The position calls for someone that is comfortable working with business users along with business analyst expertise.

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:

10+ years - Enterprise Data Management

10+ years - SQL Server based development of large datasets

5+ years with Data Warehouse Architecture, Snowflake experience preferred

3+ 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 SnowPipe

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.

Previous experience leading an enterprise-wide Cloud Data Platform migration with strong architectural and design skills

Capable of discussing enterprise level services independent of technology stack

Experience with Cloud based data architectures, messaging, and analytics

Superior communication skills

Cloud certification(s)

Any experience with Regulatory Reporting is a Plus

Education

Minimally a BA degree within an engineering and/or computer science discipline

Master's degree strongly preferred