Data Modeller

Description:

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.