Data Analyst

Summary

Good Apple is an independent agency focused on driving efficiency and simplifying processes for clients. As a Data Analyst, you will partner with clients and internal teams to solve complex problems through data analysis and metrics, ensuring effective media planning and optimization.

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
• Provide ad-hoc data science-driven regression analyses that discover the connections not discernible from a dashboard or spreadsheet
• 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 processes (technical or business) improvements for reporting and analysis
• Diligently see solutions through to the end and be meticulous on QA

Skills

• 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)
• Meticulous attention to detail
• Background in a logic-based field or experience in a logic-focused role is ideal
• Familiarity with tag managers, tagging implementation, website architecture, and CMS platforms is a plus
• Experience with Amazon Web Services is a plus
• Programming experience, Python in particular, is a plus

Qualifications

Must Haves

• 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)
• Meticulous attention to detail
• Background in a logic-based field or experience in a logic-focused role is ideal

Nice to Haves

• Familiarity with tag managers, tagging implementation, website architecture, and CMS platforms is a plus
• Experience with Amazon Web Services is a plus
• Programming experience, Python in particular, is a plus