Position: Data Engineer
We are seeking a highly skilled and motivated Data Engineer to join our growing team. The ideal candidate will support data architecture, data pipelines, and automation across multiple research and technology projects.
Key Responsibilities
· Design and implement *relational database schemas*, including *junction tables, composite primary keys, and foreign key constraints*.
· Define and enforce *data integrity rules* (unique constraints, referential integrity).
· Refactor existing schemas to improve *normalization and query performance*.
· Manage structured and unstructured datasets for research and analytics.
· Develop data models and optimize database performance.
· Collaborate with economists, engineers, and researchers on technical requirements.
· Ensure data accuracy, integrity, and security across projects.
· Automate workflows and support deployment of data solutions.
Required Qualifications
* Bachelor’s or Master’s degree in Computer Science, Data Engineering, Statistics, or a related field.
* Strong experience with SQL and data modeling.
* Proficiency with Python and common data engineering libraries.
· Strong experience in *relational database design* (PostgreSQL/MySQL).
· Proven ability to design *composite keys and many-to-many relationships*.
· Solid understanding of *database normalization and constraints*.
* Familiarity with ETL pipelines, APIs, and workflow orchestration.
* Knowledge of version control (Git) and CI/CD practices.
Preferred Skills
* Experience optimizing *complex SQL queries* on large relational datasets.
* Familiarity with *schema versioning and migration tools*.
* Experience refactoring legacy databases without data loss.
* Understanding of *data integrity, indexing strategies, and constraint performance*.
* Knowledge of data visualization platforms.
* Familiarity with patent data, regulatory data, or technical standards datasets.
Type d’emploi : Temps plein, CDI, CDD
Durée du contrat : 6 mois
Rémunération : 8.000,00DH à 9.000,00DH par mois
