Job Location : New York,NY, USA
Major bank in Manhattan seeks Resolution Planning Project Manager and Data Analytic Specialist for long term hybrid contract role in NYC
Looking for data analyst to perform strong analysis of data point from different sources to straighten the control plan and identify the gaps
- Proficient in MS Access - advanced level
- Advanced Excel skills (pivot tables, VLOOKUP/XLOOKUP, Power Query, VBA)
- PowerBi a plus
- Maintain the MS Access database
- Understanding of financial institution and critical process
- Reconcile process, data, applications, vendors, contracts
- Know how to identify the gaps in datasets
- Write complex queries and also work on reports
The Operational Resilience Department enables the bank to effectively manage business threats and mitigate risk of disruptions. The department ensures readiness of each entity as well as the ability to respond adequately to disruptive events, minimizing the impact on the services delivery of the bank's critical operations
The department addresses both Resilience Transformation and Resilience Operations. The transformation aspect encompasses resilience strategy, program execution, and the development of new capabilities across the organization. Resilience operations provide visibility and readiness in daily activities, including new product launches, continuity testing, and event or crisis management
The functions performed span all lines of business and corporate functions across the region to mitigate risks and disruptions through an efficient and sustainable framework, effectively reducing risk and enabling the bank to meet growing business expectations and regulatory requirements.
Role:
One of the key components of the Resolution Plan is the identification and ongoing maintenance of Resolution Critical Services
Document and implement Resolution Planning Critical Services requirements including changes to the existing business continuity planning process and adding quarterly critical services, dependent resources, and key personnel data quality and reconciliation processes
Document and execute the new controls and quality checks
Coordinate and manage the data consolidated from various sources to enable the identification of Resolution Critical Services
Optimize and maintain the Access database used to aggregate and enrich the dataset
Ensure implemented Resolution Critical Services are documented, tested, sustainable and repeatable in the event of the firm was to ever go into resolution.
Requirements:
5 years of experience with several years of experience in the financial services industry preferably in an Operational Resilience, Business Continuity Planning capacity
Proficient in MS Access queries, forms, reports, VBA
Advanced Excel skills- pivot tables, VLOOKUP/XLOOKUP
Experience in the use of dashboarding tools such as Power BI, or Excel dashboards
Experience writing policy and procedure documents
Strong analytical and problem-solving skills
Working knowledge of US financial services regulatory requirements associated with Operation Resilience, Business Continuity and Disaster Recovery A PLUS
Strong project management skills and proven experience leading and delivering projects
Plan and schedule project timelines and milestones using appropriate tools
Track project milestones and deliverables
Develop and deliver progress reports, proposals, requirements documentation, and presentations
Set and continually manage project expectations with team members and other stakeholders
Strong analytical and problem-solving skills
Bachelor's Degree or higher