Program Analyst – Frederick, MD

Rohde & Schwarz; Frederick (MD); On-site; USD 90,000 - 130,000; Full time

Job summary

Rohde & Schwarz USA, Inc. seeks a Data-driven Forecasting and Analytics professional to develop and maintain program forecasts across scope, schedule, cost, and resources. You will partner with program managers to align plans across multiple workstreams and refine models as conditions change.

This role designs Excel-based models, dashboards, and reporting tools, analyzes large datasets for trends and risks, and produces executive-ready reports to inform strategic decisions and governance forums.

Responsibilities

• Develop and maintain comprehensive forecasts for program scope, schedule, cost, and resource utilization.
• Partner with program managers to build integrated program plans across multiple workstreams.
• Continuously refine forecasting models to improve accuracy and responsiveness to changing program conditions.
• Design and maintain sophisticated Excel-based models, dashboards, and reporting tools (e.g., pivot tables, Power Query, Power Pivot, complex formulas, macros/VBA if applicable).
• Analyze large datasets to identify trends, risks, and optimization opportunities.
• Produce executive-level reports and visualizations to support decision-making.
• Track program KPIs, milestones, and deliverables against plan.
• Conduct variance analysis (forecast vs. actuals) and provide clear insights and recommendations.
• Support governance forums by preparing status reports, risk summaries, and performance dashboards.
• Support budgeting, financial forecasting, and cost tracking for complex programs.
• Model resource demand and capacity planning across multiple projects and teams.
• Identify financial and operational risks and propose mitigation strategies.
• Work cross-functionally with program managers, finance, operations, and leadership teams.
• Translate technical and analytical findings into clear, business-friendly insights.
• Support strategic planning initiatives with data-driven recommendations.

Job description

• Develop and maintain comprehensive forecasts for program scope, schedule, cost, and resource utilization.
• Partner with program managers to build integrated program plans across multiple workstreams.
• Continuously refine forecasting models to improve accuracy and responsiveness to changing program conditions.
• Design and maintain sophisticated Excel-based models, dashboards, and reporting tools (e.g., pivot tables, Power Query, Power Pivot, complex formulas, macros/VBA if applicable).
• Analyze large datasets to identify trends, risks, and optimization opportunities.
• Produce executive-level reports and visualizations to support decision-making.
• Track program KPIs, milestones, and deliverables against plan.
• Conduct variance analysis (forecast vs. actuals) and provide clear insights and recommendations.
• Support governance forums by preparing status reports, risk summaries, and performance dashboards.
• Support budgeting, financial forecasting, and cost tracking for complex programs.
• Model resource demand and capacity planning across multiple projects and teams.
• Identify financial and operational risks and propose mitigation strategies.
• Work cross-functionally with program managers, finance, operations, and leadership teams.
• Translate technical and analytical findings into clear, business-friendly insights.
• Support strategic planning initiatives with data-driven recommendations.