Junior Associate Dashboard Developer - DHS ICE

Winston Center; Washington (District of Columbia); On-site; USD 90,000 - 100,000; Full time

Job summary

TRG seeks a Junior Associate Dashboard Developer to support DHS ICE financial reporting and data visualization work. The developer contributes to reports, dashboards, data extracts, and documentation that help stakeholders understand financial and operational information.

Location: ICE Office of Financial Management headquarters, Washington, DC. Remote work requires prior government approval; this is not a guaranteed remote position.

Qualifications

• Bachelor's degree in accounting, finance, business administration, information management, IT, computer sciences, data analytics, or a related field is required.
• Excellent oral and written communication skills is required.
• The Core Team collectively provides activity-based costing, financial shared services analysis, advanced Excel and visualization, federal change/release management, SharePoint and Microsoft Office skills, and technical writing.
• U.S. citizenship and fluent written and spoken English is required.
• Ability to obtain and maintain required ICE fitness approval, background investigation, and access credentials.
• Current residence in the United States or its territories and residence there for at least three of the previous five years, unless an ICE-approved exception applies is required.
• Complete required security and applicable privacy training, sign required nondisclosure agreements, and protect sensitive government information.

Responsibilities

• Build and maintain assigned dashboard and reporting products using approved data and tools.
• Support data extraction, transformation, validation, and reconciliation for financial analyses.
• Present trends, variances, and project status through clear visuals and reporting outputs.
• Document data definitions, sources, workflows, and changes; maintain traceable reporting artifacts.
• Support approved reporting changes, user guidance, and data portability activities as assigned.

Skills

Excellent communication

English proficiency

Analytical skills

Team collaboration

Security awareness

Education

Bachelor's degree in accounting/finance/IT/data analytics

Tools

Excel

SharePoint

Microsoft Office

Data Visualization

Job description

Position Overview

TRG is seeking a Junior Associate Dashboard Developer to support anticipated DHS ICE financial reporting and data visualization work. The developer contributes to reports, dashboards, data extracts, and documentation that help stakeholders understand financial and operational information.

Location: ICE Office of Financial Management headquarters, Washington, DC. Remote work requires prior government approval; this is not a guaranteed remote position. Travel: As-needed support may include Dallas, TX, Williston, VT, or other government-designated sites. Opportunity: Anticipated contract support position; employment is contingent on contract award, final staffing assignment, and required government approvals. Key Personnel: Not initially designated.

Key Responsibilities

• Build and maintain assigned dashboard and reporting products using approved data and tools.
• Support data extraction, transformation, validation, and reconciliation for financial analyses.
• Present trends, variances, and project status through clear visuals and reporting outputs.
• Document data definitions, sources, workflows, and changes; maintain traceable reporting artifacts.
• Support approved reporting changes, user guidance, and data portability activities as assigned.

Availability Requirement

• Support program reporting during normal business hours. Work location and access are subject to government approval.
• Education and experience requirements may vary with the final assignment level. TRG will confirm the applicable level during candidate review.

Required Qualifications

• Bachelor's degree in accounting, finance, business administration, information management, IT, computer sciences, data analytics, or a related field is required.
• Excellent oral and written communication skills is required.
• The Core Team collectively provides activity-based costing, financial shared services analysis, advanced Excel and visualization, federal change/release management, SharePoint and Microsoft Office skills, and technical writing. Candidates should identify the areas they can contribute.
• U.S. citizenship and fluent written and spoken English is required.
• Ability to obtain and maintain required ICE fitness approval, background investigation, and access credentials. An active security clearance does not replace ICE approval.
• Current residence in the United States or its territories and residence there for at least three of the previous five years, unless an ICE-approved exception applies is required.
• Complete required security and applicable privacy training, sign required nondisclosure agreements, and protect sensitive government information.

Preferred Qualifications

• TRG preference: Current ICE/DHS fitness approval or an active federal security clearance, including Secret. These are preferences, not prerequisites.

TRG provides competitive salaries commensurate with education and experience with full options for advancement and a robust benefits program.

If you are an individual with a disability and would like to request a reasonable accommodation as part of the employment selection process, please contact Dawn Newton, HR and Talent Acquisition Manager at [e-mail].

Salary: $90000 - $100000 per year