Data Analyst

Good Apple is an independent agency driving an average +30% efficiency while making lives 100% easier. Built on the belief that big agency bureaucracy isn't necessary to drive scalable results, Good Apple operates as that group of friends you love to collaborate with whether you are an employee, agency, publisher, or client partner.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.Key Responsibilities:Collaborate with internal teams to translate business needs into measurement plans and their implementations via website/ad-server tracking setups and data flowsDemocratize data and insights through data integration and the use of visualization toolsWork with media teams to create marketing plans and ensure measurement requirements are built into the media structureTurn business requirements into metrics and implement tracking solutions to measure those metricsLearn 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 optimizationBuild dashboards and supporting SQL database setups for weekly, monthly, and quarterly reports and analyses for clientsProvide ad-hoc data science-driven regression analyses that discover the connections not discernible from a dashboard or spreadsheetCreate clean, effective, and actionable presentations for clients and internal teamsExcellent analytical skills and the ability to plainly communicate results to clients and internal teamsLead and contribute to processes (technical or business) improvements for reporting and analysisDiligently see solutions through to the end and be meticulous on QADesired Skills/Qualifications:Bachelor's Degree with 3.0 or higher GPA or equivalent work experience0-2 years of marketing or analytics experienceCreative problem-solving skills and clear communication of results to a non-technical audienceExcellent communication skills to both internal teams and clients – presenting to clients is an expectationFast learner, comfortable using advanced SQL, experience working with data pipelines, understanding data architectureExperience 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, website architecture, and CMS platforms is a plusMeticulous attention to detailBackground in a logic-based field or experience in a logic-focused role is idealExperience with Amazon Web Services is a plusProgramming experience, Python in particular, is a plusPowered by JazzHR