Application Integration SME - TS required - Wash DC & Hybrid
About The Position
The Application Integration Engineer designs, builds, and maintains data integration pipelines connecting Microsoft Dataverse and the Power Platform with internal and external systems. The role focuses on reliable, secure, and performant data migration and integration across cloud and on-premises environments. The engineer develops ETL/ELT processes and Power Automate workflows, works with REST APIs and web services, and configures the On-Premises Data Gateway. The role also covers data profiling and transformation, pipeline monitoring and error handling, technical documentation, migration planning and execution, performance optimization, testing, security and compliance, and production support. The engineer collaborates with solution architects, functional consultants, and business stakeholders to translate integration requirements into technical designs and keeps current with Microsoft Power Platform, Dataverse, and Azure integration services.
Requirements
- At least 5 years of experience in data engineering, data migration, or systems integration roles.
- Demonstrated experience integrating and migrating data into and out of Microsoft Dataverse and Power Platform.
- Hands-on experience with Power Automate integration and orchestration workflows.
- Hands-on experience with Power Apps/Platform Dataflows.
- Hands-on ETL experience with SQL Server Integration Services (SSIS).
- Hands-on experience with pipeline orchestration and data movement in Azure Data Factory.
- Experience designing, consuming, and troubleshooting REST APIs for system-to-system integration.
- Experience configuring and maintaining the On-Premises Data Gateway.
- Strong proficiency in SQL, including query optimization and relational database design.
- Solid understanding of the Dataverse data model, entity relationships, and Power Platform security model, including business units, security roles, and teams.
- Experience with data mapping, transformation logic, and data quality validation techniques.
- Familiarity with OAuth 2.0, Azure AD/Entra ID app registrations, and service principals.
- Strong analytical and troubleshooting skills, including diagnosing complex data and integration issues.
- Excellent written and verbal communication skills, including technical design documentation for technical and non-technical audiences.
Nice To Haves
- Microsoft certifications such as PL-400, PL-600, DP-600, DP-203, or AZ-204.
- Experience with Azure Logic Apps and/or Azure Functions for custom integration logic.
- Experience with Dataverse virtual tables/entities and virtual connectors.
- Familiarity with Microsoft Fabric, Dataverse short-term retention, or Azure Synapse Link for Dataverse.
- Experience with source control and CI/CD practices, such as Azure DevOps or GitLab CI/CD.
- Knowledge of message-based or event-driven integration patterns, such as Azure Service Bus, Event Grid, and webhooks.
- Experience with API management platforms.
- Familiarity with data governance, master data management, and data retention/archival practices.
- Experience integrating Power Platform with ERP or CRM systems.
- Working knowledge of C#/.NET or PowerShell for custom connectors, plug-ins, or automation scripting.
- Experience with Power Platform ALM, including managed/unmanaged solutions and environment strategy.
- Familiarity with monitoring and observability tools such as Application Insights and Azure Monitor.
Responsibilities
- Design, develop, and maintain data integration and migration pipelines between Dataverse/Power Platform and on-premises, cloud, and SaaS systems.
- Build and orchestrate ETL/ELT processes using Azure Data Factory, SSIS, and Power Apps/Power Platform Dataflows.
- Develop and support scheduled, triggered, and event-driven integration workflows using Power Automate.
- Design, consume, and expose REST APIs and web services for bi-directional data exchange between Dataverse and external systems.
- Configure, maintain, and troubleshoot the On-Premises Data Gateway.
- Perform data profiling, cleansing, mapping, and transformation to ensure data quality and integrity.
- Develop and maintain error handling, logging, alerting, and monitoring for integration pipelines.
- Collaborate with solution architects, functional consultants, and business stakeholders to gather requirements and create technical designs.
- Document data flows, integration architecture, mapping specifications, and operational runbooks.
- Plan and execute data migration for Dataverse implementations, including extraction, transformation, validation, and loading.
- Optimize integration throughput, latency, and API/service protection limits.
- Support unit, integration, and user acceptance testing for migration and integration solutions.
- Apply security and compliance practices for data in transit and at rest, including secrets management and role-based access control.
- Provide production support and troubleshoot integration failures, data discrepancies, and performance issues.
- Stay current with Microsoft Power Platform, Dataverse, and Azure integration service updates and recommend improvements.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Education Level
No Education Listed
