Digital Marketing Analyst
PMG is a digital company that helps marketers connect people with their brand. Focused on people and grounded in data, our award-winning culture fosters meaningful careers. Partnering with the most iconic brands in the world, we put people at the center of everything we do to deliver value, innovation, and business transformation.
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
- 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
- Basic understanding of Media Mix Modeling and why to leverage it in paid media/marketing environments
About PMG:
PMG is a global independent digital company that seeks to inspire people and brands that anything is possible. Driven by shared success, PMG uses business strategy and transformation, creative, media, and insights, as well as its proprietary marketing intelligence platform Alli, to deliver Digital Made for Humans™. Our team is made up of over 500 employees globally, and our work for brands like Apple, Best Western Hotels & Resorts, CKE Restaurants, Experian, Intuit, Kohler, Nike, Sephora, Therabody, and Whole Foods runs across 85+ countries and has received top industry recognition from Cannes Lions to Adweek Media Plan of the Year.
Named to Ad Age’s 2023 A-List, MediaPost’s 2023 Independent Agency of the Year, and Adweek’s 2021 Breakthrough Media Agency of the Year, PMG has grown through commitments to continuous improvement, business integrity, and cultivating dynamic relationships. We are proud to be named among Fast Company’s Best Workplaces for Innovators, Fortune’s Best Workplaces for Women, Fortune's Best Workplaces in Advertising & Marketing (ranked #1), and to be the only company named to Ad Age’s Best Places to Work nine years in a row.
Being part of PMG means being part of a company culture that’s unmatched in digital. We’re willing to work hard to serve our clients and deliver value, results, and innovation -- which often requires true grit and remaining agile. We believe in taking care of ourselves and each other so that we continuously improve in every way.
We’d love to get to know you and share more about why we love PMG and the work we do.
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 we only change for the better by bringing different people 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. Learn more about our commitment to Diversity and Inclusion and our action plan for change here.