COMPANY: Hawthorne Advertising
OPENINGS AVAILABLE: 1 opening available
LOCATION: Remote
HOW TO APPLY: Submit your resume and complete our Data Science Skills Assessment
The Hawthorne Junior Analyst, Digital Media supports the larger Digital and Account teams in developing and executing reports and analyses to drive client success and impact. They are responsible for ensuring data and reporting integrity throughout the implementation, execution, and analysis phases of a client engagement. In addition to this responsibility, the junior analyst will provide strategic insights based on the reports to the internal agency team and clients as appropriate.
This role will allow you to be a significant contributor as part of the team, making recommendations when applicable.
While it is not mandatory, applicants who fill out our Data Science Skills Assessment will have a better chance of being selected.
More details will follow if your resume is chosen for an interview.
Responsibilities:
Operate as a member of the Digital Media or Account team, performing scheduled and ad hoc analyses as business requirements dictate
Complete actionable reporting and analyses for the Digital Media or Account teams using a variety of reporting tools, including media platforms, 1st party response data, etc.
Gather data requirements from the media team to be implemented on existing data sources
Build reports and dashboards leveraging Excel and other appropriate tools that provide insights into ad campaign performance to help teams make faster and better decisions
QC client dashboards to ensure data integrity and proper rendering of results
Interpret charts and graphs to identify trends in data and provide insights to the media team
Clearly outline the insights of regular and ad hoc reporting for internal teams and external client partners in a presentable format
Work with Media team members to achieve client objectives
Assist with implementation and maintenance of new and existing digital media campaigns
Create brand- and category-specific competitive analyses for digital media
Develop reporting templates and additional analytic or research-based projects
Ensure all deadlines are met
Complete other duties and projects, as assigned, based on company needs
Role Accountabilities:
Data integrity verification, including media platform and 1st party data
Coordination with Data Science on data, KPI, and initial Tableau setups
Scheduled and ad hoc reporting/analyses for client presentations
Additional research projects as assigned
Qualifications:
Bachelor's degree with 1+ years relevant work experience or minimum of two years post-high school education with 2+ years related office experience
Excellent Excel (pivot tables) and reporting skills. Data visualization tool experience is a bonus (Tableau, Power Bi, Data Studio, etc.)
Strong analytical skills (ability to identify risks and escalate issues)
Digital analytics experience (site analytics, media projections, results, etc.)
Experience with digital marketing KPIs (CPC, CTR, CPM, etc.).
Knowledge of social, search, and programmatic ads.
Highly organized, detail-focused, with the ability to prioritize
What is Hawthorne Advertising?
Hawthorne Advertising is a full-service agency with 30+ years of proven success in launching and growing brands. Their creative production, strategic media buying and detailed attribution, and analytics solutions work in concert to deliver responsive brand campaigns with provable ROI.