Senior Application Integration Engineer | Employee-Owned

Applied Information Sciences, Inc; Washington (District of Columbia); On-site; USD 120,000 - 180,000; Full time

Job summary

Applied Information Sciences, Inc. seeks a Lead Data Analytics Engineer to design, build, and maintain data integration pipelines across Dataverse and Power Platform. You will lead end-to-end data migration projects, ensure security and compliance, and collaborate with executives on data-driven initiatives.

The role emphasizes delivering reliable integration solutions, optimizing performance, and guiding teams through complex implementations in a fast-paced, mission-driven environment.

Qualifications

• Active Top Secret Clearance and 5+ years in data engineering or systems integration roles.
• Demonstrated experience integrating and migrating data into/out of Microsoft Dataverse and Power Platform.
• Strong SQL, data modeling, and data quality validation skills.

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, 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 throughout migration and integration
• Develop and maintain error handling, logging, alerting, and monitoring for all integration pipelines
• Collaborate with solution architects, consultants, and stakeholders to translate requirements into designs

Skills

SQL expertise

Dataverse/Power Platform

ETL/ELT

SSIS

Azure Data Factory

REST APIs

On-Prem Data Gateway

Data modeling

Security/ IAM

Education

Bachelor's degree in CS/IS/Engineering

Tools

Power Automate

Power Apps

Azure Data Factory

Dataverse

Job description

Applied Information Sciences, Inc. seeks a Lead Data Analytics Engineer to design, build, and maintain data integration pipelines across Dataverse and Power Platform. You will lead end-to-end data migration projects, ensure security and compliance, and collaborate with executives on data-driven initiatives.

The role emphasizes delivering reliable integration solutions, optimizing performance, and guiding teams through complex implementations in a fast-paced, mission-driven environment.