Marketing Data Analyst & Media Payables

 

The Marketing Data Analyst & Media Payables at BSE will be a very valuable, hybrid position responsible for Media Billing & Invoicing as well as Analysis & Data Reporting that help make better Marketing decisions.  If you love working with numbers, excel, google sheets and data this position is for you! Must be passionate about data and numbers with a high attention to details, and excited to work in a fast-paced, collaborative environment with a fantastic team.

On the analysis side this position you will work on things such as Revenue Analysis,  Zip Code/Demographic Analysis, various Media Campaign Analysis and addt’l reporting to assist the Media Department in making informed media buying & strategy decisions based on the data.

On the billing side of this position you will be trained to be the lead on all BSE Client Invoicing, Media & Vendor payables as well as Client Co-Op Submissions.

A LOVE of Numbers, Data and Finance is required.  The details of this position are defined below:

  • Media Analysis
    • The Marketing Data Analyst & Media Payableswill be responsible for various Revenue Analysis and Marketing Campaign Analysis for the agency.
      • Being able to organize revenue and other data in excel and google sheets is a must.
      • The understanding of taking data and organizing to tell a story is a must.
      • Use of graphs, pivot tables and formulas is a must.
      • The ability to present data in presentation format, Google slides (PowerPoint), is a must for this position as well.
    • The Marketing Data Analyst & Media Payableswill work to continue to develop and fine-tune our ‘Revenue by Zip’ Map presentations and various data sets.
    • As part of the Media Analysis, this position will need to use various software to pull the “right” data for the analysis presentations.
      • Must be a fast learner and comfortable knowing what data is needed and able to troubleshoot when pulling data from various systems.
      • This person should be a go-getter not afraid to figure things out if/when needed when it comes to data.
    • The ability to implement double checks when working with important data is also crucial to this position – vetting and ensuring reporting is accurate is a top priority.
    • Ability to work independently to define problems, collect data, establish facts and draw valid conclusions.
    • Must be able to demonstrate understanding of advanced math functions that will allow for analysis.

BSE Client Invoicing

    • This position will be responsible for the agency Client Invoicing on the 1st and 15th of each month.
      • You will review and prepare invoices from the agency project management software so they can be exported to Quickbooks and sent to clients.
      • Close attention to detail is required and experience in invoicing preferred.
      • Ensuring agency rates and time logged is correct for client projects so that invoicing is accurate for the benefit of our clients and the agency is important.
    • This position will also be responsible for running client payments on the 1st and 15th of the month in Quickbooks.
    • This position will also be responsible for Media Payables, Accounts Payable.
      • BSE pays Media vendors on the 15th of the month for the month prior schedule.
      • Resolving Media billing discrepancies when needed.
      • This position will work with the Media Director to explore further opportunities to digitize and connect the Media billing and Media reconciliation process from their buying software to BSE’s Quickbooks.
      • Must be able to work in various software and be comfortable with learning new software.
  • Co-Op Submissions
    • The Marketing Data Analyst & Media Payableswill be responsible for Co-Op submissions for several clients who will receive co-op funds for media schedules.
  • Media & Client Relations Support
      • The Marketing Data Analyst & Media Payableswill be asked to assist with overflow in certain areas such as below but not limited to:
        • Setting up new accounts or new media partner accounts – ie. Credit, Strata, wherever we need to enter
        • Proofing Assistance
        • Assist with Brand Presentations and other department Excel Documents
        • Media Traffic Assistance

Required Qualifications:

  • Minimum 2+ years of working experience in a field where you analyzed data and/or handled financial data.
  • Minimum 2+ years of experience in billing or financial experience equivalent to this.
  • Minimum 2+ years analyzing data experience in excel and/or google sheets; Formulas, Pivot Tables, Charts, Graphs, and so on will need to be used so this position must know which formats are best based on the project and client goals. Must be able to showcase data and tell a story with the numbers.
  • Bachelor’s degree, preferably with a concentration in advertising, marketing, communications, finance or related field. If not a Bachelor’s degree, working experience equivalent to a degree.
  • Basic knowledge of standard office tools such as Microsoft Word, Excel, Powerpoint or Google Sheets, Google Docs and Google Slides.

Additional Preferred Qualifications:

  • Solid written and verbal communications skills.
  • A “self-starter” with strong organizational and analytical skills.
  • Data Simulation and Data Valuation skills.
  • Natural curiosity to learn and grow.
  • Multi-tasker with good prioritizing skills.
  • Strong attention to detail.
  • Passion for learning new software, new methods and all things numbers.
  • Ability to meet deadlines with accuracy and minimum supervision.

 

    Name
    Email
    Phone
    Position Applying For
    Upload Your Resume as a PDF