Skip to content
View ZinelabidineCh's full-sized avatar

Block or report ZinelabidineCh

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Maximum 250 characters. Please don’t include any personal information such as legal names or email addresses. Markdown is supported. This note will only be visible to you.
Report abuse

Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

Report abuse
ZinelabidineCh/README.md

Hi, I'm Zinelabidine Chiguer 👋

Freelance Data Engineer | BigQuery & Google Cloud Platform

🟢 Available for freelance projects — I help teams build reliable analytics pipelines on Google Cloud: ingestion, transformation (BigQuery + Dataform), orchestration (Airflow), and CI/CD (Cloud Build + Terraform).

I specialize in the modern data stack on GCP — not general-purpose cloud work, specifically BigQuery-centric pipelines. Below is my featured "Olist Data Journey", showing a progression from local scripts to a fully orchestrated, IaC-provisioned Cloud architecture.

🚀 The Olist Data Engineering Trilogy

Phase 1: Python & SQL Foundation

Building the base: Ingestion and Exploratory Analysis.

  • Tech: Python (Pandas, SQLAlchemy), SQLite.
  • Focus: Data cleaning, relational modeling, and discovering initial business correlations (Logistics vs. Satisfaction).

Phase 2: Strategic BI & Data Modeling

Connecting the dots: Star Schema and Executive Reporting.

  • Tech: Power BI, DAX, Power Query.
  • Focus: Enterprise data modeling and interactive visualization of $16M in revenue and RFM segmentation.

Phase 3–4: Production Cloud ELT Pipeline + Orchestration

Scaling to the Cloud: Modern Data Stack on GCP, provisioned and orchestrated as code.

  • Tech: Google Cloud (BigQuery, Dataform, GCS), SQLX, Airflow, Terraform, Cloud Build, Looker Studio.
  • Focus: Automated ELT, daily orchestration, infrastructure as code, validating CI/CD, cost optimization (Partitioning/Clustering), and data quality assertions.

🛠️ Technical Toolbox

  • Languages: Python (Pandas, Scikit-learn), SQL (PostgreSQL, BigQuery Standard SQL).
  • Data Engineering: BigQuery, Dataform, Cloud Storage, ETL/ELT workflows.
  • Orchestration & IaC: Airflow / Cloud Composer, Terraform, Cloud Build, IAM.
  • BI & Visualization: Power BI, Looker Studio, Seaborn/Matplotlib.
  • Database Management: MySQL, SQLite, BigQuery.

📫 Let's Connect

Pinned Loading

  1. olist-python-sql-foundation olist-python-sql-foundation Public

    Phase 1: Local Data Engineering & EDA. Automated SQLite database creation and exploratory analysis using Python, Pandas, and SQL.

    Python

  2. olist-bi-powerbi-dashboard olist-bi-powerbi-dashboard Public

    Phase 2: Advanced Data Visualization and KPI tracking using Power BI to drive business decision-making.

  3. olist-elt-pipeline-gcp-looker olist-elt-pipeline-gcp-looker Public

    Phase 3: Production-grade ELT pipeline on Google Cloud Platform using BigQuery, Dataform, and Looker Studio for automated reporting.

    HCL