# William Gannon

William Gannon is a remote worker on Himalayas, VP Data Operations at SMBC Aviation Capital, based in Ireland. Their ID is verified.

Source: https://himalayas.app/@billygannon

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

| Detail | Value |
| --- | --- |
| Availability | Looking for a job |
| Location | Ireland |
| Authorized to work in | Ireland |
| Salary expectations | 100k+ EUR |
| Job categories | Data Architect |
| Skills | Data Architecture, Enterprise Data Strategy, Data Governance, AI Enablement, AI Adoption, AI Data Architecture, Semantic Layer Design, Enterprise Data Warehousing, Kimball Dimensional Modeling, Data Vault, Inmon 3NF, Metadata Driven Architecture, Master Data Management, Data Quality, Regulatory Reporting |

## About

```text
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

### VP Data Operations

SMBC Aviation Capital. Jan 2026 - Sep 2026

```text
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.
```

Skills: Microsoft-Fabric, Power-BI, Semantic-layer, Data-Strategy, Data-Infrastructure

### Head of Data Analytics

Mater Private Network. Jan 2020 - Dec 2025

```text
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.
```

Skills: 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

```text
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.
```

Skills: 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

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

Skills: Dimensional-Modeling, Risk-Management, Regulatory-Reporting

### Senior MI Analyst Developer

LV= Insurance. Jan 2011 - Dec 2014

```text
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.
```

Skills: SAS, Oracle, Data-Vault, Kimball, SSRS, SQL, Data-Warehouse

### MI Analyst

Hobbycraft. Jan 2008 - Dec 2011

```text
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.
```

Skills: Business-Objects, SQL-Server, Data-Warehouse, Dashboarding, Stock-Analysis

### Operations Analyst

Nectar (Loyalty Management Services). Jan 2005 - Dec 2008

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

Skills: Metadata-Management, Data-Validation, Balanced-Scorecard

### Information Analyst

[AIB Group](https://himalayas.app/companies/aib). Jan 1999 - Dec 2005

```text
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.
```

Skills: Teradata, Data-Quality, Data-Governance, Customer-Segmentation, Basel-II-III

## Education

### National University of Ireland, Maynooth

Higher Diploma, Information Technology. 2000 - 2001

```text
Completed a Higher Diploma in Information Technology.
```

### National University of Ireland, Maynooth

Bachelor of Arts (Honours), Arts. 1996 - 1999

```text
Earned a Bachelor of Arts (Honours) degree.
```

## Tech stack

- Snowflake
- Tableau
- SAS
- Microsoft Azure
- dbt
- Oracle
- Python
- SQL
- Microsoft Fabric
- MicroStrategy
- Power BI
- MEDITECH

To contact William, message them from this profile with a Himalayas employer account: [Hire on Himalayas](https://himalayas.app/hire).

## People also viewed

- [Brian O'Connor](https://himalayas.app/@brianoconnor): Data Analyst, Meta
- [Victor Garlet User](https://himalayas.app/@victorgarlet): Senior Data Analyst, AG Capital
- [Pranaty Dara](https://himalayas.app/@pranatydara): Data Architect, Vertice Cloud
- [Pulkit Sh](https://himalayas.app/@pulkit160): Associate, Quant Analytics Consumer Banking, JPMorgan Chase
- [Chunmun Mudgal](https://himalayas.app/@chunmunmudgal): Senior Business Analyst, ESW
- [Dyuti Dash](https://himalayas.app/@dyutidash): Senior Manager, Data Systems, XOCEAN
- [Darren Kierans](https://himalayas.app/@darrenkierans): Senior Data Engineer, ForvisMazars
- [Gabriel Ogunkola](https://himalayas.app/@gabrielogunkola): Data Governance & Quality Lead, Berkeley Data Strategist UK
- [Sean Ward](https://himalayas.app/@seanward): Data Insights Analyst, Irish Farmers Journal
- [Kevin Bunyan](https://himalayas.app/@kevinbunyan): Senior Data Analytics Developer, Freelance Data Projects