Data Modeller 5782 (Toronto)

Overview

As part of the modernization of the analytics platform, review existing data model and redesign to be scalable and flexible to meet current program and client needs for analytical and operational reporting.

Responsibilities

• Support data migration plan to redesign current on‑premise or hybrid processes from a SQL Server environment to a cloud‑based data lake built on Azure Data Lake service, using Azure Databricks.
• Review business requirements, familiarize with and understand business rules and transactional data model; define conceptual, logical model and physical model mapping from data source to curated model and data mart.
  • a) Analyse requirements and recommend changes to the physical model.
  • b) Develop scripts for the physical model, create database and/or delta lake file structure.
  • c) Access Oracle DB environments, set necessary tools for developing solution.
• Implement data design met...