Aidan Connolly
Data Engineer at SYZYGY London- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
Topline Score
Bio
Experience
-
SYZYGY London
-
United Kingdom
-
Advertising Services
-
1 - 100 Employee
-
Data Engineer
-
Aug 2022 - Present
Remote • Write Python scripts to pull data out of platform APIs for one-off projects or scheduled pulls using Apache Airflow • Oversee data pipelines and storage for the entire agency, utilizing Google BigQuery, Google Cloud Storage, Amazon S3, Snowflake, and client SFTP servers • Identify inefficiencies (client-side and internal) that data engineering and automation can improve, including monthly reports, regular QA checks and more • Design data tables and warehouses to store client data for… Show more • Write Python scripts to pull data out of platform APIs for one-off projects or scheduled pulls using Apache Airflow • Oversee data pipelines and storage for the entire agency, utilizing Google BigQuery, Google Cloud Storage, Amazon S3, Snowflake, and client SFTP servers • Identify inefficiencies (client-side and internal) that data engineering and automation can improve, including monthly reports, regular QA checks and more • Design data tables and warehouses to store client data for dashboards and additional analysis • Meet with clients on a weekly basis to understand client requirements and explain advancements since previous check-in
-
-
Technical Performance Analyst
-
Aug 2021 - Aug 2022
• Designed and implemented analytics tracking on client websites using Google Tag Manager and Google Analytics • Built dashboards in Looker Studio to help clients understand key insights from their advertising and analytics data • Led the end-to-end process for implementation — from initial discussions with the client to understand business requirements, to reviewing technical requirements with client developers, to running a full QA on the resulting data, to training client employees on… Show more • Designed and implemented analytics tracking on client websites using Google Tag Manager and Google Analytics • Built dashboards in Looker Studio to help clients understand key insights from their advertising and analytics data • Led the end-to-end process for implementation — from initial discussions with the client to understand business requirements, to reviewing technical requirements with client developers, to running a full QA on the resulting data, to training client employees on how interpret the data
-
-
-
Colts Youth Organization
-
United States
-
Musicians
-
1 - 100 Employee
-
Director of Media and Events
-
Nov 2019 - Apr 2021
Dubuque, Iowa • Single-handedly migrated online store from 3dcart to Shopify and ingested sales data into Salesforce customer history • Redesigned and built the organization’s website to more effectively connect with potential members, show attendees and donors • Distilled updates and procedures for communication to varying audiences in a clear and concise manner
-
-
-
Digital IQ, INC
-
United States
-
Business Consulting and Services
-
1 - 100 Employee
-
Application Engineer
-
Aug 2018 - Oct 2019
Remote • Migrated analytics and other third-party tags from hardcoded implementations to Launch. • Utilized Typescript and AWS to create ETL pipelines between data sources and data analysis tools • Designed and oversaw development of W3C standard data layer, customized to client's needs. • Created reports using SQL and Tableau to allow monitoring of key business metrics. • Audited both Google Analytics and Adobe Analytics implementations to recommend best practices.
-
-
-
University of Nebraska Lincoln - Athletic Department
-
United States
-
Spectator Sports
-
100 - 200 Employee
-
Video Production Intern
-
Aug 2016 - May 2018
Lincoln, Nebraska • Operated cameras, EVS replay systems and other technology to help create and capture the gameday experience • Produced and edited Pro Big Red segments for football games and a season highlight video for Men’s Tennis • Collaborated with Big Ten Network and other interns to produce StudentU broadcasts for an online market
-
-
-
University of Nebraska-Lincoln
-
United States
-
Higher Education
-
700 & Above Employee
-
Webmaster
-
Aug 2016 - May 2018
Lincoln, Nebraska • Created and redesigned webpages for the Political Science department using UNL’s Drupal framework and custom HTML • Communicated with professors to correct errors and develop improvements
-
-
-
The Daily Nebraskan
-
United States
-
Newspaper Publishing
-
1 - 100 Employee
-
Editor-in-chief
-
May 2017 - Nov 2017
Lincoln, Nebraska • Coordinated transition from twice-weekly newspaper to monthly magazine to better fit our reader’s needs • Directly hired 25 senior staff members with interview process and oversaw total staff of 140 • Organized and managed $120,000 budget for large projects, equipment and staff wages • Collaborated with professionals to create monthly newsletter to send to Daily Nebraskan alumni
-
-
-
The Buffalo News
-
United States
-
Newspaper Publishing
-
200 - 300 Employee
-
Data Intern
-
Jun 2017 - Aug 2017
Buffalo, New York • Developed throw-tracking app using D3 and Django for sports reporters to diagram plays • Created NFL stats comparison app from generic stats feed
-
-
-
Omaha World-Herald
-
United States
-
Newspaper Publishing
-
200 - 300 Employee
-
Data fellow
-
Oct 2016 - May 2017
Omaha, Nebraska • Developed script to scrape data from the Nebraska Legislature website on a regular schedule • Taught myself Django to ingest the scraped data into a database and populate appropriate models • Designed HTML website to allow exploration of legislature data based on bill, committee or senator
-
-
-
-
News reporter
-
Jan 2016 - Oct 2016
Lincoln, Nebraska • Identified relevant topics and pitched story ideas to editors for potential stories • Interviewed sources and collected information from reference materials to capture entire story • Combined information and quotes into articles for publication, more than 50 articles in total
-
-
-
-
Resident Assistant
-
Aug 2015 - May 2016
Lincoln, Nebraska • Hosted educational programs for residents to learn about resources provided for them to succeed • Resolved conflict between residents and handled confidential information properly
-
-
Education
-
University of Nebraska-Lincoln
Bachelor of Journalism, Journalism; Minors in Mathematics, Music Technology, Informatics and Music