Program Analyst – Frederick, MD
Key Skills for This Role
Full Job Posting
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.
Exciting insights into Rohde & Schwarz
Our colleagues provide insider information about:
Daily adventures and challenges
Our passionate team
The technologies behind the innovative projects and solutions
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.
About Rohde & Schwarz
Global technology company specializing in electronics, communications, and cybersecurity.
Visit company websiteJobs and hiring trendsApply for this job in 1 click
Skip the repetitive application forms
Install the Base Career Chrome Extension and autofill job applications across major job boards with your profile.
Trusted by over 500,000 job seekers on Base Career
More from this employer
More jobs at Rohde & Schwarz
Testjob APAC
New Delhi, IND
Test System Support – RF & Digital
Bengaluru, IND
SAP FI Consultant
Bengaluru, IND
Test system Support
Bengaluru, IND
APACMEA.ABTest
Adelaide, AUS
Contracts Manager - Columbia, MD
Columbia, USA
Business Development Manager – Space and Satellite
, USA
Senior Contracts Manager
, USA