Senior Data Analyst, Payments Reporting – Qolo

Posted 11 hours ago

This is a fully remote position, open to applicants in United States.

📋 Description

• Develop, maintain, and enhance financial and transactional reports that serve Qolo clients and internal teams.

• Create and optimize intricate SQL Server and T-SQL queries, stored procedures, and reporting workflows.

• Convert reporting requirements into functional reports for the implementation of new enterprise clients.

• Examine reporting inconsistencies, which may include missing transactions, balance discrepancies, duplicate entries, timing variations, and pending versus posted transactions.

• Assist in financial reconciliation by comparing authorizations, settlements, and ledger entries while identifying discrepancies.

• Address slow-running or timing-out reports, collaborating with DBAs and Engineering to enhance query performance.

• Evaluate execution plans and resolve issues related to indexing, locking, blocking, and overall database performance.

• Document reporting logic, data sources, and business rules clearly.

• Collaborate closely with Product teams to comprehend reporting requirements and support larger technical projects.

• Work in partnership with developers and technical teams when reporting functionality necessitates broader application or system modifications.

• Effectively communicate findings and financial data discrepancies to both technical and non-technical stakeholders.


⛳️ Requirements

• Over 8 years of experience in data analysis, business intelligence, database reporting, or a similar technical reporting role.

• Advanced proficiency with Microsoft SQL Server and T-SQL, including complex joins, window functions, CTEs, stored procedures, dynamic SQL, temporary tables, and error handling.

• Strong skills in SQL performance tuning, with experience in execution plans, indexing, statistics, and resolving slow-query issues.

• Comprehensive understanding of database fundamentals, data modeling, data integrity, and large transactional datasets.

• Proven experience in building, scheduling, and maintaining production reporting processes.

• Familiarity with financial or transactional data where accuracy in amounts, balances, dates, and reporting periods is essential.

• Background in fintech, banking, payments, or other financial services environments.

• Exceptional analytical and problem-solving skills, with the ability to pinpoint the root causes of complex data discrepancies.

• Ability to convey technical findings in a clear manner to non-technical business partners.

• Experience working collaboratively across functions with Product, Engineering, database, and operational teams.

• Comfort in using AI tools thoughtfully, including providing sufficient context through prompting to enhance code, optimize solutions, troubleshoot issues, and increase efficiency.

• Understanding of card and payment processing, including authorization, clearing, settlement, interchange, and chargebacks.

• Experience with ledger, transaction, or balance reconciliation.

• Familiar with Azure and cloud-based data environments.

• Proficient in Power BI, Microsoft Fabric, or similar business intelligence/reporting tools.

• Working knowledge of C#/.NET, with the ability to understand or make minor modifications to report-generation services.

• Experience with SQL Agent, SSRS, or comparable production reporting technologies.

• Background in supporting financial reporting within fintech, banking, payments, prepaid, or card-processing environments.

• Candidates must be authorized to work in the United States without the requirement for sponsorship, now or in the future.


🏝️ Benefits

• Competitive salary.

• Eligibility for incentive awards based on both individual and business performance.

• Comprehensive range of benefits.

People also viewed

Huzzle.com9 hours ago

Data Analyst

BR flagBrazil OnlyFull-timeData Analyst
ApplyView job
Expana9 hours ago

Publishing & Data Operations Analyst

US flagUnited States OnlyFull-timeData Analyst
ApplyView job
RELX9 hours ago

Data Analyst II

NL flagNetherlands OnlyFull-timeData Analyst€44.5k – €74.3k/year
ApplyView job
Sandvik9 hours ago

Data Analyst

SE flagSweden OnlyFull-timeData Analyst
ApplyView job
Sharp HealthCare9 hours ago

Business Data Analyst – Finance

US flagUnited States OnlyFull-timeData Analyst$44 – $63/hour
ApplyView job
Illumina10 hours ago

Associate Director, Digital Analytics & Data Integration

US flagUnited States OnlyFull-timeData Analyst$170.6k – $255.8k/year
ApplyView job

Never miss a great job!

Get handpicked remote jobs straight to your inbox weekly.

Trusted by 7,400+ designers