Integration, SME

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 Dataverseand 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 Dataflowsto 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 APIsto facilitate bi-directional data exchange between Dataverse and external systems.
• Configure, maintain, and troubleshoot theOn-Premises Data Gateway for secure data access across on-premises and cloud environments.
• Execute data profiling, cleansing, mapping, andtransformationactivities, 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 managementandrole-based access control.
• Support testing efforts, including unit testing,integration testing, anduser 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 least8 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…