Data Modeler

at  Saskatchewan Government Insurance

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 / Full Time
Permanent Opportunity
Work Location: Saskatchewan and Manitoba
Remote work opportunities in Saskatchewan and Manitoba only.
The successful candidate must be open to relocating within either Saskatchewan or Manitoba.

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 organizations 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

• Knowledge of database structures, theories, principles, and practices.
• Knowledge of data modeling techniques with an understanding of data gathering, inspection, cleansing, and transformation.
• Skill in using data modeling tools and approaches with an understanding of physical implementation issues, data strategies, design implications, and performance requirements.
• Knowledge of solution design, database design and management, application integration, agile implementation, and machine learning methods.
• Knowledge of data storage and warehousing solutions that can help source and process data (e.g., Azure Data Lake, Cosmos DB, Synapse Analytics).
• Knowledge of Azure cloud data platform, Azure Stream, Azure Data Lake, Blob Storage, Synapse, Databricks, Azure Data Factory, and cloud best practices.
• Knowledge of Azure D&A frameworks.
• Knowledge of strategic D&A implementation migrations.
• Knowledge of Property and Casualty industry products and services.

EDUCATION & CERTIFICATIONS

• 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

• 5 – 7 years of experience in a Data Modeler role or equivalent technology role.
  Pay Range:$86,532.00 - $109,213.00
  Posting Close Date:
  September 30, 2024
  As you prepare to submit your application, and cover letter if applicable, please highlight the achievements that demonstrate why you’re a great candidate for this role

The Data Modeler is a specialized 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, the Data Modeler translates and represents business information requirements into a data structure that is easily comprehended by business end-users, supporting growth in our reporting and analytics. Assists in comprehensive data design and mapping to realize an integrated view of our data, resulting in a single version of truth representation. Works with other members of the Data Office team, as well as IT Developers, on all aspects of data and analytics solutioning. Ensures that a consistent and harmonized approach to solution development is achieved across disparate projects.