Business Office Management Data Analyst

Grow your career as a Business Office Management Data Analyst with an innovative global bank in Getzville, NY. Contract role with strong possibility of extension. Will require working a hybrid schedule 2-3 days onsite per week.

Join one of the world's most renowned global banks and trusted brand with over 200 years of continuously evolving financial services worldwide. Will have significant impact in global footprint and resourcing strategy by influencing decisions through advice, counsel and/or facilitating hiring for the hiring managers. You will work alongside some of the smartest minds in the industry who are excited to share their knowledge and to learn from you.

Contract Duration: 12+ Months

Required Skills & Experience

• Bachelors/University degree or equivalent experience in Budgeting/Financial background
• 5+ years of experience of Data Analysis.
• Must be capable of organizing and managing complex and dynamic data sets.
• Advanced understanding of Microsoft Excel (advanced look ups/ Pivot tables/ conditional formatting/MACROs/data slicers and filters)
• Understanding of manual data assimilation, cleaning, and organizing them in tabular/graphical format for Sr. Management reporting.
• Automation skills (Macros/scripts) and look up skills (Vlookup, Xlookup, Conditional formatting, PIVOT tables and Joins) are mandatory
• Analytical skills to filter, prioritize and validate potentially complex and dynamic financial data points.
• Proficient understanding of end-to-end head count management processes (internal backfill/incremental requests and vendor contracts for fixed price) and resource data metrics (number of heads sourced, utilization, cost metrics, assignment, actuals vs the forecast) obtained from different vendors to coordinate and contribute to the objectives of the function and overall business.
• Strong communication and diplomacy skills are required.
• Ability to monitor tight deadlines or unexpected requirement changes
• Able to manage a small team in this space.

What You Will Be Doing

• Primary focus will be vendor resource management, overseeing resource management for global contractor population of vendor resources, ensure timely onboarding, renewals and roll offs.
• Will apply in-depth disciplinary expertise to track, maintain and monitor the head count details (internal and contracted per Vendor commitments) of a specific line of business.
• Regularly assumes leadership role within the project management/development teams.
• Work closely with project managers/ leads, Staffing office and Procurement to facilitate the execution of vendor work orders/Statements of Work(SOW) and amendments as required.
• Summarize budgets and submit recommendations for the approval or disapproval of funds requests Head Count management - source information, manage and monitor Head Count data (employees and non-employees) from Vendor reports and internal requisitions and present the data in various formats per executive management request.
• Maintains a central repository of resource count, project assignments, and other relevant information for weekly reporting.
• Provides technical expertise to manage and automate manual data sets using advanced Excel and data management techniques.
• Provide reports and analysis to senior managers to identify savings/re-balancing opportunities and support for strategic planning.
• Developing, analyzing, and maintaining metrics for measuring success, opportunities for improvement, management reporting and escalation.
• Responsible for delivery of end results and contributes to planning, budget asks and formulation of procedures which directly impacts the business analysis area, influences resource planning for savings. Promote process improvement in all areas involved through proactive identifications of gaps and risks.
• Create and maintain process standards/ methodologies and best practices.