Data Modeler

SGI; Swift Current; On-site; CAD 91,000 - 115,000; Full time

Job summary

SGI is hiring a Data Modeler to translate business information requirements into scalable data models within our Azure data platform. You will work closely with the Data Office, IT, and business stakeholders to support advanced analytics and reporting initiatives.

The role requires five to seven years of experience in data modeling, strong knowledge of databases, and expertise with Azure data services. Remote-friendly in Canada, with on-site options in Saskatchewan/Manitoba.

Qualifications

• Four-year degree in a relevant field of study.
• Five to seven years of experience in a Data Modeler role or equivalent.
• Advanced knowledge of database structures, data modeling techniques, and data schemas.
• Proficient knowledge of Azure data platform tools and cloud data services.
• Experience contributing to RFP processes and enterprise data strategy.

Responsibilities

• Assist Data Model activities to support reporting and analytics.
• Model data to meet business outcomes aligned to enterprise strategies.
• Collaborate with Data Office, IT, and business stakeholders on data models.
• Design data solutions for high availability, security, and performance targets.
• Publish and maintain data models, mappings, and metadata across platforms.
• Support data education and provide guidance to teams.

Skills

Data modeling

Azure platform

Data architecture

RFP processes

Data governance

Education

Four-year degree in Computer Science or related

Tools

Azure Data Lake

Cosmos DB

Synapse Analytics

Databricks

Azure Data Factory

Job description

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.

In-Scope
Permanent, Full-Time
Work Location: Saskatchewan or Manitoba. Remote work will be considered for candidates residing outside of Regina.

Pay Range: $90,911 - $114,739
Posting Close Date: Thursday, Sept 10, 2026

The Data Modeler is a specialised technical position assisting the Director, Data Architect with the continually changing and highly complex Data Architecture required to support business reporting and advanced analytics. As a highly experienced data practitioner, you will translate and represent business information requirements into a data structure that business end-users can easily understand, supporting growth in our reporting and analytics.

You will be responsible for comprehensive data design and mapping to realise an integrated view of our data, resulting in a single version-of-truth representation. You will also work with other members of the Data Office team, as well as Developers, on all aspects of data and analytics solutioning. Ensuring that a consistent and harmonised approach to solution development is achieved across disparate projects.

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 Model Planning & Strategy Support

• Assists in all Data Model activities on behalf of SGI and the Data Office with a focus on developing, maintaining, and publishing Data Model to support business reporting and advanced analytics.

• Ensures that solutions are modeled to meet the business outcomes while strategically aligning to the Data Office and enterprise systems vision and strategies.

• Maintains knowledge of emerging Data Modeling techniques and trends and utilizes this knowledge to educate both the Data Office, Systems, and the business on opportunities to build better solutions that support and drive business decisions.

• Participates in the definition of the Data Model and technology needs of the organization based on new and emerging technologies.

• Collaborates with business and technology subject-matter experts to develop representative Data Models.

• Contributes technical data practitioner knowledge during Request for Proposal (RFP) processes:

  • Participates in the development of complex RFPs for the procurement of products and services.

  • Creates and updates the technical RFP requirements.

  • Participates as a member of the decision-making team in the evaluation of RFP responses and recommendations.

Data Model Delivery & Support

• Jointly presents the solution to the business, providing technical expertise and explaining the trade-offs with various data design alternatives.

• Identifies the key technology interactions and dependencies across data systems/platforms impacting the organization’s ability to achieve integration, compatibility, and performance targets.

• Conducts research and analysis and provides recommendations for the design and delivery of the Data Models required for the delivery of IT-based solutions, services, and support.

• Designs solutions for high availability, connectivity, and disaster recovery, as required.

• Provides technical advice and support to Data Office, Systems, and management relating to Data Models and schemas.

• Ensures Data Model designs follow established security policies.

• Ensures technical designs comply with architecture guiding principles.

• Writes professional/technical proposals, reports, and manuals.

• Collaborates with other Data Office and Systems teams on enterprise-wide IT strategies and technologies, as required.

Data Solution Design & Development

• Partners with members of the Data Office team, specifically the Director, Data Platform Solution Architect and the Data Engineers, modeling in our Azure data platform for operational and analytical data, structured and unstructured data, data in motion, and data at reset.

• Partners with members of the Data Office team and IT stakeholders to assist in defining data processing requirements and dependencies across the data platform for data ingestion, data standardization, data integration, and data consumption.

• Assists in designing, developing, publishing, and maintaining the Azure data platform semantic layer and maps its data lineage back through the various data propagation zones of the data platform and subsequently back to the physical operational source systems where the source data is captured/originates.

• Assists in designing, developing, publishing, and maintaining the data platform standard for data integration (aka. single version of truth), naming conventions, use of reference data, data profiling process support, and metadata.

• Defines and translates business and systems requirements into a relevant data structure by collaborating with business stakeholders, members of the Data Office team, and IT on how given requirements will best be realized.

• Partners with members of the Data Office team and IT stakeholders to instantiate physical data models and optimize data performance.

• Reviews and participates in the testing and acceptance of data model design and mappings, tool infrastructure design, and data pipeline solutions.

• Applies creativity and thoughtful solutioning in instances where business end-users require data in a form that may differ from that which was originally captured.

• Plays a critical role in building and delivering a data education and training program to ensure the success of the Data & Analytics (D&A) program and to maximize the likelihood of end-user adoption of the data platform. The data education track will be centred on building an understanding of our organisations data and its journey from the physical operational source systems to the data platform’s Consumer Zone.

Production Support

• Proactively works with members of the Data Office team and IT stakeholders to identify and resolve any/all data issues adversely impacting service-level agreement commitments.

• Engages with members of the Data Office team and business stakeholders to enable data governance, data quality, and metadata, aligning with SGI's policies, standards, and frameworks.

High Performance Team & Culture

• Supports a culture of leadership and accountability to effectively meet the key accountabilities within the scope of the role.

• Displays leadership by committing to a culture of continuous learning/development of self and supports others by actively sharing knowledge, providing guidance, mentoring, training, and supporting developmental opportunities.

• Demonstrates that the Health, Safety and Emergency Management Policy is applied in area of responsibility for self and others.

• Actively applies knowledge to support transformation and strategic initiatives of the corporation, while participating and advocating change and applying a growth mindset.

Technical Knowledge & Skills

• Advanced knowledge of database structures, theories, principles, and practices.

• Advanced knowledge of data modeling techniques with an understanding of data gathering, inspection, cleansing, and transformation.

• Advanced skill in using data modeling tools and approaches with an understanding of physical implementation issues, data strategies, design implications, and performance requirements.

• Proficient knowledge of solution design, database design and management, application integration, agile implementation, and machine learning methods.

• Proficient knowledge of data storage and warehousing solutions that can help source and process data (e.g., Azure Data Lake, Cosmos DB, Synapse Analytics).

• Proficient knowledge of Azure cloud data platform, Azure Stream, Azure Data Lake, Blob Storage, Synapse, Databricks, Azure Data Factory, and cloud best practices.

• Fundamental knowledge of Azure D&A frameworks.

• Fundamental knowledge of strategic D&A implementation migrations.

• Fundamental knowledge of Property and Casualty industry products and services.

Education & Certification

• Four-year degree from an accredited post-secondary education institution in a relevant field of study, such as Computer Science, Mathematics & Applied Science, Engineering, or Information Technology, or defined equivalency.

Experience

• Five to Seven years of experience in a Data Modeler role or equivalent technology role.

Behavioural Competencies

Leader Level 3 - Applies (Team/Dept)

• Accountability - Provides Direction and Sets Expectations

• Business Acumen - Applies Broader Business Metrics and Understands the Internal and External Environment

• Change Agility - Makes Change Real for Others

• Leadership - Leads the Team

At SGI, we’re committed to building a workplace where everyone feels seen and heard, and where every individual is respected. Our commitment to reconciliation includes actively hiring Indigenous people and creating opportunities for diverse talent to thrive. We offer more than a job; we embrace diverse backgrounds and experiences, provide a career with purpose, growth, and belonging. Join us and help shape a workplace where every voice matters and contributes to our shared success.

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:$90,911.00 - $114,739.00

Posting Close Date:

September 10, 2026