Data Analyst: Dashboards, Automations & Payments

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

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.