Ian Brennan
Summary
Experienced data management professional with expertise in data governance, quality management, and master data management (MDM). Proficient in metadata management, data lineage, and regulatory compliance, with hands-on experience in leading tools such as Informatica Intelligent Cloud Services (IICS), Informatica Data Quality (IDQ), and Collibra. Skilled in designing robust data architectures, modelling, integration, and migration strategies to optimise enterprise data ecosystems. Adept at leveraging analytics platforms like Power BI, Tableau, and SAP BusinessObjects to deliver actionable insights. Demonstrates a strong command of SQL Server, Oracle databases, and Microsoft Azure platforms to support scalable solutions. Committed to driving innovation in enterprise data strategies while ensuring alignment with organisational goals.
Overview
1
1
Certification
7
7
years of post-secondary education
28
28
years of professional experience
Work history
CTM Global
2025.07 - 2026.07
- Leading the design and implementation of an enterprise Data Quality and Master Data Management platform using Informatica IICS, Informatica MDM, SQL Server, and Power BI. Architected a scalable solution that replaced a manual, spreadsheet-based reporting process with an automated enterprise platform supporting multiple business units and source systems. Designed the enterprise data model, data quality framework, governance standards, KPIs, monitoring dashboards, and reporting architecture. Developed data profiling, validation, cleansing, transformation, and MDM match/merge processes while establishing data standards, remediation workflows, and AI-assisted monitoring to improve data quality, operational efficiency, and regulatory compliance.
Motor Insurers Bureau
UK
2024.03 - 2025.07
- Led the design and implementation of an enterprise Data Governance and Data Quality solution using Informatica Intelligent Cloud Services (IICS), supported by a centralised Power BI reporting portal for UK insurers. Defined the solution architecture, governance approach, data quality standards, and implementation roadmap. Worked closely with business and technical stakeholders to establish monitoring, reporting, and remediation processes, while providing technical leadership, best-practice guidance, and continuous improvement across the programme.
Advanced
London
2023.11 - 2024.03
- Designed and implemented a Data Quality framework to support the migration of financial systems to NetSuite. Worked with senior stakeholders across multiple business functions to define data requirements, identify quality risks, and establish appropriate validation and remediation controls. Developed the supporting SQL Server data model and Power BI reporting solution, enabling clear visibility of data issues, migration readiness, and remediation progress throughout the programme.
Rabobank
Utrecht
2022.11 - 2023.10
- Delivered Data Quality and Data Governance solutions within the KYC Risk function, supporting the development of critical risk model monitoring and reporting. Facilitated workshops with business stakeholders to identify Critical Data Elements (CDEs), define business terminology, and document end-to-end data lineage. Designed and implemented data quality rules, profiling processes, and monitoring dashboards using Informatica Data Quality, Collibra, SAP BI, and SQL, providing greater visibility of data quality, regulatory compliance, and operational risk.
Aviva
London
2021.03 - 2022.07
- Led the implementation of Informatica Data Quality as part of Aviva's enterprise Data Governance programme, establishing a scalable framework integrating Informatica Data Quality, Axon, and Enterprise Data Catalog (EDC). Designed reusable data quality standards, business rules, and integration processes while supporting the onboarding of multiple business domains. Provided technical leadership, solution design, best-practice guidance, and product training to business and technical teams.
AXA Bank
Antwerp
2020.06 - 2021.03
- Architected and delivered an enterprise Data Quality monitoring and reporting solution using Informatica Data Quality, Informatica Metadata Manager, Oracle, and Power BI to support the bank's Data Governance programme. Designed an integrated metadata-driven framework combining business and technical metadata to provide end-to-end visibility of data quality, data lineage, business glossary, and stewardship activities. Implemented workflow and reporting capabilities that improved issue management, governance, and regulatory reporting across the organisation.
Mitsubishi Financial Services
Amsterdam
2019.09 - 2020.06
- Designed and developed an enterprise Data Governance solution supporting MUFG’s data quality programme using SQL Server and Power BI. Established a metadata-driven framework for data profiling, monitoring, lineage, reporting, and issue resolution across critical business data. Worked closely with the Data Management team to define governance requirements, reconcile business and technical metadata, and improve visibility of data quality issues and remediation activity.
Rabobank
Utrecht
2016.11 - 2018.04
- Designed and implemented a bank-wide Data Quality monitoring and reporting solution using Informatica Data Quality, Tableau, and SAP BusinessObjects. Worked with business teams, data owners, and data stewards to define and implement data quality rules, establish reporting standards, and support the rollout of data quality controls across multiple business areas. Provided technical guidance, best-practice support, and user training.
Network Rail
Milton Keynes
2015.01 - 2016.10
- Delivered Data Quality analysis and rule implementation for a major Ellipse data migration programme using Informatica Data Quality. Defined data quality requirements, performed data analysis, developed business rule specifications, and implemented cleansing and validation logic within the ETL process. Provided Informatica best-practice guidance throughout the migration lifecycle.
HSBC
London
2013.12 - 2014.12
- Lead the delivery of a global customer data consolidation programme designed to create a single view of HSBC’s customer base across more than 100 countries. Worked across requirements definition, data mapping, profiling, issue analysis, cleansing, standardisation, and matching using Informatica Data Quality, SQL, and Oracle. Developed data quality rules and matching processes to improve consistency and support the creation of a consolidated global customer record.
Johnson & Johnson
Belgium
2013.09 - 2014.03
- Delivered Data Quality services for an Informatica MDM implementation, including requirements definition, data profiling, cleansing, matching, consolidation, and rule development. Provided technical guidance and best-practice support for the rollout of parallel data quality solutions across multiple business areas.
Commerzbank
Frankfurt
2012.02 - 2013.09
- Designed and implemented ETL and Data Quality monitoring processes supporting a financial and risk data warehouse programme. Developed reusable validation, cleansing, and monitoring controls to enable continuous assessment and improvement of data quality across critical financial and risk data.
BMW Financial Services
Hook
2011.03 - 2011.12
- Senior Informatica Developer who designed and developed ETL interfaces for the Operational Data Store, supporting insurance reporting and business intelligence.
Informatica
Dublin
2004.11 - 2011.03
- Senior Consultant delivering enterprise Data Quality, Data Governance, MDM, Data Migration, CRM, ERP, and Data Warehousing solutions across Europe, North America, and Asia-Pacific. Led end-to-end client engagements from architecture through implementation and knowledge transfer.
- Key clients: Reuters, KPN (Global Innovation Award), NAF, Philips, Electrolux, Kesko, Danske Bank, BOC, Givaudan, AAA.
Phoenix Technology Group
Dublin
2000.07 - 2001.10
- Technical Implementation Analyst responsible for implementing enterprise software solutions for financial services clients, working closely with business and technical teams to analyse requirements, configure applications, and deliver cost-effective business solutions. Involved throughout the full project lifecycle including business analysis, solution design, implementation, testing, client support, and knowledge transfer.
Kindle Banking Systems
Dublin
1998.04 - 2000.07
- Technical Implementation Consultant responsible for implementing core banking software solutions for international banking clients, translating business requirements into configured application solutions. Worked closely with client teams to support business process change, software configuration, testing, user training, and successful project delivery.
Education
Bachelor of Business Studies -
University of Wolverhampton
UK 1991.01 - 1995.01
MSc - Computing and Information Systems
University of Ulster
Northern Ireland 1995.01 - 1996.01
Postgrad Certificate - Telecommunications and Distributed Systems
University of Ulster
Northern Ireland 2000.01 - 2001.01
Professional Certificate - Computer Science for Artificial Intelligence
Harvard University
Cambridge, MA 2023.01 - 2024.01
Skills
- Data Management: Data Governance
- Data Quality Management
- Master Data Management (MDM)
- Metadata Management
- Data Lineage
- Data Architecture
- Data Modelling
- Data Integration
- Data Migration
- Data Stewardship
- Business Glossary
- Critical Data Elements (CDE)
- Regulatory Compliance
- Informatica: Informatica Intelligent Cloud Services (IICS)
- Informatica Data Quality (IDQ)
- Informatica MDM
- Informatica Axon
- Enterprise Data Catalog (EDC)
- PowerCenter
- Metadata Manager
- Informatica Analyst
- Product Information Management (PIM)
- Analytics & Databases: SQL Server
- Oracle
- Power BI
- Tableau
- SAP BusinessObjects (SAP BO)
- SAP BI
- Collibra
- Python
- Platforms & Operating Systems: Microsoft Azure
- Windows Server
- Red Hat Linux
- AIX
Certification
- Informatica Certified Developer
- Informatica Certified Data Quality (Administrator/Developer)
Timeline
CTM Global
2025.07 - 2026.07
Motor Insurers Bureau
2024.03 - 2025.07
Advanced
2023.11 - 2024.03
Professional Certificate - Computer Science for Artificial Intelligence
Harvard University
2023.01 - 2024.01
Rabobank
2022.11 - 2023.10
Aviva
2021.03 - 2022.07
AXA Bank
2020.06 - 2021.03
Mitsubishi Financial Services
2019.09 - 2020.06
Rabobank
2016.11 - 2018.04
Network Rail
2015.01 - 2016.10
HSBC
2013.12 - 2014.12
Johnson & Johnson
2013.09 - 2014.03
Commerzbank
2012.02 - 2013.09
BMW Financial Services
2011.03 - 2011.12
Informatica
2004.11 - 2011.03
Phoenix Technology Group
2000.07 - 2001.10
Postgrad Certificate - Telecommunications and Distributed Systems
University of Ulster
2000.01 - 2001.01
Kindle Banking Systems
1998.04 - 2000.07
MSc - Computing and Information Systems
University of Ulster
1995.01 - 1996.01
Bachelor of Business Studies -
University of Wolverhampton
1991.01 - 1995.01