Data Analytics Engineer, Customer Data Platform
il y a 1 semaine
About the Role
We are seeking a versatile Data Analytics Engineer to serve as the critical bridge between data engineering and business analysis for the Dupont REGISTRY's Customer Data Platform (CDP). This role is responsible for the design, maintenance, and optimization of our core data warehouse while simultaneously empowering business stakeholders by creating high-impact analytical views and dashboards. You will be the primary owner of our Google BigQuery data environment, leveraging an ELT approach and Medallion Architecture.
Key ResponsibilitiesData Engineering & Architecture
- CDP Foundation: Design, build, and optimize robust data pipelines, primarily managing the Extract and Load phases to ingest raw data into the Bronze layer of BigQuery.
- Transformation Logic: Own the Transformation phase of the ELT process, developing and managing all complex data cleaning, conforming, and aggregation logic using dbt (Data Build Tool) or BigQuery Scheduled Queries.
- Silver Layer Development: Implement data cleaning, deduplication, standardization, and joining/conforming logic to create the "single source of truth" Silver layer, structuring data into Dimension (dim_{entity}) and Fact (fct_{process}) tables.
- Gold Layer Creation: Build the final, user-facing Gold layer, consisting of denormalized, aggregated views (e.g., customer_360_view) designed to answer specific business questions and serve BI tools and reports.
Data Analysis & BI Enablement
- Business Intelligence (BI) Support: Act as the primary technical partner for BI, responsible for querying and structuring the Gold layer data for dashboard consumption.
- Looker Dashboard Maintenance: Create, maintain, and update Looker dashboards and reports, ensuring they accurately reflect the underlying business logic defined in the Gold tables.
- Advanced SQL Querying: Write, optimize, and document complex SQL queries in BigQuery to support ad-hoc business requests, deep-dive analyses, and data investigations.
- Stakeholder Engagement: Collaborate with marketing and business stakeholders to understand data requirements and translate them into well-structured, production-ready Gold layer views.
Data Quality & Governance
- Quality Assurance: Implement data quality tests at each layer (Bronze, Silver, Gold), utilizing dbt tests to ensure data integrity, such as checking for unique and non-null primary keys.
- Governance: Adhere to the defined project structure (DRG DATA LAKE project ), naming conventions , and principles (e.g., Bronze data is immutable and append-only ).
- Access Control: Understand and support access control policies using IAM, granting most business users read-only access to the Gold layer.
Technical Qualifications
- Expertise in SQL and BigQuery: Deep, hands-on experience with advanced SQL and optimizing queries, particularly within Google BigQuery.
- Data Transformation Tools: Proven experience building complex transformation models using dbt (Data Build Tool).
- BI Tool Experience: Direct experience with Looker (or similar modern BI tools) for data modeling, dashboard development, and maintenance.
- Cloud Platform: Strong working knowledge of the Google Cloud Platform (GCP), including BigQuery and IAM.
- Data Modeling: Solid understanding of Dimensional Modeling and experience structuring data into Dimension and Fact tables.
Type d'emploi : Temps plein
Rémunération : 10.000,00DH à 18.000,00DH par mois
-
Chief Data Monetization and Analytics Officer
il y a 3 jours
Rabat, Rabat-Salé-Kénitra, Maroc Maroc Telecom Temps plein 900 000 - 1 200 000 par anChief Data Monetization and Analytics Officer:Maroc Telecom recrute un Chief Data Monetization and Analytics OfficerMaroc Telecom, acteur de référence dans le secteur des télécommunications au Maroc et en Afrique Subsaharienne, recherche unChief Data Monetization and Analytics OfficerLe Chief Data Monetization & Analytics Officer pilote la stratégie...
-
Senior Data Engineer
il y a 4 jours
Rabat, Rabat-Salé-Kénitra, Maroc AXA Global Business Services (AXA GBS) Temps plein 90 000 - 120 000 par anJOB PURPOSE :As a Senior Data Engineer, you will be responsible for designing, developing, and maintaining scalable data pipelines and architectures using Azure and Databricks platforms.You will play a key role in enabling data-driven decision-making by ensuring high-quality data availability and processing across the organization.PROFILE :The ideal...
-
Data Engineer
il y a 2 semaines
Rabat, Rabat-Salé-Kénitra, Maroc NGBS Temps pleinNous recrutons un Data Engineer Senior Nous recherchons unData Engineer Senior(6 ans d'expérience et plus) pour rejoindre notre équipe Big Data et contribuer à transformer la donnée brute en informations exploitables pour nos équipes métiers et analytiques.Vos missions :Transformer la donnée brute en données exploitables et requêtables dans le ...
-
Data Engineer
il y a 2 semaines
Rabat, Rabat-Salé-Kénitra, Maroc Orange Business Temps plein 1 200 000 - 2 400 000 par anAbout usOrange Business is a network and digital integrator that understands the entire value chain of the digital world, freeing our customers to focus on the strategic initiatives that shape their business. Every day, you will collaborate with a team dedicated to providing consistent, sustainable global solutions, no matter where our customers operate....
-
Data Engineer Neo4j
il y a 2 semaines
Rabat, Rabat-Salé-Kénitra, Maroc SQLI Temps plein 900 000 - 1 200 000 par anNotre mission depuis 30 ans ?Être présent au bon moment Notre expertise ?Accompagner nos clients à capter l'attention de l'utilisateur et transformer cette interaction furtive en une interaction mémorable. C'est dans cette optique que nous accompagnons les entreprises dans la mise en œuvre, et le pilotage de dispositifs digitaux pour une expérience...
-
Data Analyst
il y a 3 jours
Rabat, Rabat-Salé-Kénitra, Maroc Fortrade Ltd. Temps plein 100 000 - 150 000 par anLocation:Rabat, MoroccoType:Full-Time | On-SiteLanguage:Fluent English RequiredEnvironment:Multicultural | Fast-paced | International****************************************************************************************About the CompanyFounded in 2013 and headquartered in the UK, our business partner is a rapidly growing provider ofonline trading...
-
Data Engineer MS Fabric PySpark
il y a 2 semaines
Rabat, Rabat-Salé-Kénitra, Maroc SQLI Temps plein 45 000 € - 55 000 € par anDescription de l'entreprise Notre mission depuis 30 ans ? Être présent au bon moment Notre expertise ? Accompagner nos clients à capter l'attention de l'utilisateur et transformer cette interaction furtive en une interaction mémorable. C'est dans cette optique que nous accompagnons les entreprises dans la mise en œuvre, et le pilotage de...
-
Data Engineer senior GCP
il y a 3 jours
Rabat, Rabat-Salé-Kénitra, Maroc Devoteam Temps plein 900 000 - 1 200 000 par anDescription de l'entreprise Chez Devoteam, nous sommes des « Digital Transformakers ». Le respect, la franchise et la passion animent chaque jour notre tribu. Ensemble, nous aidons nos clients à remporter la bataille du Digital : du conseil à la mise en œuvre de technologies innovantes, jusqu'à l'adoption des usages.Cloud, Cybersecurity, Data, DevOps,...
-
Data Engineer senior GCP
il y a 15 heures
Rabat, Rabat-Salé-Kénitra, Maroc Devoteam Temps plein 900 000 - 1 200 000 par anChez Devoteam, nous sommes des « Digital Transformakers ». Le respect, la franchise et la passion animent chaque jour notre tribu.Ensemble, nous aidons nos clients à remporter la bataille du Digital : du conseil à la mise en œuvre de technologies innovantes, jusqu'à l'adoption des usages.Cloud, Cybersecurity, Data, DevOps, Fullstack Dev, Low Code, RPA...
-
Data Scientist Sénior
il y a 3 jours
Rabat, Rabat-Salé-Kénitra, Maroc WIRKY Group Temps plein 90 000 - 120 000 par anNous recrutons : Data Scientist SéniorProfil recherché :Data Scientist Sénior spécialisé enGenAIetIA agentique, maîtrisantPython, PySpark, Databricks et Azure, avec plus de5 ans d'expérience.Tes responsabilités :Concevoir et entraîner des modèles prédictifs et génératifs (GenAI, LLMs) adaptés aux besoins business.Développer des solutions d' ...
