Power Platform Developer/Data Analyst

TechOp Solutions International; Washington; On-site; USD 90,000 - 130,000; Full time

Job summary

TechOp Solutions International is seeking a Technical Program Analyst to develop and modernize applications using Microsoft Power Platform, Power Apps, and Power Automate. The role emphasizes building automation workflows and ETL processes to move data from legacy sources to modern SQL databases.

Candidates with a Power Platform background or software development experience are encouraged, with active CBP/ICE Public Trust or DoD Top Secret eligibility.

Qualifications

• Experience building digital applications using Power Platform (Power Apps, Power Automate).
• Ability to design, launch, and sustain automation workflows.
• Experience with ETL and moving data from legacy sources to modern databases.

Responsibilities

• Utilize Power Platform or CS skills to design and deploy digital applications.
• Create, implement, and manage advanced automation workflows that ETL data to modern databases.
• Collaborate with cross-disciplinary teams and stakeholders to gather requirements and deliver technical solutions.
• Troubleshoot and resolve issues in Power Apps and Power Automate within DHS CBP environment.

Skills

Power Apps development

Power Automate development

ETL/data integration

SQL databases

Education

Background in application development or computer science

Tools

Power Apps

Power Automate

SQL

Microsoft Entra / Azure AD

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.

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