Madison H.

Data Engineer at Masterworks
  • Claim this Profile
Contact Information
us****@****om
(386) 825-5501
Location
Palo Alto, California, 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.
Join now
You need to have a working account to view this content.
Join now

Credentials

  • Artificial Intelligence for Marketing
    LinkedIn
    Jul, 2022
    - Nov, 2024
  • Python for Data Visualization
    LinkedIn
    Jul, 2022
    - Nov, 2024
  • Learn SQL Course
    Codecademy
    Jan, 2022
    - Nov, 2024
  • Alteryx Designer Core Certification
    Alteryx
    Aug, 2022
    - Nov, 2024
  • Google Search Ads Certification
    Google
    Apr, 2022
    - Nov, 2024
  • Google Analytics Individual Qualification
    Google
    Mar, 2022
    - Nov, 2024
  • Google Display Ads Certification
    Google
    Mar, 2022
    - Nov, 2024

Experience

  • Masterworks
    • United States
    • Advertising Services
    • 1 - 100 Employee
    • Data Engineer
      • Jan 2023 - Present

      Designed a relational database, allowing for internal data pipeline process improvements. Built automation tools on top of the new relational database using advanced SQL.

    • Data Automation Consultant
      • Oct 2022 - Jan 2023

      Led analysis of the data pipeline to develop actionable recommendations lowering costs, manual effort, and turnaround time.Implemented automation tasks utilizing SQL, JavaScript, and internal software reducing hundreds of manual database uploads and validations.Created schemas, entity relationship diagrams, and built a relational database tables to improve internal operations.

  • Costco Wholesale
    • United States
    • Retail
    • 700 & Above Employee
    • Marketing Analyst
      • Jun 2022 - Sep 2022

      Performed aggregate analysis on nationwide customer transaction data using Alteryx, SQL, and Power BI to evaluate shopping cadence and distribution. Developed a customer lifecycle marketing model based on data driven metrics, allowing Costco to monitor the cadence and shopping behavior of its customers. Designed dashboards to present data-based findings at an executive level, including the assistant VP of Membership & Marketing. Performed aggregate analysis on nationwide customer transaction data using Alteryx, SQL, and Power BI to evaluate shopping cadence and distribution. Developed a customer lifecycle marketing model based on data driven metrics, allowing Costco to monitor the cadence and shopping behavior of its customers. Designed dashboards to present data-based findings at an executive level, including the assistant VP of Membership & Marketing.

  • Masterworks
    • United States
    • Advertising Services
    • 1 - 100 Employee
    • Marketing Data Specialist
      • Feb 2022 - Jun 2022

      Designed and developed an end-to-end software solution to solve a repetitive issue reducing average project charter turn around time by one business day. Prepared and organized data files for internal use, reporting and analysis using SQL & Google BigQuery. Manipulated data tables to segment audiences delivering customized marketing materials while tracking engagement and profitability. Designed and developed an end-to-end software solution to solve a repetitive issue reducing average project charter turn around time by one business day. Prepared and organized data files for internal use, reporting and analysis using SQL & Google BigQuery. Manipulated data tables to segment audiences delivering customized marketing materials while tracking engagement and profitability.

  • George Fox University
    • United States
    • Higher Education
    • 700 & Above Employee
    • Research and Data Assistant
      • Aug 2020 - Jan 2022

      Managed the database for George Fox of University constituents, allowing for seamless connection to donors and alumni. Handled gift entry and confidential information. Compiled and created a training curriculum to instruct Tableau basics to management and peers. Managed the database for George Fox of University constituents, allowing for seamless connection to donors and alumni. Handled gift entry and confidential information. Compiled and created a training curriculum to instruct Tableau basics to management and peers.

Education

  • George Fox University
    Bachelor of Business Administration - BBA, Business Administration and Management, General
    2019 - 2022

Community

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