Detention Subject Matter Expert - IT (PowerApp Specialist and SharePoint Developer)

SiloSmashers • Arlington, VA

5d • Onsite

About The Position

The Detention Subject Matter Expert-IT will be responsible for providing expert detention and executive level support to meet the demands and strategic requirements to manage the Federal Detention Management System. The contractor shall provide consultation in the area of federal detainee operations, including working knowledge of U.S. Marshals Service, U.S. Probation, Immigration and Custom Enforcement (ICE), Bureau of Prisons (BOP), and Justice Prisoner and Alien Transportation System (JPATS) operations. Functional Responsibility Support includes, but is not limited to, unbiased guidance, advice, and assistance to Prisoner Operations Division leadership and the Office of Detention Technology in the management and executions of the USMS Federal Detention Management System. The contractor shall work independently to conduct and compose executive level research and analysis to provide correspondence, reports, and briefings. This may also include strategic level studies, analyses and reports documenting any proposed developmental, consultative or implementation efforts. The subject matter expert must have knowledge of, but not limited to, the following: An executive level understanding of the federal detention and judicial processes. Coordinate activities with Immigration and Custom Enforcement (ICE), Bureau of Prisons (BOP), and other associated Agency executive and field personnel to facilitate the implementation of the USMS National Detention Management System. Develop and write strategic and business actions plans, including the development of performance measures and indicators. Conduct gap analysis and corrective action planning to identify inefficiencies and areas for improvement in strategic planning concerning integrating the complexities of the detention environment and detention communities. Research emerging issues and conduct Congressional and legal analysis. Support the development and implementation of the pilot projects, lead tabletop exercises, and test hypotheses. Develop conceptual and practical implementation plans of operations. Research and compose unbiased, executive level correspondence, reports, and effective presentations. Shall possess the interpersonal skills to interact frequently with internal and external detention customers as well as a diverse staff group. Communicate, both orally and in writing, with all levels of an Agency. The contractor shall meet deadlines and provide required deliverables within the contract requirements. Provide Tier 3 support and training for CAPTURE applications. Conducts analysis of Detention Data Services reporting for accuracy and makes recommendations for efficient use of detention bed space costs as it relates to the designation and transportation of federal prisoners. Provides technical expertise and recommends efficiencies regarding CAPTURE application workflows as it relates to Arrest to Commitment. Possess a thorough knowledge of Microsoft Word, PowerPoint, Excel, Outlook, and SharePoint. Work independently to conduct and compose executive level research and analysis to provide correspondence, reports, and briefings. This may also include strategic level studies, analyses and reports documenting any proposed developmental, consultative or implementation efforts. Additionally, would ideally have expertise developing applications with GIS software such as ESRI, and other technological software and/or statistical packages such as MS-BI, SAS and/or Tableau.

Requirements

• Bachelor's Degree (or High School Diploma plus two (2) additional years of relevant experience).
• Knowledge of the USMS or similar federal operations.
• U.S. Citizenship required.
• Thorough knowledge of Microsoft Word, PowerPoint, Excel, Outlook, and SharePoint.
• Interpersonal skills to interact frequently with internal and external detention customers as well as a diverse staff group.
• Ability to communicate, both orally and in writing, with all levels of an Agency.
• Ability to meet deadlines and provide required deliverables within the contract requirements.
• Strong analytical and problem-solving skills.
• Ability to work independently and collaboratively in a dynamic, fast-paced environment while managing multiple priorities.
• Flexibility and ability to thrive in a time-sensitive environment to meet strict deadlines with sudden and unpredictable needs with a high tolerance for ambiguity.
• A self-starter with a strong work ethic who sets high standards for self and others and demonstrates enthusiasm for the mission of the team.

Nice To Haves

• Expertise developing applications with GIS software such as ESRI.
• Expertise with other technological software and/or statistical packages such as MS-BI, SAS and/or Tableau.
• 3+ years of experience developing and administering SharePoint solutions, preferably in SharePoint Online.
• 2+ years of hands-on experience with Microsoft PowerApps and Power Automate, including building custom applications, workflows, forms, and automated processes.
• Ability to develop and maintain Power BI dashboards, reports, and data models that translate program data into clear, actionable insights for leadership and operational teams.
• Ability to design intuitive visual layouts and build efficient data structures, including measures and optimized model relationships, to ensure accuracy, consistency, and strong performance across all reporting products.
• Expertise to collaborate with stakeholders to gather requirements and update dashboards as program needs evolve, ensuring reporting tools remain relevant, user-friendly, and aligned with organizational priorities and business objectives.
• Ability to create and enhance PowerApps applications that automate routine workflows, improve data collection, and support program operations.
• Expertise to develop, maintain, configure Power Pages with Dataverse, Power Automate, and role-based access controls to ensure secure, compliant, and efficient data handling.
• Technical skillset to integrate PowerApps with SharePoint, Dataverse, SQL, and other approved data sources, ensuring reliable data flow and adherence to security requirements.
• Expertise to document application features, data structures, and reporting logic, and provide basic user training or guidance to support adoption and effective use of developed tools.
• Ability to identify opportunities to streamline processes and enhance data visibility through improved reporting, automation, and integration within the Microsoft Power Platform.
• Experience with data reconciliation, data management, and process automation, with the ability to streamline workflows and improve data accuracy.
• Excellent communication skills, with the ability to collaborate effectively with technical and non-technical stakeholders and translate requirements into functional solutions.
• Experience with data quality management is preferred and considered an asset.

Responsibilities

• Provide expert detention and executive level support to meet the demands and strategic requirements to manage the Federal Detention Management System.
• Provide consultation in the area of federal detainee operations, including working knowledge of U.S. Marshals Service, U.S. Probation, Immigration and Custom Enforcement (ICE), Bureau of Prisons (BOP), and Justice Prisoner and Alien Transportation System (JPATS) operations.
• Provide unbiased guidance, advice, and assistance to Prisoner Operations Division leadership and the Office of Detention Technology in the management and executions of the USMS Federal Detention Management System.
• Work independently to conduct and compose executive level research and analysis to provide correspondence, reports, and briefings.
• Conduct strategic level studies, analyses and reports documenting any proposed developmental, consultative or implementation efforts.
• Coordinate activities with Immigration and Custom Enforcement (ICE), Bureau of Prisons (BOP), and other associated Agency executive and field personnel to facilitate the implementation of the USMS National Detention Management System.
• Develop and write strategic and business actions plans, including the development of performance measures and indicators.
• Conduct gap analysis and corrective action planning to identify inefficiencies and areas for improvement in strategic planning concerning integrating the complexities of the detention environment and detention communities.
• Research emerging issues and conduct Congressional and legal analysis.
• Support the development and implementation of pilot projects, lead tabletop exercises, and test hypotheses.
• Develop conceptual and practical implementation plans of operations.
• Research and compose unbiased, executive level correspondence, reports, and effective presentations.
• Interact frequently with internal and external detention customers as well as a diverse staff group.
• Communicate, both orally and in writing, with all levels of an Agency.
• Meet deadlines and provide required deliverables within the contract requirements.
• Provide Tier 3 support and training for CAPTURE applications.
• Conduct analysis of Detention Data Services reporting for accuracy and make recommendations for efficient use of detention bed space costs as it relates to the designation and transportation of federal prisoners.
• Provide technical expertise and recommend efficiencies regarding CAPTURE application workflows as it relates to Arrest to Commitment.
• Develop and administer SharePoint solutions.
• Build custom applications, workflows, forms, and automated processes using Microsoft PowerApps and Power Automate.
• Develop and maintain Power BI dashboards, reports, and data models.
• Design intuitive visual layouts and build efficient data structures, including measures and optimized model relationships.
• Collaborate with stakeholders to gather requirements and update dashboards as program needs evolve.
• Create and enhance PowerApps applications that automate routine workflows, improve data collection, and support program operations.
• Develop, maintain, and configure Power Pages with Dataverse, Power Automate, and role-based access controls.
• Integrate PowerApps with SharePoint, Dataverse, SQL, and other approved data sources.
• Document application features, data structures, and reporting logic.
• Provide basic user training or guidance to support adoption and effective use of developed tools.
• Identify opportunities to streamline processes and enhance data visibility through improved reporting, automation, and integration within the Microsoft Power Platform.
• Perform data reconciliation, data management, and process automation.
• Troubleshoot and resolve technical issues related to SharePoint, PowerApps, Power Automate, and Power BI.
• Collaborate effectively with technical and non-technical stakeholders and translate requirements into functional solutions.
• Work independently and collaboratively in a dynamic, fast-paced environment while managing multiple priorities.
• Manage data quality.
• Thrive in a time-sensitive environment to meet strict deadlines with sudden and unpredictable needs with a high tolerance for ambiguity.
• Set high standards for self and others and demonstrate enthusiasm for the mission of the team.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior