Looking for a job

William Gannon

@billygannon

Data and AI leader at SMBC Aviation Capital who helped establish Microsoft Fabric and defined the semantic layer for Fabric Data Agents.

Ireland

Message

At SMBC Aviation Capital, I played a leading role in establishing a Microsoft Fabric implementation programme. I defined Power BI standards and an intelligent semantic layer to serve Fabric Data Agents, supporting a move toward an ontology-based data model.

At Mater Private Network, I led the Data Strategy and built a Data Analytics team. I replaced unsupported reporting with a metadata-driven data warehouse and led the reporting and analytics workstream for the Meditech electronic health record programme, rebuilding reporting in Power BI when the initial environment proved inadequate.

I’ve used data to address practical challenges across healthcare, finance and operations. At Mater Private Network, I delivered required data for 15,000 patients within a month during COVID-19, helped correct 60,000 historical insurance cases, and cut radiology waiting times by 95% with a Power BI dashboard.

Experience

Work history, roles, and key accomplishments

VP Data Operations

SMBC Aviation Capital

Jan 2026 - Sep 2026 (8 months)

Played a leading role in establishing a Microsoft Fabric implementation programme. Defined Power BI standards and an intelligent Semantic Layer to support an Ontology-based data model.

Microsoft Fabric Power BI Semantic layer Data Strategy Data Infrastructure

Head of Data Analytics

Mater Private Network

Jan 2020 - Dec 2025 (5 years 11 months)

Led data strategy and built a data analytics team, delivering solutions across operations, finance, and clinical areas. Replaced legacy reporting with a metadata-driven data warehouse and Power BI, and led reporting for a €31 million EHR programme.

Data Strategy Data Governance SQL Server SSIS Power BI Power Automate Excel Kimball Modelling Methodology Microstrategy Azure Fabric DBT GDPR ICD 10 SNOMED

Senior Business Intelligence Consultant

Client Solutions

Jan 2015 - Dec 2020 (5 years 11 months)

Led client-facing BI and data warehouse projects for the Central Bank of Ireland, Eir, and the Food Safety Authority of Ireland. Advised on data strategy, governance, and GDPR compliance.

SQL Server Power BI Microstrategy Business Objects SSRS Data Warehouse ETL Agile Data Governance GDPR

Data Warehouse Developer

DMS Offshore Investments

Jan 2014 - Dec 2015 (1 year 11 months)

Designed a dimensional data model for risk management regulatory reporting and supported the Chief Risk Officer in developing risk models for fund governance.

Dimensional Modeling Risk Management Regulatory Reporting

Senior MI Analyst Developer

LV= Insurance

Jan 2011 - Dec 2014 (3 years 11 months)

Drove the modernisation of the General Insurance division's data environment, moving from SAS to an Oracle Data Warehouse. Established an MI User Group and delivered training workshops.

SAS Oracle Data Vault Kimball SSRS SQL Data Warehouse

MI Analyst

Hobbycraft

Jan 2008 - Dec 2011 (3 years 11 months)

Managed end-to-end reporting systems and established new dashboards for various departments. Played a central role in the company's buyout and delivered stock analysis that led to significant savings.

Business Objects SQL Server Data Warehouse Dashboarding Stock Analysis

Operations Analyst

Nectar (Loyalty Management Services)

Jan 2005 - Dec 2008 (3 years 11 months)

Built a metadata repository and developed a data validation process that saved £75,000 annually. Created a Balanced Scorecard for the Executive team.

Metadata Management Data Validation Balanced Scorecard

Information Analyst

AIB Group

Jan 1999 - Dec 2005 (6 years 11 months)

Worked as an Information Analyst and Lead Data Quality Analyst, using data for customer segmentation in the CRM division. Supported data governance and quality initiatives.

Teradata Data Quality Data Governance Customer Segmentation Basel II III