Business Analytics Consultant Senior - Marketing & Customer Analytics

PNC•Tysons, VA

3d•Onsite

About The Position

At PNC, our people are our greatest differentiator and competitive advantage in the markets we serve. We are all united in delivering the best experience for our customers. We work together each day to foster an inclusive workplace culture where all of our employees feel respected, valued and have an opportunity to contribute to the company’s success. As a Business Analytics Consultant Senior within PNC's Data, Model & Analytics Marketing & Customer Analytics organization, you will be based in Pittsburgh, PA or Tysons Corner, VA. We are seeking a highly skilled Business Analytics Consultant Senior to join our Customer and Marketing Analytics team. This role will play a critical part in measuring, analyzing, and optimizing marketing performance across key channels, with a particular focus on direct mail, email, and digital marketing campaigns. The ideal candidate brings a strong blend of statistical and technical expertise, advanced data visualization skills, and marketing domain knowledge, along with a passion for modern analytics tools, automation, and AI-assisted development. This individual is expected not only to execute high-quality analytics but also to influence how we evolve our dashboards, reporting, and analytical approaches.

Requirements

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.
Strong data storytelling and presentation skills for senior or executive audiences.
Analytical Thinking
Business Intelligence (BI)
Concept Development
Data-Driven Decision Making
Data Integration
Market Research
Performance Metrics
Qualitative Research
Strategic Planning
Business Acumen
Business Analytics
Consulting
Decision Making and Critical Thinking
Effective Communications
Emerging Technologies
Roles at this level typically require a university / college degree, with 3+ years of relevant / direct industry experience.
In lieu of a degree, a comparable combination of education, job specific certification(s), and experience (including military service) may be considered.

Nice To Haves

Bachelor’s degree in Analytics, Statistics, Economics, Computer Science, Marketing Analytics, or a related field (or equivalent experience)
Hands on marketing campaign measurement experience
Exposure to or strong interest in AI-assisted analytics and development tools (e.g. Github Copilot, Microsoft Copilot).

Responsibilities

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.
Bring fresh ideas and best practices to data visualization, storytelling, and user experience.
Balance summary-level executive views with the ability to drill into detailed performance and diagnostic metrics.
Use and contribute to shared analytics codebases, following best practices with Github or Bitbucket for version control.
Follow structured development workflows, including pull requests, code reviews, and documentation.
Manage work using project management tools such as Jira or Microsoft project management tools, ensuring timely and well communicated delivery.
Leverages complex analytical tools to provide business and technical expertise for the analytics process, tools and useful applications across multiple functions or business units to create data driven solutions.
Consulting to clients on tool and strategy implementation and monitoring, statistical scoring, business intelligence, data quality, and analytical product / solution development.
Determining the optimal analytic approach and supporting development, implementation and enhancements.
Conceptualizing, developing and continuously optimizing analytical solutions for business leadership to enable data driven decision making.
Analyze results and make recommendations for key business partners and senior management or communicate conclusions from complex analytical solutions to a wide range of audiences.