Program Support Analyst

First Roles; Washington; On-site; USD 105,000 - 115,000; Full time

Benefits offered by this job

401(k)

401(k) contribution

Dental insurance

Medical insurance

Life & Disability insurance

Flexible spending account

Flexible schedule

Professional development

Work-life balance

Job summary

Constellation seeks a Program Support Analyst to join our Washington, DC team, evaluating processes, people, and technology for client operations. You'll collect, review, and analyze information to support the Department of Homeland Security’s law enforcement mission, delivering reports and presenting analysis to clients.

The ideal candidate has data management, analytics and dashboard creation experience, with a background as a government consultant.

Qualifications

• Bachelor’s degree in Business, HRM, or a related field.
• Minimum of 2 years’ experience with Power BI or similar visualization tools.
• Minimum of 4 years proven experience as a government consultant or support contractor.
• U.S. citizen able to pass a background investigation by the client agency. DHS clearance preferred.
• Strong interpersonal skills in a fast-paced government environment.

Responsibilities

• Use Power BI or Tableau to synthesize information for executives.
• Develop methods to evaluate data from multiple sources.
• Establish KPIs to measure strategic initiatives.
• Prepare and present progress reports to senior leadership.
• Schedule management and milestone tracking for projects.
• Document process requirements and create guidance.
• Provide calendar, meeting support, and note-taking.
• Draft memos and briefing materials for customers.
• Perform data entry and asset management per agency policies.
• Maintain centralized source-request tracker for operations.
• Monitor inquiries and escalate to senior leadership.

Skills

Power BI

Tableau

Data analytics

Dashboard creation

Data management

Education

Bachelor’s degree in Business, Human Resource Management, or a related field

Tools

Power BI

Tableau

Job description

Pay: $105,000.00 - $115,000.00 per year

Work Location: Onsite/Washington, DC

Job description: Program Support Analyst

Constellation is seeking a Program Support Analyst to join our team in Washington, DC, evaluating the processes, people, and technology for our clients’ operations. The Analyst working independently or as part of a contractor team, will evaluate and solve the agency’s business challenges, specifically in support of the Department of Homeland Security’s law enforcement mission by collecting, reviewing, and analyzing information. The Analyst will utilize various communication strategies to prepare reports, summarize findings and present analysis to clients. Detail-oriented experienced analyst with proven track record in data management and interpretation, data integrity, scheduling, data analytics, and dashboard creation.

Key Responsibilities:

• Use tools like Power BI, Tableau or other visualization software to synthesize the information and assist senior executives in making decisions.
• Develop analytical methods and tools to evaluate and integrate data from various sources to assess and recommend solutions to assigned problems.
• Establish metrics and key performance indicators (KPIs) to assess the effectiveness of strategic initiatives.
• Prepare and present reports on progress, performance, and outcomes to senior leadership and other stakeholders. Use performance data to inform strategic adjustments and continuous improvement efforts.
• Facilitate sessions with stakeholders to understand and enhance business processes, producing documentation of process requirements and details.
• Deliver schedule management and milestone tracking for various customer projects utilizing strong problem-solving and analytical skills.
• Apply oral and written communication expertise to develop project deliverables, including analysis plans, written reports, briefing slides, and discussions with clients and stakeholders.
• Support studies and meetings; document and compile notes; analyze data; develop guides, standard operating procedures, trackers, and publications, one pagers, facts sheets, etc.
• Provide calendar and meeting support, including scheduling, agenda preparation, and note taking for staff meetings and office projects.
• Draft and edit memos, reports, and briefings for review and use by the customer.
• Perform data entry and asset management functions to include inventory of assets in accordance with agency policies.
• Provide support for maintaining the organizational source requests utilizing a centralized tracker to meet operational needs.
• Monitor and respond to routine inquiries via the shared email box or phone, escalating when necessary to the senior leadership.

The ideal candidate must have the following experience, background, and credentials:

• Bachelor’s degree in Business, Human Resource Management, or a related field.
• Minimum of 2 years’ experience with Power BI or similar visualization tools.
• Minimum of 4 years proven experience as a government consultant or support contractor collecting, analyzing, preparing, and presenting data to senior government leadership.
• Strong interpersonal skills and ability to work with and for our client understanding their needs and work in a face paced dynamic environment
• Be a U.S. citizen able to pass a background investigation by the client agency. DHS clearance with CBP/ICE, or DoD Top-Secret preferred.

Job Type: Full-time

Benefits:

• 401(k)
• 401(k) contribution
• Dental insurance
• Medical insurance
• Life & Disability insurance
• Flexible spending account
• Flexible schedule
• Professional development
• Work-life balance