Application Integration SME - 176328 - 176757 - 177185

Piper Companies; Washington (District of Columbia); Híbrido; USD 140.000 - 185.000; Jornada completa

Ventajas ofrecidas por este puesto de trabajo

Cigna Medical

Dental

Vision

401K

PTO

Holidays

Descripción de la vacante

Zachary Piper Solutions is seeking an Application Integration Engineer for a Washington, D.C. hybrid role. You will design, build, and maintain enterprise data integration pipelines connecting Microsoft Dataverse and Power Platform with internal and external systems.

Work with Dataverse, Power Platform, Azure Data Factory, Power Automate, and Azure integrations on DOJ program data migrations. Top Secret clearance is required to support sensitive government workloads.

Formación

• Bachelor's Degree in Information Technology or related field (or equivalent) and 8+ years of experience.
• 5+ years in data engineering, data migration, or systems integration with Dataverse/Power Platform.
• Hands-on with Azure Data Factory, SSIS, Power Platform Dataflows, Power Automate.
• Experience designing and troubleshooting REST APIs and system integrations.
• Experience with On-Premises Data Gateway, Dataverse security, and RBAC.
• Strong SQL, data mapping, validation, and authentication incl. OAuth 2.0/Entra ID.
• Experience with Azure Logic Apps, Functions, API Management, CI/CD, Git, Azure DevOps, ALM.
• Certs preferred: PL-400, PL-600, DP-203, DP-600, AZ-204.

Responsabilidades

• Design and maintain data integration and migration pipelines between Dataverse, Power Platform, Azure, and enterprise systems.
• Develop ETL/ELT processes using 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.
• Perform data mapping, transformation, validation, monitoring, troubleshooting, and performance optimization.
• Collaborate with architects and stakeholders to deliver secure, scalable integration solutions.

Conocimientos

Dataverse

Power Platform

Azure Data Factory

Power Automate

REST APIs

C#/.NET

Azure Logic Apps

CI/CD

Git

Azure DevOps

Educación

Bachelor's Degree in Information Technology

Herramientas

SSIS

Power Platform Dataflows

On-Premises Data Gateway

API Management

Azure Functions

Azure Data Factory

Descripción del empleo

Zachary Piper Solutions is seeking an Application Integration Engineer. This job is located in Washington D.C. and will be Hybrid. The Application Integration Engineer will be responsible for designing, building, and maintaining enterprise data integration pipelines that connect Microsoft Dataverse and the Power Platform with internal and external systems. This is an exciting opportunity to work with Dataverse, Power Platform, Azure Data Factory, Power Automate, Azure integrations, and enterprise data migration initiatives in Washington D.C. supporting a DOJ Program.

REQUIRES A TOP SECRET CLEARANCE

Responsibilities of the Application Integration Engineer include:

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

Qualifications for the Application Integration Engineer include:

• Bachelor's Degree in Information Technology or a related field (or equivalent experience) 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.

Compensation for the Senior Database Administrator include:

• Salary Range: $140,000 - $185,000
• Comprehensive Benefits: Cigna Medical, Dental, Vision, 401K, PTO, Sick Leave if required by law, and Holidays

This job opens for applications on 10/12/2026. Applications for this job will be accepted for at least 30 days from the posting date.

#LI-WM1

#LI-Hybrid

Application Integration Engineer, Data Integration, Data Migration, Dataverse, Microsoft Dataverse, Power Platform, Power Apps, Power Automate, Power Platform Dataflows, Azure Data Factory, ADF, SSIS, ETL, ELT, REST API, API Development, API Integration, Web Services, On-Premises Data Gateway, SQL, SQL Server, Data Mapping, Data Transformation, Data Validation, Data Quality, Azure, Azure Logic Apps, Azure Functions, Azure Service Bus, Event Grid, Webhooks, API Management, OAuth 2.0, Microsoft Entra ID, Azure AD, Service Principals, Power Platform Security, Dataverse Security, Business Units, Security Roles, Teams, CI/CD, Azure DevOps, Git, GitLab, Application Lifecycle Management, ALM, Managed Solutions, Unmanaged Solutions, Microsoft Fabric, Azure Synapse Link, Dataverse Virtual Tables, ERP Integration, CRM Integration, Dynamics 365, C#, .NET, PowerShell, Custom Connectors, Plug-Ins, Enterprise Integration, System Integration, Monitoring, Azure Monitor, Application Insights, Data Governance, Master Data Management, DOJ.