Data Modeler Job 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.
WHY WOULD YOU WANT THIS JOB?
Do you want to work at an award-winning top employer! If you are looking for an empowering and progressive place to shape your future, then you’ve landed in the right place at SGI. With our corporate Head Office in Regina and locations around Canada, we offer an outstanding culture that cares about diversity and inclusion, corporate social responsibility and gives the freedom to innovate, influence decisions, and develop a challenging career path. Be part of a team that supports the local community and has the ability draw on global best-in-class talent to work remotely. A career that includes competitive compensation, a pension, and excellent training and professional development programs.
THE OPPORTUNITY
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 clients reporting and analytics. Assists in comprehensive data design and mapping to realize an integrated view of our client’s 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.
PRIMARY AREAS OF ACCOUNTABILITY
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.
IDEAL CANDIDATE QUALIFICATIONS
-
5 – 7 years of experience in a Data Modeler role or equivalent technology role
-
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/PROFESSIONAL QUALIFICATIONS
-
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.
How to Apply:
Please apply online at
https://www.linkedin.com/jobs/view/3373032011
Only applicants who apply directly to LHH Knightsbridge will be considered.
For further information about this career opportunities, please feel free to contact:
Bruce Diemert,
bruce.diemert@lhhknightsbridge.com
Phone: (604) 282-6075
We thank all applicants for their interest; however, only those selected will be contacted for an interview.
Pay Range:$82,368.00 - $103,956.00
Posting Close Date:
December 30, 2022
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.
Please Note :
optimuspartners.com is the go-to platform for job seekers looking for the best job postings from around the web. With a focus on quality, the platform guarantees that all job postings are from reliable sources and are up-to-date. It also offers a variety of tools to help users find the perfect job for them, such as searching by location and filtering by industry. Furthermore, optimuspartners.com provides helpful resources like resume tips and career advice to give job seekers an edge in their search. With its commitment to quality and user-friendliness, Site.com is the ideal place to find your next job.