Phoenix, AZ · Mechanical engineer turned BI lead

Jose Farfan

Senior BI Developer & Data Lead · Power BI · Microsoft Fabric · SQL

Available Nov 2026 · US work authorized
Change language
EN ES
BI experience
7+ yrs
Power BI & data · 10+ yrs in engineering
Active users
500+
on a semantic model I led end to end
Savings
~$52K / yr
manual reporting removed (Biffa)
Plant floor
6× MTBF
from <10 to 60+ min between stops

01 Summary

Developer depth · lead-level ownership

I build the Power BI and Fabric models that 500+ people use to run the business, and lead the stakeholders, governance and data quality that make them trusted.

Mechanical engineer turned BI lead. I learned analytics on the plant floor, working alongside 40+ technicians with sensor data, MTBF, OEE and Lean Six Sigma, so I design data products around how operations really run, and I lead the change management that gets them adopted. Industries: manufacturing, consumer goods (CPG) and waste & recycling, across the UK and Latin America. Bilingual in English and Spanish.

02 Projects

Selected BI deliveries
Data flowIllustrative
Simplified Sales and Finance data flowNetSuite feeds customer and CRM data, the central system feeds contracts, revenue and services, and Dayforce feeds employee and HR data into one galaxy-schema semantic model, which serves Sales, Finance and Leadership: 500+ active users. NetSuiteCRMCentral systemContractsDayforceHR system SEMANTIC MODELCustomersCRM dataContractsRevenue · ServicesEmployeesHR dataGALAXY SCHEMA 500+active usersSalesFinanceLeadership
Biffa · 2025 – Present · Led end to end

Enterprise Sales & Finance Semantic Model

500+active users
~$52Ksaved per year
20 → 5 minmodel refresh
Problem
Sales and Finance ran on 5+ siloed Excel processes (pipeline, revenue projection, rolling revenue, churn, contract health), with competing revenue definitions, including the ones used for bonuses.
Approach & impact
Approach
A galaxy-schema semantic model: contract, revenue and service facts from the central system, customer and CRM data from NetSuite, and HR data from Dayforce, with one agreed set of revenue definitions, row-level security and deployment pipelines. I led it from requirements through adoption.
Impact
One source of truth for every UK region, all sales channels, Finance and leadership; ~13,500 manual requests a year eliminated (~$52K); refresh cut from 20 to 5 minutes with more data. Nominated for Biffa's Diamond Awards.

Savings method: ~13,500 report requests a year × 6 minutes each × $39/hour average cost of the people requesting and processing them ≈ $52K (£40K) a year. The diagram is simplified.

Power BI DAX Galaxy Schema NetSuite Dayforce RLS
Report interfaceIllustrative
Simplified recreation of the CR selection reportThree slicers (change type, data object, market) filter a table of change request types. The best match is highlighted and each row has a button that opens the form to raise that request. Find the right CR 200+ CR types CHANGE TYPEUpdateDATA OBJECTPackagingMARKETEurope CR TYPEMATCHLINK Packaging spec updateRaise ↗ Full SKU spec updateRaise ↗ Material master changeRaise ↗ New market extensionRaise ↗ Best matchRaise ↗
BAT · 2022 – 2025

Change Request Selection Tool

200+ hrssaved per month
5 → 1 minper request
~10%fewer incorrect CRs
Problem
Global operations users raised 3,000+ SKU change requests a month and had to find the right type among 200+ CR types, taking ~5 minutes each, with wrong picks causing rework.
Approach & impact
Approach
A report with slicers for change type, data object and market that filters 200+ CR types into a table, highlights the best match and links straight to the form to raise it, following global master-data rules.
Impact
Selection time cut from ~5 to ~1 minute (200+ hours saved a month) and ~10% fewer incorrect requests; 3K+ views a month across five continents.

Hours method: 3,000+ requests a month × ~4 minutes saved each ≈ 200 hours a month. Master-data governance rules live in the filters, so the standard is enforced by design rather than by review. The interface shown is a simplified recreation with sample values.

Master Data SAP ECC/Fiori Data Governance UX for Data
MTBF run chartIllustrative
Illustrative MTBF run chartSample data. Packing-machine mean time between failures stays under 10 minutes for six weeks, corrective actions start, and it climbs to over 60 minutes over the following eight weeks. 0 30 60 min Before After Corrective actions Sample week 1: 7 min Sample week 2: 5 min Sample week 3: 8 min Sample week 4: 6 min Sample week 5: 9 min Sample week 6: 7 min Sample week 7: 22 min Sample week 8: 34 min Sample week 9: 45 min Sample week 10: 53 min Sample week 11: 58 min Sample week 12: 62 min Sample week 13: 64 min Sample week 14: 66 min <10 min 60+ min
BAT · 2021 – 2022

Manufacturing Reliability & KPI Suite

6×packing-machine MTBF
65% → 71%OEE (target 70%)
12 lines80+ users
Problem
Frequent stops on the packing machines, the last step of the line, and no shared view of what drove downtime and waste across 12 production lines.
Approach & impact
Approach
A Power BI KPI suite on machine sensor data (stops, MTBF, OEE, waste), used by 80+ technicians, admin staff and factory leaders in Lean Six Sigma root-cause sessions run alongside 40+ factory technicians.
Impact
Packing-machine MTBF up from under 10 to 60+ minutes (6×); plant OEE from ~65% to ~71% over the year, beating the 70% target.

Sensor and stop data cleansed and modeled in SQL and Power Query, covering all 12 lines end to end, with MTBF measured on the packing machines as the final constraint. The chart uses sample data to show the shape of the improvement.

Power BI SQL OEE / MTBF Lean Six Sigma SPC

Visuals are simplified illustrations with sample data. No employer data is shown.

03 Experience

7+ years in BI · UK & Latin America
Biffa – Present · London, UK (Hybrid)

Senior Business Intelligence Analyst

UK waste & recycling services · Sales & Finance analytics
  • Led end to end the enterprise Sales & Finance semantic model in Power BI: a galaxy schema over NetSuite, Dayforce and contract data, now the single source of truth for 500+ active users across every UK region, all sales channels (field, telesales, e-commerce), Finance and leadership. Nominated for Biffa's Diamond Awards for this work.
  • Replaced 5+ siloed Excel processes (pre-sales CRM, revenue projection, rolling revenue, churn, contract-health checks), eliminating ~13,500 manual requests a year: ~$52K (£40K) in labor.
Show 3 more
  • Standardized revenue definitions (projected, rolling and the variants used for bonus calculations) with Sales and Finance leadership, so reporting and sales bonuses run on one agreed number.
  • Introduced Azure DevOps sprint delivery for the 8-person BI team, moving ad-hoc requests into a prioritized, visible backlog.
  • Own model governance (row-level security, deployment pipelines, refresh reliability); cut refresh time from 20 to 5 minutes while covering more data.
Power BI DAX Microsoft Fabric T-SQL Azure DevOps Data Governance
British American Tobacco (BAT) – · Southampton, UK

Business Intelligence Executive

Global Operations Data Management (ODM) · CPG manufacturer
  • Designed a Change Request selection tool that routes users to the right option among 200+ CR types, cutting selection time from ~5 to ~1 minute (200+ hours saved a month) and incorrect requests by ~10%.
  • Built Power BI SLA-compliance reporting for the global ODM team, covering 3,000+ SKU master-data change requests a month in SAP ECC/Fiori across five continents.
Show 3 more
  • Helped sustain the 99% master-data quality compliance target through monitoring and fast corrective fixes.
  • Designed and enforced SLA frameworks for global reporting processes, reducing delivery variability for cross-functional teams.
  • Delivered executive data storytelling for regional and global Continuous Improvement and Work Process Improvement (WPI) leadership.
Power BI SAP ECC/Fiori Master Data Data Governance SLA Frameworks
British American Tobacco (BAT) – · Caracas, Venezuela

Business Intelligence Engineer

Manufacturing plant · 12 production lines
  • Partnered with maintenance on root-cause analysis using Lean Six Sigma methods, raising packing-machine MTBF from under 10 to 60+ minutes (6×) and plant OEE from ~65% to ~71%, beating the 70% target.
  • Built an end-to-end Power BI KPI suite on machine sensor data (stops, MTBF, OEE, waste) for 12 production lines, used by 80+ technicians, admin staff and factory leaders.
Show 2 more
  • Automated data cleansing and transformation in SQL and Power Query, replacing manual production reports.
  • Worked day to day with 40+ factory technicians (line manager for about 20), embedding the KPI suite into shop-floor routines.
Power BI SQL OEE / MTBF Lean Six Sigma Change Management
ASIS Consulting – · Caracas, Venezuela

Business Intelligence Developer

BI consultancy · tax-consulting clients
  • Delivered Power BI solutions for 5+ major tax-consulting clients: financial modeling, tax and transactional reporting, with DAX time intelligence.
Show 2 more
  • Administered Power BI Service across client environments: workspace governance, deployment and user access.
  • Translated stakeholder requirements into scalable data models, working with the MySQL team to ensure data integrity.
Power BI DAX Power BI Service MySQL Financial Modeling
Earlier engineering experience 2016 – 2019 · Venezuela

3D Printing Engineer

3D TECH · – · Caracas, Venezuela
Details
  • Operated and maintained the lab's 3D printers, producing 6+ medical models a month (mainly jaw models) that doctors used to plan procedures and prosthetics.

Junior Project Engineer

Venezuelan Heavy Industry CA (VHICOA) · – · Bolívar, Venezuela
Details
  • Worked on 2–3 high-pressure vessel projects for the oil industry, each worth $30M+, to ASME, AWS and API standards: prepared and checked drawings, coordinated NDT and hydrostatic testing, and tracked materials, labor and progress in Excel.
Mechanical Engineering ASME / AWS / API Quality Control Advanced Excel

04 Skills

Grouped by capability

BI & Semantic Modeling

Power BI Microsoft Fabric DAX Power Query (M) Semantic Models Star / Galaxy Schema Row-Level Security (RLS) Deployment Pipelines KPI Dashboard Design Data Storytelling

Data Engineering

T-SQL Fabric Lakehouse & Warehouse Dataflows Gen2 PySpark Notebooks MySQL ETL / ELT Pipelines

Data Leadership & Governance

Data Governance Data Quality Stakeholder Management Change Management Bilingual — English & Spanish Requirements Gathering Master Data Management (MDM) KPI Definition & Standardization Training & Enablement Mentoring & Coaching

Delivery & Platforms

Azure DevOps (ADO) Agile / Scrum SAP ECC / Fiori NetSuite Sprint Planning Backlog Management Dayforce

Manufacturing & Methods

OEE MTBF Root Cause Analysis Lean Six Sigma Methods Lean Manufacturing Loss Elimination Statistical Process Control (SPC) Continuous Improvement Advanced Excel / Power Pivot

AI & Automation

Claude Code MCP Servers AI-Assisted Development LLM Workflow Automation Prompt Engineering

05 Education

Engineering foundation
Universidad Metropolitana – · Caracas, Venezuela

Bachelor of Engineering (B.Eng.), Mechanical Engineering

The engineering base behind my reliability (MTBF, OEE), process-improvement and manufacturing analytics work.

Mechanical Engineering Reliability (MTBF / OEE) Process Improvement Engineering Standards
Recognition & Development

Awards & Courses

  • Nominee, Biffa Diamond Awards · high-performer recognition, for the Sales & Finance semantic model
  • Digital Learner Award · British American Tobacco
Show 4 courses
  • Project Management · Tecnología Financiera · 2016
  • Change Management Foundations · LinkedIn Learning
  • Having Difficult Conversations: A Guide for Managers · LinkedIn Learning
  • Decision-Making Strategies · Learning Power BI Desktop · MySQL Installation and Configuration · LinkedIn Learning

Let's talk data.

Phoenix, AZ · Open to Senior BI Developer, Power BI and BI Lead roles across Greater Phoenix and remote.

jrfarfanf@gmail.com

Résumé: PDF · Word (.docx)

Download résumé (PDF)