Title: IT Planning Analyst
Location: Must be on site once a week in Oakland area
Duration: 6 months
Excel Assessment required on pre- screen
MUST HAVE GREAT COMMUNICATION
Job Responsibilities/Qualifications
Assist with the daily contract operations and provide general IT business & planning support.
- Prepare reports through gathering, analyzing, and summarizing data and information; prepares presentation materials for management reports.
- Assist in the initiation, conducting and coordinating of contract renewal analysis for IT operations, financial reviews; and analyzing multi-year contract to ensure that costs are planned in the most efficient manner.
- Maintain annual Operational Expense budgets utilizing proper accounting/budgeting controls, enter financial data into tracking system, and compile regular and ad-hoc financial status reports.
- Monitor Purchase Orders, review contract invoices, accruals, identify disparities, and resolve issues with the vendors.
- Analyzes actual spend and forecasting to determine if/when appropriate change controls and escalation reporting to leadership.
- Provides financial analysis on portfolio cost variances for plan vs. actual and can identify inappropriate charges by resources or vendors and makes appropriate corrections in SAP.
- Leads meetings and acts as a liaison among stakeholders to coordinate, document, and schedule changes to IT contracts.
- Capture, analyze and present data to managers and directors to aid in making business decisions.
- Effectively plans and control scope of work on contract renewals; integrates all aspects, tracks and ensures that contracts origination targets are on schedule and meets the required standard.
- Develops communications needed to summarize analysis and to discuss recommendations for IT management. This may take the form of dashboards, power point decks, or summarized emails.
- Facilitates problems solving sessions and workshops with diverse set of business and technology team members.
- Proactively follows-up on issues and initiatives for senior leaders to ensure successful resolution and implementation.
- Works closely with leaders and other key stakeholders to ensure that key initiatives and activities are delivered in a timely and coordinated manner that is aligned with the goals of the organization.
- Works with the data management team to build new tools and assist with creation and migration of reports to Power BI.
- Experience with downloading and extracting data from SAP into meaningful business intelligence reports and dashboards.
- Works with IT and functional leadership to establish a variety of key business, financial and performance metrics.
Qualifications
Minimum:
- BA/BS in Computer Science, Business, or job-related discipline or equivalent experience
- 4 years of general business experience
Desired:
- Proficient in Microsoft Office, Visio, PowerPoint and expert level Excel skills
- Experience with structuring contract agreements
- Experience with basic financial modeling or data management
- Experience with presenting to leadership and developing power point slides
- Experience with Power BI a plus