<p>Robert Half Technology are assisting a market leading financial services organisation to recruit a Business Data Analyst on a 6 month contract to perm basis. Onsite required - London based </p><p data-end="567" data-start="235">This role sits at the intersection of data, operations, and business strategy, with a strong focus on improving middle office processes, enhancing reporting capabilities, and driving automation initiatives.</p><p data-end="768" data-start="569">You will work closely with Operations, Finance, Technology, and Front Office stakeholders to analyse business processes, identify efficiency opportunities, and deliver scalable data-driven solutions.</p><p><strong>Role</strong></p><ul><li>The Business Data Analyst will analyse complex datasets to support operational, financial, and regulatory reporting</li><li>Develop and maintain SQL queries and data models to support business intelligence and reporting needs</li><li>Use Python to automate workflows, improve data quality checks, and streamline recurring processes</li><li>Build and maintain advanced Excel models and reporting tools (including Power Query, Power Pivot, VBA where applicable)</li><li>Review and optimise middle office processes, identifying control gaps and automation opportunities</li><li>Partner with stakeholders to gather business requirements and translate them into technical solutions</li><li>Drive process automation initiatives to improve accuracy, reduce manual intervention, and increase scalability</li><li>Support reconciliation, valuation, and trade lifecycle analysis where required</li><li>Contribute to data governance, documentation, and control frameworks</li><li>Assist with system enhancements and implementation projects</li></ul><p><strong>Profile</strong> </p><p> </p><ul><li>The Business Data Analyst will have strong SQL skills (query writing, joins, performance optimisation, data manipulation)</li><li>Proficiency in Python for data analysis and automation (e.g., pandas, scripting, APIs)</li><li>Advanced Excel skills (complex formulas, pivot tables, data modelling)</li><li>Proven experience working in a Middle Office role within a financial services environment</li><li>Strong understanding of trade lifecycle, reconciliations, valuations, and operational controls</li><li>Experience reviewing and improving operational processes</li><li>Demonstrated ability to drive automation and efficiency initiatives</li><li>Strong analytical thinking and problem-solving skills</li><li>Excellent communication skills with the ability to work across technical and non-technical teams</li><li>Experience with Advent Geneva</li><li>Exposure to data visualisation tools (e.g., Power BI, Tableau)</li><li>Experience with financial instruments (equities, fixed income, derivatives, alternatives)</li></ul><p> </p><p><strong>Company</strong></p><ul><li>Market leading financial services organisation with offices in London</li><li>Onsite required - London based </li></ul><p><strong>Salary & Benefits</strong></p><p>The salary range/rates of pay is dependent upon your experience, qualifications or training.</p><p>Robert Half Ltd acts as an employment business for temporary positions and an employment agency for permanent positions. Robert Half is committed to diversity, equity and inclusion. Suitable candidates with equivalent qualifications and more or less experience can apply. Rates of pay and salary ranges are dependent upon your experience, qualifications and training. If you wish to apply, please read our Privacy Notice describing how we may process, disclose and store your personal data: roberthalf.com/gb/en/privacy-notice.</p><img src="https://counter.adcourier.com/S2F6aW0uSGFzc2FuLjAxMTMwLjEwOTIzQHJoaS5hcGxpdHJhay5jb20.gif">
<p>Robert Half have partnered with a B2B SaaS organisation is seeking a Business Data Analyst for an initial 2-month contract to support a critical data and systems improvement initiative.</p><p>The primary objective of this role is to support data quality, commercial data structures, and system readiness, with a particular focus on Salesforce data migration and Excel-based pricebook development.</p><p>This role will involve hands-on data cleansing, restructuring, and validation, alongside the development of robust Excel tools to support SaaS commercial processes and pricing structures.</p><p data-start="699" data-end="713"><strong>Role:</strong></p><p>You will play a key role in supporting commercial and operational data initiatives, working closely with internal stakeholders to ensure data accuracy, consistency, and alignment across systems. The role requires strong Excel and data-handling capability, combined with a solid understanding of SaaS commercial metrics and Salesforce data structures.</p><p>Key responsibilities include:</p><ul data-end="1787" data-start="1096"><li data-start="1096" data-end="1190">Cleansing, mapping, restructuring, and preparing large datasets ahead of Salesforce import</li><li data-start="1191" data-end="1308">Validating data against Salesforce schema, including Accounts, Contacts, Opportunities, Products, and Price Books</li><li data-start="1309" data-end="1397">Supporting product and pricebook data alignment to ensure consistency across systems</li><li data-end="1460" data-start="1398">Developing and refining a structured Excel-based pricebook</li><li data-start="1461" data-end="1559">Implementing advanced Excel logic, automation, and calculations using complex formulas and VBA</li><li data-end="1643" data-start="1560">Supporting large-scale data manipulation, conversion, and validation activities</li><li data-start="1644" data-end="1711">Ensuring data integrity and accuracy across commercial datasets</li><li data-end="1787" data-start="1712">Working collaboratively with stakeholders to deliver project milestones</li></ul><p data-end="1814" data-start="1789"><strong>Experience:</strong></p><p>Core Skills (Essential):</p><ul data-end="2480" data-start="1844"><li data-end="1963" data-start="1844">Advanced Microsoft Excel expertise, including complex formulas and data modelling</li><li data-start="1844" data-end="1963">Proven experience in data manipulation, cleansing, and large-scale data conversion</li><li data-start="2051" data-end="2319">Working knowledge of Salesforce, including: <ul data-end="2319" data-start="2099"><li data-end="2219" data-start="2099">Understanding of Salesforce data schema and objects (Accounts, Contacts, Opportunities, Products, Price Books, etc.)</li><li data-start="2222" data-end="2319">Experience with Salesforce data exports/imports, deduplication, validation, and field mapping</li></ul></li><li data-start="2320" data-end="2480">Strong understandingofSaaS commercial metrics, including: <ul data-end="2480" data-start="2384"><li data-start="2384" data-end="2397">ACV / ARR</li><li data-start="2400" data-end="2441">Contract terms and renewal structures</li><li data-start="2444" data-end="2480">Product and pricebook structures</li></ul></li></ul><p>Nice to Have:</p><ul data-end="2672" data-start="2500"><li data-end="2590" data-start="2500">Experience with Atlassian Jira administration (custom fields, workflows, bulk updates)</li><li data-end="2672" data-start="2591">Previous experience working within SaaS or subscription-based business models</li></ul><p data-end="2696" data-start="2674"><strong>Contract:</strong></p><ul data-end="2858" data-start="2697"><li data-start="2697" data-end="2728">Initial 8-week contract - Inside IR35 </li><li data-start="2729" data-end="2800">Remote working, with occasional on-site visits to Cambridge</li><li data-start="2801" data-end="2840">Full-time availability required</li><li data-start="2841" data-end="2858">Start: ASAP</li></ul><p>Robert Half Ltd acts as an employment business for temporary positions and an employment agency for permanent positions. Robert Half is committed to diversity, equity and inclusion. Suitable candidates with equivalent qualifications and more or less experience can apply. Rates of pay and salary ranges are dependent upon your experience, qualifications and training. If you wish to apply, please read our Privacy Notice describing how we may process, disclose and store your personal data: roberthalf.com/gb/en/privacy-notice.</p><img src="https://counter.adcourier.com/YW5kcmUuZ2FyZGVuZXJtY2ZhcmxhbmUuMTE3MjAuMTA5MjNAcmhpLmFwbGl0cmFrLmNvbQ.gif">
