Digital Marketing Campaign Analyst

We are PMGNamed Ad Age Best Places to Work for 9 years in a row and Fast Company Best Workplaces for Innovators since 2022, PMG is a global independent marketing services and technology company that seeks to inspire people and brands that anything is possible. Driven by shared success, PMG utilizes business strategy and transformation, creative, media, and insights-as well as its proprietary marketing intelligence platform, Alli-to deliver cutting-edge digital solutions and innovative media strategies. Our team comprises over 900 employees globally, and our work for ambitious brands like Apple, Best Western Hotels & Resorts, CKE Restaurants, Experian, Intuit, Kohler, Nike, Sephora, Therabody, and Whole Foods spans 85+ countries.

As a Digital Marketing Campaign Analyst at PMG, you'll leverage cutting-edge BI tools, like Tableau and Looker Studio, to deliver insights that drive business transformation for some of the world's most iconic brands. Join us and be part of an award-winning culture that values inclusivity, continuous improvement, and innovative thinking. Apply now and make your mark with PMG!

Responsibilities:

• Independently translate client requests into dashboards and reports in common BI tools, such as: Tableau, Looker Studio or Power BI (we most commonly use Tableau and Looker at PMG)
• Consistently implement data management best practices and understands why to follow them (Proficient in data cleansing techniques, such as removing duplicates, standardizing formats and handling missing data) - Familiarity with data warehousing concepts and ETL processes
• Play an active role in planning and executing projects: define project scope, set realistic timelines, create project plans, manage the project. Identify risk and steps for mitigation; understand the importance of documenting projects, transformations and data models
• Collaborate with client strategy to provide comprehensive reporting, tracking, and forecasting, contributing valuable insights for assessing program performance across channels and shaping future strategies.
• Drive digital growth through a thorough analysis of the competitive landscape, fine-tuning existing channel performance, and uncovering opportunities for operational efficiency enhancements.
• Develop, implement, and oversee vital channel forecasting.
• Effectively communicate with customers and internal stakeholders; understand customer problems and provide tailored solutions to ensure customer satisfaction
• Actively listen to customer feedback and collaborate with internal teams to address customer needs, as they arise
• Collaborate with other analysts cross-functionally
• Support onboarding, training and mentoring of junior analysts
• Effectively communicate with customers and internal stakeholders; understand customer problems and provide tailored solutions in order to ensure customer satisfaction
• Actively listen to customer feedback and collaborate with internal teams to address customer needs, as they arise
• Independently work with internal media leaders internally at PMG in order to conduct analysis; collect and visualize datasets when necessary to support media questions

Required Skills & Experience

• 2+ years of experience automating reports in Excel/Google Sheets
• 2+ years of experience working within data warehouse tools such as RedShift and BigQuery (both will be used in this role at PMG), and the ability to work interchangeably within the two
• 2+ years of experience as a Marketing Data Analyst in either a marketing agency or in house retail environment
• 2+ years of experience in pulling data from tools such as Tableau or Looker Studio for reporting purposes
• Ability to use SQL to clean and transform complex datasets, with limited supervision
• Ability to interchangeably use two or more database syntaxes (variations of SQL language) throughout the day
• Strong communication skills to articulate complex analytical findings in a clear and concise manner.
• Basic understanding of Media Mix Modeling and why to leverage it in paid media/marketing environments

What We Offer

• Professional Development: Take advantage of our learning and development programs, mentorship opportunities, and career advancement support.
• Generous PTO: Benefit from our generous paid time off policy to recharge and spend time with loved ones.
• Parental Leave: We provide paid parental leave to support your family during important life events.
• Retirement Plans: Plan for your future with our competitive 401(k) matching program.
• Fertility and Family Support: Access fertility benefits for all team members and their spouses.
• Pet Insurance: Protect your pet's health and your finances.
• Lifestyle Spending Accounts: Enjoy 100% company-funded accounts to promote healthy habits and well-being.
• Annual Bonus: All employees are eligible for an annual bonus.
• Volunteering Opportunities: Receive 8 give-back hours to volunteer in your local communities.
• AI Enterprise License: Access AI Enterprise accounts and participate in weekly AI training sessions to empower and ensure AI safety.

What Sets Us Apart

Being part of PMG means joining a company culture that's unmatched in digital. We're dedicated to working hard to serve our employees and clients, delivering value, results, and innovation-which often requires true grit and agility. We believe in taking care of ourselves and each other to continuously improve in every way.

In alignment with our core values to be inclusive and always change for the better, PMG is committed to creating a more diverse and inclusive culture, and we are proud to be an equal opportunity employer. We believe that we only change for the better by bringing diverse perspectives to our company. PMG recruits, employs, trains, compensates, and promotes regardless of race, color, religion, gender, gender identity or expression, sexual orientation, national origin, genetics, disability, age, or veteran status.