Data Modeler

Role : Data Modeler

Location- Toronto ( Hybrid)

Type- 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

Secondary Skills