Job Description

Candidate should have data modeling experience, Erwin data modelling tool Experience with AWS and Redshift database models is a plus Designing L2 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 L2 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.
Job Type: Full-time

Pay: $50.00-$55.00 per hour

Application question(s):

Do you have experience with Erwin Data Modeling tools? Do you have experience with OLAP? Do you have experience with MDX queries and coding? * Can you do 3 days a week in office based in Toronto?