logo

View all jobs

Data Integration Engineer

New York, NY · Information Technology
Our client, a major bank in New York City, is looking for talented Senior Data Integration Engineer Consultant.
Hybrid commute, 2/3 days home/office.

Consulting position, initial term is about 6 months with possible extensions and option to hire.
Hourly Rate: $90-100/h on W2. C2C is also an option.

Please read the description below and to be considered immediately email your resume to igork@brainsworkgroup.com

Senior Data Integration Engineer

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.
Requirements:
  • 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)
  • Regulatory Reporting experience is a Plus
  •  
Education: 
  • Minimally a BA degree within an engineering and/or computer science discipline
  • Master’s degree strongly preferred


Please email your resume or
Use this link to apply directly:
https://brainsworkgroup.catsone.com/careers/index.php?m=portal&a=details&jobOrderID=16160612
Or email: igork@brainsworkgroup.com
Check ALL our Jobs: http://brainsworkgroup.catsone.com/careers




Keywords: sql python banking financial snowflake snow azure integration architecture visualization OLTP OLAP cloud regulatory metadata
Powered by