Data Analyst Professional North Andover, MA

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

Benefits offered by this job

Hybrid work schedule

Professional development and training

Promotion from within

Paid vacation and sick days

Referral bonuses

Job summary

TSD Mobility Solutions, Inc. is seeking a Data Analyst to transform sales, revenue, and margin data into dashboards and executive reports. You will own the team’s operational automations and maintain the configuration behind TSD's payments platform, including monthly sales reporting and rep attribution hygiene.

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.

Qualifications

• 2+ years of experience in a data analyst role.
• Advanced Excel skills including pivots, macros/VBA, and complex formulas.
• Experience building recurring dashboards and reporting from sales, revenue, and margins data.
• Hands-on with workflow automation tools (e.g., Zapier).
• Proficient in AI tools to automate daily tasks.
• Experience with Stripe or payments platform configuration is a plus.

Responsibilities

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

Skills

Attention to detail

Communication

Documentation habits

Dashboards & reporting

Education

College Degree in relevant field preferred

Tools

Excel

Power Query

Google Sheets

Zapier

SQL

Python

HubSpot

Salesforce

AI tools (Claude/ChatGPT)

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-Hybrid

Training

On the job training.

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.

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

We strive to offer an environment that provides our associates with the right balance between work and family. We offer a comprehensive benefits package including:
- 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