Application Integration, SME

Cayuse Holdings • Washington, DC

23h • $151,000 - $153,441

About The Position

The Application Integration, SME will design, develop, and maintain data integration pipelines connecting Microsoft Dataverse and the Power Platform with internal and external systems. The role focuses on secure, reliable, and high-performance data migration and integration across cloud and on-premises environments, including complex data workflows, API integrations, and hybrid system connections, while adhering to security and compliance standards. Employment is conditional upon successful execution of the client contract.

The position works with solution architects, business stakeholders, and functional consultants to gather requirements and develop technical solutions. It supports testing and production troubleshooting, documents integration designs and operating procedures, and keeps current with Power Platform, Dataverse, and Azure integration services. The role aligns with Cayuse values of Innovation, Excellence, Collaboration, Adaptability, and Integrity.

This role is performed in a professional office environment, with the ability to work onsite in the main office. Business travel may be requested. A flexible schedule, including holidays, and work outside normal business hours may also be requested.

Requirements

• Bachelor’s degree in Information Technology, Computer Science, or a related field, or equivalent experience.
• At least 8 years of related professional experience.
• 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 for integration and orchestration workflows.
• Hands-on experience with Power Apps/Power 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 authentication and authorization protocols, including OAuth 2.0, Azure AD/Entra ID app registrations, and service principals.
• Strong analytical and troubleshooting skills, including the ability to diagnose complex data and integration issues.
• Active Top Secret Security Clearance.
• Must be able to pass a background check; additional checks may be required by projects or clients during employment.
• Exceptional interpersonal skills and clear, professional, articulate communication.
• Exceptional verbal and written communication skills.
• Excellent organizational, analytical, and problem-solving skills, with strong attention to detail.
• Ability to multitask and prioritize in a fast-paced environment with changing priorities; adaptability and ability to learn quickly.
• Self-motivated, able to work independently and as part of a multifunctional team.
• Ability to handle sensitive and confidential information appropriately.
• Proficiency in MS Office, including Word, Outlook, PowerPoint, and Excel.

Nice To Haves

• 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, such as Azure DevOps or GitLab CI/CD.
• Familiarity with message-based or event-driven integration using Azure Service Bus, Event Grid, or webhooks.
• Working knowledge of C#/.NET or PowerShell for custom connectors, automation scripting, and plug-ins.
• Knowledge of master data management, data retention, and archival strategies.
• Experience with Power Platform Application Lifecycle Management (ALM), including managed/unmanaged solutions and environment strategies.
• Familiarity with Application Insights and Azure Monitor to enhance system reliability and observability.

Responsibilities

• Design, develop, and maintain integration and migration pipelines using Azure Data Factory, SQL Server Integration Services (SSIS), and Power Apps/Power Platform Dataflows to connect Dataverse with on-premises, cloud, and SaaS systems.
• Build and support scheduled, triggered, and event-driven Power Automate integration flows.
• Develop, consume, and expose REST APIs for bidirectional data exchange between Dataverse and external systems.
• Configure, maintain, and troubleshoot the On-Premises Data Gateway.
• Perform data profiling, cleansing, mapping, and transformation, maintaining data quality and integrity and applying analytical techniques to troubleshoot data issues.
• Optimize pipelines for throughput, latency, and protection limits, and implement error handling, logging, alerting, and monitoring.
• Gather requirements with solution architects, business stakeholders, and functional consultants; 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 unit, integration, and user acceptance testing, and 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 improvements to system performance and capabilities.
• Perform other duties as assigned.

Benefits

• Medical, dental, and vision insurance.
• Wellness Program.
• Flexible Spending Accounts for healthcare, dependent care, and commuter expenses.
• Short-term and long-term disability options.
• Company-provided basic life and AD&D insurance.
• Voluntary life and AD&D options.
• 401(k) Retirement Savings Plan with matching after one year.
• Paid Time Off.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior