Tom Warren
Athboy,Ireland
Summary
Experienced Media analyst with expertise in advanced SQL, relational databases, and data quality assurance processes. Skilled in transforming complex datasets into actionable insights through data analysis, reporting, and stakeholder communication for Fortune 500 companies in Ireland and the U.S. Proficient in Python for automation, Microsoft Excel for advanced data manipulation, and PowerPoint for creating compelling report narratives. Adept at managing small teams of analysts and leveraging media analytics platforms to deliver impactful results. Career focus on driving data-driven decision-making and optimising business outcomes through innovative solutions.
Overview
6
6
years of professional experience
Work history
Senior Media Analyst
PublicRelay
Cavan, Ireland
2020.03 - 2026.04
- Analyse large-scale structured and unstructured datasets to identify trends, patterns, and performance indicators across media coverage.
- Worked with structured and unstructured data across relational systems, ensuring accurate processing and reconciliation of data
- Performed detailed data validation and QA checks to ensure consistency, accuracy, and reliability across outputs
- Investigated data discrepancies, identified root causes, and implemented solutions to improve data quality
- Supported data workflows from ingestion through to final reporting, ensuring smooth data movement across systems
- Collaborated with internal teams and international stakeholders to resolve data issues and refine data requirements
- Developed and maintained recurring reports to monitor KPIs, identify anomalies, and support decision-making
- Mentor and support junior analysts, providing guidance on data interpretation, quality standards, and best analytical practices.
- Acted as the lead analyst for PNC Financial Services, the sixth-largest U.S. bank, gaining in-depth exposure to financial institutions and strengthening expertise across key financial topics through detailed data analysis.
- Key Achievements:
- Improved data accuracy by identifying and resolving recurring data quality issues
- Reduced reporting errors through enhanced QA and validation processes
- Consistently delivered high-quality analysis under tight deadlines in a fast-paced environment
- Quickly learned and applied new skills to daily tasks, improving efficiency and productivity.
- Successfully delivered on tasks within tight deadlines.
Education
Level 7 Degree - Computer Science - Software Development
Dundalk Institute of Technology
Dundalk, LouthSkills
- Advanced SQL (complex queries, joins, aggregations, data validation)
- Relational Databases (data extraction, transformation, reconciliation)
- Data Quality & QA Processes
- Data Analysis & Reporting
- Data Issue Investigation & Root Cause Analysis
- Stakeholder Communication (Ireland & US Based fortune 500 companies)
- Transforming Data into actionable insights for clients and stakeholders
- Data Processing & Data Movement
- Python (data analysis / automation)
- Microsoft Excel (advanced formulas, pivot tables)
- Microsoft PowerPoint (interpreting data into charts and report narrative)
- Media analytics and monitoring platforms
- Git / version control (academic use)
- Managing small teams of analysts
Web Forum Application (JSP & MySQL)
Designed and implemented a relational MySQL database with structured schemas, primary/foreign keys, and defined relationships, Wrote SQL queries to create, retrieve, update, and delete data, ensuring data integrity and consistency, Implemented data validation and error handling to maintain accuracy of stored data, Processed and queried structured datasets to support application functionality and reporting outputs, Built backend logic to manage data flow between user input and database systems
Additional information
- Strong attention to detail with a focus on data accuracy and integrity
- Experienced in QA-focused environments with high data quality requirements
- Comfortable working within small teams while supporting global stakeholders
- Strong communicator, able to translate technical findings into clear, actionable insights
- Confident in client-facing discussions, translating requirements into clear and actionable analytical solutions.
References
References available upon request.
Timeline
Senior Media Analyst
PublicRelay
2020.03 - 2026.04
Level 7 Degree - Computer Science - Software Development
Dundalk Institute of Technology