Program Analyst – Frederick, MD

Rohde & Schwarz GmbH & Co.; Frederick (MD); Hybrid; USD 90,000 - 120,000; Full time

Job summary

Rohde & Schwarz GmbH & Co. is seeking a forecasting analytics professional to lead program-level forecasts for scope, schedule, cost, and resources.

You will partner with program managers and finance to build integrated multi-workstream plans, refine forecasting models, and deliver executive reports and dashboards to drive data‑driven decisions. The role requires translating technical findings into business insights, maintaining strong Excel models with Pivot, Power Query, and VBA where

Qualifications

• Experience building forecasting models for programs or projects.
• Strong Excel skills including pivot tables and formulas.
• Ability to translate data into actionable insights.
• Experience with dashboards and executive reporting.

Responsibilities

• Develop and maintain forecasts for scope, schedule, cost, and resources.
• Partner with program managers to build integrated plans across multiple workstreams.
• Refine forecasting models for accuracy and responsiveness to changing conditions.
• Design Excel-based models, dashboards, and reporting tools (Pivot, Power Query, Power Pivot, formulas, macros/VBA).
• 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 insights and recommendations.
• Support governance forums with 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.

Skills

Forecasting

Excel modeling

Data analysis

Dashboards

Power Query

Power Pivot

VBA

Cross-functional collaboration

Executive reporting

Tools

Excel

Power Query

Power Pivot

VBA

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.