Program Analyst

Program AnalystLocation: San Diego, CA Duration: 3 MonthsPosition 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 learnRequired Technologies: Microsoft Office Suite (Excel, PowerPoint, Word) SharePoint Tableau, Power BI, or equivalent reporting toolsEducation & 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 experienceKey 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.