Dataverse & Power Platform Data Integration Engineer – Hybrid

Bow Wave LLC; Washington (District of Columbia); On-site; USD 110,000 - 150,000; Full time

Job summary

Bow Wave LLC is seeking an Application Integration Engineer in Washington, DC to design, build, and maintain data integration pipelines between Microsoft Dataverse/Power Platform and various systems. You will implement ETL/ELT processes using Azure Data Factory and SSIS, and develop REST APIs for data exchange.

The role emphasizes secure, scalable data migration and integration across cloud and on‑prem environments, with collaboration across solution architects and stakeholders.

Qualifications

• 5+ years of experience in data engineering, data migration, or systems integration roles.
• Demonstrated experience integrating and migrating data into/out of Microsoft Dataverse and Power Platform.
• Hands-on experience with Power Automate for building 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/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 (query optimization, relational database design).
• Solid understanding of Dataverse data model, entity relationships, and Power Platform security model.

Responsibilities

• Design, develop, and maintain data integration and migration pipelines between Dataverse/Power Platform and disparate source and target systems.
• Build and orchestrate ETL/ELT processes using Azure Data Factory, SSIS, and Power Apps/Power Platform Dataflows.
• Develop and support integration flows using Power Automate, including scheduled, triggered, and event-driven workflows.
• 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 for secure connectivity between cloud services and on-premises data sources.
• Perform data profiling, cleansing, mapping, and transformation to ensure data quality during migration and integration.

Skills

Data integration

Dataverse

Power Platform

Azure Data Factory

SSIS

Power Automate

REST APIs

On-Premises Data Gateway

SQL

Security/RBAC

Education

Bachelor's degree in Computer Science

Tools

SSIS

Power Apps

Power Platform Dataflows

Postman

Job description

Bow Wave LLC is seeking an Application Integration Engineer in Washington, DC to design, build, and maintain data integration pipelines between Microsoft Dataverse/Power Platform and various systems. You will implement ETL/ELT processes using Azure Data Factory and SSIS, and develop REST APIs for data exchange.

The role emphasizes secure, scalable data migration and integration across cloud and on‑prem environments, with collaboration across solution architects and stakeholders.