Finance Data Specialist

Who We Are   Moneycorp is a thriving dynamic business with an excellent reputation helping Corporate and Private Clients with their FX and International Payments requirements for over 40 years. As a globally expanding business, our footprint covers UK & Ireland, Europe, USA, Canada, Hong Kong, UAE, and Brazil!   With our extremely rare single IBAN multi-currency account, we are able to assist with a variety of different payment needs, including business payment solutions, personal payments abroad (for example buying a property), travel money, as well as the ability to offer interest on deposits. Supplementing this, we also support the global supply chain of wholesale banknotes through our Financial Institutions Group (FIG) and partnership with the US Federal Reserve Bank, to build deeper payment relationships with international banking customers.   It is through obtaining our own banking and payment licenses, the acquisition of two banking platforms and access to 16+ liquidity providers that we are able to proposition a trailblazing FinTech payment infrastructure that simplifies our customer’s diverse business needs and reduce their costs. There is no doubt that we are a major player and differentiated ourselves in a continuously evolving and competitive industry.  With 600+ employees, Moneycorp prides itself in attracting some of the world’s top talent and the people who work at Moneycorp are truly behind its continued success. As Moneycorp continues to expand into new territories, there are considerable opportunities for growth for newcomers and the learning possibilities are endless. We welcome you to be part of a team which has a passion for the business, all within a collaborative and supportive working environment that has ultimately translated to a unique exciting business. To find out more about our journey click here.    Who You Are / Your Next Challenge  We are looking for a Finance Data Specialist to join our Finance team on a full-time, permanent basis in our London office. This position reports directly to the Finance Transformation consultant. This role is to add value to the bottom line by using data effectively across Finance & Treasury. Work on specific Finance Transformation and multiple other strategic projects to accelerate the Finance month end using data analytics, modelling and intelligence to promote efficiency. Support the Finance & Treasury systems suite and their users including Purchase Ledger system, Expense system, General ledger, trading platforms and supporting SQL databases.  What we’re looking for: 

• Responsible for designing, developing, and maintaining SQL databases, writing efficient SQL queries, and optimising database performance.
• Collaborate with cross-functional teams to understand data requirements and ensure accurate and timely delivery of solutions.
• Work closely with stakeholders to gather requirements and translate them into technical specifications. 
• Design and develop data pipelines and queries, for efficient data extraction and transformation.
• Write efficient SQL queries to extract and manipulate data.
• Write and maintain production-level code to support lead management and Finance systems, ensuring scalability, performance, and reliability.
• Perform database tuning and optimization.
• Collaborate with software developers to integrate SQL databases into applications.
• Development and maintenance of complex datasets needed for reports, dashboards, and visualisations. 
• Troubleshoot database-related issues.
• Monitor and optimize database performance, identifying and resolving bottlenecks and inefficiencies.
• Conduct regular reviews of SQL code and queries for performance improvements
• Ensure data security and integrity.
• Stay updated with the latest database technologies and best practices.
• Responsible to the end-to-end implementation of the Finance data warehouse project, from requirement gathering to deployment.
• Collaborate with stakeholders to define project scope, objectives, and deliverables.
• Design and develop robust data warehouse architectures that support scalability, performance, and data integrity.
• Implement best practices for data modelling, ETL processes, and data integration.
• Optimise data warehouse performance through efficient query design, indexing strategies, and data partitioning.
• Provide technical guidance and mentorship to team members, ensuring adherence to industry standards and best practices.
• Work closely with business analysts and data scientists to understand analytical requirements and translate them into technical solutions.
• Collaborate with cross-functional teams to ensure seamless integration of data warehouse solutions with existing systems and applications.

 Knowledge and Experience:

• Extensive SQL and Access Database experience including configuration of databases and stored procedures.
• Extensive experience of interfacing between the GL system and supporting trading/source systems.
• Experience of working within financial services and regulated entities.
• Experience of end-to-end process flows and data quality management of FX or volume payments processes or wholesale banking physical notes business preferred.
• Advanced Excel skills.
• Experience with large data reconciliations
• Previous experience of working in a fast-paced finance environment.

 Skills and Competencies:

• Advance IT skills most notably with programming languages such as VBA, VB Script, SQL and MS packages specifically Excel (including pivot tables) or equivalent is essential.
• Proficient use of Visual Basic and SQL and using both to apply to reconciliations and processes.
• Experience working with Python would be desirable but not essential
• Good interpersonal and communication skills both written and verbal.
• Good analytical abilities, with an enquiring mind.
• Robust, capable of clearly and strongly articulating position.
• Excellent attention to detail with the ability to think analytically and work methodically in a high performing team.   

 Education:

• Bachelor's degree in Computer Science, Information Systems, or a related field.
• Proven experience as a SQL Analyst / Developer with a focus on BI and production-level code.
• Strong proficiency in SQL, T-SQL, and experience working with relational databases (e.g., SQL Server, Oracle, MySQL)
• Knowledge of software development best practices and ability to write production-level performant SQL code.
• A recognised Finance qualification is desirable but not essential

  Personal Attributes:

• Curious and willing to learn / adapt.
• Respectful, professional and conscientious.
• Enjoys working in a fast-paced environment.
• Highly capable operating and executing independently, at times, and with larger multi-functional teams.
• Heavily driven to improve (self, team, process, company).

 The successful candidate will be part of a dynamic team and work in a fast-paced environment, catering to a diverse mix of stakeholders with varying needs. Therefore, the ideal candidate should be a self-starter, as there is an opportunity to make an immediate and tangible contribution to the business.     Please note: This is a permanent role within the Finance team based in our London office.      What you get in return:     This role offers a competitive salary, plus a benefits package including private medical health insurance. Interested?     If the role sounds like you, we invite you to upload a copy of your CV and can do this by clicking on the Apply Now button.     Start date: ASAP     For company news, announcements and market insights, visit our News Hub.     You can also find Moneycorp on Facebook, Twitter UK, Twitter Americas, Instagram, LinkedIn, where you can discover how we are leading the way in global payments and currency risk management.    Diversity and Inclusion     Moneycorp is proud to be an Equal Opportunity employer. Across our Group, Moneycorp maintains a philosophy that an inclusive company culture inspires creativity, fosters a sense of belonging, and is imperative to both personal and professional growth. With a makeup of 47 percent female employees, Moneycorp has a remarkably diverse workforce. Our commitment to inclusion and opportunity continues to evolve and improve as we listen and engage with our diverse teams.    All qualified applicants will receive consideration for employment without regard to age, colour, family or medical care leave, gender identity or expression, genetic information, marital status, medical condition, national origin, political affiliation, status as an individual with a physical or mental disability status as an individual with a protected veteran status, race, religion, sex (including pregnancy), sexual orientation, or any other characteristic protected by applicable laws, regulations and ordinances.    Moneycorp believes that diversity is critical to our success in helping Corporate and Private Clients with their FX and International Payments requirements across the world and is committed to creating an inclusive, mutually respectful environment which celebrates diversity. We hire on the basis of talent, merit, competence, performance, and business needs.