Job Type: Full-Time, Contract
Location: ICE/EPMU, Washington, D.C. / National Capital Region
Work Setting: On-Site
Position Type: Full-time (Contingent on Award)
Security Requirement: Must be able to pass required DHS/ICE suitability, fitness, and access requirements
Position Overview
Team PAC Group LLC is seeking a skilled Dashboard Developer to design, build, deploy, maintain, and improve interactive dashboards supporting acquisition, budget, and human resources reporting for ICE’s Executive Programs Management Unit.
The Dashboard Developer will work directly with stakeholders to gather requirements, connect data sources, build Tableau dashboards, validate data, perform testing, support user acceptance, and ensure dashboards provide timely, accurate, and actionable insight into contract lifecycle status, budget commitments and obligations, expenditures, and personnel actions.
Key Responsibilities
- Meet with EPMU stakeholders to gather and document dashboard requirements.
- Define daily update frequency, reporting needs, wireframes, and dashboard mockups.
- Identify and connect relevant data sources, including contract management systems, financial systems, FFMS, FileOnQ/WebView, spreadsheets, SQL, APIs, and related repositories.
- Develop and maintain automated data pipelines for daily refresh.
- Apply ETL processes to cleanse, transform, and prepare acquisition, budget, and HR data.
- Build interactive Tableau dashboards showing contract lifecycle stages, vendor information, timelines, milestones, budget variances, forecasts, commitments, obligations, expenditures, and personnel actions.
- Implement dashboard filters, parameters, and drill-down features.
- Conduct unit testing, integration testing, and user acceptance testing.
- Publish dashboards to Tableau Server or Tableau Online and configure access permissions and security protocols.
- Document dashboard features, data sources, maintenance procedures, and user access processes.
- Monitor daily refresh jobs, troubleshoot failures, improve dashboard performance, and respond to user inquiries.
- Support dashboards related to acquisition and financial metrics, earned value management, OMB Exhibit 300 documentation, RAP, and PART updates.
Required Qualifications
- Bachelor’s degree from an accredited university or equivalent professional experience in a relevant field.
- Minimum of two to five years of hands-on experience designing, developing, and maintaining Tableau dashboards and visualizations.
- Experience working with databases, data warehouses, SQL, Excel, APIs, and multiple data sources.
- Experience with ETL, requirements gathering, data modeling, KPI development, and business intelligence reporting.
- Experience validating dashboard accuracy, conducting UAT, troubleshooting issues, and documenting data sources and dashboard features.
- Experience implementing user access controls and data security protocols in Tableau Server or Tableau Online.
- Ability to fluently read, write, speak, and understand English.
- U.S. Citizenship required.
Preferred Qualifications
- Experience developing acquisition and budget-related dashboards.
- Experience supporting financial analysis, procurement tracking, and resource allocation reporting.
- Experience integrating and visualizing data from federal financial and acquisition systems.
- Tableau Desktop Specialist or Tableau Certified Data Analyst certification.
- Experience with Power BI, Qlik, or other business intelligence tools.
- Familiarity with federal financial, acquisition, or DHS reporting environments.
Work Requirements
- Ability to work on-site in the Washington, D.C. / National Capital Region.
- Ability to work with program stakeholders to turn reporting needs into actionable dashboards.
- Ability to maintain data accuracy, security, and dashboard performance.
- Ability to manage multiple dashboard products and evolving business requirements.
How to Apply
Interested candidates should submit their resume and include the position title, Dashboard Developer, in their application materials.
LinkedIn: https://www.linkedin.com/in/pacgroupllc/
Website: www.gopacgroup.com
Email: info@gopacgroup.com