Data Architect/Modeler for CDE Long-Term Solution

Lancesoft; Toronto; Hybrid; CAD 124,000 - 193,000; Full time

Job summary

Lancesoft in Toronto, ON is seeking a Data Architect/Modeller Senior for a 5-month contract with hybrid onsite/remote work. The role focuses on reviewing business needs, designing target data models, and mapping source data to target schemas.

Strong SQL and RDBMS skills are required along with expertise in data modelling tools and standards. The ideal candidate will collaborate with Business Analysts, SMEs, Developers, and Architects to deliver logical and physical data models aligned with

Qualifications

• 8+ years reviewing business needs and designing target data models.

Skills

Data architecture

Data modelling

SQL

RDBMS

Data analysis

Source-to-target mapping

Data integration

Enterprise data standards

Python

Azure Data Lakehouse

Delta Lake

Parquet

Star Schema

Snowflake

CASE Tools

Information Management

Tools

Delta Lake

Parquet

Snowflake

CASE Tools

Azure Data Lakehouse

Job description

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.

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.
• Expertisein data modelling tools and alignment with enterprise data modelling standards.
• Abilitytocollaboratewith Business Analysts, SMEs, Developers, Architects, and other stakeholders.
• Abilitytocommunicatedatamodellingoutputsandworkindependentlywithminimalsupervision.