At GMS, we've been helping Canadians for more than 75 years to get the health and travel insurance they want and need. The same pioneering spirit that started our story is what drives us to do things differently today. Insurance, honestly, is our promise, and it's what we do at GMS. We care about our customers, our community and each other. As a non-profit organization, we're proud to reinvest our profits into the health of the communities we serve and that have supported us since 1949.

We want our employees to feel good about coming to work and being in a workplace that promotes flexibility, growth and a healthy work-life balance. If you'd like to be part of a team that truly takes care of our customers, our communities, and each other, this could be your chance.

Here's the role

For the Technical Solutions Architect data integration plays a pivotal role in GMS's digital transformation, leading the shift from on premise systems to a modern, Azure based cloud platform. This role combines hands-on development with architectural thinking, focusing on designing and building scalable, secure, and efficient data integration pipelines. This role works closely with architects, data engineers, and business stakeholders to ensure data is reliable, secure, and aligned with enterprise standards and business rules which enables data-driven decision-making and accelerates the adoption of AI and real-time data capabilities.

Position Responsibilities

•Provide architectural guidance and technical direction for modern, cloud-based data solutions that align with GMS's strategic objectives.

•Contribute to architectural decisions for scalable, resilient, and cost-effective system integration and data solutions, with a focus on Azure technologies.

•Evaluate, select, and integrate technology components and third-party services to support scalable system integration, optimize performance, and meet evolving architectural and operational requirements.

•Lead the definition and implementation of development standards, architectural frameworks, and best practices, including those related to code governance, security, and DevOps.

•Participate in solution planning activities such as Sprint 0 and architecture runways, to ensure technical roadmaps are aligned with strategic business objectives.

•Design, develop, and maintain ETL/ELT pipelines using tools such as Azure Data Factory, Azure Data Bricks and SSIS to integrate data from APIs, file systems, databases, and SaaS platforms.

•Write and review code, troubleshoot complex integration issues, and optimize data pipeline performance, reliability, and scalability.

•Ensure data quality, consistency, and lineage through validation, profiling, and automated error detection and handling mechanisms.

•Lead data migration and system integration initiatives from legacy platforms to modern cloud-based environments ensuring scalability, reliability and alignment with architectural standards.

•Collaborate across teams with business analysts, data stewards and other stakeholders to support enterprise reporting, analytics, and data warehousing initiatives through effective data integration and shared data standards.

•Lead the development and maintenance of technical documentation, data flow diagrams, and support materials while championing data governance standards and promoting consistency across teams and initiatives.

Competencies

•Critical Thinking & Judgement: Applies sound judgment in complex or uncertain situations. Builds context and weighs risks, benefits, past experience and diverse perspectives to guide decisions. Identifies connections between actions and consequences to help inform choices and drive meaningful results. Provides thoughtful, strategic recommendations that balance competing priorities and advance organizational goals.

•Impact & Influence: Establishes credibility with diverse audiences and uses thoughtful, sophisticated techniques to gain support for organizational priorities. Contributes and encourages original ideas that challenge the status quo and drive improved outcomes. Share expertise to elevate team thinking and shape direction. Actively scans trends, insights, and data to inform viewpoints and decisions.

•Results Orientation: Maintains focus and effectiveness in challenging or fast-paced situations. Manage shifting priorities, solve problems under pressure, and ensure work is completed to a high standard. Demonstrates persistence and follow-through to achieve results, even when faced with ambiguity or competing demands.

Education & Experience

•Bachelor's degree in Computer Science, Information Systems, or a related field, or equivalent professional experience.

•Minimum of 8 years in IT with proven success in solution architecture, data integration design and development, and hands on software development.

•Demonstrated expertise in Azure cloud services and data integration technologies such as Azure Data Factory, SSIS, Azure Data Bricks and Azure Integration Services.

•Advanced proficiency in SQL and experience with relational and non relational databases such as SQL Server and Cosmos DB.

•Strong understanding of data modeling, data warehousing concepts, and enterprise reporting services.

•Proven track record in designing and implementing scalable data architectures for advanced analytics and business intelligence.

•Hands-on experience with data governance practices including metadata management, lineage tracking and data security, using tools such as Microsoft Purview and Fabric.

•Proficient in working with REST APIs, and handling JSON/XML data exchange in hybrid environments spanning both cloud and on-premises infrastructure.

•Insurance or financial services experience would be an asset.

•Familiarity with scripting languages (Python, PowerShell).

•Experience with AI/ML frameworks and real time data automation.

Are we a fit?

If you think so, please apply by August 28, 2025. We'd love to reach out to everyone who applies, but we just don't have enough hands! If you're selected for an interview, we'll be in touch. If not, please consider us again in the future.