Application Integration SME

Gridiron IT; Washington (District of Columbia); On-site; USD 150,000 - 175,000; Full time

Benefits offered by this job

Medical insurance

Dental insurance

Vision insurance

HSA

FSA

401(k)

Disability insurance

Life insurance

Pet insurance

Job summary

Gridiron IT is seeking an Application Integration Engineer to design, build, and maintain data pipelines that connect Microsoft Dataverse and the Power Platform with internal and external systems. You will ensure reliable, secure data migration across cloud and on-prem environments while optimizing performance and governance.

The role requires hands-on experience with ADF, SSIS, Power Automate, and Dataverse data models, plus strong SQL and API skills to support scalable integrations and robust

Qualifications

• 5+ years of experience in data engineering, data migration, or systems integration roles.
• Hands-on experience with Dataverse and Power Platform data migrations.
• Hands-on ETL with SSIS and Azure Data Factory.
• Experience designing, consuming, and troubleshooting REST APIs for system integrations.
• Strong SQL skills and data modeling for Dataverse environments.

Responsibilities

• Design, develop, and maintain data integration pipelines between Dataverse/Power Platform and various source/target systems.
• Build and orchestrate ETL/ELT processes using ADF, SSIS, and Dataflows.
• Develop and support integration flows with Power Automate, including scheduled and event-driven workflows.
• Expose REST APIs and web services for bi-directional data exchange with external systems.
• Configure and troubleshoot On-Premises Data Gateway for secure connectivity.

Skills

ETL

Power Automate

SSIS

Azure Data Factory

SQL

Dataverse

REST APIs

Data governance

Security/compliance

Troubleshooting

Tools

Power Apps/Platform Dataflows

On-Premises Data Gateway

Dataverse connections

Azure Synapse

Azure AD/Entra ID

Job description

The 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 Responsibilities

• Design, 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 Dataflows
• Develop and support integration flows using Power Automate, including scheduled, triggered, and event-driven workflows
• Design, consume, and expose REST APIs and web services to enable bi-directional data exchange between Dataverse and external systems
• Configure, maintain, and troubleshoot the On-Premises Data Gateway to enable secure connectivity between cloud services and on-premises data sources
• Perform data profiling, cleansing, mapping, and transformation activities to ensure data quality and integrity throughout migration and integration processes
• Develop and maintain error handling, logging, alerting, and monitoring for all integration pipelines to ensure reliability and rapid issue resolution
• Collaborate with solution architects, functional consultants, and business stakeholders to gather integration requirements and translate them into technical designs
• Document data flows, integration architecture, mapping specifications, and operational runbooks
• Participate in data migration planning and execution for new Dataverse implementations, including extraction, transformation, validation, and load activities
• Optimize integration performance, including throughput, latency, and API/service protection limits within Dataverse and connected systems
• Support testing efforts including unit, integration, and user acceptance testing for data migration and integration solutions
• Apply security and compliance best practices for data in transit and at rest, including credential/secrets management and role-based access control
• Provide production support and troubleshooting for integration failures, data discrepancies, and performance issues
• Stay current with Microsoft Power Platform, Dataverse, and Azure integration service updates and recommend improvements to existing solutions

Mandatory Qualifications

• 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
• Excellent written and verbal communication skills; technical design documentation for technical and non-technical audiences

Preferred Qualifications

• Microsoft certifications such as PL-400, PL-600, DP-600, DP-203, or AZ-204
• Azure Logic Apps and/or Azure Functions for custom integration logic experience
• Dataverse virtual tables/entities and virtual connectors experience
• Familiarity with Microsoft Fabric, Dataverse short-term retention, or Azure Synapse Link for Dataverse
• Experience 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 platforms
• Familiarity with data governance, master data management, and data retention/archival practices
• Experience in integrating Power Platform with ERP or CRM systems
• Working knowledge of C#/.NET or PowerShell for custom connectors, plug-ins, or automation scripting
• Experience with Application Lifecycle Management (ALM) for Power Platform solutions (managed/unmanaged solutions, environment strategy)
• Familiarity with monitoring and observability tooling (Application Insights, Azure Monitor)

Clearance

Applicants selected will be subject to a security investigation and may need to meet eligibility requirements for access to classified information; Top Secret clearance required

Compensation and Benefits

Salary 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.