Over Kim
With 3 years of experience in analytics engineering as a part of a freelance collective, I help organizations build scalable, transparent, and reliable analytics ecosystems that empower business teams to make confident, data-driven decisions.
As a freelancer, I focus on:
- Transforming legacy SQL workflows into modular dbt models that are testable, maintainable, and well-documented.
- Designing semantic layers and dimensional data models in dbt to support consistent and intuitive reporting across teams.
- Driving self-service analytics adoption by aligning business logic with curated datasets in Looker.
- Promoting data governance and trust through dbt testing, documentation, and naming conventions.
- Supporting the implementation of dbt Mesh to enable domain-based ownership while maintaining shared modeling standards.
- Partnering with stakeholders to define KPIs and business metrics, accelerating the delivery of high-value dashboards and insights.
- Advocating for analytics engineering best practices, enabling teams to scale from ad hoc reporting to structured, governed analytics operations.
My goal is to bridge the gap between raw data and actionable insight—delivering clarity, trust, and speed in every analytics project.
Frans
Tweetalig / moedertaal
Engels
Vloeiend
Kan op locatie werken
Paris (tot 50km)
Werkervaring
- AccorAnalytics EngineerHORECAapril 2024 - mei 2026 (2 jaren en 1 maand)Issy-les-Moulineaux, Frankrijk
Collaborative Analytics Development with dbt and Data Mesh Principles
- Led the migration of legacy Snowflake stored procedures into modular, documented dbt models, improving clarity, maintainability, and team onboarding.
- Contributed to a multi-team dbt architecture (data mesh approach), separating core models and team-owned transformations to ensure autonomy and standardization.
- Defined data contracts and dbt model ownership across teams, supporting scalable collaboration and reducing conflicting definitions of key metrics.
Data Quality and Observability for Analysts and Stakeholders
- Enabled data observability using Elementary, monitoring test results and dbt runs to proactively surface issues in dashboards and datasets.
- Advocated for a "trust but verify" approach to reporting by embedding test coverage stats and freshness alerts in shared dashboards.
- Piloted a centralized metadata catalog to improve discoverability and understanding of dbt models and downstream dashboards.
Semantic Layer and Dashboard Reliability
- Designed and tested semantic models using the dbt Semantic Layer and Cube, exploring consistent metric definitions across tools like Tableau and Looker Studio.
- Partnered with BI developers to validate semantic definitions against existing reports, ensuring consistent logic across tools.
Analytics Enablement and Best Practices
- Delivered internal training workshops on dbt for data and analytics teams, helping standardize modeling practices and improve team-wide SQL quality.
- Shared dbt tips, model patterns, and documentation practices, leading to measurable gains in delivery speed and model reuse across teams.
- PrimelisAnalytics EngineerDIGITAAL BUREAU & IT-CONSULTANCYnovember 2023 - april 2024 (5 maanden)Levallois-Perret, Frankrijk
Scalable Analytics Models for Marketing Insights
- Developed a reusable dbt package to deliver cross-platform marketing insights from sources like Google Ads and Search Console, rolled out across 80+ client accounts including Smartbox, La Redoute, and UNICEF.
- Built dashboard-ready dbt models for key marketing metrics (e.g., impressions, CTR, conversion rates), integrated with a custom frontend for real-time analysis.
- Supported business teams with consistent, automated reporting logic, reducing time spent on manual analysis.
Data Quality Monitoring and Process Standardization
- Enabled automated anomaly detection and data quality alerts using Elementary to monitor model test results and freshness, ensuring reliability in client-facing dashboards.
- Promoted data modeling best practices using dbt_project_evaluator, ensuring consistency and maintainability across dozens of client implementations.
Client-Facing Insights Platform & Model Optimization
- Partnered with product and BI teams to integrate dbt outputs into a user-facing analytics dashboard, providing timely and actionable marketing insights to non-technical users.
- Optimized performance across 80+ dbt projects (each with ~150 models), improving model run times and enabling faster iteration for reporting enhancements.
Analytics Tooling Exploration
- Led PoCs for next-generation tools like SQLMesh (as a potential dbt alternative), and contributed to platform evaluation for dashboard scalability and version control.
Aanbevelingen
Wees de eerste die Kim aanbeveelt
Help deze freelancer om te schitteren door te vertellen hoe het is om met hem of haar te werken.
Deze freelancerprofielen matchen ook met zoekopdracht.
Agatha Frydrych
Backend Java Software Engineer
4.7
(3)
2
Baptiste Duhen
Fullstack developer
4.6
(4)
5
Amed Hamou
Senior Lead Developer
4
(2)
7
Audrey Champion
Web developer
4.3
(3)
4