Application Integration SME

Application Integration EngineerLocation: Washington, DCClearance: Top Secret clearanceThe 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.Key ResponsibilitiesDesign, develop, and maintain data integration and migration pipelines between Dataverse/Power Platform and disparate source and target systems (on-premises, cloud, and SaaS)Build and orchestrate ETL/ELT processes using Azure Data Factory, SQL Server Integration Services (SSIS), and Power Apps/Power Platform DataflowsDevelop and support integration flows using Power Automate, including scheduled, triggered, and event-driven workflowsDesign, consume, and expose REST APIs and web services to enable bi-directional data exchange between Dataverse and external systemsConfigure, maintain, and troubleshoot the On-Premises Data Gateway to enable secure connectivity between cloud services and on-premises data sourcesPerform data profiling, cleansing, mapping, and transformation activities to ensure data quality and integrity throughout migration and integration processesDevelop and maintain error handling, logging, alerting, and monitoring for all integration pipelines to ensure reliability and rapid issue resolutionCollaborate with solution architects, functional consultants, and business stakeholders to gather integration requirements and translate them into technical designsDocument data flows, integration architecture, mapping specifications, and operational runbooksParticipate in data migration planning and execution for new Dataverse implementations, including extraction, transformation, validation, and load activitiesOptimize integration performance, including throughput, latency, and API/service protection limits within Dataverse and connected systemsSupport testing efforts including unit, integration, and user acceptance testing for data migration and integration solutionsApply security and compliance best practices for data in transit and at rest, including credential/secrets management and role-based access controlProvide production support and troubleshooting for integration failures, data discrepancies, and performance issuesStay current with Microsoft Power Platform, Dataverse, and Azure integration service updates and recommend improvements to existing solutionsMandatory Qualifications5+ years of experience in data engineering, data migration, or systems integration rolesDemonstrated experience integrating and migrating data into/out of Microsoft Dataverse and Power PlatformHands-on experience with Power Automate for building integration and orchestration workflowsHands-on experience with Power Apps/Platform DataflowsHands-on ETL experience with SQL Server Integration Services (SSIS)Hands-on experience with pipeline orchestration/data movement in Azure Data FactoryExperience designing, consuming, and troubleshooting REST APIs for system-to-system integrationExperience configuring and maintaining the On-Premises Data GatewayStrong 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 techniquesFamiliarity 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 issuesExcellent written and verbal communication skills; technical design documentation for technical and non-technical audiencesPreferred QualificationsMicrosoft certifications such as PL-400, PL-600, DP-600, DP-203, or AZ-204Azure Logic Apps and/or Azure Functions for custom integration logic experienceDataverse virtual tables/entities and virtual connectors experienceFamiliarity with Microsoft Fabric, Dataverse short-term retention, or Azure Synapse Link for DataverseExperience with source control and CI/CD practices (Azure DevOps, GitLab CI/CD)Knowledge of message-based/event-driven integration patterns (Azure Service Bus, Event Grid, webhooks)Experience with API management platformsFamiliarity with data governance, master data management, and data retention/archival practicesExperience in integrating Power Platform with ERP or CRM systemsWorking knowledge of C#/.NET or PowerShell for custom connectors, plug-ins, or automation scriptingExperience with Application Lifecycle Management (ALM) for Power Platform solutions (managed/unmanaged solutions, environment strategy)Familiarity with monitoring and observability tooling (Application Insights, Azure Monitor)ClearanceApplicants selected will be subject to a security investigation and may need to meet eligibility requirements for access to classified information; Top Secret clearance requiredCompensation and BenefitsSalary Range: $150,000 - $175,000 (Compensation is determined by various factors, including but not limited to location, work experience, skills, education, certifications, seniority, and business needs. This range may be modified in the future.)Benefits: Gridiron offers a comprehensive benefits package including medical, dental, vision insurance, HSA, FSA, 401(k), disability & ADD insurance, life and pet insurance to eligible employees. Full-time and part-time employees working at least 30 hours per week on a regular basis are eligible to participate in Gridiron’s benefits programs.Gridiron IT Solutions is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, pregnancy, sexual orientation, gender identity, national origin, age, protected veteran status or disability status.Gridiron IT is a Women Owned Small Business (WOSB) headquartered in the Washington, D.C. area that supports our clients' missions throughout the United States. Gridiron IT specializes in providing comprehensive IT services tailored to meet the needs of federal agencies. Our capabilities include IT Infrastructure & Cloud Services, Cyber Security, Software Integration & Development, Data Solution & AI, and Enterprise Applications. These capabilities are backed by Gridiron IT's experienced workforce and our commitment to ensuring we meet and exceed our clients' expectations.