Data Analyst Professional North Andover, MA

The Reynolds and Reynolds Company; Andover (MA); Hybrid; USD 70,000 - 100,000; Full time

Benefits offered by this job

Health insurance

401(k) matching

Professional development

Career advancement

Paid vacation

Holidays

Referral bonuses

Hybrid work option

Job summary

TSD Mobility Solutions, Inc., an affiliate of Reynolds and Reynolds, is seeking a Data Analyst to convert sales, revenue, and margin data into dashboards and executive reports. You will own the team’s automations and maintain the payments platform configuration.

Responsibilities include monthly sales reporting, rep attribution hygiene, and building pivot-ready datasets with Excel, Power Query, and Google Sheets. Hybrid work is available for eligible positions.

Qualifications

• 2+ years in a data analyst role with dashboards and reporting.
• Advanced Excel skills: pivots, macros/VBA, complex formulas.
• Experience with Power Query, Google Sheets, and data automation.

Responsibilities

• Own existing automations that report team stats.
• Route escalations and manage metadata attribution.
• Manage monthly payments account maintenance and configuration.
• Flag anomalies affecting billing or margin.
• Maintain and extend automations as needs evolve.
• Build repeatable workflows to extract cost, interchange, and margin insights from raw statements.

Skills

Excel

Power Query

Google Sheets

SQL

Python

Dashboards

Automation tools

AI tools

CRM systems

Data analysis

Education

College Degree in relevant field

Tools

Zapier

Stripe

HubSpot

Salesforce

Job description

Job Description

TSD Mobility Solutions, Inc., an affiliate of Reynolds and Reynolds, is looking for a Data Analyst to join our growing team. In this role, you will turn sales, revenue, and margin data into dashboards and executive reports that leadership relies on; own the team's operational automations; and maintain the configuration behind TSD's payments platform. You will be responsible for monthly sales reporting and rep attribution hygiene by maintaining payments reporting (including rate, margin pools, and volume trends). You will build pivot-ready datasets, macros, and automated workflows in Excel, Power Query, and Google Sheets, and take ownership of existing automations that report team stats.

#LI-DNI

Responsibilities

• Take ownership of existing automations that report team stats.
• Route escalations and handle metadata attribution.
• Manage monthly payments account maintenance, including pricing adjustments and configuration updates.
• Flag anomalies affecting billing or margin.
• Maintain, troubleshoot, and extend these automations as reporting and operational needs evolve.
• Build repeatable workflows to extract cost, interchange, and margin insights from raw merchant processor statements.

Training

On the job training.

Requirements

• 2+ years of experience in a similar data analyst position required
• Advanced experience in excel (pivots, macros/VBA, complex formulas), Power Query, and Google Sheets required
• Experience building and maintaining recurring dashboards and reporting from sales, revenue, and margin data required
• Hands-on experience with workflow automation tools (Zapier or similar) and able to troubleshoot and extend existing automations required
• Power user of AI tools (e.g., Claude, ChatGPT) to automate and accelerate daily work required
• Experience with Stripe or another payments platform configuration preferred
• Industry background in payments, fintech, SaaS, or mobility/rental is a plus
• College Degree in relevant field preferred
• Experience in SQL, Python, and CRM systems like HubSpot or Salesforce is a plus
• Strong attention to detail and documentation habits
• Excellent written and verbal communication skills

Benefits

• Medical, dental, vision, life insurance, and a health savings account
• 401(k) with up to 6% matching
• Professional development and training
• Promotion from within
• Reynolds offers a hybrid work schedule, based on position eligibility. Following completion of your training period, eligible associates may work-from-home up to two days per week.
• Paid vacation and sick days
• Eight paid holidays
• Referral bonuses

Reynolds and Reynolds promotes a healthy lifestyle by providing a non-smoking environment. Reynolds and Reynolds is an equal opportunity employer.

2+ years of experience in a similar data analyst position required. Advanced experience in excel (pivots, macros/VBA, complex formulas), Power Query, and Google Sheets required. Experience building and maintaining recurring dashboards and reporting from sales, revenue, and margin data required. Hands-on experience with workflow automation tools (Zapier or similar) and able to troubleshoot and extend existing automations required. Power user of AI tools (e.g., Claude, ChatGPT) to automate and accelerate daily work required. Experience with Stripe or another payments platform configuration preferred. Industry background in payments, fintech, SaaS, or mobility/rental is a plus. College Degree in relevant field preferred. Experience in SQL, Python, and CRM systems like HubSpot or Salesforce is a plus. Strong attention to detail and documentation habits. Excellent written and verbal communication skills