Data Architect/Modeler for CDE Long-Term Solution

Position: Data Architect/Modeller – Senior
Location: Toronto, Ontario (Hybrid – 3 Days Onsite / 2 Days Remote)
Office Location: 40 St. Clair Avenue West, Toronto, ON
Duration: 5 Months Contract (Possibly Extension)

Keywords: Data Architecture, Data Modelling, Data Architect, Logical Data Models, Physical Data Models, SQL, RDBMS, Data Analysis, Data Mapping, Source-to-Target Mapping, Data Modelling Tools, Enterprise Data Standards, Python, Azure Data Lakehouse, Delta Lake, Parquet, Star Schema, Snowflake, CASE Tools, Information Management, Data Integration.

Job Description

Mandatory Requirements:

• 8+ years of experience reviewing and analyzing business needs and requirements for existing IT applications and related data, and designing target data models.

• Strong experience in research, data analysis, and developing effective IT data model designs.

• Experience analyzing source data models and developing source-to-target data mappings.

• Excellent RDBMS knowledge and SQL skills for data analysis and validation.

• Experience creating, developing, and managing logical and physical data models.

• Expertise in data modelling tools and alignment with enterprise data modelling standards.

• Ability to collaborate with Business Analysts, SMEs, Developers, Architects, and other stakeholders.

• Ability to communicate data modelling outputs and work independently with minimal supervision.