Technical business analyst in regulatory reporting

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.

• Understand the reporting process and investigate data issues
• Investigate missing data, rejected records, inconsistent calculations or incorrect reports.
• Clarify expected results and reporting deadlines with business users;
• Trace information from source data to the final report using SQL queries, application logs, job results and comparisons of totals.
• Identify where data was lost, changed or rejected;
• Document issues for developers or the software vendor: reproduction steps, expected and actual results, affected data, transformation rules and reporting impact.
• Prioritize tickets by reporting impact and deadlines.
• Coordinate investigations with reporting users, developers, the software vendor and Production;
• Keep client banks informed of investigation progress, available workarounds and resolution, in English and, where possible, in French;
• Help plan job reruns or data recovery with Production and database specialists.
• Check that data is complete and consistent and that reports can be generated after recovery;
• Review recurring incidents and client requests to identify causes and improvements that prevent the same issues from returning.
• Translate reporting issues and user requests into specifications covering data rules, calculations, interfaces and expected results.
• Provide developers or the vendor with examples and acceptance criteria;
• Define acceptance and regression tests for fixes, configuration changes or upgrades.
• Validate reports with business users and check results after deployment;
• Maintain test datasets and expected reports.
• Compare report totals with source data and record the results of checks across relevant reporting configurations.
• Maintain investigation guides, known-issue records and recovery procedures.
• Share practical knowledge of the reporting applications with the support team;
• Propose checks for missing inputs, rejected records, delayed jobs and inconsistent report totals.
• Strengthen data-quality controls and identify recurring reporting problems;
• Agree improvement priorities with business users, developers and Production; follow actions through to completion and check their operational benefit;
• Use SQL queries and existing scripts to make data checks repeatable.
• Work with Production to improve job dependencies, restart procedures and report efficiency.

• The main requirements are understanding the regulatory reporting process, practical SQL, application support and clear analysis for developers or vendors. Comparable reporting-software experience is welcome; expertise in every country’s framework or infrastructure tool is not required.
• 5+ years in regulatory reporting application support, technical business analysis or a comparable data-focused role in banking.
• Relevant degree or equivalent professional experience;
• Understand how banking data becomes a regulatory report, including data transformations, quality checks, reconciliations and deadlines.
• Work with reporting specialists to confirm regulatory rules and expected results;
• Practical SQL skills on Oracle or Microsoft SQL Server: queries, joins, data comparisons and investigation of incorrect or missing records.
• Experience with one database is sufficient to start;
• Experience with OneSumX / FRS, FiRE or comparable regulatory reporting software.
• Ability to investigate data processing, report generation and user-access issues;
• Experience documenting application defects or reporting changes, following them through with developers or vendors and validating the results with reporting users;
• Strong analytical skills, attention to detail, ownership and clear communication with technical and business audiences.
• Fluent English is required.
• Будет плюсом: Experience with a regulatory reporting framework, such as COREP / FINREP, AnaCredit or a comparable national reporting scheme; Familiarity with OneSumX / FRS or FiRE reporting engines, data models or report-generation tools; Exposure to Citrix for remote application access, WildFly application servers or Keycloak authentication from a support perspective; Familiarity with TWS or another batch scheduler, XLDeploy deployment tools, PowerShell or support automation; French language skills, particularly for communication with client banks

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