Wire Room Data Analyst

Type:

FTE-Hybrid Role 3 days a week in office

Requirement ID:

Location:

New York City

Apply To:

diane.katz@primesoftinc.com

/

diane.katz@primesoftinc.com

/

561-573-1581

Type:

FTE-Hybrid Role 3 days a week in office

Location:

New York City

Requirement ID:

Setup:

Apply to:

diane.katz@primesoftinc.com

,

diane.katz@primesoftinc.com

,

561-573-1581

Apply Now

Purpose of Position

The Data Analyst is responsible for the day-to-day operations in a high-volume wire room. Hands-on management of the operational activities are needed to support controls oversight onto the daily processing of domestic/international wire transactions. The Data Analyst will be responsible to provide Compliance Senior Management with statistical reports, weekly, bi-weekly and monthly.

Essential Job Functions

·        Review of the raw data and the wire data post-processing;  

·        Conduct data analysis for quality in messaging data and/or other wire data metric;

·        Maintain dashboards, pivot tables and other reports.

·        Reports are based on special needs as required by the Wire Room Manager;  

·        Provide timely and accurate analysis involving daily reviews of wire messages in a fast-paced, time sensitive operations environment;

·        Analyze, design, write testscripts and perform end-to-end testing of real-time and batch integrations between multiple systems;

·        Responsible for DataMapping/Integration of several internal data tables, for screening messages inproduction and test environments;

·        Prepare monthly metrics reports for Wire Room Manager and Compliance Senior Management; Provide system testing, analysis, maintaining delivery of dashboard metrics reports;

·        Working knowledge of ETL process for inbound and outbound wire payments;

·        Present data analytics in data visualizations that is meaningful to Compliance Senior Management for over sight and monitoring the effectiveness of controls; and

·        Develop Share Point sites for the connection of SQL stored procedures output to facilitate case adjudication by Compliance Analysts.

·        Act as point person on interna lbanking ETL processes for inbound and outbound wire payments concerning improvements in the internal payment processing system and final repository.

Knowledge, Skills and Experience Requirements

Apply Now

·        Bachelor's degree required;

·        2 years of experience with data modeling, staging, ETL, data ware house design and support; Excellent critical thinking and creative problem solving capabilities;

·        Working knowledge of real time payments networks such as SWIFT, Chips, Fed Wire;

·        Experience with statistical analysis software;

·        SQL Server Report Services, Analysis Services, Integration Services, Power BI all a big plus; Background in math, statistics and information systems; and

·        Possess a strong technical skill set, with solid experience in generating reports for BAU purposes.

Reportsto Wire room Compliance Manager

Apply for this job

Reconciliation and Control Administrator

See job description

FirstName-LastName-CV

cancel
Select file
Thank you! Your submission has been received. We will get back to you soon.
Oops! Something went wrong while submitting the form.