
Senior Data Analyst, Payments Reporting – Qolo
Posted 11 hours ago

Posted 11 hours ago
This is a fully remote position, open to applicants in United States.
• 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.
• 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.
• Competitive salary.
• Eligibility for incentive awards based on both individual and business performance.
• Comprehensive range of benefits.
Expana
RELX
Get handpicked remote jobs straight to your inbox weekly.