Design and execute robust measurement strategies for marketing campaigns, with emphasis on direct mail, email, and digital marketing.
Analyze campaign performance using metrics such as response rates, average cost, cost per conversion, and return on marketing investment (ROMI).
Partner with marketing and business stakeholders to translate business questions into analytical solutions and actionable insights.
Develop and maintain analytical solutions using Python and SQL to support campaign analytics.
Work with large-scale datasets in Hadoop and big data environments, ensuring efficient and scalable data processing.
Leverage modern development practices, including AI-assisted tools such as GitHub Copilot and Microsoft Copilot, to improve productivity and code quality.
Build and own advanced dashboards in Tableau and/or Power BI that clearly communicate performance, trends, and insights to executive and business audiences.
Use and contribute to shared analytics codebases, following best practices with Github or Bitbucket for version control.
Manage work using project management tools such as Jira or Microsoft project management tools, ensuring timely and well communicated delivery.

Bachelor’s degree in Analytics, Statistics, Economics, Computer Science, Marketing Analytics, or a related field (or equivalent experience)
Hands on marketing campaign measurement experience
Proficient in Python and SQL for data analysis and transformation
Experience working with Hadoop and large-scale / big data environments
Advanced dashboarding skills in Tableau and/or Power BI, with demonstrated ability to design impactful, executive-ready visualizations.
Solid understanding of marketing performance metrics, including average cost, response rates, cost per conversion, ROMI, and ROAS.
Experience using code management tools such as Github or Bitbucket.
Exposure to or strong interest in AI-assisted analytics and development tools (e.g. Github Copilot, Microsoft Copilot).
Strong data storytelling and presentation skills for senior or executive audiences.

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, unless otherwise required by law
between 15 to 25 vacation days each year, depending on career level; and years of service

Senior Business Analytics Consultant – Marketing & Customer Analytics

Key skills