You're seeing this page as if you were . The main menu is still yours, though. Exit from immersion
Malt Strategy
New report
Malt Tech Trends 2026
Roland ZhangRZ

Roland Zhang

Analytics Engineer / BI Engineer

€699/day
Paris, FR
3-7 years
Data Analysis
SQL
ETL/ELT
PowerBI
Databricks

Average response time: 1 hour

Freelancer profile translated to English.
Back to original language

About Roland

Analytics Engineer / BI Engineer, 5 years of experience across the entire data chain at Colas, an international construction group (€16 billion in revenue), part of the Bouygues group.

I design performance management decision-making platforms in the equipment (asset management) ecosystem: Databricks lakehouse data pipelines and gold models, SQL/DAX development, Power BI report production used daily by several thousand users in 32 countries.

Specifically, I use data daily to manage the performance of a fleet of 60,000 pieces of equipment worldwide and ~€200 million in annual investments.

My added value: I bridge the gap between IT (Data Engineers, Data Scientists) and business units. I translate a vague need into an exploitable data model, and I deliver a tool that users actually adopt — not just another dashboard.

What I can help you with:

Data architecture and modeling (lakehouse, data architecture: bronze/silver/gold layers)

Power BI development and optimization: advanced DAX, Power Query/M, performance, RLS, TMDL

Industrialization and deployment of reporting at various scales (multi-country, multi-ERP)

Audit and redesign of existing reports: performance, data reliability, UX

Implementation of good data governance and documentation practices

Stack: Power BI (DAX, Power Query/M, TMDL), Databricks, SQL, Azure, Python, Git.

Available for remote work or on-site in the Île-de-France region. French, English, Mandarin.
Construction
Plant and Machinery
Civil Engineering and Infrastructure

  • French

    Native or bilingual

  • Chinese

    Native or bilingual

  • English

    Fluent

Can work on-site
Paris (up to 50km)

Experience

  • COLAS SA (Groupe Bouygues)
    Analytics Engineer / BI Engineer
    CIVIL ENGINEERING
    April 2021 - Today (5 years and 4 months)
    15th arrondissement, 75015 Paris, France
    • Group-wide Power BI Reporting: Owner of about ten production Power BI reports (DAX, Power Query), including 3 in the top 20 most used reports in the group (out of 26,000 published), with several thousand unique users across 32 countries. OPEX KPIs, availability, reliability, utilization rate.
    • Lakehouse & multi-ERP ingestion: Design, with the Digital Factory (Colas Digital Solutions), of pipelines feeding the Databricks lakehouse; management of multi-system ingestion (North America, Europe, APAC, EMEA, Rail) and provision of equipment data (work orders, KPIs, OPEX, machine meters) to business units.
    • Gold models & big data: Complex multi-table SQL queries and optimization of production gold models, on large fact tables (accounting transactions, financial results, man/machine time tracking, maintenance) — tens of millions of rows over 6-7 years of history.
    • AI & predictive maintenance: Development of an AI agent using work order data and OEM documents to diagnose failures and anticipate upcoming maintenance for the fleet of 60,000 machines.
    • CAPEX Management (~€200M/year): Automation of the investment arbitration process (own CAPEX and IFRS 16 leasing at PPU) across 5 sectors (construction, rail, real estate, industry, materials), with dynamic arbitration between investment data and KPIs (OPEX, utilization, asset reliability).
    • Data governance: Definition with the Digital Factory of data ownership, responsibility, and update rules, IT/business alignment on data quality and lifecycle.
    • IT/Business Interface: Gateway between Data Engineers, Data Scientists, and field stakeholders (operations managers, equipment managers, real estate, purchasing, finance), simplification and deployment of the data approach across all business units.
    SQL Databricks PowerBI ETL/ELT Data Analysis
  • VINCI Facilities (VINCI Énergies)
    Business Intelligence / Methods
    ENERGY AND UTILITIES
    June 2020 - September 2020 (3 months)
    Le Kremlin-Bicêtre, France
    • Development of management Power BI dashboards (Safety KPIs, Operational Excellence, CMMS performance, Monthly Activity Report) for monitoring infrastructure maintenance in tertiary buildings.
    Design of a digital contract repository and optimization of EDM under SharePoint: document structuring and data reliability.
    PowerBI EDM CMMS SQL Data Analysis
  • CITEOS (VINCI Énergies)
    Internship
    ENERGY AND UTILITIES
    June 2019 - August 2019 (2 months)
    Chartres, France
    • Creation of a database listing public lighting points (600 points digitized) and evaluating their real-time operation to optimize field interventions for workers.
    • Analysis of team interventions and optimization of field interventions for each agency team.
    Data Analysis Digitalization Microsoft Excel

Recommendations

Be the first to recommend Roland

Help this freelancer shine by sharing your experience working together.

These freelancer profiles also match your criteria

AgathaA

Agatha Frydrych

Backend Java Software Engineer

4.7

(3)

2

BaptisteB

Baptiste Duhen

Fullstack developer

4.6

(4)

5

AmedA

Amed Hamou

Senior Lead Developer

4

(2)

7

AudreyA

Audrey Champion

Web developer

4.3

(3)

4

Signup to reveal

Education

  • Engineering Degree
    ESTP Paris
    2021
    Diplôme d'ingénieur
  • Markets. Classe préparatoire MPSI/PSI
    Lycée Blaise Pascal
    2018
    CPGE Classe préparatoire MPSI/PSI

Categories