PowerApps Developer

DRT Strategies, Inc.•Silver Spring, MD

1d•$90,000 - $110,000

About The Position

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. 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.

Requirements

5-7 years of experience
Exceptional communication skills
Experience using PowerApps, Power Automate, Dataverse and Canvas App

Nice To Haves

Experience creating and drafting requirements for development
Experience working in an Agile environment
Experience working as a solo developer
MS PowerApps Certification is a plus

Responsibilities

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
Implement 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
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
Test updates in Dev and Test
Deploy the managed OPCAP solution to Test and Production
Manage Backlog: Add new customer requests, Periodically add LOE, Review with customer as needed
Create a Monthly Status Report