drive hands-on analytics work across digital marketing campaigns (paid search, SEO, social, email, programmatic, etc.) to identify trends, optimize performance, and maximize ROI
write advanced SQL queries to extract, transform, and analyze data from enterprise data platforms including Hadoop, Teradata, and cloud-based systems
build, maintain, and enhance interactive dashboards and visualizations using tools like Tableau, Power BI, or Adobe Analytics to communicate insights effectively to stakeholders
develop and refine analytical models including attribution models, customer segmentation, and customer journey analytics to drive personalized experiences across channels
collaborate closely with marketing strategists, product teams, and finance stakeholders to define KPIs, translate business questions into analytical frameworks, and deliver actionable insights
design and analyze A/B tests, geo lift studies, and other experimentation strategies, providing analytical rigor to optimize campaign performance and inform strategic decisions
provide strategic guidance and subject matter expertise on digital marketing analytics best practices, emerging techniques, and optimization opportunities
mentor junior analysts informally, sharing technical knowledge and analytical approaches to build team capabilities
Requirements
proven track record of success as a digital marketing analytics professional, with significant hands-on experience as a senior analyst or lead individual contributor
deep technical proficiency in SQL with demonstrated ability to write complex queries, optimize performance, and work with large-scale enterprise data platforms (Hadoop, Teradata, Spark, Impala, or similar)
strong expertise in data visualization and dashboarding tools such as Tableau or Power BI
understanding of various digital marketing channels and familiarity with some of the digital marketing platforms (e.g. SA360, CM360, DV360, Adobe Analytics, Google Analytics, Google Ads, etc.) and the data they generate
strategic thinker with the ability to translate complex business questions into analytical frameworks and deliver clear, actionable recommendations
strong story-telling skills with the ability to present complex data findings to both technical and non-technical audiences
self-motivated and able to work independently while collaborating effectively across multiple business functions
intellectual curiosity, a continuous learning mindset, and enthusiasm for mentoring others and sharing knowledge across the team
Tech Stack
Cloud
Hadoop
Spark
SQL
Tableau
Benefits
medical/prescription drug coverage (with a Health Savings Account feature)
dental and vision options
employee and spouse/child life insurance
short and long-term disability protection
401(k) with PNC match
pension and stock purchase plans
dependent care reimbursement account
back-up child/elder care
adoption, surrogacy, and doula reimbursement
educational assistance, including select programs fully paid
a robust wellness program with financial incentives
maternity and/or parental leave
up to 11 paid holidays each year
9 occasional absence days each year
between 15 to 25 vacation days each year, depending on career level; and years of service