Ismail Mezzour

I help companies deploy self‑service analytics on Snowflake, dbt and Airflow.

What DataFrost does

DataFrost sets up the platform, the guardrails and the training so analysts ship their own work.

Data stack design and modernization
New or modernized data stacks with Snowflake, dbt, Airflow, and BigQuery on AWS, GCP, or Azure, from scratch or through migration projects.
Snowflake and BigQuery audits
Audits covering performance, usage, cost optimization, and governance, whether you run on Snowflake or BigQuery.
dbt and Airflow adoption
Hands-on guidance, conventions, and training programs so teams adopt dbt and Airflow and keep them healthy as they grow.
MLOps
Patterns for industrializing ML workflows, plus model registries and monitoring in production.
Semantic layer readiness
A check of data quality, modeling, governance, and business alignment before you adopt a semantic layer.
Data quality audits and recommendations
Reviewing tests, monitoring, and observability across your pipelines, then handing over a prioritized plan built on tools like dbt tests, Soda, or Elementary.
Agents and automation setup
AI agents and automated workflows around your data platform, such as pipeline triage, documentation and recurring operational tasks.
Workshops and field feedback
Hands-on workshops on Snowflake, dbt, and Airflow, with lessons learned from running these tools in production.

Experience

Data platforms built across hospitality, fintech, enterprise software, and travel.

FounderSep 2026 – Present

DataFrost Consulting

Details, Founder, Sep 2026 – Present
  • Founded DataFrost Consulting, a data platform consultancy based in Paris
  • Audited Snowflake and Azure data platforms
  • Ran a workshop on self-service analytics
  • Led an Airflow meetup session: “From Self-Service to Scale: How We Empowered Analytics Engineers Without Growing the Platform Team”
Cloud data platform engineerFeb 2023 – Sep 2026

Accor

Details, Cloud data platform engineer, Feb 2023 – Sep 2026

dbt & Airflow

  • Set up dbt and standardized it across Accor’s data teams
  • Set up and maintained Apache Airflow on Astronomer
  • Built reusable Airflow templates to generate dbt DAGs
  • Advised data teams on orchestration and scheduling
  • Wrote onboarding documentation for dbt and Airflow
  • Orchestrated Snowflake stored procedures and tasks
  • Implemented monitoring DAGs for reliability

CI/CD

  • Implemented GitLab CI/CD for dbt and Airflow deployments
  • Set up multi-stage deployments (dev, pre-prod, prod)
  • Designed tag-based configurations to route teams through CI/CD pipelines and reduce duplication
  • Added unit tests and automated checks
  • Cut Astronomer deployment time from about 5 minutes to about 1 minute
  • Configured pre-commit hooks and sqlfmt

Snowflake

  • Built FinOps dashboards to monitor and optimize warehouse costs
  • Managed Snowflake infrastructure as code with Terraform
  • Set up a pre-production environment for dbt testing
  • Audited access and usage logs and built Snowsight dashboards
  • Optimized warehouse sizing, auto-suspend, and workload isolation
  • Defined role-based access models and governance
  • Benchmarked semantic layer solutions

Data quality

  • Implemented dbt tests for data integrity
  • Set up Soda quality checks
  • Benchmarked observability tools (Sifflet, Monte Carlo)
  • Delivered POCs with Sifflet, Elementary, and Soda

MLOps

  • Defined the team’s MLOps pattern at Accor: model registry strategy, workflow industrialization, and monitoring standards
  • Delivered POCs across Snowflake, SageMaker, and GitLab model registries
  • Worked with data scientists to optimize ML workflows end to end
  • Set up an ML model in Snowflake
  • Defined the Streamlit pattern at Accor so data teams ship internal apps fast
  • Turned data teams into a Streamlit factory with templates, standards, and deployment pipelines

AWS

  • Managed AWS infrastructure as code with Terraform
  • Built Terraform modules for scheduling and monitoring dbt
  • Developed AWS Lambda functions to send data from Snowflake to Splunk

Collaboration

  • Gathered data needs from business teams and worked with data science and analytics
  • Ran functional and technical POCs and workload estimates
  • Worked in Scrum, running daily stand-ups and sprint planning
Data engineerMar 2021 – Feb 2023

Younited

Details, Data engineer, Mar 2021 – Feb 2023

ETL & pipelines

  • Built and maintained ETL jobs with Python, Spark, SQL, dbt, and Airflow
  • Developed data quality monitoring tools and POCs on data flows
  • Model development, Spark job optimization, and profiling
  • Set up cloud functions for data transformation

Cloud platform

  • Designed, maintained, and documented the Google BigQuery warehouse
  • Set up Azure workbooks to monitor nightly batch pipeline metrics
  • Worked across Microsoft Azure and Google Cloud

Collaboration

  • Gathered data needs from business teams and worked with data science and analytics
  • Ran functional and technical POCs and workload estimates
  • Worked in Scrum with daily stand-ups, sprint reports, and planning summaries
Data analystMar 2020 – Oct 2020

SAP

Details, Data analyst, Mar 2020 – Oct 2020
  • Built real-time dashboards in SAP Analytics Cloud giving business teams live visibility into their products
  • Connected SAP Analytics Cloud to an OData service through a cloud connector
  • Engineered Python and SQL data pipelines
  • Built a custom data processing executable in Python
Data scientistJun 2019 – Sep 2019

Amadeus

Details, Data scientist, Jun 2019 – Sep 2019
  • Built time-series forecasting models with LSTM, GRU, and ARIMA
  • Set up system monitoring based on model predictions
  • Extracted and processed Logstash and Grafana data with Python
  • Built data processing pipelines feeding the forecasting models

Writing and talks

Articles and talks on dbt, Airflow, Snowflake, and running data platforms.

Talk decks
The PDFs from my talksAirflow, dbt and self-service analytics.
Podcast on YouTube, hosted by Datanosco
Architecture d’un projet DATA: dbt & Airflow best practicesFrom Terraform to dbt and Airflow: a real use case on project architecture.
Article on Medium, Accor Digital & Tech
The dbt + Airflow Effect: Enhanced Data Deployments at AccorHow combining dbt and Airflow changed data deployments at Accor.
Article on Medium, Accor Digital & Tech
Deploying Airflow at Accor for 80+ Data Engineers & ScientistsLessons learned rolling out Airflow to a large data organization with Astronomer.
Article on Medium, Snowflake Explained
Building a Semantic Layer in Snowflake with Terraform and CortexA practical guide to deploying a semantic layer on Snowflake with Terraform and Cortex AI.
Article on Medium
How We Turned Data Teams Into a Streamlit FactoryHow we set up the Streamlit pattern at Accor so data teams ship internal apps fast.
Code on GitHub
GitHub projectsOpen-source templates and tools for data engineering workflows.

Skills

The tools I use day to day.

Cloud platforms
Snowflake, BigQuery, AWS, Google Cloud (GCP), Microsoft Azure, Terraform
Data engineering
dbt, Apache Airflow, Astronomer, Apache Spark, SQL, Python, ETL, Streamlit
Data quality and observability
Soda, Sifflet, Elementary, Monte Carlo, dbt tests
MLOps and data science
SageMaker, Snowflake ML, LSTM / GRU, ARIMA, Model monitoring
DevOps and CI/CD
GitLab CI/CD, Terraform, AWS Lambda, pre-commit, sqlfmt
AI and agentic tools
Claude Code, Snowflake Cortex, LLM integration, Agentic pipelines, Prompt engineering

Education

An engineering background in applied mathematics and data science, with a business degree on top.

Polytech Nice Sophia2017 – 2020
Engineering degree in applied mathematics and data scienceData science major covering mathematics, computer science, AI, business analysis, and big data, with ETL foundations.
IAE Nice2020
Master’s degree in management and business administrationGraduate School of Management. A business complement to the engineering track, focused on strategy and organizational management.
Polytech MarseilleBefore 2017
Classes préparatoiresIntensive preparatory curriculum in mathematics, physics, and sciences, leading to engineering school admission.

Contact

If you want your teams answering their own data questions, let’s talk. I’m based in Paris and DataFrost Consulting works with teams across Europe, remote or on-site.

Email
mezzour.ismail07@gmail.com
Phone
+33 6 60 48 58 82
Location
Paris 16, France
DataFrost on LinkedIn
datafrost-consulting
LinkedIn (personal)
ismail-mezzour
Medium
@mezzour.ismail07
Instagram
@datafrost_talks
TikTok
@datafrost_talks
YouTube
@datafrost_talks