Campaign Analyst (Remote/Virtual)

Analytics Boston, MA NY Charlotte, NC Philadelphia, Pennsylvania


Description

WorkReduce, the largest technology-enabled services provider for the media buying industry, is looking for a Campaign Analyst with experience in digital media and offline channels to assist in gathering and preparing data and conducting analyses using various tools in support of the delivery of analytic solutions.

About WorkReduce

We serve brands and agencies as a distributed team of media and technology experts operating through the WorkReduce platform. We are committed to providing employment that pays well, expands access to jobs and training, and makes a difference. We hire people who share our values of transparency, inclusivity, dedication, and fairness. We are committed to providing employment that pays well, expands access to jobs and training, and makes a difference.

What you’ll do:

  • Collaborate with internal/external stakeholders and manage data logistics – including data specifications, structures, rules and transfers from numerous media channels and partners.
  • Access collected data and thoroughly QC and prepare the data for subsequent analysis
  • Exhibit an ability to interpret/synthesize analysis findings and draw insights pertinent to the client’s business
  • Prepare basic report content (Word, Excel, PowerPoint) in support of deliverables
  • Limited participation in the presentation of results to internal and external stakeholders
  • Answer questions about data sets and analyses and maintain project documentation
  • Document and articulate steps taken in an analysis to project managers
  • Effectively manage time in order to meet deadlines with high-quality outputs on a limited number (1-4) of concurrent projects / demonstrate ability to multitask
  • Proactively communicate with supervisor regarding workload and the status of assignments
  • In addition to the execution of projects, begin to participate in project design and planning



 

What we’re looking for:

  • Ability to conduct various analyses and reporting leveraging at least two of the following tools - SQL, Excel and Tableau
  • Demonstrate a base level of proficiency with SQL as evidenced by the ability to:
    • De-duplicate data in database tables using queries
    • Leverage database functions to calculate metrics
    • Join tables
  • Demonstrate a base level of proficiency with Excel as evidenced by the ability to:
    • Use functions such as VLOOKUP, XLOOKUP to correct data
    • Use SUMIFS, SUMPRODUCT, etc. to create reports
    • Create pivot tables to summarize data
  • Demonstrate a base level of proficiency with Tableau as evidenced by the ability to:
    • Create basic calculated fields and basic visualizations such as tables and bar charts
    • Create dashboards that convey basic information and publish to a Tableau Server
  • Bachelor’s degree typically in a quantitative discipline (e.g., Statistics, Economics, Mathematics, etc.)
  • Up to 2 years of experience (including internships) in a professional services or corporate environment
  • Demonstrated base level of proficiency with at least two of the following tools - SQL, Excel, Tableau
  • Working knowledge of MS Office; including PowerPoint, Word and Excel
  • Acute attention to detail (QA/QC)
  • Strong analytic thought process
  • Good verbal and written communication skills
  • Motivated and collaborative team player with strong interpersonal skills
  • Familiarity with various online and offline media channels

Nice to haves:

 

  • Advanced degree typically in a quantitative discipline
  • Prior media analytics experience/knowledge
  • Ability to program in other languages such as SAS, SPSS, R and Python

What you can expect from WorkReduce:

WorkReduce provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.

WorkReduce does not accept unsolicited resumes from third-party recruiters without a signed agreement on file with WorkReduce. Third-party recruiters include agencies, organizations, or individuals recruiting candidates for temporary, part-time or full-time opportunities other than for their own needs.  

WorkReduce will not pay a fee to a third-party recruiter for any resumes or CV’s submitted to any employee that does not have a signed agreement with WorkReduce. The agreement must be dated no earlier than one year previous to the date of resume submission. Candidate introductions, resumes or CV’s must only be submitted via the WorkReduce recruiting team and only if a) an agreement is already in place and b) the third-party recruiter has received formal instruction from a member of the recruiting team to submit candidates to a vacancy.