Data Modeller

• Role: MongoDB Data Modeller
• Location: Toronto, ON
• Duration: Long Term Contract

Job Description:

• MongoDB data modeller (JSON data modelling and schema creation).
• 5+ years of experience in JSON-based data modelling. Lead schema design to ensure data quality and performance.
• Create XSD and JSON schemas. Lead MongoDB schema evolution, versioning, and migration. Rahona Data Engineer (data analytics ingestion and curation). Advanced proficiency with SQL query language.
• Advanced proficiency in PySpark, including Spark SQL and performance optimization.
• Minimum 2+ years of experience with Azure Cloud Development such as Azure Databricks (primary platform for PySpark), Azure Data Factory (ADF), Azure Synapse.
• Strong knowledge of data ingestion, ETL processes, and orchestration frameworks for cloud environments.
• Ability to design and manage data pipelines—extracting, transforming, and loading data—especially in cloud environments.

• Soft Skills
• Ability to work with business partners to gather data requirements. Strong analytical thinking, problem-solving, and troubleshooting abilities.
• Self-motivated and proactive, with a keen eye for identifying opportunities for improvement and efficiency.
• Excellent communication and documentation skills. NICE-TO-HAVE SKILLS: MongoDB data modeller (JSON data modelling and schema creation).
• Apply MongoDB schema design patterns to develop scalable, performant data models.
• Understand Confluent Kafka Schema Registry and how it influences schema design.
• Experience with MongoDB indexing, sharding, and performance.
• Experience with MongoDB Atlas in Azure. Rahona Data Engineer (data analytics ingestion and curation).
• Knowledge of TD governance processes e.g., PIA, DAC. Familiarity with complying with audits and how processes should be set up so that audits go smoothly.

• Domain Knowledge and Soft Skills.
• Knowledge of the Payments domain. Awareness of ISO 20022 schemas in the Payments domain. Understanding data quality and lineage expectations for regulated environments.
• Ability to work independently, research and explore new technologies, and develop solutions to complex problems while meeting timelines.