As a Location Strategy Professional in our Finance team you will spend each day defining, refining and delivering set goals for our firm.
Job Responsibilities
- Partner with CCB (Consumer and Community Banking) Location Strategy and Logistics teams to manage the Headcount Location Planning (HLP) process and seat management
- Receive and analyze data feeds from HR, financial, and real estate systems to produce location-driven reporting and dashboard updates
- Update cost center mapping tables monthly to reflect organizational changes for reporting purposes
- Create and update monthly headcount location demand vs. seat supply reports for building-level capacity management
- Develop month-end resource rosters incorporating detailed location data from CCB headcount and global real estate feeds
- Maintain and update various seat supply/demand reports for strategic planning and real estate negotiations
- Perform budget cycle reporting activities, including location validation testing and creation of data source reports for budget presentations
- Conduct monthly database maintenance, including query and reference table updates for reporting
- Translate senior leadership requests into actionable deliverables and automate reporting to improve efficiency
- Conduct ad-hoc data mining, reporting, and analysis as needed, while driving process improvements and resolving data quality issues
Required qualifications, capabilities, and skills
- Over 8+ years of experience in reporting and data mining, particularly with large datasets in Excel
- Strong experience in data mining and problem-solving
- Self-motivated, detail-oriented, with a high degree of ownership and accountability
- Excellent qualitative and quantitative analytical skills. Effective time management and multitasking abilities to meet deadlines
- Ability to collaborate with others and work independently with minimal direction
- Strong analytical and logical thinking skills, adept at understanding complex business processes
- Proven track record in resolving project-related issues and meeting objectives
- Experience working with diverse stakeholders to document business requirements and processes
Preferred qualifications, capabilities, and skills
- Advanced skills in Alteryx and Excel; knowledge of SQL, SharePoint, and VBA is a plus