Technical business analyst for treasury systems

Decskill, founded in 2014 as an IT Consulting Company, places paramount importance on its greatest asset: its people. Our main mission is to deliver value through knowledge and talent, and we achieve this by fostering a culture of excellence and investing in the development and well-being of our people. With over 600 dedicated professionals and offices in Lisbon, Porto, Madrid, and Luxembourg, Decskill operates across three core areas:

• Understand financial processing and investigate data issues
• Investigate discrepancies in accounting entries, positions, cash flows, risk calculations or liquidity indicators. Clarify expected results and business impacts with the relevant users;
• Follow data from the core banking system through file extracts, database imports, calculations and reports. Use SQL, logs and processing results to find missing records or incorrect transformations;
• Document the issue for developers: steps to reproduce it, expected and actual results, affected data, likely cause and business impact;
• Prioritize tickets by business impact and processing deadlines. Coordinate investigations with business users, developers, Production and database specialists;
• Keep client banks informed of investigation progress, available workarounds and resolution, in English and, where possible, in French;
• Help plan batch restarts or data reloads with Production and database specialists. Check completeness, duplicates, financial totals and downstream calculations after recovery;
• Review recurring incidents and client requests to identify causes and improvements that prevent the same issues from returning.
• Translate incidents and business requests into specifications covering calculation rules, accounting behavior, data transformations and interfaces. Provide developers with examples and acceptance criteria;
• Define acceptance tests and regression tests, check results with business users and verify application behavior after deployment;
• Maintain test datasets and expected results for accounting closing, cash flows, risk calculations and liquidity indicators. Check that fixes preserve the consistency of related outputs.
• Maintain investigation guides, known-issue records, data-flow documentation and recovery procedures. Share knowledge of the financial applications with the support team;
• Propose checks for missing files, rejected or duplicated records, delayed jobs and inconsistent financial calculations. Improve reconciliation and processing controls;
• Agree improvement priorities with business users, developers and Production; follow actions through to completion and check their operational benefit.
• Use SQL queries, job logs, import counts and existing scripts to make investigations repeatable. Identify ways to simplify data checks and reduce manual support work.

• The main requirements are knowledge of one relevant financial domain, practical SQL, production-support experience and clear analysis for developers. Expertise across every financial domain or programming language is not required. Specialist database and financial-model topics are handled with the relevant teams.
• 5+ years in banking application support, technical business analysis or a comparable role in treasury, accounting, liquidity or risk systems. Relevant degree or equivalent professional experience;
• Strong knowledge of at least one area: treasury, accounting, liquidity or risk operations. Ability to investigate calculations and reconcile results, with support from business specialists for related domains;
• Practical SQL skills on IBM DB2 or Microsoft SQL Server: queries, joins, comparisons and checks on imported data. Experience with one database is sufficient to start;
• Ability to follow calculation and data-processing logic with developers. Experience investigating COBOL or C# / .NET applications, or a comparable banking system, is relevant;
• Experience documenting defects and business changes for developers, following them through to resolution and validating results with business users;
• Strong analytical skills, attention to detail, ownership and clear communication with technical and business audiences. Fluent English is required.
• Будет плюсом: Experience with core banking, treasury, accounting, liquidity or risk-management applications; Exposure to T-SQL data imports, Access / Excel / VBA, or a second database or application language beyond the main area of expertise; Experience with treasury-system interfaces such as Kondor+, or comparable financial-file and market-data feeds; Familiarity with TWS or another batch scheduler, accounting closing processes, liquidity ratios or test automation; French language skills, particularly for communication with client banks

• Условий в вакансии нет