
Longyin C.
Analytics Engineer
2 recommendations
Salary / Daily rate
2 people recommend
Paris, France
Mobility: Île-de-France, Annecy
Freelance, open to permanent contract
Can come onsite
Skills
Languages
About me
Intro
I am a trilingual Data / BI Analyst with analytics engineering and data pipeline experience, bringing 10+ years of international experience across data analytics, business intelligence, CRM, digital marketing, customer intelligence, e-commerce and business performance. My focus is customer lifecycle analytics: understanding why customers purchase again, when they are likely to repurchase, which segments show long-term value, and how CRM, retention or recommendation strategies can support healthier revenue growth. I work with SQL, Power BI, Python, BigQuery, Google Data Studio, Excel and GCP to transform raw, fragmented or underused data into structured, reliable and business-ready insights. My experience includes KPI dashboards, reporting automation, customer segmentation, CRM analytics, repeat purchase analysis, marketing performance reporting, API data ingestion, Python-based ETL pipelines, data quality checks and analytical data modeling. At Qualit‘ENR, I worked with operational data, KPI monitoring, dashboarding, reporting automation and performance analysis, helping business teams gain clearer visibility and make more reliable decisions. Previously, at Carrefour, I worked on marketing, inventory and e-commerce analytics using SQL, BigQuery, Google Data Studio and GCP, contributing to automated reporting and actionable business insight generation. Alongside these roles, my freelance and consulting experience has allowed me to design practical end-to-end data solutions, from API data ingestion and SQL extraction to Power BI dashboards, KPI frameworks, CRM analytics and customer segmentation. One key project involved identifying abnormal non-repeat-purchase patterns after a large promotional campaign, validating suspicious customer data through third-party checks, and supporting the implementation of an alert mechanism to reduce future campaign performance distortion. What differentiates me is my ability to connect data engineering, analytics and commercial decision-making. I can work across the data value chain: ingesting and structuring raw data, improving data reliability, building analytical datasets, visualizing KPIs, and translating customer behaviour into actionable retention or recommendation strategies.
Work experience
Analytics Engineer
Qualit'EnRFreelance
Jan 2025 - Present
1 year 10 months
Paris, France
Data & Analytics Engineer – Enterprise Analytics Platform Designed and delivered a production-grade data platform covering both data engineering reliability and analytics engineering usability. Built Python-based ETL pipelines integrating HR and customer support SaaS systems, transforming raw API data into trusted, analytics-ready datasets used for KPI tracking and executive decision-making. Key responsibilities and strengths: • Engineered robust, batch-based ETL pipelines with explicit incremental loading and checkpointing (timestamps, cursors) to ensure idempotency, auditability, and safe reprocessing • Solved complex API ingestion constraints (pagination, rate limits, non-incremental endpoints) using production-safe strategies • Designed modular ETL architecture (base classes, shared utilities) enabling scalability and maintainability • Modeled business-oriented analytical tables aligned with operational and executive KPIs • Ensured data quality through normalization, type enforcement, and UPSERT-based loading • Acted as a bridge between engineering and analytics by translating business questions into reliable data models • Delivered clear technical and executive documentation (architecture, design decisions, KPI-to-decision mapping) Impact: • Established a single source of truth for HR and customer support analytics • Reduced manual reporting and increased confidence in data-driven decisions • Enabled downstream BI tools without vendor lock-in Tech stack: Python · SQL · REST APIs · ETL Architecture · Incremental Loads · Data Modeling · Data Engineering · Analytics Engineering
Data Analyst
Carrefour
Jul 2024 - Jan 2025
7 months
91300 Massy, France
# Extracted, analyzed, and interpreted data on marketing, product, and shop performance using Google BigQuery (SQL) to provide actionable insights. # Created dynamic and automated dashboards in Google Data Studio to visualize campaign performance, enabling real-time strategy adjustments. # Participated in brainstorming sessions with cross-functional teams, contributing ideas for advanced segmentation and predictive analytics methodologies.
Freelance Marketing Consultant Data & BI
Longyin ZhangFreelance
Sep 2012 - Oct 2023
11 years 2 months
Paris, France
Boosted marketing campaign impact for clients through application of analytical reports, covering competitor research, trends and industry performance while developing digital vision roadmaps. Champion online transformation; embed knowledge of digital marketing channels to ensure brand consistency. Key achievements # Gathered, analysed and assimilated data to present actionable insights, using tools including Google Analytics. # Authored on-trend content and delivered insights for event securing over 200k daily views and 50K+ likes and comments in just one day. # Analysed consumer data to segment and target specific markets through diverse channels. # Applied creative event marketing plans and digital campaigns to drive awareness. # Monitored and minimised digital marketing expenditure in line with a budget of €500k. # Reduced wage costs by €25k annually, having delineated and rationalised resource requirements. # Gained exposure to web analytics, campaign A/B testing, and metrics monitoring.
Director of E-commerce
Ai Shopping
Mar 2017 - May 2018
1 year 3 months
7620 Paris, Denmark
A fast-growing marketing and e-commerce start-up, recognized by AFP, BFM, and Figaro for its success. As a key member of the e-commerce team, I led data-driven initiatives to enhance the online user experience (UX) and optimize conversion rates across the website. One of my major contributions was leading the redesign of the product page, focusing on UX/UI optimization to improve user engagement, streamline navigation, and enhance product visibility. I utilized A/B testing and customer behavior analysis to make informed decisions that boosted performance. By collaborating closely with cross-functional teams, I ensured the product page design aligned with user needs, resulting in a more intuitive and visually appealing shopping experience. Key Achievements: #Led UX/UI optimization of the product page to improve user interaction, reduce bounce rates, and increase conversions, using web analytics and A/B testing to refine design elements based on data insights. #Realized a 10% user growth and 20% sales increase in one month through a targeted digital marketing strategy backed by comprehensive web performance analysis. #Improved sales speed by 15% by analyzing web traffic and customer data to identify trends, recommend new products, and tailor sales strategies accordingly. #Drove B2B revenue growth from zero to €100,000 in one month by analyzing market behavior and tailoring strategies to meet business needs. #Implemented solutions that reduced lost packages by 10% by leveraging data analytics to streamline the logistics and e-commerce process.
Manager of Marketing & Database
FTL EXPRESS
Feb 2016 - Mar 2017
1 year 2 months
7620 Paris, Denmark
An fast growing international logistic and transportation company, who are a pioneer expert on the logistic and air transportation between China and France. Authored engaging content across marketing literature and social media channels for this international logistics and transportation company connecting China and Europe. Key achievements #Led A/B testing and UX/UI optimization for the FTL Express mobile app, improving user engagement and conversion rates by testing design variations and refining the user journey. Utilized data-driven insights to enhance the app's functionality and overall user experience. # Delivered 20% increase in users having analysed target customer behaviours to improve user experience (UX) across website and mobile application, culminating in consistently positive feedback. #Scoped and led digital campaigns for new website; grew followers to 1k daily in week one via creative SEO. # Achieved ten-fold increase in brand exposure having established and expanded Public Relations (PR) network. # Identified market-driven logistics needs and proposed new service solutions that became the company’s leading revenue stream, contributing approximately 45% of total revenue.
Project Coordinator
SG [010] Productions
Jun 2011 - Jul 2011
2 months
Beijing, China
I was an intern in the vivid,and fast growing international company who is specialised on event production and management as well as on PR and marketing solutions. The skills I practiced included content production, business research, event planning, event management, supplier sourcing, proposal set-up.
International Business Development Specialist
AOJI Education Group
Jul 2007 - May 2010
2 years 11 months
Beijing, China
Developed business plans, roadmap and marketing strategies to facilitate entry into China for this international education company with 1,000+ employees and 43 offices across four continents. Key achievements #Fostered, maintained and nurtured key internal / external relationships in support of business development. # Proactively monitored partner health and performance. # Negotiated, reviewed and amended mutually acceptable agreements.
Ecommerce Specialist
Zip technology LTD
Jun 2006 - Jul 2007
1 year 2 months
Beijing, China
Before JD.com founded, while Amazone era in China, The "2688" under Beijing Zip was one of hottest B2C E-commerce website in China. Key achievements # Managed end-to-end e-commerce processes – from procurement to supplier negotiations. # Orchestrated digital marketing, website back-end management and logistics. # Delivered 11x sales increase via contributions to creative marketing strategies aimed at optimising brand image.
Education
DSTI - School of Engineering
Master of Science - MS, Data Analytics
2023 - 2025
1 year 7 months
Grade: 90 - summa cum laude - Mention Très Bien
Course content: Machine Learning with Python Data Wrangling with SQL Advanced Excel for Data Analytics Data PipeLine Semantic Web Big Data Processing with R Graph Databases BoSQL NoSQL-Mongo DB CRM Data Management Statistical Analysis and Machine Learning Applied Mathematics for Data Science
Birmingham City University
Master of Arts, Events and Exhibition Management
2011 - 2012
1 year 1 month
Activities and societies: - Curator, Exhibition organiser and on-site manager: Oriental. an Contemporary art exhibition at Birmingham - Exhibition planner( Art Section) -Fusion, the Multi culture exhibition, Birmingham (Art, Food and Fashion) - Project initiator and event planner and manager: U-Exchange, which is a vintage market in the campus of Birmingham City University
Modules: 1. The Events and Exhibition Industry: knowledge of industry and how to apply into real life business 2. Enterprise: Finance skills, management skills and research skills a entrepreneur needed in a real business world 3. Exhibition Production: Created a real-life exhibition with very limited resource 4. Production Lab: Learned and practised project management skills and research skills 5. MA by Practice : In the report of module, a real-life project that conducted by students must be analysed and evaluated.
London Metropolitan University
Master of Arts, Events Marketing Management
2010 - 2011
1 year 1 month
Activities and societies: 1.Marketing for London Met taking part in Lord Mayor's show on social network. 2.Marketing intern for Silverbullet (live music and performance hub) 2.Volunteer for the sponsorship conference produced by Think! Group 3.Member of London Business Society
Course content: Event and Live Media Industries Events Marketing Managing the Service Sector Financing Events Research Methods for Leisure and Tourism
London Metropolitan University
Graduate Certificate in Business, Globle Business,Management, Business Research etc
2010 - 2010
1 month
Activities and societies: London Metropolitan University Business society
Skills learned: International Business Management and Organisations Research skills for postgraduate study
Beijing Foreign Studies University
Diploma, English Linguistics
2002 - 2006
4 years 1 month
Licenses & certifications
Managing Safely
Issued: Jul 2026
Microsoft Certified: Power BI Data Analyst Associate
Issued: Aug 2025
Microsoft Certified: Power Platform Functional Consultant Associate
Issued: Feb 2025
Neo4j Certified Professional
Issued: Oct 2024
Google Data Analytics Professional Certificate
Issued: May 2022
Portfolio
