Data Engineer (compliance banking)

Responsibilities:  assists in  the day-to-day operations in a high-volume wire room. Hands-on management of the operational activities is needed to support controls
oversight onto the daily processing of domestic/international wire transactions. The Data Engineer will be responsible for concept creation included in the WRCT controls framework, and supporting Data Analysts with various deliverables to the Compliance Team. Works with machine learning engineers to provide enriched data sets for machine learning exploratory analysis and model training

Responsibilities:
Assist WRCT Manager with the development and maintenance of Python for the WRCT daily BAU workflow process needs
Develop procedure to interrogate controls from raw wire data origination
Automate procedures for data analysis to reproduce quality metrics reporting
Provide timely and accurate analysis involving daily reviews of wire messages in a face-paced, time-sensitive operations environment
Analyze, design, write test scripts and perform end-to-end testing of real-time and bath integrations between multiple systems
Responsible for Data Mapping/Integration of several internal data tables for screening messages in production and test environments
Provide system testing, analysis, implementation and ongoing maintenance of WRCT internal databases
Enhancement of WRCT internal databases to allow for continual development of the teams workflow needs.
Perform alongside of the team, and assist the DA’s with BAU needs for development and maintenance of stored procedures in Python,
SQL, VBA, and SharePoint;
Act as a team of SMEs to assess WRCT internal needs, understand requirements, requirements fulfilment, and present solutions for
continual workflow processes to remain in good standings and be performed on time;
Articulate observations into presentations of Repeat Offenders to Senior Management;
Ensure current Wire Room Compliance Analysts (“CA”) are sufficiently supported in BAU environment; and
Back up WRCT’s Data Analysts needs using Python, SQL, VBA, and SharePoint management
Skills ,
Competencies,
and Experience
Preferred
Bachelor's degree required;
2 years of experience with data modeling, staging, ETL, data warehouse 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