Data Architect

Saskatchewan Government Insurance; Manitoba; Hybrid; CAD 109,000 - 145,000; Full time

Job summary

Saskatchewan Government Insurance is seeking a Data Architect to define, govern, and assure enterprise data models and integration patterns across the data platform. You will translate business needs into scalable data structures, enforce standards, and provide leadership on data architecture to support analytics and AI initiatives.

The role requires six years in data architecture and familiarity with Azure cloud services, data governance, and enterprise data solutions.

Qualifications

• Four-year degree required in a relevant field.
• Certification in data management or architecture discipline.
• Six years’ experience in data architecture, modeling, or related roles with Azure or cloud platforms.

Responsibilities

• Define and oversee enterprise data models and standards.
• Guide data platforms on Azure and cloud-based solutions.
• Lead Data Architecture Review Board and governance efforts.
• Ensure data quality, security, and governance across solutions.
• Collaborate with IT and business teams on data initiatives.

Skills

Data Architecture

Data Modeling

Data Governance

Data Integration

AI/ML awareness

Azure Cloud

Education

Four-year degree in CS/IT/Math/Eng

CDMP / TOGAF / Data Vault certs

Tools

Power BI

Cognos

Azure Data Factory

Databricks

Synapse Analytics

Cosmos DB

Azure Data Lake

Blob Storage

Snowflake

Delta Lake

Apache Iceberg

Amazon Redshift

Job description

Do you value integrity and innovation? How about passion and caring? Great! Us too, and that's why you'll fit right in. Our intentional culture promotes trust and participation, encouraging you to bring your heart and mind to work every day.

Out-of-scope Permanent, Full-Time Work Location: Saskatchewan, Manitoba, Alberta, and Ontario. This role is eligible for in-office, hybrid, or remote work within the provinces where we operate. Pay Range: $109,052 - $145,411 Posting Close Date: September 14, 2026

General Accountability The Data Architect is a specialized technical position responsible for defining, governing, and assuring the integrity of enterprise data models, standards, and integration patterns required to support business operations. As a Data Architect you will translate business requirements into standardized, scalable data structures while establishing and enforcing modeling standards, governance frameworks, and conformance practices. Through oversight of data model design and alignment, you will ensure consistency, quality, and reusability of data assets, enabling a trusted and integrated data foundation for enterprise reporting, analytics, and decision-making.

Key Accountabilities

Note: This section is not intended to be an exhaustive list of duties and responsibilities – other duties and responsibilities may be assigned.

Data Architecture

Data Architecture Partners with Data Office members and IT stakeholders to design and instantiate physical and semantic data models on the Azure data platform. Defines, governs and reviews solution designs to supports data ingestion, standardization, integration, and consumption requirements across the data platform. Develops and maintains the conceptual logical, physical and semantic layers, mapping data lineage from source systems through all propagation zones to consumer-facing outputs. Establishes governance, standards, frameworks, and patterns for data integration, naming conventions, reference/meta data usage, data quality, and master data management. Translates business and systems requirements into implementable data structures. Ensures data models and integration designs are optimized for performance and supports testing and validation of data models, pipelines, and supporting infrastructure. Applies creative solutions to deliver business-required data formats that differ from the source system structure. Provides technical leadership and subject matter expertise to Data Modelers and cross-functional teams on data architecture and best practices including leading data model reviews and design approvals. Develops and maintains technical documentation including data models, architecture diagrams, and integration patterns/standards. Chairs the Data Architecture Review Board (DARB), overseeing committee-based approval of new data solutions and tools and contributes as a voting member by presenting and articulating recommendations.

Planning and Strategy Support

Contributes to shaping data architecture, modern data platform capabilities, and reporting frameworks by engaging with technical architects and data leadership to inform current and future state data ecosystems. Monitors emerging architecture, platform technologies and analytic techniques and applies this knowledge to inform architectural recommendations, support platform evolution and educate the Data Office, IT, and business teams. Develops and maintains architectural frameworks and performance metrics to monitor data platform usage and enable proactive optimization of data accessibility, reporting performance, and analytics capabilities. Recommends and supports proof-of-concept and pilot initiatives to evaluate new technologies and architectural approaches. Participates in architecture and governance meetings to ensure alignment of data platform direction with organizational standards and requirements. Collaborates with business and technology subject-matter experts to design representative and effective data architectures, reporting ecosystems, and data integration patterns. Develops role-based learning content aligned to the data education strategy by interpreting data platform architecture, standards, and patterns, and incorporating supporting reference implementations, guidance, and governance alignment. Aligns architecture patterns, data models, and integration approaches to enable scalable, composable data platforms supporting analytics, artificial Intelligence and machine Learning (AI/ML), and enterprise reporting across cloud environments. Contributes technical expertise during Request for Proposal (RFP) processes by assisting in the development of technical RFP requirements and participating in the evaluation of RFP responses and recommendations.

Delivery and Support

Ensures data solutions are implemented across data platforms in alignment with approved data architecture standards and integration patterns. Defines and ensures the delivery of end-to-end data solutions including data models, semantic layers, data pipelines, and reporting architectures that enable reliable data consumption for business intelligence, analytics, and AI use cases. Identifies technology interactions and dependencies across systems, data platforms and reporting tools that impact integration, performance, scalability and compatibility. Conducts research and provides recommendations for data architecture and solution delivery of the enterprise data platform and reporting ecosystem. Ensures solutions follow security policies and comply with established enterprise architecture principles. Partners with IT and Data Office teams on enterprise-wide data initiatives, platform enhancements, and production support to ensure reliability, performance, and operational stability of data and reporting solutions.

Leadership

Actively contributes to and supports a culture of a high performing workforce. Participates in divisional succession plans, ensuring ongoing professional and career development and supports development in others. Supports a culture of leadership and accountability to effectively deliver on strategic and corporate strategies. Is actively committed to leadership development across the company, supporting team and workforce readiness through mentoring, training and developmental opportunities.

Corporate Management

Enables the success of programs and policies that are in alignment with corporate, strategic and divisional strategies. Manages risk in area of authority. Ensures that the Health, Safety and Emergency Management Policy is applied in area of responsibility.

Education and Experience

Four-year degree from an accredited post-secondary education institution in a relevant field of study, such as Computer Science, Information Technology, Mathematics & Applied Science, Engineering, or defined equivalency. Certification in a recognized data management or architecture discipline (e.g., CDMP, TOGAF, Data Vault). Six years’ experience in data architecture, modeling, or related technology roles with experience in Azure or cloud-based data platforms, enterprise data solutions, and data integration initiatives.

Knowledge, Skills and Abilities

Knowledge of enterprise data architecture principles, including data platform design, modern data architectures (Lakehouse, Medallion, Data vault, and Data Mesh), and scalable data ecosystems supporting analytics, AI/ML, and enterprise reporting. Knowledge of data modeling techniques, including gathering, inspection, cleansing, and transformation of data. Knowledge of solution design, database design and management, application integration, agile implementation, and cloud-based platforms. Knowledge of Azure cloud data platform components: Azure Data Lake, Cosmos DB, Synapse Analytics, Databricks, Azure Data Factory, Blob Storage, Azure Stream, and cloud best practices. Knowledge of modern data platform technologies across cloud ecosystems, including platforms such as Snowflake, Delta Lake, Apache Iceberg, Amazon Redshift, and emerging data ecosystem tools. Knowledge of enterprise BI and reporting architecture, including semantic modeling, reporting frameworks, and visualization platforms such as Power BI and Cognos, ensuring scalable, governed, and high-performance enterprise reporting solutions. Knowledge of Property and Casualty industry data, products, and services. Skill in using data modeling and architecture tools, understanding physical implementation, design implications, and performance requirements.

Behaviourial Competencies

Leader Level 4 - Applies (Department/Division) Accountability - Enables Performance Across Teams/Business Units Business Acumen - Formulates Departmental/Divisional Plans in Relation to Internal and External Environment Change Agility - Defines Areas for Change and Follows Through Leadership - Leads the Department/Division

At SGI, we are committed to a workplace where people feel respected, valued, and able to contribute fully. Through fair, consistent, and transparent people practices, we attract skilled talent with varied lived experiences and offer meaningful work, opportunities for growth, and a strong sense of belonging. Our commitment to reconciliation includes inclusive hiring practices that create meaningful opportunities for Indigenous peoples and support a workforce reflective of the communities we serve.

Everyone at SGI and SGI CANADA enjoys great benefits, perks and options to balance work and everything else life sends their way. We also believe in you and your future career aspirations. Regardless of where you start, SGI and SGI CANADA will invest in you by supporting education, accreditation and professional development.

SGI has 2 distinct operations — the Saskatchewan Auto Fund and SGI CANADA. The Auto Fund is Saskatchewan’s compulsory auto insurance program, operating the driver licensing and vehicle registration system. SGI CANADA is the property and casualty insurance division which offers products in Saskatchewan, British Columbia, Alberta, Manitoba and Ontario through a network independent insurance brokerages. SGI and SGI CANADA are Crown corporations, owned by the Government of Saskatchewan.

Pay Range:$109,052.00 - $145,411.00 Posting Close Date: September 14, 2026