Job Description
Pay range 90-100/hr
onsite NYC- 2-3 days/week
- 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.
- 10+ years - Enterprise Data Management
- 10+ years - SQL Server based development of large datasets
- 5+ years with Data Architecture
- 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, 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