Thierry Vanroy

Available to hire

I'm a UK-based Business Intelligence and Data Engineering professional with over 15 years of experience spanning corporate finance, financial modelling, business analytics and enterprise reporting.

About

I’m a UK-based Business Intelligence and Data Engineering professional with over 15 years of experience spanning corporate finance, financial modelling, business analytics and enterprise reporting.

My speciality is bridging the gap between business requirements and technical solutions. I help organisations turn complex, fragmented data into reliable reporting systems, automated workflows and actionable management information.

My technical experience includes:

  • Power BI: Executive dashboards, financial and operational reporting, DAX, Power Query, semantic models and data visualisation.
  • Data Engineering: SQL, Azure, Microsoft Fabric, Snowflake, Informatica IICS, ETL/ELT pipelines and data warehouse architecture.
  • ERP & Business Systems: SAP ECC6, financial and operational data integration, inventory management, sales analytics and procurement reporting.
  • Financial Modelling: Forecasting, budgeting, investment appraisal, DCF valuations, scenario analysis and management accounting.
  • Process Automation: Excel, Power Query, data transformation, automated reporting and workflow optimisation.

I currently work with a multinational industrial distribution company, developing enterprise-scale business intelligence solutions that integrate SAP data with modern cloud analytics platforms. My work includes designing data models, developing complex financial and operational KPIs, improving reporting performance and supporting data warehouse modernisation initiatives.

Previously, I worked across corporate finance, investment analysis and financial modelling, including projects involving private equity, mergers and acquisitions, infrastructure and energy. This commercial background allows me to approach technical projects with a clear understanding of the decisions the data needs to support.

I’m particularly interested in freelance projects involving Power BI development, SQL and data engineering, financial modelling, reporting automation and business intelligence consulting.

Whether you need a one-off dashboard, an improved data pipeline, a financial model or ongoing analytical support, I bring a combination of technical expertise, financial understanding and practical problem-solving.

Based in Leeds, UK, I’m available for remote projects with UK and international clients, as well as occasional in-person collaboration.

  • Joined October 2026

Languages

  • DutchFluent
  • EnglishFluent
  • FrenchAdvanced
  • GermanIntermediate
  • JapaneseBeginner
  • ArabicBeginner

Industry experience

  • Energy & Utilities
  • Financial Services
  • Manufacturing
  • Retail
  • Professional Services
  • Real Estate & Construction
  • Wholesale & Distribution
  • Transportation & Logistics
  • Education

More experts in Leeds, United Kingdom

Projects · 1

Power BI Dashboarding

Enterprise Business Intelligence & Power BI Dashboard Suite Technologies: Power BI, DAX, Power Query, SQL, Data Modelling, SAP ERP, ETL/ELT Development of an integrated suite of enterprise Business Intelligence dashboards designed to transform complex operational and financial data into actionable management insights. The solution brings together multiple business functions within a multinational industrial distribution environment, providing interactive reporting across: Sales & Production: Order tracking, production scheduling, manufacturing progress, material availability and exception monitoring. Inventory & Operations: Inventory ageing, stock valuation, regional comparisons, order fulfilment and operational performance indicators. Procurement & Expediting: Supplier performance, purchase order tracking, delivery reliability and outstanding order management. Accounts Payable: Outstanding liabilities, overdue invoices, payment performance and financial exposure. Accounts Receivable: Customer balances, ageing analysis, overdue receivables, credit exposure and collection priorities. Key technical contributions: Designed relational data models and Power BI semantic models integrating ERP and financial information. Developed advanced DAX measures for financial KPIs, operational metrics, ageing calculations and dynamic reporting. Built interactive dashboards featuring drill-down capabilities, dynamic filtering, conditional formatting and exception highlighting. Implemented SQL-based data transformations and automated reporting processes. Translated complex business requirements into intuitive, decision-oriented visualisations. The dashboards demonstrate an approach that combines data engineering, financial expertise and user-focused dashboard design, enabling stakeholders to monitor performance, identify bottlenecks and make informed operational and commercial decisions. Portfolio presentation uses synthetic demonstration data to protect commercially sensitive information.

  • Data Analyst
  • Data Engineer
  • Data Visualizer

Work experience· 7 roles

Business Intelligence Analyst / Finance Analyst · MRC GlobalSep 2024 – Present · 2 yrs 3 mos

Design and maintain Power BI reporting and semantic models across finance, inventory, sales, and supply-chain processes using SAP ECC6 data, Azure data warehouse views, and Snowflake sources. Develop SQL views and transformations for inventory ageing/provisions, quote-to-cash, vendor purchasing, delivery performance, and monthly management reporting. Translate complex business policies into reproducible data logic including FIFO stock consumption, provision baselines, period snapshots, local/group currency valuation, and as-of reporting. Build and troubleshoot DAX measures and Power Query logic for period comparison, latest-as-of reporting, KPI analysis, and management dashboards. Support Informatica IICS ETL/ELT pipelines (incremental/full-load patterns, mapping tasks) and reconcile report outputs to source transactions to resolve duplicates/master-data issues. Partner with Finance, Supply Chain, Sales, and IT/HCL teams to convert operational requirements into data models and self-ser

Data, Finance & BI Contractor · Various clientsOct 2023 – Sep 2024 · 1 yr

Delivered short-term assignments across financial data analysis, ERP remediation, and management reporting, including financial modelling and finance transformation work. Acted as the finance-side ERP/data lead in manufacturing environments, supporting data validation, process mapping, and continuity through system change. Audited and improved month-end tools, reconciliations, and reporting processes, correcting transaction and master-data issues following ERP implementation.

Data Engineer / FP&A & Financial Modelling Contractor · Shell, Waldorf Production, PRAX Group and othersJan 2019 – Jul 2023 · 4 yrs 7 mos

Aggregated and validated multi-source data and built Power BI dashboards that replaced spreadsheet-based workflows for LNG traders and analysts. Built reporting and modelling solutions combining operational and financial data, including automated data aggregation, KPI reporting, scenario analysis, and management information. Supported FP&A, corporate modelling, and M&A analysis by using transactional data to improve forecasting and decision support. Worked across Power BI, SQL, Excel/VBA, Python/R, and ERP/accounting systems to translate finance requirements into technical implementation.

Data Engineer / FP&A & Financial Modelling Contractor · Shell; Waldorf Production; PRAX Group; and othersJan 2019 – Jul 2023 · 4 yrs 7 mos
Data Engineer / FP&A & Financial Modelling Contractor · Shell; Waldorf Production; PRAX Group and othersJan 2019 – Jul 2023 · 4 yrs 7 mos
Financial Analyst & M&A Lead · Gilgamesh Oil Field Services / Noor Al HilalJan 2017 – Jan 2019 · 2 yrs 1 mo
Associate Analyst · Boutique real estate / private equityJan 2010 – Jan 2017 · 7 yrs 1 mo

Education

Advanced Project Finance & Financial Modelling (School of Project Finance, IFF) · IFF - School of Project Finance2019

Post-Graduate Qualification

BSc Applied Economic Sciences · University of Hasselt2006 – 2012

Hire Thierry Vanroy today

Post a job and invite Thierry, or contact them directly. No hidden commission.

Post a job