Power Platform Developer/Data Analyst

TechOp Solutions International; Washington (District of Columbia); On-site; USD 120,000 - 160,000; Full time

Job summary

TechOp Solutions International is supporting the U.S. Customs and Border Protection (CBP) Office of Facilities and Asset Management with a Technical Program Analyst role focused on application development, automation, and system modernization using Microsoft Power Platform.

The role emphasizes building and maintaining Power Apps and Power Automate solutions, ETL data movement to SQL databases, and collaborating with stakeholders to deliver scalable technical outcomes in a DHS environment.

Qualifications

• Develop, deploy, and maintain digital applications using Power Apps to collect, process, store, and display data.
• Build automation workflows using Power Automate to support system modernization and automated communications.
• Support data movement and modernization efforts, including ETL workflows transitioning legacy data sources to modernized databases (e.g., SQL).
• Collaborate with cross-functional teams and stakeholders to gather requirements and deliver technical solutions.
• Troubleshoot and resolve technical issues related to Power Apps and Power Automate within a DHS CBP environment.
• Create clear functional and technical documentation to support ongoing operations.

Responsibilities

• Design, launch, and sustain digital applications using Power Platform.
• Create, implement, and manage advanced automation workflow systems that move data to modern databases like SQL and automate communications.
• Collaborate with cross-disciplinary teams and engage clients to understand project requirements and deliver technical solutions.
• Apply Power Platform or CS skills to diagnose and resolve issues in Power Apps/Power Automate within the DHS CBP environment.

Skills

Power Platform

Power Apps

Power Automate

ETL

SQL

Java

C#

Python

Documentation

Stakeholder communication

Education

Background in application development or computer science

Tools

Power Fx

Job description

We are supporting the U.S. Customs and Border Protection (CBP) Office of Facilities and Asset Management (OFAM) MAPMO with a Technical Program Analyst role focused on application development, automation, and system modernization.

This role supports enterprise systems used by tens of thousands of users annually and centers on building and maintaining applications and automation workflows within the Microsoft Power Platform. Candidates may come from a Power Platform background or a traditional software development background, with the expectation that solutions will be delivered using Power Apps and Power Automate.

Key Responsibilities

• Utilize Power Platform (Code Language: Power Fx) or computer science skills to design, launch, and sustain digital applications that gather, process, store, and showcase data
• Create, implement, and manage advanced automation workflow systems that extract, transform, and load data from outdated sources into modern databases like SQL while automating communication processes
• Collaborate with cross-disciplinary teams and engage clients to comprehend project requirements and deliver effective technical solutions
• Apply Power Platform or computer science skills to diagnose and resolve technical issues associated with digital Power Apps or Power Automate systems and their functionality within the DHS CBP environment

Clearance

• CBP/ICE Public Trust with suitability or DOD Top Secret. For this role we can only accept candidates with active clearances as mentioned.

Requirements

• Develop, deploy, and maintain digital applications using Power Apps to collect, process, store, and display data.
• Build and maintain automation workflows using Power Automate to support system modernization and automated communications.
• Support data movement and modernization efforts, including ETL workflows transitioning legacy data sources to modernized databases (e.g., SQL).
• Collaborate with cross-functional teams and stakeholders to gather requirements and deliver technical solutions.
• Troubleshoot and resolve technical issues related to Power Apps and Power Automate within a DHS CBP environment.
• Create clear functional and technical documentation to support ongoing operations
• Background in application development or computer science.
• Hands‑on experience developing solutions using Microsoft Power Platform (Power Apps, Power Fx) is preferred, or a strong background in object‑oriented programming languages (e.g., Java, C#, Python) with the expectation of delivering solutions using Power Apps and Power Automate.
• Experience with Power Automate or ETL technologies.
• Ability to work directly with stakeholders to gather requirements and communicate technical solutions.
• Proficiency with Microsoft Word, PowerPoint, and Excel.
• Ability to meet CBP/ICE Public Trust or DoD Top Secret clearance requirements.
• Ability to work on-site in the Washington, D.C. area as mission needs evolve

Preferred

• Experience with ETL technologies.
• Experience working with SQL.
• Familiarity with Microsoft Entra (Azure AD).