Associate Business Analyst/ Data Analyst
San Ramon, CA
Job title: Associate Business Analyst/ Data Analyst
Location: San Ramon, CA
Description:
OPEN TO CANDIDATES IN CALIFORNIA ONLY. NO ADDITIONAL EXPENSES ARE ELIGIBLE FOR REIMBURSEMENT (i.e., internet, cell phone, mileage, travel related, etc.).
ASSIGNMENT IS HYBRID WITH APPROXIMATELY 1 MONTH IN PERSON TEAM MEETING WHEN NEEDED.
TOP THINGS LOOKING FOR:
- Experience with PowerBI and Excel. 40 hour workweek availability.
SOURCING DATA COMPILATION, ANALYSIS, AND PRESENTATION:
- Maintain Service category databases.
- Perform SAP and Access queries to analyze and summarize data for presentation to decision makers.
- Review unit cost variances and reconcile contract deviations.
- Track key performance indicators and commodity indices to verify supplier increase requests, identify cost saving opportunities, elevate possible threats, and inform contract negotiations.
- Create new tools and processes where needed.
- Maintain awareness of industry and market trends through ongoing research.
- Maintain develop reports and management presentations.
CONTRIBUTE TO STRATEGIC SOURCING AND PROCUREMENT STRATEGIES:
- Support spending analysis, needs assessment, benchmarking and business case development.
- Identify potential cost savings, spend reduction, supplier consolidation and standardization opportunities.
- Assist Generation Supply Chain Portfolio Manager and Category Leads with supplier selection and recommendation activities including: qualitative and quantitative analysis, selection criteria, long and short lists, RFI and RFP development and analysis.
SUPPLIER RELATIONSHIP MANAGEMENT:
- Monitor financial condition of suppliers to proactively identify solvency risks and recommend mitigation strategies.
- Track supplier quality, cost and contract performance.
- Define, develop, and implement supplier scorecard metrics and measurement tools. Qualifications
Minimum Qualifications
- 2 + years of experience in business or financial analysis
Desired Qualifications
- Bachelor's degree in business or economics (or related industry experience)
- Strong interpersonal skills, a team focus, and the ability to work in cross- functional teams
- Excellent quantitative skills, with demonstrated proficiency in data analysis (SAP/MS Access), modeling (MS Excel), and presenting (MS PowerPoint)
- Knowledge of basic statistics