Senior App Integration Engineer — Dataverse & Power Platform

Zachary Piper Solutions; Washington (District of Columbia); Hybrid; USD 140,000 - 185,000; Full time

Job summary

Zachary Piper Solutions seeks an Application Integration Engineer to design and maintain enterprise data integration pipelines connecting Microsoft Dataverse and the Power Platform with internal and external systems in Washington, D.C. The role focuses on Azure Data Factory, Power Automate, REST APIs, and enterprise data migration initiatives for a DOJ Program.

The candidate will work in a hybrid environment with top secret clearance requirements, contributing to secure, scalable integrations

Qualifications

• Bachelor's Degree in Information Technology or a related field and 8+ years of relevant experience.
• 5+ years of experience in data engineering, data migration, or systems integration with demonstrated experience integrating Microsoft Dataverse and Power Platform environments.
• Hands-on experience with Azure Data Factory, SSIS, Power Platform Dataflows, Power Automate, and enterprise ETL/ELT solutions.
• Strong experience designing, consuming, and troubleshooting REST APIs, web services, and system-to-system integrations.
• Experience configuring and supporting On-Premises Data Gateway, Dataverse data models, Power Platform security, and role-based access controls.
• Strong SQL expertise, data mapping, transformation, data quality validation, and authentication technologies including OAuth 2.0 and Entra ID.
• Experience with Azure Logic Apps, Azure Functions, API Management, CI/CD pipelines, Git, Azure DevOps, event-driven integrations, and Power Platform ALM practices.
• Strong troubleshooting, communication, and documentation skills; Microsoft certifications (PL-400, PL-600, DP-203, DP-600, AZ-204), ERP/CRM integrations, C#/.NET, PowerShell, Fabric, Synapse Link, and monitoring tools are highly preferred.

Responsibilities

• Design and maintain data integration and migration pipelines between Microsoft Dataverse, Power Platform, Azure, and enterprise systems.
• Develop ETL/ELT processes utilizing Azure Data Factory, SSIS, Power Platform Dataflows, and Power Automate workflows.
• Design, build, and support REST APIs, web services, and On-Premises Data Gateway connectivity solutions.
• Perform data mapping, transformation, validation, monitoring, troubleshooting, and performance optimization across integration platforms.
• Collaborate with architects, stakeholders, and technical teams to deliver secure, scalable, and reliable integration solutions.

Skills

Azure Data Factory

Power Platform

ETL/ELT

REST APIs

SQL

C#/.NET

Azure DevOps

Git

Data mapping

Security RBAC

Education

Bachelor's Degree in Information Technology or related field

Tools

Dataverse

SSIS

On-Premises Data Gateway

Azure Synapse

Job description

Zachary Piper Solutions seeks an Application Integration Engineer to design and maintain enterprise data integration pipelines connecting Microsoft Dataverse and the Power Platform with internal and external systems in Washington, D.C. The role focuses on Azure Data Factory, Power Automate, REST APIs, and enterprise data migration initiatives for a DOJ Program.

The candidate will work in a hybrid environment with top secret clearance requirements, contributing to secure, scalable integrations