Application Integration SME

Applied Information Sciences

Washington (District of Columbia)

Vor Ort

USD 140.000 - 180.000

Vollzeit

14 Tage+

Erhalte eine Antwort von diesem Arbeitgeber

Dein Lebenslauf und dein Anschreiben, genau auf das zugeschnitten, was gesucht wird.

Schaffe es an den ATS-Filtern vorbei

Zusammenfassung

Applied Information Sciences in Washington, DC seeks a Lead Data Analytics Engineer to design, build, and maintain data integration pipelines across Dataverse/Power Platform and external systems.

This role requires Top Secret clearance, 5+ years of data engineering or migration experience, and Microsoft data ecosystem expertise. You will lead end-to-end projects, ensure security, and collaborate with executives on strategic data initiatives.

Qualifikationen

  • This role requires an active Top Secret Clearance.
  • 5+ years of experience in data engineering, data migration, or systems integration.
  • Demonstrated experience integrating and migrating data into/out of Microsoft platforms.

Aufgaben

  • Design, develop, and maintain data integration and migration pipelines across Dataverse/Power Platform and external systems.
  • Build ETL/ELT processes using Azure Data Factory, SSIS, and Power Platform Dataflows.
  • Develop and support integration flows with Power Automate for various workflows.
  • Expose REST APIs and web services for bi-directional data exchange.
  • Ensure secure connectivity and data quality throughout migration and integration processes.
  • Provide leadership in project delivery and team resource planning.

Kenntnisse

SQL & data architecture
Cloud pipelines
APIs & integrations
Security & compliance
Leadership & planning
AI/ML basics

Tools

Azure Data Factory
SSIS
Power Automate
Dataverse
Power Platform
REST APIs

Jobbeschreibung

Why AIS?

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

Employee Ownership : Your contributions directly impact the company's success, and you share in its achievements.

Continuous Learning : Access to resources, training, and mentorship to support your professional growth.

Inclusive Culture : A workplace where diversity is celebrated, and everyone's voice is valued.

Mission-Driven Work : Engage in projects that make a meaningful difference for our clients and communities.

What are we looking for?

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

Working@AIS

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

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

Work & Complexity: Owns full lifecycle delivery; resolves ambiguous, enterprise-scale problems; shapes technical direction and project outcomes.

Quality & Independence: Establishes best practices and performance metrics; oversees QA for major initiatives; operates with wide decision latitude.

Teamwork & Communication: Leads teams implementing complex solutions; aligns with business objectives; serves as primary liaison to executives; drives structured feedback.

Consulting & Engagement: Advises executive stakeholders on strategic data initiatives; leads consulting teams; embeds innovative, data-driven

As your initial project assignment, you will support the unique needs of our client as a Application Integration SME.

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

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 opportunity
  • Develop and maintain error handling, logging, alerting and monitoring for all integration pipelines to ensure reliability and rapid opportunity
Required For This Opportunity
  • Active Top Secret Clearance
  • 5+ years of experience in data engineering, data migration, or systems integration roles
  • Demonstrated experience integrating and migrating data into/out of Microsoft
Hol dir deinen kostenlosen, vertraulichen Lebenslauf-Check.

oder ziehe deine Datei hierhin.

Similar jobs

Ähnliche Jobs, die dir auch gefallen könnten

Application Integration SME
Application Integration SME

Applied Information Sciences, Inc • Washington

Vor Ort
USD 120.000 - 180.000
Application Integration SME
Application Integration SME

AIS (Applied Information Sciences) • Washington

Vor Ort
USD 125.000 - 189.000
Employee Ownership
Continuous Learning
Inclusive Culture
Application Integration SME - TS required - Wash DC & Hybrid
Application Integration SME - TS required - Wash DC & Hybrid

Bow Wave LLC • Washington

Vor Ort
USD 110.000 - 150.000
Application Integration SME
Application Integration SME

Bow Wave LLC • Washington

Vor Ort
USD 120.000 - 160.000
Lead Data Integration Engineer - Dataverse/Power Platform
Lead Data Integration Engineer - Dataverse/Power Platform

AIS (Applied Information Sciences) • Washington

Vor Ort
USD 125.000 - 189.000
Employee Ownership
Continuous Learning
Inclusive Culture
Senior Application Integration Engineer | Employee-Owned
Senior Application Integration Engineer | Employee-Owned

Applied Information Sciences, Inc • Washington

Vor Ort
USD 120.000 - 180.000
Sr Power Platform Engineer
Sr Power Platform Engineer

AIS (Applied Information Sciences) • Washington

Hybrid
USD 100.000 - 150.000
Sr Power Platform Engineer
Sr Power Platform Engineer

Applied Information Sciences, Inc. • Washington

Hybrid
USD 100.000 - 150.000
Application Integration, SME
Application Integration, SME

Cayuse Holdings • Washington

Vor Ort
USD 120.000 - 160.000
Medical, Dental and Vision Insurance
Flexible Spending Accounts
Short-Term and Long-Term Disability
+3
Database Engineer
Database Engineer

AIS (Applied Information Sciences) • USA

Remote
USD 90.000 - 137.000
Remote work
Competitive compensation