Marketing Data Analytics Specialist

Prosci

5d•$75,000 - $90,000•Remote

About The Position

Prosci is seeking a Marketing Data Analytics Specialist to join our Global Marketing Center of Acceleration (CoA). This role is critical in turning complex marketing data into clear, actionable insights that drive executive decision-making and empower regional teams worldwide. You will build and maintain reporting across Power BI, HubSpot, Salesforce, and channel specific platforms. Prosci is looking for someone who can help us create compelling and impactful data stories today while looking to improve data integrity and attribution in the future. This is a hands-on, technical analytics role — ideal for someone who thrives on building BI solutions, reconciling cross-system data, and helping leadership see the “what, so what, now what.” Since our founding in 1994, Prosci has been laser-focused on change. By combining our deep understanding of people with a proven methodology rooted in the creation of the ADKAR® model, we’ve helped countless people and organizations thrive. Our solutions empower customers with lasting change resiliency through a unique blend of training, advisory services, and licensing options, including Kaiya, our AI change management coach. At Prosci, we are a purpose-driven organization full of passionate, curious, and results-oriented people. Working at Prosci means being part of a dynamic team that is dedicated to our purpose of creating a world where change is done right. Join us and be part of a culture that thrives on continuous learning, growth, and making a difference. Check out our website for more about our team and approach: https://www.prosci.com/about.

Requirements

Power BI – dashboard building, DAX, and data models.
SQL – querying/joining data from multiple systems.
Salesforce reporting & campaign hierarchy – ability to work within the structure, understand constraints, and adapt reporting approaches.
HubSpot reporting & dashboards – segmentation, campaigns, data hub, lead scoring, attribution views.
APIs and data connectors – Funnel.io (current), HubSpot API, Mulesoft (future).
Google Tag Manager (GTM) – event and conversion tracking.
Campaign tracking best practices – UTMs, tagging frameworks, QA.
Microsoft Excel / 365 – strong skills in analysis, pivot tables, formulas, and data validation for ad hoc reporting.
Microsoft PowerPoint / 365 – ability to translate data into compelling executive-level presentations and visual narratives.
Channel & performance marketing reporting – SEMrush, Google Ads, LinkedIn Ads.
Experience reconciling multi-system data (HubSpot, Salesforce, GA4) to deliver accurate reporting in complex environments.
Bachelor’s degree in Marketing, Business, Data Science, or related field (or equivalent experience).
3–5+ years of direct marketing analytics / BI experience
Proven track record building executive-level reporting in Power BI.
Strong SQL skills and BI development experience.
Demonstrated success building reporting in complex, cross-system environments.

Responsibilities

Deliver monthly and quarterly Power BI dashboards for Leadership, Board, and Regional team. Ensure reporting consistency across global regions, currencies, and phased technology rollouts.
Analyze and report on campaign, channel, and funnel performance (enterprise vs. practitioner).
Identify gaps or inconsistencies in attribution data and recommend practical reporting solutions for both today and the future.
Partner with campaign managers and Marketing Ops to define tracking requirements for campaigns, events, and new assets. Ensure proper tagging and parameters are in place to capture performance data.
Monitor data integrity between HubSpot and Salesforce; flag sync or attribution issues.
Partner with Marketing Ops, ICT, and Sales Ops to align reporting with data governance standards.
Build, maintain, and iterate Power BI dashboards; write SQL queries to join data sources.
Manage interim connectors (Funnel.io, HubSpot API) and support the transition to Mulesoft in partnership with ICT as the long-term enterprise connector.
Ensure smooth data pipelines across marketing, CRM, and eCommerce systems (HubSpot, Salesforce, Magento, GA4).
Maintain and validate event/conversion tracking in GA4 and HubSpot, using Google Tag Manager and campaign UTM frameworks.
Use SEMrush, Google Ads, and LinkedIn Ads to measure SEO rankings, campaign performance, social engagement, and channel ROI.
Provide funnel visualizations and actionable recommendations to optimize spend and improve conversion.
Train regional marketers on dashboard use and interpretation.
Collaborate with Growth Marketing, Sales Ops, and ICT to ensure analytics insights are aligned with business needs.
Translate data into compelling narratives for executives and practitioners.