DATA MODELER

E-Solutions; Toronto; Hybrid; CAD 80,000 - 100,000; Part time

Job summary

A leading consulting firm seeks a Data Modeler for a hybrid role in Toronto. The ideal candidate will have significant data modeling experience, particularly with relational databases and tools like Erwin. Banking experience is essential, and familiarity with AWS and Redshift is a plus. Responsibilities include designing OLAP cubes and optimizing data models for analytics. Strong communication skills and attention to detail are crucial for success in a fast-paced environment.

Qualifications

• Experience with large data sets is required.
• Banking experience is a must.
• Finance data experience is a plus.

Responsibilities

• Design and develop OLAP cubes using Kyvos for large-scale data analytics.
• Write complex MDX queries to support reporting and dashboarding.
• Collaborate with data engineering teams to define data sources and relationships.

Skills

Data modeling experience

Erwin data modelling tool

Knowledge of SQL

Presentation skills

Organizational skills

Attention to detail

Ability to work in a fast-paced environment

Tools

AWS

Redshift

SAP PowerDesigner

Microsoft Visio

Kyvos

Job description

Data Modeler

Toronto (Preferred local candidates / Hybrid) - Contract

Job Responsibilities

Candidate should have data modeling experience, Erwin data modelling tool

Experience with AWS and Redshift database models is a plus

Designing L Layer experience for Large Data Transformation Program

Experience of working as a Lead Data Modeler and working with senior stakeholders

Knowledge of relational databases and data architecture computer systems, including SQL

Experience of ER modeling, big data, enterprise data, and physical data models

Experience of working with large data sets.

Banking experience is a must. Finance data experience, Anaplan experience is a plus.

Familiarity with data modeling software such as SAP PowerDesigner, Microsoft Visio, or erwin DataModeler

Excellent presentation, communication, and organizational skills

Strong attention to detail

Ability to work in a fast-paced environment

Design and develop OLAP cubes using Kyvos for large-scale data analytics. Write complex MDX queries to support reporting, dashboarding, and drill-through functionality.

Build and optimize data models to support high-performance BI queries and dashboards. Implement aggregation strategies, partitioning, and performance tuning within Kyvos. Collaborate with data engineering and architecture teams to define data sources, fact / dimension relationships, and schema models.

Primary Skills

Data modeling experience, Erwin data modelling tool. Experience with AWS and Redshift database models is a plus

Designing L Layer experience for Large Data Transformation Program. Experience of working as a Lead Data Modeler and working with senior stakeholders

Knowledge of relational databases and data architecture computer systems, including SQL. Experience of ER modeling, big data, enterprise data, and physical data models

Experience of working with large data sets. Banking experience is a must. Finance data experience, Anaplan experience is a plus.

Familiarity with data modeling software such as SAP PowerDesigner, Microsoft Visio, or erwin DataModeler. Excellent presentation, communication, and organizational skills. Strong attention to detail. Ability to work in a fast-paced environment

Design and develop OLAP cubes using Kyvos for large-scale data analytics. Write complex MDX queries to support reporting, dashboarding, and drill-through functionality.

Build and optimize data models to support high-performance BI queries and dashboards. Implement aggregation strategies, partitioning, and performance tuning within Kyvos. Collaborate with data engineering and architecture teams to define data sources, fact / dimension relationships, and schema models.

Secondary Skills

Excellent presentation, communication, and organizational skills

Strong attention to detail

Ability to work in a fast-paced environment