Finance Data Engineer

Moneycorp powers global payments for corporates, institutions and high net worth individuals, combining worldwide reach with local expertise. With over 45 years of market experience, two banking licences and offices in 11 countries, our technology delivers 24/7 accessibility, while our people deliver award-winning service. In 2024, we supported £79bn+ of international payments, reaching 190 countries in 130 currencies. Our 32k+ corporate clients benefit from our regulatory resilience with 63+ permissions globally, access to major payment rails, and proprietary technology.

Moneycorp is a place where energy, commitment to our shared success, and collaboration are core to our values. We’re restless in our drive to surpass the expectations of our customers and unlock opportunities to support them at every stage of their journey. The foundation of our success is our people, and nurturing a culture of belonging for all our colleagues is central to our journey as a global business.

The Data Engineer plays a critical role in enabling Finance & Treasury to deliver accurate, timely, and insight‑driven reporting by building scalable data solutions, maintaining core data infrastructure, and supporting the modernisation of Finance systems. This role is responsible for engineering robust data pipelines, managing datasets across the Microsoft Fabric platform, and ensuring Finance has reliable, consistent, and governed data to support transformation, automation, and improved operational efficiency.

As Finance undergoes significant change, the Data Engineer will be a key technical contributor—helping shape new ways of working, supporting system enhancements, and ensuring Finance is equipped with modern, resilient data capabilities.

• SQL, Data Extraction and Transformation
• Design, develop, and maintain SQL data structures within Microsoft Fabric, writing efficient SQL queries and Python‑based transformations to support scalable data pipelines and optimise performance across Lakehouse and Warehouse workloads.
• Build and maintain reporting datasets optimised for analytics and visualisation, implementing Slowly Changing Dimension (SCD Type 2) logic to support historical reporting and data accuracy.
• Ensure data security and integrity throughout the medallion architecture, enforcing access controls, auditing data changes, and ensuring accurate, consistent data is delivered.
• Develop and maintain Power BI semantic models and model layouts built on Microsoft Fabric Gold‑layer datasets, ensuring secure, performant, and well‑governed reporting models for dashboards and analytical consumption.
• Support the onboarding of new data sources into Microsoft Fabric by working with DevOps teams on secure connectivity, API integrations, and operational ingestion processes.
• Design and develop data pipelines and queries, for efficient data extraction and transformation.
• Write and maintain production‑level code to support lead management and Finance systems, ensuring scalability, performance, and reliability.
• 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.
• Stay updated with the latest database technologies and best practices.

• Implement best practices for data modelling, ETL processes, and data integration.
• Optimise data warehouse performance through efficient query design, indexing strategies, and data partitioning.
• Stay updated on emerging trends and technologies in data management and analytics and evaluate their potential impact on our data warehouse architecture.

• Support configuration changes as needed to meet Finance & Business requirements.
• Take ownership of upgrade processes including testing and configuration changes, ensuring the current system is fit for purpose for Finance users.
• Facilitating with the implementation of the new functionality arising from the upgraded software.

• Extensive SQL experience: Working with relational databases (e.g., SQL Server, Oracle, MySQL).
• Strong proficiency in SQL, T-SQL and SparkSQL.
• Proven background as a SQL Analyst / Developer or Data Engineer.
• Experience working with structured and unstructured data sources.
• Experience writing stored procedures and production‑level data transformation code.
• Previous experience of working in a fast-paced environment.
• Knowledge of software development best practices.
• Strong analytical mind, excellent attention to detail.
• Good interpersonal and communication skills both written and verbal.
• Good analytical abilities, with an enquiring mind.
• Robust, capable of clearly and strongly articulating position.

• Hands‑on experience with Microsoft Fabric.
• Advance development experience, most notably with programming languages such as python.
• Power BI model development and semantic modelling.
• API setup/testing experience (e.g., Postman).
• Experience with cloud platforms and modern data architectures.
• Experience within financial services or regulated environments.
• Advanced Excel skills.

• Bachelor’s degree in Computer Science, Information Systems, STEM, or related field.
• Certifications in Python, PySpark, or cloud technologies are desirable but not essential.

This is a full-time, fixed term contract with an opportunity to work in a hybrid working model within our Finance Transformation team based in our London office.

This role offers a competitive salary, plus a benefits package including private medical health insurance.

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.

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.

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 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.