Program Analyst – Frederick, MD

Rohde & Schwarz; Maryland; On-site; USD 83,000 - 110,000; Full time

Job summary

Rohde & Schwarz is seeking a highly analytical Program Analyst to support complex program planning, forecasting, and performance tracking in our PMO. This role requires onsite presence several days per week in Frederick, MD and US citizenship is required.

You will build integrated plans, refine forecasting models, and deliver executive reports using advanced Excel, Power Query/Power Pivot, and Power BI. Strong communication with senior stakeholders is essential.

Qualifications

• Bachelor’s degree in Business, Finance, Engineering, Data Analytics, or a related field.
• 5+ years of experience in program analysis, PMO support, or a similar analytical role.
• Advanced Excel expertise including complex formulas, Pivot tables, and Power Query/Power Pivot.
• Experience with large, cross-functional programs and presenting insights to senior stakeholders.

Responsibilities

• Develop and maintain forecasts for program scope, schedule, cost, and resources.
• Partner with program managers to build integrated multi-workstream plans.
• Refine forecasting models to improve accuracy and responsiveness.
• Design Excel-based models, dashboards, and reporting tools (Pivot, Power Query/Power Pivot).
• Analyze large datasets to identify trends, risks, and optimization opportunities.
• Produce executive-level reports and visualizations for decision-making.
• Track KPIs, milestones, and deliverables against plan.
• Conduct variance analyses (forecast vs actuals) and provide insights.
• Support governance forums with status reports and risk summaries.
• Assist budgeting, forecasting and cost tracking for complex programs.
• Model resource demand and capacity planning across projects.
• Identify risks and propose mitigation strategies.
• Collaborate across program managers, finance, operations, and leadership.
• Translate findings into clear business insights and support strategic planning.

Skills

Advanced Excel

Data Analysis

Forecasting

Cross-functional Collaboration

Executive Communication

Education

Bachelor's degree in Business, Finance, Engineering, Data Analytics, or related field

Tools

MS Project

Smartsheet

Power BI

Jira

Pivot Tables

Job description

Recently named by Newsweek as one of the Best American Mid-Sized Workplaces in 2026, we are seeking a highly analytical and detail-oriented Program Analyst to support complex program planning, forecasting, and performance tracking within our Program Management Organization. The ideal candidate brings advanced Excel proficiency, strong business acumen, and the ability to translate data into actionable insights that drive program success. This position requires a few days each week onsite in our Frederick, MD office. US Citizenship is required.

Your tasks

• 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.

Your Qualifications

• Bachelor’s degree in Business, Finance, Engineering, Data Analytics, or a related field.
• 5+ years of experience in program analysis, PMO support, or a similar analytical role.
• Advanced Excel expertise is required, including complex formulas (INDEX/MATCH, XLOOKUP, array formulas), Pivot tables and charts, data modeling and scenario analysis, Power Query / Power Pivot (preferred). VBA/macros expertise is preferred.
• Strong analytical and problem-solving skills with high attention to detail.
• Experience supporting large, complex, cross-functional programs.
• Excellent communication skills with the ability to present data insights to senior stakeholders.
• In order to be considered, candidates must reside in the US and be a U.S. citizen capable of receiving a US Government security clearance or public trust. Preferred Qualifications:
• Experience with program/project management tools (e.g., MS Project, Smartsheet, Power BI, Jira).
• Familiarity with financial modeling and forecasting methodologies.
• Knowledge of PMO best practices and governance frameworks.
• Experience working in fast-paced, matrixed environments.

Interested?

The total compensation for this position is $83K-$110K. Total compensation includes base salary, variable pay (when applicable) plus benefits. The range is determined by the position, geographic location and level. Individual pay within the range is determined by several factors including location, education or training, relevant work history, sales incentive structure and job-related skills.

Rohde & Schwarz is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to sex, race, color, religion, national origin, disability, protected Veteran status, age or any other characteristic protected by law.

Rohde & Schwarz is a global technology company with approximately 14,000 employees and three divisions: Test & Measurement, Technology Systems and Networks & Cybersecurity. For 90 years, the company has been developing cutting-edge technology, pushing the boundaries of what is technically possible and enabling customers from various sectors such as business, government and public authorities to maintain their technological sovereignty.