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.
The leading financial institution in MENA
While more than half a century old, we proudly think like a challenger, startup, and innovator in banking and finance, powered by a diverse and dynamic team who put customers first. Together, we pioneer key innovations and developments in banking and financial services. Our mandate? To help customers find their way to Rise Every Day, partnering with them through the highs and lows to help them reach their goals and unlock their unique vision of success. Delivering superior service to clients by leading with innovation, treating colleagues with dignity and fairness while pursuing opportunities that grow shareholders value. We actively contribute to the community through responsible banking in our mission to inspire more people to Rise.