Intermediate Data Modeler- Capital Markets - data architecture strategy, data modeling, and the overall data practice with a OLTP environment - 80460-1

Position Title: Data Architect

Line of Business: Capital Markets ASG

Duration: 1 year

Potential for this contract to be extended or converted to FTE? FTE is conversion/extension is possible

Remote/Hybrid: Hybrid, twice a week

Office Location: 161 Bay 4th floor

How many years of experience? 5+ years

Job Description: Seasoned professional responsible for providing operational leadership, governance and stewardship for the data architecture strategy, data modeling, and the overall data practice, in addition to all related principles, policies, and procedures around data management. Your responsibilities extend to leading the Data Architecture practice within the team, creating & improving processes & Artifacts, and providing training & guidance to other members of the team.

Must Have Requirement:

· Experience with OLTP systems/data modelling - 2+ years

· Data Modelling (logical and physical both are required) experience - 5 years

· Oracle, DB2, SQL server or other RDBMS - 5+ years

· Experience with data modeling tools (Erwin is preferred) - 5 years

· Performance optimization - 2 years

· SQL experience - 5 years

Nice to Have:

· NO SQL and Mongo db

· PL/SQL

· Experience with banking/financial industry

· Power BI/Cognos experience

Notes: Not looking for ETL developers/ not looking for warehouse experience/ looking for online applications for OLTP system.