Senior Campaign Data 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 Senior Campaign Data Analyst with experience in digital media and offline channels to partner with both internal and external stakeholders and data providers, leveraging analytics and measurement to enable optimization of media spending. The Senior Campaign Data Analyst takes on an expanded role and supports all aspects of data processing for subsequent analysis and performance reporting.

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:

  • Develop a deeper understanding of client’s industry, business objectives and strategy, media plans, and consumer journey to provide context for analysis and reporting needs
  • Help develop measurement plans tying KPI’s to business objectives at a tactical level
  • Build an understanding of digital and media ecosystems including challenges of data tracking with cookies/SDK’s, website tagging options, impact of walled gardens, and basic TV and OOH measurement and attribution options available
  • Collaborate with internal/external stakeholders and manage data logistics – including data specifications, structures, rules and transfers from numerous media channels and partners
  • Act as a project manager on analyses of limited scope/complexity, delegating select tasks such as data prep and QC to Analysts and reviewing their work / Serve as a mentor
  • Conduct more in-depth analyses and reporting leveraging at least two of the following tools - SQL, Excel and Tableau
  • Demonstrate a greater level of proficiency with SQL as evidenced by the ability to:
    • Execute advanced SQL queries such as Stored Procedures to process and automate data
    • Optimize query performance, improve processes, diagnosis problems
    • Implement best-practices on database schemas and ETL processes
  • Demonstrate a greater level of proficiency with Excel as evidenced by the ability to:
    • Create macros to clean data from different workbooks and automate repetitive tasks
    • Use IF, THEN, SUMPRODUCT, OFFSET, etc to create more advanced reports
    • Pull data from external data sources using Excel’s ODBC connectors
    • Create more advanced pivot tables using calculated fields
  • Demonstrate a greater level of proficiency with Tableau as evidenced by the ability to:
    • Perform data blending procedures directly in Tableau
    • Use calculated fields and parameters to create interactive visualizations
    • Build advanced visualizations. (e.g. graphs with multiple axes, mapping geographic data to perform segmentation analysis, etc)
  • Exhibit problem-solving capability and an ability to work more independently
  • Demonstrate a deeper ability to interpret/synthesize analysis findings and draw insights pertinent to the client’s business; show ability to develop actionable recommendations
  • Play an expanded role in the development of report content (Word, Excel, PowerPoint) in support of deliverables
  • Greater participation in the presentation of results to internal and external stakeholders
  • Handle some of the day-to-day contact and interaction with internal and external stakeholders associated with project work
  • Effectively manage time in order to meet deadlines with high-quality outputs on a larger workload; demonstrate greater ability to multitask
  • Take on broader responsibility and independence in project design and planning – including resource scoping and timelines and the identification of potential bottlenecks and risks

What we’re looking for:

 

  • Bachelor’s degree typically in a quantitative discipline (e.g., Statistics, Economics, Mathematics, Engineering)
  • Minimum of 2 years of experience in a professional services or corporate environment
  • Experience with ad-serving platforms such as Google Campaign Manager; web analytics tools such as Google Analytics and Adobe Analytics, and tag management tools such as DTM/Launch, GTM and Tealium
  • Excellent verbal and written communication skills
  • Highly motivated and collaborative team player with strong interpersonal skills
  • Greater familiarity with various online and offline media channels

Nice to haves:

 

  • Advanced degree typically in a quantitative discipline
  • Prior media analytics experience/knowledge
  • Greater ability to program in other languages such as SAS, SPSS, R and Python
  • Familiarity with media mix modeling and other forms of regression-based ROI; A/B and multivariate test design

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.