Application Integration, SME

Cayuse Holdings

Location
Washington, DC, US
Role
Engineering
Pay
USD 151,000–153,441 per year
Listed
Nov 10, 2026
Apply on the original listing →

Employment in this role is conditional upon successful execution of the contract by the client. The Work:

The Application Integration, SME will design, develop, and maintain data integration pipelines that seamlessly connect Microsoft Dataverse and the Power Platform with internal and external systems. This role focuses on ensuring secure, reliable, and highly performant data migration and integration across diverse cloud and on-premises environments. This role will demonstrate an ability to handle complex data workflows, API integrations, and hybrid system connections, while adhering to the latest security and compliance standards.

This position aligns with Cayuse’s core values of Innovation, Excellence, Collaboration, Adaptability, and Integrity by fostering technical solutions that meet customer needs, promoting teamwork, and prioritizing quality in deliverables. Key Responsibilities: Design, develop, and maintain data integration and migration pipelines using tools such as Azure Data Factory, SQL Server Integration Services (SSIS), and Power Apps/Power Platform Dataflows to connect Dataverse to on-premises, cloud, and SaaS systems.

Build and support Power Automate integration flows, including scheduled, triggered, and event-driven workflows.

Develop, consume, and expose REST APIs to facilitate bi-directional data exchange between Dataverse and external systems.

Configure, maintain, and troubleshoot the On-Premises Data Gateway for secure data access across on-premises and cloud environments.

Execute data profiling, cleansing, mapping, and transformation activities, ensuring data quality and integrity throughout integration processes; apply analytical techniques for troubleshooting data issues.

Optimize integration pipelines for throughput, latency, and protection limits while implementing robust error handling, logging, alerting, and monitoring to ensure reliability and rapid issue resolution.

Work with solution architects, business stakeholders, and functional consultants to gather requirements, design technical solutions, and document data flows, integration architecture specifications, and operational runbooks.

Apply security best practices for data in transit and at rest, including credential management and role-based access control.

Support testing efforts, including unit testing, integration testing, and user acceptance testing for integration workflows; provide production support and troubleshooting for integration failures, performance bottlenecks, and data discrepancies.

Stay current with Power Platform, Dataverse, and Azure integration service updates and recommend solutions to enhance system performance and capabilities.

Other duties as assigned.

Qualifications – Here’s What You Need:

The qualifications and skills listed below are intended to provide a general overview of the requirements for this position. However, due to the anticipated nature of the contract and the absence of a finalized task order from the client, this list should not be considered all-encompassing. Additional qualifications, certifications, skills, or experience specific to the client’s requirements may be identified and requested upon award of the task order. Candidates should demonstrate flexibility and a willingness to adapt to evolving responsibilities as outlined by the client. Bachelor’s degree in Information Technology, Computer Science, or a related field, or equivalent experience.

At least 8 years of related professional experience.

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 (business units, security roles, teams).

Experience with data mapping, transformation logic, and data quality validation techniques.

Familiarity with authentication and authorization protocols (OAuth 2.0, Azure AD/Entra ID app registrations, service principals).

Strong analytical/troubleshooting skills; ability to diagnose complex data/integration issues.

Active Top Secret Security Clearance.

Must be able to pass a background check. May require additional background checks as required by projects and/or clients at any time during employment.

Minimum Skills: Exceptional interpersonal skills with the ability to communicate in a clear, professional, and articulate manner.

Exceptional verbal and written communication skills.

Excellent organizational, analytical, and problem-solving skills with high-level attention to detail.

Proven ability to multitask and prioritize in a fast past environment with changing priorities; adaptable to change and a quick learner.

Must be self-motivated and able to work well independently as well as on a multi-functional team.

Ability to handle sensitive and confidential information appropriately

Proficient in MS Office, Word, Outlook, PowerPoint, and Excel.

Preferred Qualifications: Microsoft certifications such as PL-400, PL-600, DP-600, DP-203, or AZ-204.

Experience with Azure Logic Apps, Azure Functions, and Dataverse virtual tables/entities.

Knowledge of source control and CI/CD practices (e.g., Azure DevOps, GitLab CI/CD).

Familiarity with message-based/event-driven integra

Apply on the original listing →

This listing was collected from a public job posting. Applications go through the original listing. It may close without notice.

Job alerts

New Power Automate roles, by email.

One short email a day when roles are added. No recruiters, no spam, unsubscribe in one click.

The Brief

The iPaaS newsletter, by email.

What is changing in integration work, who is hiring, and what it pays. From the team behind iPaaS Jobs.

Free. One email to confirm, unsubscribe anytime.