Reporting Contractor - Settlement & Reconciliation

Job description

About The Role: We're looking for a detail-driven Reporting Contractor to join our Settlement & Reconciliation team and play a key role in how we turn complex, high-volume data into clarity. Working closely with our PDP database and Databricks environment, you'll design and build the reports that our reconciliation specialists rely on every day to catch discrepancies, resolve settlement breaks, and keep our financial operations running smoothly. This is a role for someone who enjoys solving puzzles hidden in large datasets and takes pride in turning messy, complex information into clean, reliable reports that people can actually trust and act on. If you love working with SQL and Python, thrive on precision, and want your work to have a direct, visible impact on how a financial operations team functions, we'd love to hear from you. Note: This is a 6-12-month fixed-term contract position. What You'll Do (Responsibilities): Report Design & Development: Design, build, and maintain reports sourced from the PDP database (integrated with Databricks), tailored to settlement and reconciliation workflows. Translate business requirements and stakeholder instructions into clear accurate, and well-structured report specifications. Ensure reports are consistent in format, logic, and presentation, and easy to interpret by both technical and non-technical stakeholders. Maintain version control and documentation for report logic/queries/notebooks to support auditability. Data Management & Analysis: Query, extract, clean, and validate large volumes of transactional and settlement data from PDP/Databricks and other source systems. Write and optimize SQL queries to pull and aggregate data efficiently at scale. Perform data processing, automation, and recurring reconciliation tasks within the Databricks environment. Identify data discrepancies, anomalies, or breaks within the data and flag them for the reconciliation team. Settlement & Reconciliation Reporting: Build recurring and ad hoc reports covering transaction matching, exceptions, outstanding items, and settlement status Support the reconciliation team by structuring data outputs that highlight mismatches, aging items, and unresolved settlement breaks. Ensure reports align with internal control requirements and support audit/compliance needs. Collaborate with the Settlement & Reconciliation team to refine report logic as data structures or business processes evolve. Automation & Process Improvement: Automate manual, repetitive reporting tasks to increase accuracy and reduce turnaround time. Recommend and implement improvements to reporting pipelines, queries, and Databricks notebooks/workflows. Maintain scalability and performance of reporting solutions as data volume and complexity grow. What You’ll Need To Be Successful In This Role: Bachelor's degree in a relevant field (Computer Science, Information Systems, Finance, Mathematics, or related) - or equivalent practical experience. Strong proficiency in SQL, with demonstrated ability to write and optimize complex queries against large relational and distributed databases. Hands-on experience with Databricks (notebooks, SQL warehouses/clusters, and ideally Spark SQL or PySpark for large-scale data processing). Proficiency in Python for data processing, automation, and report generation, particularly within a Databricks/notebook environment. Direct experience working with PDP or comparable enterprise transactional databases is strongly preferred. Excellent attention to detail and data accuracy, given the sensitivity of settlement data. Ability to interpret business/stakeholder requirements and convert them into functional, well-structured reports without extensive back-and-forth. Experience handling large-scale/distributed datasets and optimizing query/report performance under high data volume. Familiarity with version control (e.g., Git) and basic documentation practices, including notebook hygiene in Databricks. Strong organizational skills and ability to manage multiple report requests/deadlines in a fast-paced environment. Would Be Considered a Plus: Prior experience in FinTech, banking, or financial operations is advantageous. Direct experience working with PDP or comparable enterprise transactional databases is strongly preferred. Solid understanding of settlement and reconciliation processes in financial services (transaction matching, breaks, exception handling) - prior experience in this domain is a strong plus. Certifications in Databricks (e.g., Databricks Certified Data Engineer/Analyst), BI tools (Tableau, Power BI), or financial operations (CTP) are a plus but not required Why Join Paysend? Make a Global Impact: Join a company that is transforming how people and businesses move money around the world. Your work will contribute to products and services that help millions of customers stay connected globally. Own Meaningful Outcomes: We empower our people to take ownership, make decisions, and drive real impact. You'll have the opportunity to shape solutions, challenge the status quo, and see the results of your work firsthand. Grow with Us: As a fast-growing global fintech, we offer opportunities to learn, develop new skills, take on new challenges, and advance your career across functions and geographies. Collaborate with Exceptional People: Work alongside talented colleagues from diverse backgrounds and disciplines who are united by a shared ambition to build, innovate, and deliver great outcomes for our customers. Move Fast and Make Things Happen: We value action, curiosity, and continuous improvement. You'll be part of a culture that encourages experimentation, embraces change, and focuses on delivering meaningful results. Be Part of Our Journey: We're building the future of the global money movement. Join us at an exciting stage of growth where your ideas, expertise, and contributions can help shape what's next.