Sean Ward
Advertising Data Analyst at The Irish Times- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
-
English Native or bilingual proficiency
-
Japanese Native or bilingual proficiency
Topline Score
Bio
Daniel Chan
Sean is a hard working individual with a strong skillset in SQL. He utilised his knowledge to drive automated reporting and analysis solutions within the wider business, adding value internally and for clients. He was a pleasure to work with!
Jennifer Lorimer
Sean was a pleasure to work with during my time at ForwardPMX. Always eager to learn more and taking on board feedback for improvement. He has been especially pro-active in SQL and leading projects in the agency tech stack. Alongside his role he has also been proactive in continued learning in coding and programming.
Daniel Chan
Sean is a hard working individual with a strong skillset in SQL. He utilised his knowledge to drive automated reporting and analysis solutions within the wider business, adding value internally and for clients. He was a pleasure to work with!
Jennifer Lorimer
Sean was a pleasure to work with during my time at ForwardPMX. Always eager to learn more and taking on board feedback for improvement. He has been especially pro-active in SQL and leading projects in the agency tech stack. Alongside his role he has also been proactive in continued learning in coding and programming.
Daniel Chan
Sean is a hard working individual with a strong skillset in SQL. He utilised his knowledge to drive automated reporting and analysis solutions within the wider business, adding value internally and for clients. He was a pleasure to work with!
Jennifer Lorimer
Sean was a pleasure to work with during my time at ForwardPMX. Always eager to learn more and taking on board feedback for improvement. He has been especially pro-active in SQL and leading projects in the agency tech stack. Alongside his role he has also been proactive in continued learning in coding and programming.
Daniel Chan
Sean is a hard working individual with a strong skillset in SQL. He utilised his knowledge to drive automated reporting and analysis solutions within the wider business, adding value internally and for clients. He was a pleasure to work with!
Jennifer Lorimer
Sean was a pleasure to work with during my time at ForwardPMX. Always eager to learn more and taking on board feedback for improvement. He has been especially pro-active in SQL and leading projects in the agency tech stack. Alongside his role he has also been proactive in continued learning in coding and programming.
Credentials
-
TABLEAU 2018: Hands-On Tableau Training For Data Science!
UdemyJan, 2021- Nov, 2024 -
Automate the Boring Stuff with Python Programming
UdemySep, 2020- Nov, 2024 -
R Programming A-Z™: R For Data Science With Real Exercises
UdemyMay, 2019- Nov, 2024 -
R Programming: Advanced Analytics In R For Data Science
UdemyMar, 2019- Nov, 2024 -
Excel 2013 Essential Training
LinkedInNov, 2018- Nov, 2024 -
Excel 2013: Advanced Formulas and Functions
LinkedInNov, 2018- Nov, 2024 -
SQL Tips, Tricks, & Techniques
LinkedInNov, 2018- Nov, 2024 -
Duolingo French Fluency: Elementary (Estimated)
DuolingoMay, 2016- Nov, 2024 -
Display and video certification exam
GoogleSep, 2018- Nov, 2024 -
NYLT leadership course
Boy Scouts of America -
Scuba diver
PADI
Experience
-
The Irish Times
-
Ireland
-
Newspaper Publishing
-
300 - 400 Employee
-
Advertising Data Analyst
-
Apr 2021 - Present
Revolutionized data analysis with the implementation of custom dashboards using Google Sheets and Google Data Studio, resulting in a 20% YoY increase in performance. Efficiently streamlined recurring tasks, leading to a reduction of 20 man-hours and elimination of human error. Delivered valuable ad-hoc insights and analysis, providing the team access to previously untapped data sources. Revolutionized data analysis with the implementation of custom dashboards using Google Sheets and Google Data Studio, resulting in a 20% YoY increase in performance. Efficiently streamlined recurring tasks, leading to a reduction of 20 man-hours and elimination of human error. Delivered valuable ad-hoc insights and analysis, providing the team access to previously untapped data sources.
-
-
-
ForwardPMX
-
United States
-
Advertising Services
-
1 - 100 Employee
-
Insights Analyst
-
Nov 2019 - Apr 2021
Managed and led transformation of weekly reporting process for a digital advertising company. In one example, the data source used for the weekly commentary regularly failed to import and would regularly change numbers in a client call. I investigated the data and found a new connection the IT team had made. I then used SQL to provide data via the new method, enabling no delay and errors in reporting.Visualised data using Google Data Studio combining various data sources that were custom built, which lead to 30 man hours per week for junior teams, and saved up to 2 hours for senior members per client request by adding all data points in the same point.Developed and improved on new ways of performing health checks on ads running, reducing 20-man hours performed on QA done on ongoing advertising campaigns.Upskilled junior members in SQL, data validation, company tech stack, and compiled knowledge into a company Wiki, which lead to more automation happening across clients.Collaborated with different teams to ensure all goals were met, and because a point of contact for the IT team to come for better, more specialized points of communication.Performed in-depth analysis for client QBRs. Show less
-
-
Programmatic Analyst
-
Dec 2017 - Nov 2019
Analyze and manage several display campaigns for online advertisements, optimizing to different KPI targets.Honed presenting and communication skills through client facing QBR, post campaign analysis and weekly client reports.
-
-
-
Kepler EMEA
-
United Kingdom
-
Advertising Services
-
1 - 100 Employee
-
Optimisation Analyst
-
Jun 2017 - Nov 2017
Infectious Media is an international programmatic agency that partners with global brands to deliver effective and efficient media campaigns. Founded at the dawn of the programmatic era, Infectious Media has developed specialist teams and technology that exclusively focus on making programmatic work for advertisers. Currently I analyse and manage several display and social campaigns for online advertisements, optimising to different KPI targets. Variables such as Domain, Placement, Exchange Group, Frequency, Time & Day and Region are analysed. I work with a variety of DSPs to optimise as delivery. (IDB, FBM, 4C, DBM) Current clients include Adidas, Reebok, Dyson, John Lewis and Clarks Analysis performed include mastering of data analytics system Looker to create stored queries & dashboards to aid efficient decision making Brand Safety is a key part of the job, which include using custom Keyword blocking, Whitelists & Blacklists and Exchange/Publisher exclusions to ensure adequate placement of adverts. Show less
-
-
-
Nuritas
-
Ireland
-
Biotechnology
-
1 - 100 Employee
-
Commercial Intern
-
Jun 2016 - Aug 2016
Nuritas™ is a company revolutionizing the discovery of novel and natural active ingredients with scientifically proven health benefits. Our disruptive approach to discovery combines artificial intelligence and DNA analysis to data-mine billions of molecules. This means that for the first time Nuritas can rapidly and efficiently provide access to the most health-benefiting components within foods, called bioactive peptides. Translated documents, emails and the company website for correspondence with Japanese companies, as the company is planning of expanding to Japan. Conducted analysis on potential partners in the cosmetics and health food markets, using published financial statements from companies. Took minutes for various phone conferences and meetings with potential partners. Show less
-
-
-
TCD
-
Dublin
-
Japanese Teacher
-
Sep 2015 - May 2016
Taught intermediate level Japanese to 20 Irish students Increased their understanding of Japanese culture and language. Taught intermediate level Japanese to 20 Irish students Increased their understanding of Japanese culture and language.
-
-
-
Keiki Intercultural Preschool
-
Tokyo, Japan
-
Office Administrator
-
May 2015 - Aug 2015
Created the companies Facebook profile, and worked on the companies social media. Boosted the number of visits to company home page. Allowed company to be more transparent to parents about the children’s daily activities. Created the companies Facebook profile, and worked on the companies social media. Boosted the number of visits to company home page. Allowed company to be more transparent to parents about the children’s daily activities.
-
-
-
IBM
-
United States
-
IT Services and IT Consulting
-
700 & Above Employee
-
Intern
-
Jul 2014 - Aug 2014
Participated in the first interns at IBM Japan. Shadowed members of the Honda business unit. Translated documents, conducted business analysis for the future of collaboration between Honda and IBM. Participated in the first interns at IBM Japan. Shadowed members of the Honda business unit. Translated documents, conducted business analysis for the future of collaboration between Honda and IBM.
-
-
-
-
Assistant loader
-
Jul 2013 - Aug 2013
Worked in a highly high paced, demanding environment that sorted out the different package posts to the Tokyo metropolitan area. Worked in a highly high paced, demanding environment that sorted out the different package posts to the Tokyo metropolitan area.
-
-
-
-
Assistant teacher
-
Jul 2012 - Aug 2012
Served as an assistant teacher, helping the teacher with various activities teaching Japanese students to learn English. Supervised fellow students as captain for various events. Served as an assistant teacher, helping the teacher with various activities teaching Japanese students to learn English. Supervised fellow students as captain for various events.
-
-
Education
-
National College of Ireland
Postgraduate Degree, Data Analytics -
Trinity College, Dublin
Bachelor’s Degree, Functional Biology -
St. Mary's International School
High School, 35 in the International Baccalaureate