Descrizione del lavoro

Overview

Pay With Spire is a fast-growing SaaS payments company focused on empowering commerce across in-store, mobile, and web platforms. We are seeking a Payment Operations Data Specialist / Analyst with strong analytical skills and a passion for transforming manual financial processes into efficient automated workflows using modern tools like Azure and Superset.

Key Responsibilities

Design and implement optimized SQL queries in Azure Synapse Analytics to automate the ingestion, matching, and reconciliation of daily settlement data.
Collaborate with data engineering teams to convert manual file transfers into automated data pipelines within the Azure environment.
Investigate historical transaction data and ACH return codes to identify root causes of discrepancies and recommend upstream process improvements.
Conduct daily reconciliations across bank accounts, payments, receipts, billing, and processing fees to ensure complete accuracy.
Lead monthly partner settlement reconciliations and support user acceptance testing for new financial technology integrations.
Ensure full compliance with regulatory guidelines, industry norms, and internal policies.

Qualifications & Skills

Bachelor's degree in Finance, Accounting, Data Analytics, or equivalent experience in banking or fintech operations with a background in high-volume settlements.
Proficient in SQL, especially with Azure Synapse / Data Lake technologies.
Experienced in building business intelligence dashboards using tools like Apache Superset, Power BI, Tableau, or Looker.
Advanced Excel expertise including XLOOKUPs, Pivot Tables, and data normalization to accurately handle large datasets during automation transitions.
Meticulous attention to detail and a problem-solving mindset to analyze complex transaction discrepancies under tight daily cutoffs.
Familiarity with banking portals, payment gateways, and interpreting technical transaction logs.
Strong communication skills to clearly convey technical findings and action steps to cross-functional teams.

Compensation & Benefits

Competitive annual salary ranging from $65,000 to $85,000 based on experience.
Comprehensive health, dental, and vision insurance coverage.
401(k) retirement savings plans to support future financial planning.
Discretionary paid time off to maintain work-life balance.

Additional Information

This position requires on-site work at our Dallas, Texas office; candidates must be local to the Dallas-Fort Worth metropolitan area.
Typical office environment with extended computer usage, manual dexterity, and occasional lifting of up to 20 pounds is required.
Some travel for client meetings or company events may be necessary.

Payment Operations Data Specialist / Analyst