Junior Associate Dashboard Developer

One Federal Solution; Washington (District of Columbia); On-site; USD 65,000 - 90,000; Full time

Job summary

One Federal Solution seeks a Junior Associate Dashboard Developer to support data optimization and reporting for the ICE OFM Customer Service Program. You will assist in extracting, transforming, analyzing, visualizing, and reporting program and financial data, and help develop dashboards and executive-level visuals used to assess status, schedules, costs, and performance.

The ideal candidate combines strong analytical and communication skills with proficiency in Microsoft Office and data

Qualifications

• Excellent oral and written communication.
• ABC modeling and cost model development experience.
• Experience analyzing FASS costs with Excel and visualization tools.
• Federal sector experience in Change and Release Management.
• Proficiency with Outlook, Project, PowerPoint, Word, Excel, SharePoint.
• Experience drafting user guides, SOPs, and technical docs.
• Strong project and financial management skills.
• Able to read/write/speak English fluently.
• Bachelor’s degree in related fields; dashboards and reporting tools experience.
• Experience with Federal government financial data.
• Advanced Excel and data visualization platforms experience.
• Experience developing executive-level reports and presentations.
• Master’s degree preferred for mid/senior level roles.

Responsibilities

• Support Data Optimization for the ICE OFM Customer Service Program.
• Identify data buckets, build/maintain extracts, translate data into reports.
• Develop/maintain MIPPS dashboards and management tools for status checks.
• Produce executive visuals showing project plans and schedules for reports.
• Perform data extraction, transformation, and reporting of FASS cost data with Excel and visualization tools.
• Support data analyses to ensure timely, accurate information.
• Assist dashboards and management reports for leadership/stakeholders.
• Support ABC modeling and cost model development.
• Analyze FASS costs with data extraction/transform/reporting.
• Support Change/Release Management in Federal sector environment.
• Utilize Outlook, Project, PowerPoint, Word, Excel, SharePoint for documentation.
• Assist with technical writing: user guides, SOPs, workflows.
• Apply knowledge of PM, FM, and customer service in program work.
• Communicate effectively with team, leadership, and stakeholders.

Skills

Analytical skills

Communication

Microsoft Office

Data visualization

Excel advanced functions

Project management

Financial management

Customer service

Education

Bachelor's degree (accounting/finance/business/IT/data analytics)

Master's degree preferred/required

Tools

Outlook

Project

PowerPoint

Word

Excel

SharePoint

Data visualization tools

Job description

One Federal Solution is seeking a Junior Associate Dashboard Developer to support data optimization and reporting activities for the ICE Office of Financial Management (OFM) Customer Service Program.

The Junior Associate Dashboard Developer will support the identification, extraction, transformation, analysis, visualization, and reporting of program and financial data. This position will assist in developing and maintaining dashboards, summary reports, management tools, and executive-level visuals used to assess project status, schedules, costs, and overall program performance.

The ideal candidate will have strong analytical and communication skills, proficiency with Microsoft Office applications and data visualization tools, and an understanding of financial management, project management, and customer service.

Key Responsibilities And Duties

• Support Data Optimization for the ICE OFM Customer Service Program.
• Identify data buckets, build and maintain data extracts, and translate data into actionable reports.
• Develop and maintain MIPPS summary reports, dashboards, and management tools used by the CO, COR, GPM, and GTM to assess project status.
• Produce executive-summary visuals illustrating project plan and schedule status for weekly, monthly, and biannual reporting.
• Perform data extraction, transformation, and reporting of FASS cost data using advanced Excel functions, data visualization tools, and other data analysis platforms.
• Support data analysis and reporting activities to ensure information is accurate, timely, and actionable.
• Assist with the development and maintenance of dashboards and management reports used by program leadership and stakeholders.
• Support activity-based cost (ABC) modeling and cost model development.
• Perform data analyses of Financial and Accounting Shared Services (FASS) costs, including data extraction, transformation, and reporting using advanced Excel functions, data visualization tools, and other relevant data analysis platforms.
• Support Change Management and Release Management activities within a Federal sector environment.
• Utilize Microsoft Outlook, Project, PowerPoint, Word, Excel, and SharePoint to support project, data, reporting, and documentation requirements.
• Assist with technical writing and documentation, including crafting user guides and technical requirement materials, writing Standard Operating Procedures (SOPs), and documenting business processes and workflows.
• Apply knowledge of project management, financial management, and customer service in support of program activities.
• Communicate effectively with team members, program leadership, and stakeholders through both written and oral communications.

Required Qualifications

• Excellent oral and written communication.
• Demonstrated experience in activity-based cost (ABC) modeling and cost model development.
• Demonstrated experience performing data analyses of Financial and Accounting Shared Services (FASS) costs, including data extraction, transformation, and reporting using advanced Excel functions, data visualization tools, and other relevant data analysis platforms.
• Demonstrated Federal sector experience in Change Management and Release Management.
• Technical proficiency in Microsoft Outlook, Project, PowerPoint, Word, Excel, and SharePoint.
• Writing/technical writing experience crafting user guides and technical requirement materials, writing Standard Operating Procedures (SOPs), and documenting business processes and workflows.
• Expertise in project management, financial management, and customer service.
• Able to read, write, speak, and understand English fluently.
• Bachelor's degree in accounting, finance, business administration, information management, IT, computer sciences, data analytics, or related field.
• Experience developing dashboards, data visualizations, and management reporting tools.
• Experience working with Federal Government financial management data.
• Experience with data extraction, transformation, and reporting.
• Experience with advanced Microsoft Excel functions and data visualization platforms.
• Experience developing executive-level reports and presentations.
• Master's degree preferred for mid-level and required for senior-level positions.

About One Federal Solution

One Federal Solution (OFS) is an innovative Professional Services provider with over 20 years of experience supporting Defense and Civilian agencies. OFS specializes in Business Intelligence, Acquisition and Procurement, and other Professional Services. We are pioneers, builders, thought leaders, and pride ourselves in thinking outside the box to co-create with our customers, helping them achieve excellent enterprise wide outcomes. As a certified Service-Disabled Veteran-Owned Small Business (SDVOSB), OFS is committed to providing people who deliver high performance and excellence to our government partners.