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