Data Architect

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

• 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. Join us in building a culture where contributions are valued and shared success is shaped by our people.  

If you require an accommodation during the recruitment process, we invite you to submit your accommodation request to [email protected] and we will work through your request with you. All information received will be kept confidential.

Posting Close Date: