Aidan Connolly

Data Engineer at SYZYGY London
  • Claim this Profile
Contact Information
Location
Kansas City, Missouri, United States, US

Topline Score

Topline score feature will be out soon.

Bio

Generated by
Topline AI

You need to have a working account to view this content.
You need to have a working account to view this content.

Experience

    • 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

    • 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

    • 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.

    • 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

    • 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

    • 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

    • 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

    • 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
    2014 - 2018

Community

You need to have a working account to view this content. Click here to join now