Program Analyst (Junior/Mid)

R&P Technologies • Bath, ME

48d • Onsite

About The Position

R&P is looking for a professional who wants to join our team. We are a small-sized defense contractor providing Engineering, Logistics, Program Management and Technical Services to government clients. We are seeking a motivated Junior or Mid-Level Program Analyst ready to join a fast-paced and exciting work environment. This position offers the opportunity to support shipbuilding oversight and acquisition management efforts for the U.S. Navy. Responsibilities This position primarily involves the extraction, processing, and analysis of raw shipyard data from various systems. This position requires sorting, analyzing and repackaging that data into standard weekly reporting formats and upload into Tableau system for creation of visualizations. It requires a high proficiency in Microsoft Excel and a solid understanding of Microsoft Access, along with proficiency in Microsoft Word and PowerPoint. The person selected for this position will work closely with senior management to review the metrics generated by the Tableau system and provide insights into what the data is telling. They will be responsible for ensuring the accuracy of the data and generating customized dashboards and visualizations using Tableau to support program reviews and quarterly deliverables. We will train selected candidates on the details of the information and functions. Key responsibilities include: Data Extraction & Processing: Extract raw data from shipyard tools and systems. Format and process the raw data using Microsoft Excel, Access, Microsoft VBA, Power BI and Python to ensure it is properly prepared for entry into the Tableau system. Generate text charts, graphs and tables Enter processed data into Tableau and verify data integrity. Data Analysis & Reporting: Monitor and review Tableau-generated metrics to identify trends, anomalies, and insights. Analyze the data to provide actionable insights that support decision-making for ship construction efforts. Create custom dashboards and visualizations in Tableau to display key performance indicators and metrics for program reviews and quarterly deliverables. Support Program Management & Administrative Functions: Assist in the development and maintenance of project plans and schedules. Provide backup for coordination of program management office operations, including schedule management, communication, and document preparation. Generate quarterly reports, including SPR PMR packages and PEO Ships Portfolio Packages.

Requirements

• High level of proficiency in Microsoft Excel for data processing and analysis.
• Proficiency in Microsoft Access and Microsoft Word.
• Strong attention to detail and self-motivation
• Excellent written and verbal communication skills.
• Position requires daily presence at the Government site and is not remote, although portions of some workdays could be conducted remotely.
• Secret Clearance. Will entertain working with highly qualified candidates that are able to obtain a clearance.

Nice To Haves

• Experience with program management software tools, including but not limited to Tableau (for dashboard creation) and Python or VBA (for automating and processing data).
• Familiarity with DoW/DoN acquisition processes and shipbuilding oversight
• Experience communicating with senior management and stakeholders, including program and project managers.
• Degree: Bachelor's degree in a relevant field preferred but not required
• Strong analytical and problem-solving abilities, particularly with large datasets.
• Ability to format and automate data processing workflows using Python or VBA.
• Ability to integrate data across various systems to ensure accuracy and consistency.
• Experience with data visualization and dashboard creation using Tableau to support decision-making.

Responsibilities

• Extract raw data from shipyard tools and systems.
• Format and process the raw data using Microsoft Excel, Access, Microsoft VBA, Power BI and Python to ensure it is properly prepared for entry into the Tableau system.
• Generate text charts, graphs and tables
• Enter processed data into Tableau and verify data integrity.
• Monitor and review Tableau-generated metrics to identify trends, anomalies, and insights.
• Analyze the data to provide actionable insights that support decision-making for ship construction efforts.
• Create custom dashboards and visualizations in Tableau to display key performance indicators and metrics for program reviews and quarterly deliverables.
• Assist in the development and maintenance of project plans and schedules.
• Provide backup for coordination of program management office operations, including schedule management, communication, and document preparation.
• Generate quarterly reports, including SPR PMR packages and PEO Ships Portfolio Packages.

Benefits

• R&P offers a highly competitive compensation package that includes contributions towards health insurance, 401(k) matching, and other non-salary benefits.

What This Job Offers

• Job Type: Full-time
• Career Level: Entry Level
• Number of Employees: 251-500 employees