Job Details

Financial Crimes MIS Analyst

NEW YORK-10021, NY, US
11/29/2018

-


Required Skills

    VBA scripts, Microsoft Powershell
Company

Infinity Consulting Solutions, Inc

Experience

-

Job Description

The NY Branch of a foreign bank is looking for Financial Crimes MIS Analyst. The Analyst will:

Support the Compliance MIS Process Owner with enhancing the Branch's MIS reporting process and revamping the current MIS reporting process with a focus on automation, intuitive-design, visualizations, addition of data points, and inclusion of additional workstreams.

Analyze available data for the Branch's BSA/AML and OFAC Program to identify potential data points for inclusion in the Branch's MIS and devise strategies for the creation of reporting decks.

Perform data manipulation and data aggregation to present available data in a manner that is easy to understand, interpret, and visualize.

Assist with designing reporting decks covering volumetric trends, productivity, aging, etc.

Assist with designing and creating SharePoint sites for the Branch Compliance Department.

Assist with migrating manual processes and spreadsheets to SharePoint lists and linking reporting dashboards to the SharePoint lists in order to automate the process of data extraction.

Assist with the enhancement and maintenance of the Compliance MIS Framework.

Assist the Compliance MIS Process Owner and Head of Compliance Technology, Transformation, and Assurance, with all technology related projects and initiatives, including but not limited to, transformation, data migration, data validation, system implementations, user acceptance testing, creation of BRD's, etc.

Maintains knowledge of developments in the area of BSA/AML and OFAC compliance, including FRBNY, NYSDFS, and FinCEN regulations.





5. QUALIFICATIONS AND EXPERIENCE





2 – 3 years of prior reporting, data analysis, and MIS experience with specific emphasis on BSA/AML and OFAC is required.

Prior BSA/AML transaction monitoring or sanctions filtering experience would be preferred.

Must be able to demonstrate knowledge of MIS reporting principals, data analysis, aggregation, and manipulation, BSA/AML and OFAC regulatory requirements.

Prior experience with Microsoft SQL, building SQL queries, building database connections in Excel files.

Prior experience writing VBA scripts in Microsoft Office Suite Applications, building macros, and performing task automation.

Prior experience with Microsoft Powershell would be highly preferred.

Prior experience with data visualization tools such as Tableau, Tibco Spotfire, or Microsoft Power BI.

Expert level experience with Microsoft Excel, pivot tables, power pivot.

Previous experience with the following skills is required:

Strong leadership and interpersonal skills with the ability to interact effectively with team members.

Excellent written and verbal communication skills.

Excellent analytical and problem resolution skills.

The ability to prioritize and complete deliverables in a timely and effective manner.

Competency with BSA/AML and OFAC compliance monitoring systems.

Level of proficiency in Prime and/or a transaction monitoring program.

Individuals with required education/experience plus Certified Anti-Money Laundering Specialist (CAMS) certification would be preferred.



FINANCIAL ANALYST
Accounting & Finance

No Preference
Contract Only
Other
1

Candidate Requirements
-
Bachelors

Walkin Information
-
-
-

Recruiter Details
Doug Klares
1350 Broadway, Suite 2205, NEW YORK-10018, NY, US
-