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
-
Senior Data Engineer
il y a 2 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 1 semaine
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 Scientist
il y a 6 jours
Rabat, Rabat-Salé-Kénitra, Maroc Odixcity Consulting Temps plein 100 000 € - 120 000 € par anThe Role:Analyse large and complex datasets to uncover trends, correlations, and actionable patterns.Develop and maintain dashboards, reports, and visualisations that provide stakeholders with clear, data-driven insights.Translate business problems into structured data questions and analytical approaches.Evaluate data quality and suggest improvements to...
-
Data Engineer
il y a 1 semaine
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 Qualité
il y a 4 jours
Rabat, Rabat-Salé-Kénitra, Maroc SQLI Temps plein 45 000 - 90 000 par anWe Elevate. Digitally.SQLI, leader européen de l'expérience client et de la transformation digitale, aide les grandes marques internationales à créer de la valeur grâce à la technologie et à l'innovation digitale. De la stratégie au déploiement des actifs technologiques de nos clients, nous imaginons et construisons des architectures robustes et...
-
Data Engineer Qualité
il y a 4 jours
Rabat, Rabat-Salé-Kénitra, Maroc SQLI Temps plein 40 000 € - 80 000 € par anDescription de l'entreprise We Elevate. Digitally.SQLI, leader européen de l'expérience client et de la transformation digitale, aide les grandes marques internationales à créer de la valeur grâce à la technologie et à l'innovation digitale. De la stratégie au déploiement des actifs technologiques de nos clients, nous imaginons et construisons des...
-
Data Analyst
il y a 6 jours
Rabat, Rabat-Salé-Kénitra, Maroc Odixcity Consulting Temps plein 30 000 - 60 000 par anThe Role: ● Design, implement, and refine predictive and analytical models for complex business problems.● Translate ambiguous business questions into structured data problems and actionable solutions.● Explore large datasets to uncover hidden patterns, trends, and opportunities.● Build and maintain...
-
Data Engineer
il y a 1 semaine
Rabat, Rabat-Salé-Kénitra, Maroc SQLI Temps plein 40 000 € - 80 000 € par anWe Elevate. Digitally.SQLI, leader européen de l'expérience client et de la transformation digitale, aide les grandes marques internationales à créer de la valeur grâce à la technologie et à l'innovation digitale. De la stratégie au déploiement des actifs technologiques de nos clients, nous imaginons et construisons des architectures robustes et...
-
Data Engineer senior GCP
il y a 2 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 Engineer senior GCP
il y a 2 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,...
