Senior Data Integration Architect – Dataverse & Power Platform

Cayuse Holdings; Washington (District of Columbia); On-site; USD 120,000 - 160,000; Full time

Benefits offered by this job

Medical, Dental and Vision Insurance

Wellness Program

Flexible Spending Accounts

Disability Insurance (ST/LT)

Life and AD&D Insurance

Voluntary Life and AD&D

401(k) with matching after 1 year

Paid Time Off

Job summary

Cayuse Holdings seeks an Application Integration SME to design, develop, and maintain data integration pipelines connecting Microsoft Dataverse and the Power Platform with various systems. The role emphasizes secure, high-performance data migration across cloud and on-premises environments.

The candidate will build Power Automate flows, expose REST APIs, and ensure data quality with strong security practices. A TS clearance and onsite work in the Washington, DC area are expected.

Qualifications

• Bachelor’s degree or equivalent experience in IT or CS.
• 8+ years of professional full-stack software development experience.
• Proficiency with Power Automate for building distributed workflows.
• Hands-on experience with Power Apps/Platform Dataflows.
• ETL expertise using SSIS.
• Familiarity with Azure Data Factory for orchestration.
• Experience designing/consuming REST APIs and web services.
• Config/administration of On-Premises Data Gateway.
• Strong SQL skills and Dataverse data model knowledge.
• Experience with authentication protocols: OAuth 2.0, Azure AD/Entra ID, service principals.

Responsibilities

• Design, develop, and maintain data integration and migration pipelines using Azure Data Factory, SSIS, and 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 enable bi-directional data exchange between Dataverse and external systems.
• Configure and troubleshoot the On-Premises Data Gateway for secure data access across environments.
• Perform data profiling, cleansing, mapping, and transformation with emphasis on quality and integrity.
• Optimize pipelines for throughput and latency; implement logging, alerts, and monitoring for reliability.
• Collaborate with architects and stakeholders to gather requirements and document data flows and runbooks.
• Apply security best practices for data in transit and at rest; manage credentials and RBAC.
• Support testing efforts and production troubleshooting for performance and data issues.
• Stay current with Power Platform, Dataverse, and Azure updates; recommend improvements.

Skills

Interpersonal skills

Verbal & written communication

Organizational & analytical skills

Multitasking & prioritization

Self-motivation & independence

Confidential information handling

MS Office proficiency

Attention to detail

Education

Bachelor’s degree in Information Technology/Computer Science or related field

Tools

Azure Data Factory

SSIS

Power Apps/Power Platform Dataflows

REST APIs

On-Premises Data Gateway

Power Automate

Dataverse security model

Job description

Cayuse Holdings seeks an Application Integration SME to design, develop, and maintain data integration pipelines connecting Microsoft Dataverse and the Power Platform with various systems. The role emphasizes secure, high-performance data migration across cloud and on-premises environments.

The candidate will build Power Automate flows, expose REST APIs, and ensure data quality with strong security practices. A TS clearance and onsite work in the Washington, DC area are expected.