{"schemaVersion":"jobsearcher.job.v1","id":"a7b5dd8bf32f2051cbced838","url":"https://jobsearcher.com/jobs/a7b5dd8bf32f2051cbced838","canonicalUrl":"https://jobsearcher.com/jobs/a7b5dd8bf32f2051cbced838","title":"Application Integration SME","description":"Why AIS?\n\nWhen you join AIS, you’re joining a mission-driven team that’s passionate about making a difference. You’ll work on projects that matter, alongside industry-leading experts, in an environment that fosters innovation, driving client success, and empowering our team to make a lasting impact. As an employee-owned company, we value collaboration, inclusivity, continuous growth, and shared success.\n\nEmployee Ownership : Your contributions directly impact the company’s success, and you share in its achievements.\n\nContinuous Learning : Access to resources, training, and mentorship to support your professional growth.\n\nInclusive Culture : A workplace where diversity is celebrated, and everyone’s voice is valued.\n\nMission-Driven Work : Engage in projects that make a meaningful difference for our clients and communities.\n\nWhat are we looking for?\n\nAt AIS, we're looking for more than just skills - we're looking for driven individuals who are passionate about making a difference, eager to grow, and aligned with our core principles.\n\nWorking@AIS\n\nAt AIS, we are dedicated to providing our employees with diverse opportunities to grow their careers while supporting a variety of impactful projects. For this position, we are seeking a talented individual to join AIS as a Lead Data Analytics Engineer.\n\nCore Knowledge & Skills: Masters SQL and data architecture; builds end-to-end pipelines on cloud platforms; ensures security and compliance; leverages APIs and advanced AI/ML; plans and leads projects and team resources.\n\nWork & Complexity: Owns full lifecycle delivery; resolves ambiguous, enterprise-scale problems; shapes technical direction and project outcomes.\n\nQuality & Independence: Establishes best practices and performance metrics; oversees QA for major initiatives; operates with wide decision latitude.\n\nTeamwork & Communication: Leads teams implementing complex solutions; aligns with business objectives; serves as primary liaison to executives; drives structured feedback.\n\nConsulting & Engagement: Advises executive stakeholders on strategic data initiatives; leads consulting teams; embeds innovative, data-driven\n\nAs your initial project assignment, you will support the unique needs of our client as a Application Integration SME.\n\nAIS is hiring a skilled Application Integration Engineer is responsible for designing, building, and maintaining data integration pipelines that connect Microsoft Dataverse and the Power Platform with internal and external systems. This role focuses on ensuring reliable, secure, and performant data migration and integration across cloud and on-premises environments.\n\nKey Responsibilities\nDesign, develop, and maintain data integration and migration pipelines between Dataverse/Power Platform and disparate source and target systems (on-premises, cloud, and SaaS)\nBuild and orchestrate ETL/ELT processes using Azure Data Factory, SQL Server Integration Services (SSIS), and Power Apps/Power Platform Dataflows\nDevelop and support integration flows using Power Automate, including scheduled, triggered, and event-driven workflows\nDesign, consume, and expose REST APIs and web services to enable bi-directional data exchange between Dataverse and external systems\nConfigure, maintain, and troubleshoot the On-Premises Data Gateway to enable secure connectivity between cloud services and on-premises data sources\nPerform data profiling, cleansing, mapping, and transformation activities to ensure data quality and integrity throughout migration and integration processes\nDevelop and maintain error handling, logging, alerting, and monitoring for all integration pipelines to ensure reliability and rapid issue resolution\nCollaborate with solution architects, functional consultants, and business stakeholders to gather integration requirements and translate them into technical designs\nDocument data flows, integration architecture, mapping specifications, and operational runbooks\nParticipate in data migration planning and execution for new Dataverse implementations, including extraction, transformation, validation, and load activities\nOptimize integration performance, including throughput, latency, and API/service protection limits within Dataverse and connected systems\nSupport testing efforts including unit, integration, and user acceptance testing for data migration and integration solutions\nApply security and compliance best practices for data in transit and at rest, including credential/secrets management and role-based access control\nProvide production support and troubleshooting for integration failures, data discrepancies, and performance issues\nStay current with Microsoft Power Platform, Dataverse, and Azure integration service updates and recommend improvements to existing solutions\n\nRequired For This Opportunity\nActive Top Secret Clearance\n5+ years of experience in data engineering, data migration, or systems integration roles\nDemonstrated experience integrating and migrating data into/out of Microsoft Dataverse and Power Platform\nHands-on experience with Power Automate for building integration and orchestration workflows\nHands-on experience with Power Apps/Platform Dataflows\nHands-on ETL experience with SQL Server Integration Services (SSIS)\nHands-on experience with pipeline orchestration/data movement in Azure Data Factory\nExperience designing, consuming, and troubleshooting REST APIs for system-to-system integration\nExperience configuring and maintaining the On-Premises Data Gateway\nStrong proficiency in SQL (query optimization, relational database design)\nSolid understanding of Dataverse data model, entity relationships, and Power Platform security model (business units, security roles, teams)\nExperience with data mapping, transformation logic, and data quality validation techniques\nFamiliarity with authentication and authorization protocols (OAuth 2.0, Azure AD/Entra ID app registrations, service principals)\nStrong analytical/troubleshooting skills; ability to diagnose complex data/integration issues\n\nNice to Have Skills\nMicrosoft certifications such as PL-400, PL-600, DP-600, DP-203, or AZ-204\nAzure Logic Apps and/or Azure Functions for custom integration logic experience\nDataverse virtual tables/entities and virtual connectors experience\nFamiliarity with Microsoft Fabric, Dataverse short-term retention, or Azure Synapse Link for Dataverse\nExperience with source control and CI/CD practices (Azure DevOps, GitLab CI/CD)\nKnowledge of message-based/event-driven integration patterns (Azure Service Bus, Event Grid, webhooks)\nExperience with API management platforms\nFamiliarity with data governance, master data management, and data retention/archival practices\nExperience in integrating Power Platform with ERP or CRM systems\nWorking knowledge of C#/.NET or PowerShell for custom connectors, plug-ins, or automation scripting\nExperience with Application Lifecycle Management (ALM) for Power Platform solutions (managed/unmanaged solutions, environment strategy)\nFamiliarity with monitoring and observability tooling (Application Insights, Azure Monitor)\n\nAt AIS, we are committed to offering competitive and fair compensation that reflects the skills, experience, and contributions of each team member.\n\nThe targeted base salary range for this role is $125,000-$189,000 per year. Please note that this range is provided as a guideline and the final offer will be based on several factors, including but not limited to, skillset and competencies, level of experience, education, certifications, and location.\n\nWe value transparency in our hiring process and are happy to discuss how your unique qualifications align with our compensation structure during the interview process.\n\nApplied Information Sciences does not discriminate on the basis of race, national origin, religion, color, gender, sexual orientation, age, disability, protected veteran status, or any other basis. Employment decisions are based solely on qualifications, merit, and business needs.","company":"Applied Information Sciences","rawCompany":"applied information sciences","city":"Washington","state":"DC","isRemote":false,"isActive":false,"createdAt":"2026-09-17T10:50:32.374Z","occupations":[{"code":"15-1243.01","title":"Data Warehousing Specialists","slug":"data-warehousing-specialists"},{"code":"15-1299.08","title":"Computer Systems Engineers/Architects","slug":"computer-systems-engineers-architects"},{"code":"15-1252.00","title":"Software Developers","slug":"software-developers"}],"industries":[{"code":"541512","title":"Computer Systems Design Services","slug":"computer-systems-design-services"},{"code":"541511","title":"Custom Computer Programming Services","slug":"custom-computer-programming-services"},{"code":"541690","title":"Other Scientific and Technical Consulting Services","slug":"other-scientific-and-technical-consulting-services"}],"jobPosting":{"@context":"https://schema.org","@type":"JobPosting","title":"Application Integration SME","description":"Why AIS?\n\nWhen you join AIS, you’re joining a mission-driven team that’s passionate about making a difference. You’ll work on projects that matter, alongside industry-leading experts, in an environment that fosters innovation, driving client success, and empowering our team to make a lasting impact. As an employee-owned company, we value collaboration, inclusivity, continuous growth, and shared success.\n\nEmployee Ownership : Your contributions directly impact the company’s success, and you share in its achievements.\n\nContinuous Learning : Access to resources, training, and mentorship to support your professional growth.\n\nInclusive Culture : A workplace where diversity is celebrated, and everyone’s voice is valued.\n\nMission-Driven Work : Engage in projects that make a meaningful difference for our clients and communities.\n\nWhat are we looking for?\n\nAt AIS, we're looking for more than just skills - we're looking for driven individuals who are passionate about making a difference, eager to grow, and aligned with our core principles.\n\nWorking@AIS\n\nAt AIS, we are dedicated to providing our employees with diverse opportunities to grow their careers while supporting a variety of impactful projects. For this position, we are seeking a talented individual to join AIS as a Lead Data Analytics Engineer.\n\nCore Knowledge & Skills: Masters SQL and data architecture; builds end-to-end pipelines on cloud platforms; ensures security and compliance; leverages APIs and advanced AI/ML; plans and leads projects and team resources.\n\nWork & Complexity: Owns full lifecycle delivery; resolves ambiguous, enterprise-scale problems; shapes technical direction and project outcomes.\n\nQuality & Independence: Establishes best practices and performance metrics; oversees QA for major initiatives; operates with wide decision latitude.\n\nTeamwork & Communication: Leads teams implementing complex solutions; aligns with business objectives; serves as primary liaison to executives; drives structured feedback.\n\nConsulting & Engagement: Advises executive stakeholders on strategic data initiatives; leads consulting teams; embeds innovative, data-driven\n\nAs your initial project assignment, you will support the unique needs of our client as a Application Integration SME.\n\nAIS is hiring a skilled Application Integration Engineer is responsible for designing, building, and maintaining data integration pipelines that connect Microsoft Dataverse and the Power Platform with internal and external systems. This role focuses on ensuring reliable, secure, and performant data migration and integration across cloud and on-premises environments.\n\nKey Responsibilities\nDesign, develop, and maintain data integration and migration pipelines between Dataverse/Power Platform and disparate source and target systems (on-premises, cloud, and SaaS)\nBuild and orchestrate ETL/ELT processes using Azure Data Factory, SQL Server Integration Services (SSIS), and Power Apps/Power Platform Dataflows\nDevelop and support integration flows using Power Automate, including scheduled, triggered, and event-driven workflows\nDesign, consume, and expose REST APIs and web services to enable bi-directional data exchange between Dataverse and external systems\nConfigure, maintain, and troubleshoot the On-Premises Data Gateway to enable secure connectivity between cloud services and on-premises data sources\nPerform data profiling, cleansing, mapping, and transformation activities to ensure data quality and integrity throughout migration and integration processes\nDevelop and maintain error handling, logging, alerting, and monitoring for all integration pipelines to ensure reliability and rapid issue resolution\nCollaborate with solution architects, functional consultants, and business stakeholders to gather integration requirements and translate them into technical designs\nDocument data flows, integration architecture, mapping specifications, and operational runbooks\nParticipate in data migration planning and execution for new Dataverse implementations, including extraction, transformation, validation, and load activities\nOptimize integration performance, including throughput, latency, and API/service protection limits within Dataverse and connected systems\nSupport testing efforts including unit, integration, and user acceptance testing for data migration and integration solutions\nApply security and compliance best practices for data in transit and at rest, including credential/secrets management and role-based access control\nProvide production support and troubleshooting for integration failures, data discrepancies, and performance issues\nStay current with Microsoft Power Platform, Dataverse, and Azure integration service updates and recommend improvements to existing solutions\n\nRequired For This Opportunity\nActive Top Secret Clearance\n5+ years of experience in data engineering, data migration, or systems integration roles\nDemonstrated experience integrating and migrating data into/out of Microsoft Dataverse and Power Platform\nHands-on experience with Power Automate for building integration and orchestration workflows\nHands-on experience with Power Apps/Platform Dataflows\nHands-on ETL experience with SQL Server Integration Services (SSIS)\nHands-on experience with pipeline orchestration/data movement in Azure Data Factory\nExperience designing, consuming, and troubleshooting REST APIs for system-to-system integration\nExperience configuring and maintaining the On-Premises Data Gateway\nStrong proficiency in SQL (query optimization, relational database design)\nSolid understanding of Dataverse data model, entity relationships, and Power Platform security model (business units, security roles, teams)\nExperience with data mapping, transformation logic, and data quality validation techniques\nFamiliarity with authentication and authorization protocols (OAuth 2.0, Azure AD/Entra ID app registrations, service principals)\nStrong analytical/troubleshooting skills; ability to diagnose complex data/integration issues\n\nNice to Have Skills\nMicrosoft certifications such as PL-400, PL-600, DP-600, DP-203, or AZ-204\nAzure Logic Apps and/or Azure Functions for custom integration logic experience\nDataverse virtual tables/entities and virtual connectors experience\nFamiliarity with Microsoft Fabric, Dataverse short-term retention, or Azure Synapse Link for Dataverse\nExperience with source control and CI/CD practices (Azure DevOps, GitLab CI/CD)\nKnowledge of message-based/event-driven integration patterns (Azure Service Bus, Event Grid, webhooks)\nExperience with API management platforms\nFamiliarity with data governance, master data management, and data retention/archival practices\nExperience in integrating Power Platform with ERP or CRM systems\nWorking knowledge of C#/.NET or PowerShell for custom connectors, plug-ins, or automation scripting\nExperience with Application Lifecycle Management (ALM) for Power Platform solutions (managed/unmanaged solutions, environment strategy)\nFamiliarity with monitoring and observability tooling (Application Insights, Azure Monitor)\n\nAt AIS, we are committed to offering competitive and fair compensation that reflects the skills, experience, and contributions of each team member.\n\nThe targeted base salary range for this role is $125,000-$189,000 per year. Please note that this range is provided as a guideline and the final offer will be based on several factors, including but not limited to, skillset and competencies, level of experience, education, certifications, and location.\n\nWe value transparency in our hiring process and are happy to discuss how your unique qualifications align with our compensation structure during the interview process.\n\nApplied Information Sciences does not discriminate on the basis of race, national origin, religion, color, gender, sexual orientation, age, disability, protected veteran status, or any other basis. Employment decisions are based solely on qualifications, merit, and business needs.","datePosted":"2026-09-17T10:50:32.374Z","dateModified":"2026-09-17T10:50:32.374Z","hiringOrganization":{"@type":"Organization","name":"Applied Information Sciences","sameAs":"https://jobsearcher.com"},"jobLocation":{"@type":"Place","address":{"@type":"PostalAddress","addressLocality":"Washington","addressRegion":"DC","addressCountry":"US"}},"identifier":{"@type":"PropertyValue","name":"JobSearcher","value":"a7b5dd8bf32f2051cbced838"},"url":"https://jobsearcher.com/jobs/a7b5dd8bf32f2051cbced838"}}