Integration SME

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.

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.

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.

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

• Owns full lifecycle delivery; resolves ambiguous, enterprise-scale problems; shapes technical direction and project outcomes.

• Establishes best practices and performance metrics; oversees QA for major initiatives; operates with wide decision latitude.

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

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

• 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…