Data Analyst Compliance.New York Compliance

Job Title: Compliance Data Analyst – US Correspondent Banking Compliance

Location: MGN, India (MBNY’s dedicated team)

Department: BSA/AML & Sanctions Compliance, Mashreq Bank, New York (“MBNY”)

Reports To: To be decided

Job Summary 

We are seeking a highly skilled Data Analyst to support the Transaction Monitoring System Analytics Manager with both BAU and ad‑hoc analytical initiatives. This role will focus on developing, optimizing, and automating compliance data analytics, MIS, and regulatory reporting to support AML, sanctions, and correspondent banking oversight.

The ideal candidate combines strong SQL development skills, advanced Excel/VBA automation, and a solid understanding of compliance data requirements in a regulated banking environment.

Key Responsibilities

• Design, develop, and maintain SQL queries used for management reporting and regulatory submissions.
• Build and enhance Excel-based automation tools and reporting dashboards using VBA.
• Create automated workflows and integrations using SharePoint Online and Power Automate.
• Collaborate with Compliance, Operations, and Technology teams to support tuning cycles, model updates, and production monitoring.
• Provide timely analytical support for production issues, data investigations, and system changes.
• Maintain clear documentation for queries, processes, and reporting logic.

Technical Qualifications

• Strong SQL across large datasets; ability to design indexing/partitioning strategies and optimize query plans.
• Proficiency in writing stored procedures, functions, and packages (T-SQL/PL-SQL/PLpgSQL).
• Excel advanced skills: macros/VBA, Power Query, pivot tables, and automation for MIS.
• Exposure to reporting/BI tools (e.g., Power BI, Tableau) for MIS and KPI visualizations.

Core Competencies

• Strong analytical and problem‑solving abilities in complex data environments.
• Clear, concise communication skills suitable for both technical and non‑technical audiences.
• Ownership mindset with urgency in production support and excellent documentation discipline.
• Collaborative, solutions-oriented approach when working with Compliance, Operations, and Technology stakeholders.

Experience

• 5–7 years of hands‑on technical experience as a Data Analyst within a financial institution, preferably a bank or regulated financial services organization.
• Proven experience working with banking data, including transactional, customer, and compliance‑related datasets.
• Demonstrated ability to translate regulatory and compliance requirements into data analytics, MIS, and reporting solutions.
• Experience supporting compliance, risk, audit, or regulatory reporting functions in a financial institution.