Jop Heuvelmans
Freelance Data & Analytics Specialist
Bridging the gap between raw data and business impact.
What I Bring to the Table
Strategic data engineering for scalable growth.
Building robust data warehouses and transformation pipelines that serve as the single source of truth for your business logic.
Implementing complex business definitions like Customer Lifetime Value (CLV) and Contribution Margin directly into your data models.
Crafting intuitive dashboards in Looker Studio and other tools to empower stakeholders with actionable insights.
Technical Expertise
A deep dive into the tools and methodologies I use to build scalable data infrastructure.
Data Engineering
- SQL (BigQuery)
- dbt (Data Build Tool)
- Airflow
- Terraform
- Medallion Architecture
AI & Python
- Python
- LLM Integration (Gemini)
- Machine Learning
- RAG Systems
- API Development
Analytics & BI
- Looker Studio
- Metric Harmonization
- Dashboard Design
- Stakeholder Management
- Data Literacy
Process & Culture
- Git / GitHub Actions
- CI/CD Pipelines
- Data Governance
- Mentoring (Data Academy)
- Agile / Scrum
Featured Projects
Transforming complex business problems into robust data solutions.
Crisp
Built one of Crisp's most critical data products, integrating 40+ distinct cost components to enable real-time CLV and customer payback analysis.
The Challenge
Disconnected cost data across ERP and Google Sheets made it impossible to see true order profitability.
The Solution
A modular dbt set-up using Jinja templating to automate 40+ joins and metrics with standardized tests.
Business Impact
This Contribution Margin model became the primary metric of acquisition and retention marketing efforts, enabling detailed insights into profitability.
Crisp
Developed a natural language search tool for Looker Studio dashboards using Vector Search and LLMs.
The Challenge
With hundreds of dashboard pages, stakeholders struggled to find relevant reports without knowing exact names.
The Solution
Used Gemini to generate embeddings for dashboard metadata, stored in BigQuery for cosine similarity search via a custom MCP server.
Business Impact
Enabled intuitive, context-aware discovery of data assets across the entire organization.
Crisp
Architected a scalable, nightly scraping service to provide Category Managers with real-time competitive pricing data.
The Challenge
Category managers lacked reliable, automated insights into competitor pricing for strategic decisions.
The Solution
Built a Python-based master scraper with Scrapy, orchestrated via Airflow and integrated with a dbt transformation layer.
Business Impact
Automated price benchmarking for thousands of products, significantly increasing price-competitiveness and efficiency.
Experience Highlights
Proven track record in scaling data capabilities.
Freelance Analytics Specialist
Self-Employed
Specializing in Data & Analytics engineering for growth-focused companies.
Senior Analytics Engineer
Crisp
Professionalized the Data Warehouse with 1,000+ models. Focused on ELT, dbt, and driving tangible business impact through reliable data.
Data Scientist
e-Luscious
Focused on web scraping, marketing data analysis, and predictive modeling.