Performance Marketing Analyst

About hireworks

hireworks is building a community of top talent in key international markets by unlocking unparalleled access to positions at leading U.S. based companies. As your employer, hireworks will ensure you have a seamless interview, onboarding, and employee experience - providing ongoing support and resources along the way. Established in 2023, hireworks is forging corp-to-corp relationships with leading U.S. based organizations looking to grow their teams with best-in-class talent around the world. Working with hireworks means unlocking access to a network of local peers and mentors and career opportunities through our client network.

About Pickaxe Foundry

From strategy to execution, Pickaxe helps clients solve their most difficult challenges, delivering best-in-class data warehouses, analytics, and automation, launching amazing new products, and radically improving martech stacks to optimize every dollar spent. We work with some of the most best known brands, and they chose us because we bring a deep understanding of both business and technology. Our team helps bring focus and clarity to problems and opportunities, and we know that it's never one-size-fits-all. Pickaxe is also the creator of the Pickaxe Insights Platform - the leading codeless data platform powered by AI. Automated analysis, insights, anomaly detection, and predictions, all in one easy-to-use platform that will speed up every aspect of your business. From enriching data in your data warehouse to generating beautiful dashboards, Pickaxe's Insights Platform will help you leave spreadsheets and complicated markup languages behind forever.

About the Position

We are hiring a Marketing Analyst to support a critical client engagement that involves analyzing and combining data from dozens of marketing channels with the clients success data. We are looking for a paid media expert - someone who has worked at an agency and is familiar with how campaigns get trafficked across various platforms and how the ad performance is reported back to clients. And how clients and agencies use that data to optimize campaigns. Additionally, in this role youll be part of the team training AI agents to help analyze paid media campaigns and performance. We have a roadmap of agents in this area, and youll be one of the subject matter experts helping develop them.

What Youll Do

• Support the build out of data flows that track aggregate paid media performance across various platforms and partners

• Help client marketers analyze that data and evaluate performance - ideally spotting high level insights and doing quick analysis

• Help identify issues in the marketing taxonomy and propose solutions for easier understanding

• Identify and flag data quality issues (missing spend, or delivery data)

• Work with an AI chatbot analyst and help evaluate its understanding of media data help make sure it is able to understand low performance and high performance across channels)

About You

• 4+ years of direct paid media experience with a proven track record managing paid social campaigns across channels such as Meta, TikTok, Reddit, Snapchat, or Programmatic and Search.

• Demonstrated ability to analyze campaigns, audiences, creatives, and budgets to report on CPA or ROAS targets

• Comfortable presenting your analysis to team mates and external clients

• Strong analytical skills with the ability to diagnose performance fluctuations. Bonus if you can and analyze for root causes using available data and third-party tools

• Experience reading (or creating) schemas for tagging and naming taxonomies. Youve either created or reported on Campaigns that you broke out by underscores or pipes. And you can explain what the naming convention means.

• You've worked in a data warehouse like Snowflake, BigQuery, MS Azure and are familiar with PowerBI, Looker, or other similar type tools.

• Bonus points if youve worked with Funnel.io or Adverity or similar aggregators.

• You have some experience working with developers, and have participated in a sprint process at some point.

• You enjoy technology and playing around with it. Youve hacked together something and shared it with others.

Benefits:

hireworks is cultivating a growing community of top talent across Colombia. In addition to unlocking access to positions at top tier U.S. based companies, we offer a variety of benefits to enhance your experience:

• Competitive Pay - compensation that reflects your experience and accomplishments

• Remote Flexibility - work from anywhere in Colombia

• Paid Time Off - ample vacation days to rest and recharge

• Public Holidays - all Colombian federal holidays are fully paid days off