Program Management Analyst with Security Clearance

IntelliSys Solutions Group; Philadelphia (Philadelphia County); On-site; USD 50,000 - 54,000; Full time

Benefits offered by this job

401(k)

Health insurance

Dental insurance

Vision insurance

Paid time off

Job summary

IntelliSys Solutions Group is seeking a Program Management Analyst to support financial planning and project execution for a DoD-focused team. On-site engagement with embedded roles within a government project, requiring strong analytical and reporting skills.

The candidate will develop dashboards, perform data-driven forecasting, and contribute to earned value management to assess schedule and profitability. A DoD clearance or government experience is essential.

Qualifications

• Bachelor's degree in a business-related field (Accounting/Finance/Economics).
• Active DoD security clearance or government experience required.
• Strong Excel and data visualization skills with pivot tables and advanced functions.

Responsibilities

• Create detailed Excel dashboards showing funds received, spent, projections, and manpower estimates.
• Use Tableau/Power BI to visualize data insights for management.
• Analyze large datasets with SQL and Excel to produce accurate financial reports.
• Prepare financial reports and presentations highlighting key insights.
• Collaborate with cross-functional teams on budgeting, forecasting, and financial modeling.

Skills

Excel advanced functions

Financial analysis

Data visualization

SQL querying

Power BI/Tableau

Communication

Time management

Education

Bachelor's degree in Business/Finance

Tools

Tableau

Power BI

SAP

Excel

Job description

Program Management Analyst Clearance: Active Department of Defense security clearance or experience working for US government entities

Pay: $50,000.00 - $54,000.00 per year

Work Location: In person/On site

Job description

IntelliSys Solutions Group is an engineering and project management consulting firm headquartered in Philadelphia PA. Our team of software developers, engineers, and business analysts work together to improve automation, streamline logistics, and establish quality control for government organizations. Job Summary In this role, the Program Management Analyst candidate would be asked to support the financial and project planning needs of a division, supporting leadership with organizational functions, and helping facilitate the needs of a core group of engineers working on mission critical tasks. ISG has comparatively placed analysts and engineers on-site for support, training, and guidance, however the Program Management Analyst will be expected to work semi-independently as an embedded resource within a DOD team. Candidate must have an active Department of Defense security clearance or experience working for US government entities.

Specific duties may include

• Creating detailed excel dashboards to provide comprehensive financial overview of funds received, funds spent, projections, individual project breakdowns and manpower estimates.
• Utilize business intelligence tools such as Tableau, Power BI, and VBA to visualize data insights effectively
• Collect, organize, and analyze large datasets using SQL, Excel pivot tables, and Excel data analysis tools for accurate financial reporting
• Prepare comprehensive financial reports and presentations for management that highlight key insights and recommendations.
• Conduct quantitative research and analysis to evaluate investment opportunities, financial risks, and profitability metrics.
• Collaborate with cross-functional teams on strategic planning initiatives involving budgeting, forecasting, and financial modeling
• Develop strategies for managing ongoing projects incorporating Earned Value Management to assess whether the project is on schedule, at risk, or falling behind
• Some administrative duties such as organizing and attending key meetings, capture discussions, and producing concise, accurate meeting minutes for distribution, scheduling and coordinate meetings with Subject Matter Experts (SMEs) and other stakeholders

Qualifications

This position requires a Bachelor's level degree in a Business-Related Field such as Accounting, Finance, Economics to apply. The ideal candidate will take pride in being organized and will be able to set appropriate work priorities independently. Strong attention to details/deadlines and the ability to timely follow-up are preferred, along with proficiencies in certain traits/skills; Required: Must have an active Department of Defense security clearance or experience working for US government entities.

• Effective communication skills for writing clear financial reports and delivering insights through data visualization tools
• Proficiency in Microsoft Excel that includes advanced functions like pivot tables, vlookups, and indexing.
• Strong knowledge of data visualization software like Tableau or Power BI
• Needs at least 2 years of experience in any field related to business metrics, financial management, financial reports, tracking schedule, cost performance tools, and databases.
• Experience with SAP or commercial off-the-shelf ERP software solution is considered a plus
• Experience with SQL for data collection and database querying is considered a plus At IntelliSys

At IntelliSys
IntelliSys Solutions is committed to increasing employment opportunities in historically underutilized areas (HUB Zones) and some recruitment efforts may give preference to applicants who reside in those certified areas. Check to see if your address is in the HUBZone at https://maps.certify.sba.gov. We are an equal opportunity employer, and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability status, protected veteran status, or any other characteristic protected by law. IntelliSys participates in the E-Verify program as required by law. Learn more about the E-Verify program at https://e-verify.uscis.go

Job Type

Full-time Pay: $50,000 – $54,000 per year Expected hours: 9-5, must keep the same hours as client

Key terms

Financial Analysis, Budgeting, Forecasting, Financial Modeling, Variance Analysis, Cost Analysis, Cash Flow Analysis, Financial Reporting, Data Visualization, KPI Tracking, Excel Expertise, Data Analysis, Dashboard Creation, ERP Systems, Financial Software, Power BI, Tableau, Python, R, Statistics, Advanced Excel, Strategic Planning, Business Partnering, Problem Solving, Process Improvement, Risk Analysis, Forecast Interpretation, Communication Skills, Attention to Detail, Time Management, Collaboration, ROI Analysis, Capital Planning, Scenario Modeling, Benchmarking, Decision Making, Microsoft Teams, Cross‑Functional Communication, Stakeholder Engagement, Organizational Skills, Problem Resolution, Meeting Facilitation, Documentation, Secret Clearance, Confidential Clearance, Department of Defense, Department of War, Federal Government, DCSA, DISS

Benefits

• 401(k)
• 401(k) matching
• Dental insurance
• Health insurance
• Health savings account
• Life insurance
• Paid time off
• Vision insurance