Data Integration Engineer Jobs

Full time or direct contract role available for a Senior Data Engineer (Snowflake) with integration experience - hybrid - Montreal.

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 :-

• 8+ years - Enterprise Data Management

• 8+ years - SQL Server based development of large datasets

• 2+ 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