Data Analyst

GoodApple•New York, NY

11d

About The Position

Good Apple is a highly specialized media and measurement agency. We develop impactful, people-first paid media strategies for brands that care to make a difference in the pharma and retail space. Good Apple prides itself on the core values of Unstoppable Momentum, Pathfinding, Always Growing, Heart First, and Intense Inner Drive. We are re-opening a permanent office in New York City, and we’re looking for a talented data analyst who will join our team. As an Apple, you have a unique opportunity to truly create the destiny and pathway that fuels you each day and drives you to deliver the best results for yourself as well as your clients. As a Data Analyst, you will act as a strategic partner to your clients and media team, solving complex problems through metrics and analysis. Our Data Analysts have a curious, logical mindset with an interest in advertising and digital marketing analytics, working internally across disciplines to deliver the most impactful integrated media solution for our clients.

Requirements

Bachelor's Degree with 3.0 or higher GPA or equivalent work experience
0-2 years of marketing or analytics experience
Creative problem-solving skills and clear communication of results to a non-technical audience
Excellent communication skills to both internal teams and clients – presenting to clients is an expectation
Fast learner, comfortable using advanced SQL, experience working with data pipelines, understanding data architecture
Experience working with 3rd party media tools such as Google Campaign Manager, data visualization tools (Looker, Tableau), Cloud DBs (Snowflake, Redshift), Pipeline tools (Rivery, Fivetran), and AI platforms (Data Robot, Dataiku)
Familiarity with tag managers, tagging implementation, and website architecture
Meticulous attention to detail
Background in a logic-based field or experience in a logic-focused role is ideal

Nice To Haves

Experience with Amazon Web Services a plus
Programming experience and other technical website knowledge is a plus

Responsibilities

Collaborate with internal teams to translate business needs into measurement plans and their implementations via website/ad-server tracking setups and data flows
Democratize data and insights through data integration and the use of visualization tools
Work with media teams to create marketing plans and ensure measurement requirements are built into the media structure
Turn business requirements into metrics and implement tracking solutions to measure those metrics
Learn what makes an effective media plan so you can be the voice of the data for the media teams and clients to guide media planning and optimization
Build dashboards and supporting SQL database setups for weekly, monthly and quarterly reports and analyses for clients
Create clean, effective, and actionable presentations for clients and internal teams
Excellent analytical skills and the ability to plainly communicate results to clients and internal teams
Lead and contribute to improvements in processes (technical or business) for reporting and analysis
Diligently see solutions through to the end and be meticulous on QA