CRM Data Analyst

Pearl River, NY (Hybrid)

$70K/yr – $80K/yrFull time

Posted 2 weeks ago

Make your application stand out

AI finds you the best job matches, helps you create custom resumes, and drafts outreach messages for people inside the company.

Try Career Agent

Overview Note: This position is Hybrid to Pearl River, New York. We are seeking a CRM Data Analyst to transform CRM and related business data into clear, actionable insights for sales and revenue teams. In this role, you will design dashboards and reporting that support accurate forecasting, pipeline visibility, and performance tracking, while partnering with leaders to define meaningful KPIs and measurement frameworks. This opportunity is ideal for an early-career data analyst (2+ years experience) who is eager to deepen their analytical skills and take on increasingly meaningful work. You’ll go beyond building reports - you’ll help shape how teams interpret and use data to make better decisions, delivering practical, trusted insights that create measurable business impact. This role sits within the Global CRM Solutions team and reports to the SVP, Global CRM & Business Solutions. As part of this collaborative team, you’ll gain hands ‑ on exposure and mentorship from experienced Business Intelligence professionals, while building practical experience with tools such as Power BI and SQL. Responsibilities Build and maintain dashboards and reports using CRM and related business data Develop SQL queries and structured datasets to support recurring and ad hoc reporting Translate business requirements into clear visualizations and actionable analysis Identify data inconsistencies and recommend improvements to strengthen reporting accuracy Help reduce reliance on manual Excel-based reporting processes Document KPI definitions and reporting logic Support ad hoc analysis for leadership and operational teams Qualifications Required 2+ years of experience in data analysis, business intelligence, analytics, or a related role Hands-on experience with BI tools (Power BI, Tableau, or similar) Working knowledge of SQL (comfortable writing joins, aggregations, and basic transformations), with a desire to deepen technical proficiency Strong analytical mindset with the ability to structure ambiguous problems High attention to detail and a commitment to data accuracy Ability to communicate insights clearly to non-technical audiences Preferred Experience working with CRM, sales, or operational data (Salesforce Sales Cloud exposure is a plus) Ability to interpret data, identify trends, and explain insights in clear, practical terms Comfort asking thoughtful questions and validating assumptions before building solutions Experience modernizing Excel-based reporting processes Demonstrated curiosity and initiative in learning new tools or analytical techniques Comfort working in evolving, cross-functional environments Unfortunately, we are unable to sponsor or take over sponsorship of an employment Visa at this time. The salary range for this role is $70,000 - $80,000. The successful candidate’s salary will depend on the actual ranges of current employees in the subject position, market considerations, budgetary considerations, geography, as well as the candidate’s skill set, level of experience, and qualifications. AMS offers an extremely competitive benefits package inclusive of medical coverage, dental, vision, disability, 401k, paid time off, community engagement opportunities, great colleagues, and great learning opportunities.

Active International logo

Active International

AdvertisingServices

Marketing team

189

Employees

713

Headquarters

Pearl River, New York, USA

Founded

1984
Active International, the corporate trade leader for nearly four decades, enables companies to maximize the value they receive for assets, increase their return on ad spend, and generate funding for unbudgeted expenses. Independent, with an unrivaled vantage point of the media industry, we help large and small brands and agencies achieve a higher ROI; leveraging incremental value in the same quality properties and services they already purchase.

Every Marketing Job, in One Place

We scan 170K+ company career pages and every major job board so you never miss an opportunity.

Search Jobs

Your next marketing role is waiting.

  • Roles from companies you’d actually want to work for

    Real marketing roles from real companies — all in one job board.

  • Find jobs before they hit LinkedIn

    Jobs sourced directly from company career pages — updated every day.

  • Only the roles that match you

    Cut through the noise with 15+ filters like work mode, company type, specialisation, salary, and more.

  • Stand out from hundreds of applications

    Be first in line for new roles with smart, real-time alerts to your inbox.