T

Technica

Cyber operations and systems engineering services

Application Integration SME

Data EngineeringConfirmed live in the last 24 hours
Full-timeWashington, DC, USA$107k - $143k /yr

About the Job

Requirements

  • A bachelor's degree in IT Technology or a related field, or equivalent education and/or experience.
  • Eight years of related experience.
  • Five years of experience in data engineering, data migration, or systems integration roles.
  • Active Top Secret clearance with SCI and CI Poly eligibility.
  • Demonstrated experience integrating and migrating data into and 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/Power Platform Dataflows.
  • Hands-on ETL experience with SQL Server Integration Services (SSIS).
  • Hands-on experience with pipeline orchestration and 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, including query optimization and relational database design.
  • A solid understanding of the Dataverse data model, entity relationships, and Power Platform security model, including business units, security roles, and teams.
  • Experience with data mapping, transformation logic, and data quality validation techniques.
  • Familiarity with authentication and authorization protocols, including OAuth 2.0, Azure AD/Entra ID app registrations, and service principals.
  • Strong analytical and troubleshooting skills to diagnose complex data and integration issues.
  • Excellent written and verbal communication skills, including technical design documentation for technical and non-technical audiences.

Responsibilities

  • Design, develop, and maintain data integration and migration pipelines between Dataverse/Power Platform and disparate source and target systems, including on-premises, cloud, and SaaS systems.
  • 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 for 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 to ensure data quality and integrity throughout migration and integration processes.
  • Develop and maintain error handling, logging, alerting, and monitoring for integration pipelines to support 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 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 troubleshoot 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.

Desired Qualifications

  • Microsoft certifications such as PL-400, PL-600, DP-600, DP-203, or AZ-204.
  • Experience with Azure Logic Apps and/or Azure Functions for custom integration logic.
  • Experience with Dataverse virtual tables/entities and virtual connectors.
  • Familiarity with Microsoft Fabric, Dataverse short-term retention, or Azure Synapse Link for Dataverse.
  • Experience with source control and CI/CD practices, including Azure DevOps and GitLab CI/CD.
  • Knowledge of message-based and event-driven integration patterns, including Azure Service Bus, Event Grid, and webhooks.
  • Experience with API management platforms.
  • Familiarity with data governance, master data management, and data retention/archival practices.
  • Experience 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, including managed/unmanaged solutions and environment strategy.
  • Familiarity with monitoring and observability tooling, including Application Insights and Azure Monitor.

About the Company

Technica

Cyber operations and systems engineering services

Technica supports the nation’s critical networks and systems by providing cyber operations solutions and high-end system engineering services to Defense, Intelligence, Law Enforcement, and federal civilian agencies since 1991. It leverages Systems Architecture & Integration, DevSecOps, IT Service Management, AIOps, AI/ML, and high-performance computing to design, build, and operate secure systems for cyber missions. Its differentiators include decades of government-focused experience, a team of senior scientists and engineers, and an approach that combines rigorous systems engineering with advances in AI, machine learning, and HPC to tackle complex cyber challenges. The company’s goal is to strengthen national cyber defense by delivering integrated technologies and services that improve the speed, accuracy, and effectiveness of cyber operations for government customers.

Company size
201-500
Company stage
Not listed
Total funding
Not listed
Headquarters
VA, United States
Founded
1991

Recently Posted Jobs

Explore more opportunities at Technica

See more jobs