Database Architect

3 weeks ago


Regina, Canada Group Medical Services Full time
At GMS Health and Travel Insurance, we've been helping Canadians feel protected and live well for more than 70 years. We care about our customers, our community and each other, giving back with our time and talents, not to mention our support for vital health programs in cardiac care and trauma services. We've also been named one of Saskatchewan's Top Employers for eleven years
Think you'd like to be part of a team that truly takes care of our customers, our communities, and each other? All in all, we're a pretty awesome bunch to work with
Here's the roleReporting to the Manager, Data and Architecture, the Database Architect is responsible for designing, deploying, and maintaining GMS's core data storage services on Azure Cloud, and their integrations with other systems. This includes designing and building data models for GMS's structured, semi-structured and unstructured data as well as maintaining and supporting operational databases. The ideal candidate will communicate with various GMS stakeholders to assess needs and goals, design and manage database/warehouse architecture and deliver top-notch database development solutions. Additionally, the Database Architect will be assisting the data engineers with designing and building high-standard and efficient data pipelines.
Position Responsibilities•Design and build database systems, data models and other data architecture components.•Implement and manage organizational database/data warehouse standards that are in line with GMS business processes.•Coordinate and collaborate with GMS's stakeholders, vendors, and cross-functional teams to build enterprise data storage services.•Evaluate current data architecture and databases to determine improvements and enhancements for GMS's new data storage services.•Ensure all data structures are in strict compliance with insurance industry standards as well as GMS regulations.•Build and maintain a repository of all data architecture artifacts, including but not limited to conceptual, logical, and physical data models, and DDL scripts.•Manage database systems and their performance, security, and backups.•Perform database and data warehouse administration activities.•Provide recommendations and data pipeline design best practices to Data engineers.
CompetenciesImpact and Influence: Can you easily establish credibility with multiple diverse audiences and use sophisticated techniques to persuade or convince others of organization priorities?Quality Orientation: Do you set high expectations for yourself and ensure accurate delivery of work across teams?Critical Thinking: Do you thrive on using data and experience to understand and develop solutions to a range of business problems?Leadership: Are you passionate about promoting organizational mission and goals and showing influence across the organization to support strategic goals?Problem Solving: Do you actively explore and analyze options and solutions to make effective customer and business decisions?
Education & Experience•Post-secondary education in Computer Science, Software Engineering, or related program.•Minimum 8 years of solid experience in working with and maintaining relational databases.•High proficiency in designing and building relational and dimensional data models.•Proven experience with a wide variety of data and data storage technologies.•Strong SQL development and database administration skills.•Experience with Azure Database services is an asset.
Are we a fit?If you think so, please apply by June 16, 2024. We'd love to reach out to everyone who applies, but we just don't have enough hands If you're selected for an interview, we'll be in touch. If not, please consider us again in the future.

  • Database Architect

    5 days ago


    Regina, Saskatchewan, Canada Group Medical Services Full time

    At GMS Health and Travel Insurance, we have a long history of safeguarding Canadians and ensuring their well-being for over seven decades.We prioritize our clients, our society, and our team members, contributing through our time, skills, and backing significant health initiatives such as cardiac care and trauma programs.We have proudly been recognized as...


  • Regina, Canada Viterra Full time

    At Viterra, we thrive on connection. As a global agricultural network, our team realizes the power in connecting local farmers to countries around the world. We’re committed to creating a workplace that provides our people with the support, guidance, and motivation needed to achieve more. Come see how we feed your drive with work you can take pride in,...


  • Regina, Canada Viterra Full time

    At Viterra, we thrive on connection. As a global agricultural network, our team realizes the power in connecting local farmers to countries around the world. We’re committed to creating a workplace that provides our people with the support, guidance, and motivation needed to achieve more. Come see how we feed your drive with work you can take pride in,...

  • Data Architect

    1 month ago


    Regina, Canada Saskatchewan Workers Compensation Board Full time

    Data Architect / Senior Database Administrator Permanent Appointment Regina Head Office WCB: We are the provincial agency that delivers workplace insurance to Saskatchewan employers and benefits to Saskatchewan workers when they are hurt at work. Our legislation,The Workers’ Compensation Act, 2013, describes the workplaces that we cover and the benefits we...

  • Data Architect

    1 month ago


    Regina, Canada Saskatchewan Workers Compensation Board Full time

    Data Architect / Senior Database Administrator Permanent Appointment Regina Head Office WCB: We are the provincial agency that delivers workplace insurance to Saskatchewan employers and benefits to Saskatchewan workers when they are hurt at work. Our legislation,The Workers’ Compensation Act, 2013, describes the workplaces that we cover and the benefits we...

  • Data Architect

    1 month ago


    Regina, Canada Saskatchewan Workers Compensation Board Full time

    Data Architect / Senior Database Administrator Permanent Appointment Regina Head Office WCB: We are the provincial agency that delivers workplace insurance to Saskatchewan employers and benefits to Saskatchewan workers when they are hurt at work. Our legislation,The Workers’ Compensation Act, 2013, describes the workplaces that we cover and the benefits we...

  • Sr. Data Architect

    2 months ago


    Regina, Canada BQ INTERNATIONAL LTD. Full time

    The Contract will be effective for an initial term commencing on the date of award and ending on March 31, 2022. The Contract will automatically renew for successive one (1) year terms, a maximum of four (4) times,BackgroundSaskEnergy’s Digital, Technology, and Security (DT&S) group is comprised of several functional groups focused on project delivery,...

  • Sr. Data Architect

    2 months ago


    Regina, Canada BQ INTERNATIONAL LTD. Full time

    The Contract will be effective for an initial term commencing on the date of award and ending on March 31, 2022. The Contract will automatically renew for successive one (1) year terms, a maximum of four (4) times,BackgroundSaskEnergy’s Digital, Technology, and Security (DT&S) group is comprised of several functional groups focused on project delivery,...

  • Sr. Data Architect

    3 weeks ago


    Regina, Canada BQ INTERNATIONAL LTD. Full time

    The Contract will be effective for an initial term commencing on the date of award and ending on March 31, 2022. The Contract will automatically renew for successive one (1) year terms, a maximum of four (4) times,BackgroundSaskEnergy’s Digital, Technology, and Security (DT&S) group is comprised of several functional groups focused on project delivery,...

  • Sr. Data Architect

    3 weeks ago


    Regina, Canada BQ INTERNATIONAL LTD. Full time

    The Contract will be effective for an initial term commencing on the date of award and ending on March 31, 2022. The Contract will automatically renew for successive one (1) year terms, a maximum of four (4) times,BackgroundSaskEnergy’s Digital, Technology, and Security (DT&S) group is comprised of several functional groups focused on project delivery,...

  • Sr. Data Architect

    2 months ago


    Regina, Canada BQ INTERNATIONAL LTD. Full time

    The Contract will be effective for an initial term commencing on the date of award and ending on March 31, 2022. The Contract will automatically renew for successive one (1) year terms, a maximum of four (4) times,BackgroundSaskEnergy’s Digital, Technology, and Security (DT&S) group is comprised of several functional groups focused on project delivery,...

  • Sr. Data Architect

    3 weeks ago


    Regina, Canada BQ INTERNATIONAL LTD. Full time

    The Contract will be effective for an initial term commencing on the date of award and ending on March 31, 2022. The Contract will automatically renew for successive one (1) year terms, a maximum of four (4) times, Background SaskEnergy’s Digital, Technology, and Security (DT&S) group is comprised of several functional groups focused on project delivery,...

  • Data Architect

    2 months ago


    Regina, Canada BQ INTERNATIONAL LTD. Full time

    SaskEnergy’s Digital, Technology, and Security (DT&S) group is comprised of several functional groups focused on project delivery, architecture, records and information management, security, application, infrastructure management, and enterprise analytics. The DT&S department consists of approximately 90 multi-vendor contractors.The Analytics team, within...

  • Data Architect

    2 months ago


    Regina, Canada BQ INTERNATIONAL LTD. Full time

    SaskEnergy’s Digital, Technology, and Security (DT&S) group is comprised of several functional groups focused on project delivery, architecture, records and information management, security, application, infrastructure management, and enterprise analytics. The DT&S department consists of approximately 90 multi-vendor contractors.The Analytics team, within...

  • Data Architect

    3 weeks ago


    Regina, Canada BQ INTERNATIONAL LTD. Full time

    SaskEnergy’s Digital, Technology, and Security (DT&S) group is comprised of several functional groups focused on project delivery, architecture, records and information management, security, application, infrastructure management, and enterprise analytics. The DT&S department consists of approximately 90 multi-vendor contractors.The Analytics team, within...

  • Data Architect

    5 days ago


    Regina, Saskatchewan, Canada BQ INTERNATIONAL LTD. Full time

    SaskEnergy's Digital, Technology, and Security (DT&S) group is comprised of several functional groups focused on project delivery, architecture, records and information management, security, application, infrastructure management, and enterprise analytics. The DT&S department consists of approximately 90 multi-vendor contractors.The Analytics team, within...

  • Data Architect

    3 weeks ago


    Regina, Canada BQ INTERNATIONAL LTD. Full time

    SaskEnergy’s Digital, Technology, and Security (DT&S) group is comprised of several functional groups focused on project delivery, architecture, records and information management, security, application, infrastructure management, and enterprise analytics. The DT&S department consists of approximately 90 multi-vendor contractors.The Analytics team, within...

  • Data Architect

    2 weeks ago


    Regina, Canada BQ INTERNATIONAL LTD. Full time

    SaskEnergy’s Digital, Technology, and Security (DT&S) group is comprised of several functional groups focused on project delivery, architecture, records and information management, security, application, infrastructure management, and enterprise analytics. The DT&S department consists of approximately 90 multi-vendor contractors. The Analytics team, within...

  • Data Architect

    2 months ago


    Regina, Canada BQ INTERNATIONAL LTD. Full time

    SaskEnergy’s Digital, Technology, and Security (DT&S) group is comprised of several functional groups focused on project delivery, architecture, records and information management, security, application, infrastructure management, and enterprise analytics. The DT&S department consists of approximately 90 multi-vendor contractors.The Analytics team, within...

  • Solutions Architect

    4 days ago


    Regina, Canada City of Regina Full time

    Position Summary Join our dynamic team as a Solutions Architect where you'll play a pivotal role in driving business solutions for our organization. As part of our dedicated team of Technology professionals, you'll maintain and enhance existing applications while spearheading the implementation of innovative new systems. Leveraging your expertise in...