Top Secret: Data Integration Engineer - Dataverse/Power

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

Benefits offered by this job

Hybrid work model

Job summary

Zachary Piper Solutions in Washington D.C. is seeking an Application Integration Engineer to design, build, and maintain enterprise data integration pipelines that connect Microsoft Dataverse and the Power Platform with internal and external systems.

The role focuses on Dataverse, Power Platform, Azure Data Factory, Power Automate, and Azure integrations within a DOJ Program, requiring a Top Secret clearance. Hybrid work arrangement in Washington D.C. is offered.

Qualifications

• Bachelor's Degree in Information Technology or 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

Dataverse

Power Platform

Azure Data Factory

ETL/ELT

REST APIs

C#/.NET

PowerShell

Azure DevOps

OAuth 2.0

Education

Bachelor's Degree in Information Technology

Tools

Dataverse

SSIS

Power Automate

On-Prem Data Gateway

Job description

Zachary Piper Solutions in Washington D.C. is seeking an Application Integration Engineer to design, build, and maintain enterprise data integration pipelines that connect Microsoft Dataverse and the Power Platform with internal and external systems.

The role focuses on Dataverse, Power Platform, Azure Data Factory, Power Automate, and Azure integrations within a DOJ Program, requiring a Top Secret clearance. Hybrid work arrangement in Washington D.C. is offered.