CRM Data Analyst

AMS; Pearl River (NY); Hybrid; USD 70,000 - 80,000; Full time

Benefits offered by this job

Medical coverage

Dental

Vision

401k

Paid time off

Job summary

A leading analytics firm in Pearl River, New York seeks a CRM Data Analyst to transform and analyze data for sales and revenue teams. This hybrid role requires 2+ years of analytical experience, proficiency in BI tools like Power BI, and SQL skills. Candidates will build dashboards, develop SQL queries, and deliver actionable insights. A competitive salary range of $70,000 - $80,000 and a comprehensive benefits package are offered.

Qualifications

• 2+ years of experience in data analysis, business intelligence, analytics, or a related role.
• Hands-on experience with BI tools like Power BI or Tableau.
• Working knowledge of SQL with a desire to deepen technical proficiency.

Responsibilities

• Build and maintain dashboards and reports using CRM and related business data.
• Develop SQL queries and structured datasets to support reporting.
• Translate business requirements into visualizations and actionable analysis.

Skills

Data analysis

Business intelligence

SQL

Power BI

Analytical mindset

Tools

Power BI

SQL

Tableau

Job description

About Us

At AMS, we’re all about growth—helping our clients scale and creating space for our people to do the same. We’re a team of curious, driven, and creative minds who love turning ideas into impact. You’ll find a culture that values collaboration, openness, and initiative—where everyone’s voice matters and great work gets recognized. If you’re looking to grow, learn, and build something meaningful, you’ll fit right in here.

About the role

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.

What you’ll do

• 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 accuracyHelp 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.