PowerApps Developer

Silver Spring, MD
Full Time
Mid Level
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.

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:
  • 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
  • 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
Required Experience:
  • 5-7 years of experience
  • Exceptional communication skills
  • Experience using PowerApps, Power Automate, Dataverse and Canvas App
Preferred Experience:
  • Experience creating and drafting requirements for development
  • Experience working in an Agile environment
  • Experience working as a solo developer
Education & Training:
  • Bachelor’s Degree
  • MS PowerApps Certification is a plus
Work Authorization, Clearance Requirement, & Additional Information:
  • 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.
Salary Range:
  • $90,000 - $110,000
  • Salary commensurate with experience.

DRT Strategies, Inc. (DRT) follows the guidelines outlined by the Equal Employment Opportunity Commission (EEOC) to provide all employees and qualified applicants employment without regard to race, color, religion, sex (including pregnancy, childbirth, or related conditions, transgender status, and sexual orientation), national origin, age, genetic information, disability, protected veteran status, or any other protected characteristic under federal, state, or local law.

Reasonable accommodations for applicants and employees with disabilities will be provided. If a reasonable accommodation is needed to participate in the job application or interview process, to perform essential job functions, and/or to receive other benefits and privileges of employment, please contact Human Resources by emailing HR@drtstrategies.com, or by dialing 571-482-2517.

For additional information, please review the Know Your Rights: Workplace Discrimination is Illegal, E-Verify (English), E-Verify (Spanish). Right to Work (English), Right to Work (Spanish).

Please be aware of recruitment fraud where malicious individuals might pose as DRT Strategies. Only job postings and emails from drtstrategies.com are authentic and legitimate communications regarding DRT Strategies employment opportunities. Please contact Human Resources at hr@drtstrategies.com if you believe you have received a fraudulent email.

Share

Apply for this position

Required*
We've received your resume. Click here to update it.
Attach resume as .pdf, .doc, .docx, .odt, .txt, or .rtf (limit 5MB) or Paste resume

Paste your resume here or Attach resume file

To comply with government Equal Employment Opportunity and/or Affirmative Action reporting regulations, we are requesting (but NOT requiring) that you enter this personal data. This information will not be used in connection with any employment decisions, and will be used solely as permitted by state and federal law. Your voluntary cooperation would be appreciated. Learn more.

Invitation for Job Applicants to Self-Identify as a U.S. Veteran
  • A “disabled veteran” is one of the following:
    • a veteran of the U.S. military, ground, naval or air service who is entitled to compensation (or who but for the receipt of military retired pay would be entitled to compensation) under laws administered by the Secretary of Veterans Affairs; or
    • a person who was discharged or released from active duty because of a service-connected disability.
  • A “recently separated veteran” means any veteran during the three-year period beginning on the date of such veteran's discharge or release from active duty in the U.S. military, ground, naval, or air service.
  • An “active duty wartime or campaign badge veteran” means a veteran who served on active duty in the U.S. military, ground, naval or air service during a war, or in a campaign or expedition for which a campaign badge has been authorized under the laws administered by the Department of Defense.
  • An “Armed forces service medal veteran” means a veteran who, while serving on active duty in the U.S. military, ground, naval or air service, participated in a United States military operation for which an Armed Forces service medal was awarded pursuant to Executive Order 12985.
Veteran status


Human Check*