The Role
Develop and support the FDA OPCAP Power Apps portal, including new features, defect fixes, Power Automate workflows, Dataverse schema and queries, Power BI reports, testing, deployments, backlog management, customer support, and monthly status reporting. The role serves as the project’s sole architect, developer, and QA tester while collaborating directly with customers to define requirements.
Summary Generated by Built In
Overview
DRT Strategies delivers expert management consulting and information technology (IT) solutions to large federal agencies, state and local government and commercial clients in health care, technology, and financial services industries.
The three letters of our name, DRT, stand for Driving Resolution Together, which is the core philosophy on which the company was founded. That is, we collaborate with our clients to solve their most pressing challenges - together.
We are problem solvers dedicated to your success, combining Fortune 500 experience with small business responsiveness. We have established a reputation with our clients as a forward-thinking consulting firm with demonstrated success in implementing solutions that lead to meaningful results. Our world-class consultants unite people to work collaboratively to achieve project goals and make vision a reality.
Project Description:
The purpose is to automate the business process for FDA OAGS Purchase Card Audit Portal (OPCAP) thru SharePoint Online and MS Power Platform solutions.
Job Summary:
This position is for a PowerApps Architect/Developer to continue work on the FDA OAGS Purchase Card Audit Portal (OPCAP) including continued development of new features, creation of reports, and development of other necessary items. The Portal was launched into the Production Environment in February 2026 and continues to need new features and reports.
The ideal candidate for this position is someone that can be a solo Architect, developer, and QA tester for the project. The candidate will be the sole developer on the project and will meet with the customers as needed for new requirements.
Responsibilities:
DRT Strategies delivers expert management consulting and information technology (IT) solutions to large federal agencies, state and local government and commercial clients in health care, technology, and financial services industries.
The three letters of our name, DRT, stand for Driving Resolution Together, which is the core philosophy on which the company was founded. That is, we collaborate with our clients to solve their most pressing challenges - together.
We are problem solvers dedicated to your success, combining Fortune 500 experience with small business responsiveness. We have established a reputation with our clients as a forward-thinking consulting firm with demonstrated success in implementing solutions that lead to meaningful results. Our world-class consultants unite people to work collaboratively to achieve project goals and make vision a reality.
Project Description:
The purpose is to automate the business process for FDA OAGS Purchase Card Audit Portal (OPCAP) thru SharePoint Online and MS Power Platform solutions.
Job Summary:
This position is for a PowerApps Architect/Developer to continue work on the FDA OAGS Purchase Card Audit Portal (OPCAP) including continued development of new features, creation of reports, and development of other necessary items. The Portal was launched into the Production Environment in February 2026 and continues to need new features and reports.
The ideal candidate for this position is someone that can be a solo Architect, developer, and QA tester for the project. The candidate will be the sole developer on the project and will meet with the customers as needed for new requirements.
Responsibilities:
- Support the requirements elicitation and analyze current requests/requirements and develop the Enterprise Performance Lifecyle (EPLC) compliant technical documentation (e.g., Concept, Requirements and Design Document) as requested.
- Manage Backlog Refining, including add new customer requests, add LOE and review with customer as needed.
- Develop and implement SharePoint Online and MS Power Platform solutions to automate and increase efficiencies with the FDA acquisition process.
- Review existing SPO Sites and Power Platform applications and recommend enhancements for additional automation and user experience.
- Leverage new Microsoft 365 features and out-of-box functionality while adhering to the FDA User Experience (UX) design best practices and design guidelines to design, develop, and deploy new SPO Sites and Power Platform applications within the FDA Government Community Cloud (GCC) environment).
- Recommend new tools and technologies for integration with Power Platform applications to support complex business and regulatory processes.
- Address and resolve user inquiries/issues logged.
- Assist with System/Integration Testing and User Acceptance Testing (UAT) as needed, including supporting production deployment.
- Design, develop and code in PowerApps/Dataverse/Canvas App new features, conduct QA testing, design and create new reports, act as the sole technical lead on the project.
- Provide Production support of the OPCAP app, including:
- Research and answer questions from customers and users
- Provide ad hoc reporting as needed
- Analyze and troubleshoot any errors from OPCAP App or Power Automate workflows
- Occasionally monitor Service Account's inbox
- Mainly needed when cardholder emails are sent out (ex. Upload Document reminders, Audit Draft status, etc.)
- Implement new features and defect fixes in:
- OPCAP Audit Portal (Power Apps)
- Canvas app using Dataverse
- Advanced techniques implemented in numerous places
- Power Automate Workflows
- Implement a variety of workflows: scheduled, triggered, called from Power Apps, child flows, etc
- Leverage Power Apps to overcome Power Apps delegation limit
- Leverage Fetch XML as needed when retrieving data from Dataverse
- Dataverse
- Maintain existing schema, add new tables and relationships as needed
- Implement formula columns as needed to offload processing from Power Apps
- Implement Views to simplify filter queries in Power Apps
- OPCAP Audit Portal (Power Apps)
- Develop Power BI reports
- As needed, implement measures and custom columns using DAX
- Develop Summary tables using M (Power Query)
- Develop visuals for Data Mining and Annual Reports
- Work with the Task Order Manager to provide status reports (risks/issues, deliverables, and completed and anticipated activities).
- Support other activities as directed by DRT Portfolio Manager.
- Minimum of 5 years of demonstrated experience in developing SharePoint Online Sites and Microsoft Power Platform applications (i.e., PowerApps, Power Automate and PowerBI).
- Demonstrated experience in creating Dashboards and Reports in PowerApps/Power BI.
- Demonstrated experience in developing Canvas App and Power Automate workflows.
- Demonstrated experience in developing Dataverse solutions as the data repository.
- Demonstrated experience in developing and implementing KPIs.
- Apply, as appropriate, activity and data modeling, transaction flow analysis, internal control and risk analysis and modern business methods and performance measurement techniques.
- Assist in establishing standards for information systems procedures.
- Develops and applies organization-wide information models for use in designing and building integrated, shared software and database management systems.
- Constructs sound, logical business improvement opportunities consistent with corporate Information Management guiding principles, cost savings, and open system architecture objectives.
- Able to translate requirements specifications into a technical solution for implementation.
- Demonstrated experience working on Agile projects using Agile/Scrum methodology.
- Requires excellent verbal/written communication skills and attention to detail.
- Must be able to multitask efficiently and effectively.
- Able to work independently and with teams.
- Must have or be able to obtain a Public Trust.
- Previous experience working with or for Federal Agencies
- Familiarity with .HTML5, JavaScript, CSS, XML, and Web Services.
- Experience with integrating SharePoint Online sites and Microsoft Power Platform applications with third party applications.
- Bachelor's degree in Information Systems, Computer Science, Software Engineering, or relevant field (Preferred)
- SharePoint Online & MS Power Platform (e.g., PowerApps) certifications (Preferred)
- This position requires the ability to obtain and maintain a U.S. government Public Trust clearance. Due to contract requirements, candidates must be U.S. citizens or lawful permanent residents (green card holders) to be eligible.
- No agencies, third parties, or Corp-to-Corp submissions.
- $90,000 - $110,000
- Salary commensurate with experience.
Skills Required
- 5-7 years of professional experience
- Exceptional communication skills
- Experience using Power Apps
- Experience using Power Automate
- Experience using Dataverse
- Experience developing Canvas Apps
- Bachelor's degree
- Experience creating and drafting development requirements
- Experience working in an Agile environment
- Experience working as a solo developer
- Microsoft Power Apps certification
- Ability to obtain and maintain a U.S. government Public Trust clearance
- U.S. citizenship or lawful permanent residency
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
DRT Strategies, Inc. (DRT) is an award-winning technology innovator and leading digital transformation partner to large federal agencies and commercial clients for nearly 20 years. The company is a ServiceNow™ Partner - Specialist, Amazon Web Services (AWS) Consulting Partner, UiPath Partner, SAFe Bronze Partner, Esri Bronze Partner, and holds ISO 9001:2015, ISO/IEC 20000-1:2018, and ISO/IEC 27001:2013 certifications and has achieved CMMI-DEV Level 3. DRT is headquartered in Arlington, Virginia, with offices in Atlanta, Georgia. More information on the company can be found at www.drtstrategies.com.
