Open to opportunities

Francesco Guarracino

@francescoguarracino

Message

I’m a Data Analyst and BI specialist turning messy data into clear dashboards and actionable insights for stakeholders.

United Kingdom

Message

What I'm looking for

I’m looking for a role where I can build end-to-end Power BI analytics—partnering with stakeholders, improving data pipelines, and delivering KPI dashboards and statistical insights that drive business decisions.

I’m a Data Analyst with a PhD background in experimental data analysis and 3.5+ years of commercial experience delivering business intelligence solutions. I focus on discovering trends and insights through data transformation, modelling, and statistical analysis, while staying grounded in the business by translating stakeholder requirements into effective dashboards.

At OrangeQuery, I’ve built end-to-end Power BI reporting solutions from requirements gathering and data modelling to dashboard deployment—delivering over 15 interactive dashboards across multiple business functions. I also built SQL queries and Python scripts to work with datasets containing millions of records, and I designed ETL workflows that improved data quality and reduced manual reporting effort by 60%.

In previous contracts, I created and managed Power BI reporting infrastructure, automated reporting with Power Query, and collaborated on ETL pipelines from CRM platforms into MySQL—reducing Power BI Service refresh times by 75%. I enjoy hands-on analytics work (e.g., Python/SQL/Excel analysis and MySQL views to reduce processing time by 30%), and I bring the same clarity to KPI definition and presenting insights to technical and non-technical audiences.

Experience

Work history, roles, and key accomplishments

Current

Senior Data & Analytics Consultant

Current

OrangeQuery

Feb 2025 - Present (1 year 4 months)

Promoted from Data & Analytics Consultant to Senior after delivering Power BI projects for multiple clients. Developed end-to-end Power BI reporting (15+ interactive dashboards), built SQL/Python analytics on million-row datasets, and designed ETL pipelines that improved data quality and reduced manual reporting by 60%.

Power BI DAX Power Query SQL Python Data Modeling ETL Data Pipelines Data Quality

Current

BI Developer

Current

Sensible Group

Mar 2024 - Present (2 years 3 months)

Created and managed the Power BI reporting infrastructure and KPI dashboards. Partnered with data engineering to design ETL from CRM into MySQL databases, reducing Power BI Service refresh times by 75%, and automated Profit & Loss reporting with Power Query to improve reporting efficiency.

Power BI Power Query DAX MySQL ETL KPI Reporting data transformation Data Validation

Data Administrator

Mitsubishi Electric

Sep 2023 - Mar 2024 (6 months)

Developed Excel dashboards to monitor employee performance, contributing to achieving a 95% call volume target. Analyzed sales and maintenance data and presented 10+ case studies to stakeholders to support improvements to the premium maintenance plan.

Data Analysis KPI Reporting Performance Metrics

Data Analyst

AQA

Jun 2023 - Sep 2023 (3 months)

Generated and analyzed grade distributions for 100+ examination subjects using Python, SQL, and Excel. Developed MySQL views to automate performance metric calculations, reducing processing time by 30%.

Python SQL Excel MySQL Data Analysis Statistical Analysis Grade Distribution Analysis Performance Metrics Data Automation

Education

Degrees, certifications, and relevant coursework

The University of Manchester

Doctor of Philosophy (PhD), Materials Engineering

PhD in Materials Engineering. Designed an interactive Power BI dashboard to monitor production volumes and properties of aluminium handlebars, identifying a bottleneck and increasing production volume by 4%.