Job Description

:

Sr. Data Integration Engineer (Datawarehouse Architect) (Financial Domain Exp)

Location: New York City, NY (Local Preferred)

Onsite: Day 1 \xe2\x80\x93 No remote

Job description:

Major Responsibilities:

\xc2\xb7 Experience designing and developing Enterprise Data Warehouse solutions.

\xc2\xb7 Demonstrated proficiency with Data Analytics, Data Insights

\xc2\xb7 Proficient writing SQL queries and programming including stored procedures and reverse engineering existing process

\xc2\xb7 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.\xe2\x80\xa2

\xc2\xb7 Perform code reviews to ensure fit to requirements, optimal execution patterns and adherence to established standards.

Skills

\xc2\xb7 12+ years - Enterprise Data Management

\xc2\xb7 10+ years - SQL Server based development of large datasets

\xc2\xb7 8+ years with Data Architecture

\xc2\xb7 5+ years\xe2\x80\x99 experience in Finance / Banking industry \xe2\x80\x93 some understanding of Securities and Banking products and their data footprints.

\xc2\xb7 2+ years Python coding experience

\xc2\xb7 Proficient with Data Visualization tools

\xc2\xb7 Hands-on experience with Snowflake utilities such as SnowSQL and SnowPipe

\xc2\xb7 Working knowledge of MS Azure configuration items with respect to Snowflake.

\xc2\xb7 Hands-on experience with Tasks, Streams, Time travel, Optimizer, Metadata Manager, data sharing

\xc2\xb7 Experience in Data warehousing - OLTP, OLAP, Dimensions, Facts, and Data modeling.

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

\xc2\xb7 Capable of discussing enterprise level services independent of technology stack

\xc2\xb7 Experience with Cloud based data architectures, messaging, analytics

\xc2\xb7 Superior communication skills

\xc2\xb7 Cloud certification(s)

\xc2\xb7 Any experience with Regulatory Reporting is a Plus

Education

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

• Master\xe2\x80\x99s degree strongly preferred

PCB Apps