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