Skip to main content
Cayuse Holdings logo

Application Integration, SME

Cayuse Holdings

Washington, DCFull-time$151–153K/yrSeen 1w agoIn the employer's feed · checked in the last 2 days

See where you stand before you apply. No sign-up to start.

You apply on the posting's application page, with no Olive account needed.

Watch jobs like this.

Don't just apply. Show up ready.

Olive works from this exact posting.

At a glance

Compensation
$151–153K/yr
Location
Washington, DC
Schedule
Full-time
Work Authorization
Citizenship required

Olive focuses on jobs in the United States, including remote roles you can work from there.

Requirements

Credentials this posting asks for.

Top Secret clearance, required

Job overview

The Application Integration, SME designs, develops, and maintains data integration pipelines connecting Microsoft Dataverse and Power Platform with internal and external systems. The role supports secure data migration and integration across cloud and on-premises environments, including API integrations and complex workflows. Employment is conditional upon successful execution of the client contract. The position is full-time, onsite, and requires an active Top Secret security clearance.

Skills & qualifications

RequiredNice to have

Skills

Data Integration, nice to haveData Migration, nice to haveMicrosoft Dataverse, nice to havePower Platform, nice to havePower Automate, nice to havePower Apps Dataflows, nice to haveSSIS, nice to haveAzure Data Factory, nice to haveREST APIs, nice to haveOn-Premises Data Gateway, nice to haveSQL, nice to haveRelational Database Design, nice to haveDataverse Data Modeling, nice to havePower Platform Security, nice to haveData Mapping, nice to haveData Transformation, nice to haveData Quality Validation, nice to haveOAuth 2.0, nice to haveAzure AD App Registrations, nice to haveService Principals, nice to haveAnalytical Troubleshooting, nice to haveInterpersonal Skills, nice to haveCommunication, nice to haveOrganization, nice to haveProblem Solving, nice to haveAttention to Detail, nice to haveMultitasking, nice to havePrioritization, nice to haveAdaptability, nice to haveIndependent Work, nice to haveTeamwork, nice to haveConfidential Information Handling, nice to haveMicrosoft Office, nice to haveMicrosoft Word, nice to haveMicrosoft Outlook, nice to haveMicrosoft PowerPoint, nice to haveMicrosoft Excel, nice to haveAzure Logic Apps, nice to haveAzure Functions, nice to haveDataverse Virtual Tables, nice to have

Qualifications

Bachelor's in IT or Related, nice to have8+ Years Related Experience, nice to have5+ Years Data Engineering Experience, nice to haveActive Top Secret Clearance, nice to haveBackground Check, nice to havePL-400 or PL-600 or DP-600 or DP-203 or AZ-204, nice to haveAzure DevOps, nice to haveGitLab CI/CD, nice to haveAzure Service Bus, nice to haveEvent Grid, nice to haveWebhooks, nice to haveC#/.NET, nice to have

Benefits

Medical Insurance
Dental Insurance
Vision Insurance
401(k) Match
Paid Time Off

Full job description

Overview

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.

Responsibilities

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

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 integration using tools like 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 Application Lifecycle Management (ALM) for Power Platform solutions, including managed/unmanaged solutions and environment strategies.

  • Familiarity with tools like Application Insights and Azure Monitor to enhance system reliability and observability.

Our Commitment to you / overview of benefits:

  • Medical, Dental and Vision Insurance; Wellness Program

  • Flexible Spending Accounts (Healthcare, Dependent Care, Commuter)

  • Short-Term and Long-Term Disability options

  • Basic Life and AD&D Insurance (Company Provided)

  • Voluntary Life and AD&D options

  • 401(k) Retirement Savings Plan with matching after one year

  • Paid Time Off

Reports to: Program Manager

Working Conditions:

  • Professional office environment, with the ability to work onsite in the main office.

  • Must be physically and mentally able to perform duties extended periods of time.

  • Ability to use a computer and other office productivity tools with sufficient speed to meet the demands of this position.

  • Must be able to establish a productive and professional workspace.

  • Must be able to sit for long periods of time looking at computer screen.

  • May be asked to work a flexible schedule which may include holidays.

  • May be asked to travel for business or professional development purposes.

  • May be asked to work hours outside of normal business hours.

Other Duties: Please note this job description is not designed to cover or contain a comprehensive list of activities, duties or responsibilities that are required of the employee for this job. Duties, responsibilities, and activities may change at any time with or without notice.

Cayuse is an Equal Opportunity Employer. All employment decisions are based on merit, qualifications, skills, and abilities. All qualified applicants will receive consideration for employment in accordance with any applicable federal, state, or local law.

Submit a Referral (https://careers-cayuseholdings.icims.com/jobs/4788/application-integration%2c-sme/job?mode=apply&apply=yes&in\_iframe=1&hashed=-1834356743)

Can't find the right opportunity?

Join ourTalent Community (https://join.cayuseholdings.com/join/talentcommunity/form) orLanguage Services Talent Community (https://join.cayuseholdings.com/ls/talentcommunity/form) and be among the first to discover exciting new possibilities!

Software Powered by ICIMS (https://icims.help/candidate-faq)

Location US-DC-Washington

ID 2026-4788

Category Information Technology

Position Type Full-Time Salary Exempt

Remote No

Clearance Required Top Secret

Pay Range USD $151,000.00 - USD $153,441.00 /Yr.

How this job compares

Set against the 3,517 open Data Engineering jobs on Olive Jobs, counted November 20, 2026.

Pay
  • This posting$151–153K/yr
  • Washington, D.C. median$128–209K/yr41 salary ranges
  • US median$124–210K/yr2,969 salary ranges

This range's midpoint, $152K, is 12% below the Washington, D.C. median midpoint ($173K) — in the middle half of Data Engineering salary ranges in Washington, D.C..

Openings
Olive Jobs lists 43 open Data Engineering jobs in Washington, D.C. and 3,517 across the US. 9% of them nationwide are listed as remote or flexible.
Hiring the most in Washington, D.C.
Experience
This posting asks for at least 8 years of experience; Data Engineering postings that state a minimum ask for 5 years at the median (3,086 postings).
Education
1,248 of the 3,517 open Data Engineering jobs (35%) ask for a bachelor's degree or higher.

Counted across the open, public US postings on Olive Jobs on November 20, 2026. Figures based on too few postings are left out.

Prepare for this role

You've read the whole posting — now see how you match it.