Business Data Analyst

Motion Recruitment; Getzville (NY); Hybrid; USD 80,000 - 110,000; Full time

Job summary

Join a leading global bank as a Business Data Analyst in a hybrid role based in Getzville, NY. This contract position offers the opportunity to influence resource planning and improve processes while collaborating with project managers and senior management. You will leverage your data analysis and automation skills to manage complex datasets and provide insights that impact the business strategy. Enjoy benefits like medical insurance and a 401(k) plan while working in a dynamic environment.

Benefits

Medical Insurance

Health Savings Account (HSA)

401(k)

Paid Sick Time Leave

Pre-tax Commuter Benefit

Qualifications

• 5+ years of experience in Data Analysis.
• Proficient in managing complex data sets.
• Strong communication and diplomacy skills.

Responsibilities

• Manage vendor resource management and head count details.
• Provide reports and analysis to senior managers.
• Promote process improvement through identifying gaps.

Skills

Data Analysis

Automation skills

Analytical skills

Communication

Education

Bachelors/University degree

Tools

Microsoft Excel

Job description

12 Month Contract (Possible Extension)

Hybrid/ 2-3 Days Onsite (Client located in Getzville, NY)

Work Schedule

Full Time – Monday-Friday

*Must be local to the Getzville, NY area

*Must be able to work on W-2 Basis

About the Company

Grow your career as a Business 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.

Job Description

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.

Skill Requirements

• 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.

Required Skills

Automation skills (Macros/scripts) and look up skills (Vlookup, Xlookup, Conditional formatting, PIVOT tables and Joins) are mandatory

Education

Bachelors/University degree or equivalent experience in Budgeting/Financial background

You will receive the following benefits:

Medical Insurance & Health Savings Account (HSA)

401(k)

Paid Sick Time Leave

Pre-tax Commuter Benefit

Applicants must be currently authorized to work in the United States on a full-time basis now and in the future.

Motion Recruitment provides IT Staffing Solutions (Contract, Contract-to-Hire, and Direct Hire) in major North American markets. Our unique expertise in today’s highest-demand tech skill sets, paired with our deep networks and knowledge of our local technology markets, results in an exemplary track record with candidates and clients.