Data Architect

SGI; Calgary; Hybrid; CAD 109,000 - 145,000; Full time

Job summary

SGI is seeking a Data Architect to define and govern enterprise data models, standards, and integration patterns on a modern Azure data platform. You will translate business needs into scalable data structures while enforcing governance and conformance across the organization.

The role emphasizes leadership of data model reviews, documentation, and collaboration with Data Office and IT stakeholders to ensure reliable analytics, reporting, and AI readiness across on-prem, cloud, and hybrid

Qualifications

• Four-year degree in a relevant field (CS/IT/Math/Engineering).
• Certification in a data management or architecture discipline (CDMP/TOGAF).
• Six years in data architecture, modeling, or related roles with Azure/cloud experience.

Responsibilities

• Define and govern enterprise data models, standards, and integration patterns.
• Lead data architecture reviews and governance boards; ensure data quality and conformance.
• Design conceptual, logical, physical, and semantic data models and data lineage.
• Provide technical leadership to data modelers and cross-functional teams on architecture best practices.

Skills

Data architecture

Azure

Governance

Data modeling

Enterprise data

Education

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

CDMP or TOGAF certification

Tools

Azure Data Lake

Cosmos DB

Synapse Analytics

Databricks

Power BI

Cognos

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

• Partners with Data Office members and IT stakeholders to design and instantiate physical and semantic data models on the Azure data platform.
• Defines,governsandreviewssolutiondesigns tosupportsdata ingestion, standardization, integration, and consumption requirements across the data platform.
• Develops andmaintainstheconceptual logical,physicalandsemantic layers, mapping data lineage from source systems through all propagation zones to consumer-facing outputs.
• Establishesgovernance,standards, frameworks, and patternsfor data integration, naming conventions, reference/metadata usage, dataquality, andmaster datamanagement.
• Translates business and systems requirements into implementable data structures.
• Ensures data models and integration designs areoptimizedforperformance andsupportstesting 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.
• Providestechnical leadership and subject matterexpertiseto Data Modelersand cross-functional teams ondataarchitecture and best practicesincluding leading data model reviews and design approvals.
• Developsandmaintainstechnical documentation including data models, architecture diagrams, andintegration 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.
• Monitorsemerging architecture, platformtechnologiesand analytic techniques andapplies thisknowledgeto informarchitecturalrecommendations, supportplatform evolutionandeducate the Data Office, IT, and business teams.
• Develops andmaintainsarchitectural frameworks and performance metrics tomonitordata platform usage and enable proactive optimization of data accessibility, reporting performance, and analytics capabilities.
• Recommends and supports proof-of-concept and pilot initiatives to evaluatenew technologiesand 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 technicalexpertiseduring Request for Proposal (RFP) processesbyassistingin the development of technical RFP requirementsandparticipatingin the evaluation of RFP responses and recommendations.

Delivery and Support

• Ensures data solutions are implementedacross data platformsinalignmentwith approveddata architecturestandards and integration patterns.
• Defines and ensures the delivery ofend-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.
• Identifiestechnology interactions and dependencies across systems, data platforms and reporting tools thatimpactintegration, performance,scalabilityand compatibility.
• Conducts research and provides recommendations for data architectureandsolution delivery of the enterprise data platform and reporting ecosystem.
• Ensures solutions follow security policies andcomply withestablished enterprise architecture principles.
• Partnerswith IT and Data Office teams on enterprise-wide data initiatives, platform enhancements, and production support to ensurereliability, performance, and operational stability of data and reporting solutions.

Leadership

• Actively contributes to and supports a culture ofa high performing workforce.
• Participates indivisionalsuccession plans, ensuring ongoing professional and career developmentand supports development in others.
• Supportsa culture ofleadershipand accountability to effectively deliver on strategic and corporate strategies.
• Isactivelycommitted to leadership development across the company, supporting team and workforce readiness through mentoring,trainingand developmental opportunities.

Corporate Management

• Enables the success of programs and policies that are in alignment with corporate,strategicand divisional strategies.
• Manages risk in area of authority.
• Ensures that the Health, Safety and Emergency Management Policyisapplied in area of responsibility.

Education and Experience

• Four-yeardegreefrom an accredited post-secondary education institution in a relevant field of study, such asComputer 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 [e-mail] and we will work through your request with you. All information received will be kept confidential.

Pay Range:$109,052.00 - $145,411.00

Posting Close Date:

September 14, 2026