*In person interview is mandatory*
*Role : Cloud Data Engineer/ Snowflake*
*Location : NYC / NJ (hybrid)*
*Job Description:*
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
Job Type: Contract
Pay: $50.
00 - $70.
00 per hour
Expected hours: 40 per week
Experience level:
* 10 years
Schedule:
* 8 hour shift
* Monday to Friday
Application Question(s):
* This Job requires in person Interview.
Are you able to show at client location for an F2F Interview?
Experience:
* Snowflake: 3 years (Required)
* Python Coding: 2 years (Required)
* Enterprise Data Management: 10 years (Required)
* Microsoft SQL Server: 10 years (Required)
Ability to Commute:
* Jersey City, NJ 07302 (Required)
Work Location: In person