Program Analyst

Job Title - Program Analyst
Location: San Diego, CA
Duration: 3 Months

Position Summary
The ideal candidate will have strong analytical skills, advanced Excel capabilities, experience with reporting tools such as Tableau or Power BI, and the ability to create executive-level reports and presentations. This role requires close collaboration with engineering, finance, procurement, and cross-functional stakeholders to ensure accurate project tracking, financial planning, and operational reporting.

Required Skills
Advanced Microsoft Excel (Pivot Tables, Charts, Reporting, Data Analysis)
Basic SharePoint Administration and Content Management
Experience with at least one reporting/visualization tool (Tableau, Power BI, etc.)
Strong analytical and problem-solving skills
Excellent written and verbal communication skills
Team-oriented mindset with a willingness to learn

Required Technologies
Microsoft Office Suite (Excel, PowerPoint, Word)
SharePoint
Tableau, Power BI, or equivalent reporting tools

Education & Experience
Associate's Degree in Business Administration, Management, Computer Science, Engineering, or related field
2-3 years of relevant project coordination, PMO, reporting, or business operations experience

Key Responsibilities
Project & Program Coordination
Support Program Managers in planning, tracking, and executing project activities.
Maintain project schedules, milestones, deliverables, and resource plans.
Coordinate with internal teams and external stakeholders to ensure project objectives are met.
Prepare meeting agendas, capture action items, and document project updates.
Escalate project risks, issues, and schedule changes when necessary.

SharePoint & Reporting
Design, create, and maintain Multimedia SharePoint and Wiki pages.
Develop SharePoint dashboards to track project status, milestones, and key metrics.
Generate reports and presentations for engineering leadership and management teams.
Deliver data-driven insights through dashboards, charts, and visual reports.
Financial Planning & Budget Management
Operational Expenditures (OpEx)
Track monthly budget changes and summarize financial performance.
Identify budget variances and collaborate with finance teams to address concerns.
Create budget walk presentations for management reviews.

Capital Expenditures (CapEx)
Support engineering teams in preparing financial content for investment reviews.
Coordinate with procurement teams to facilitate purchases and ensure PO accuracy.
Track capital spending and provide budget updates.

Project Cost Planning
Monitor planned versus actual spending across projects.
Track headcount-related expenses and hardware non-recurring engineering (HW NRE) costs.
Analyze spending trends and provide recommendations for cost optimization.

Headcount & Resource Planning
Support department-level headcount planning and forecasting activities.
Coordinate project-level workforce planning submissions.
Track consultant budgets and collaborate with finance analysts to ensure accuracy.

Product Cost Analysis
Monitor Cost of Test (COT) metrics and establish standardized tracking methodologies.
Analyze quarterly cost variances and prepare executive reports.
Partner with business units to align cost model structures.

Executive Communications
Develop concise executive presentations and management reports.
Present financial and operational metrics to leadership teams.
Recommend cost-saving initiatives and quantify business impact.