Data Systems Analyst (SQL & Database Development) - 12 month term
Top Benefits
About the role
At GMS, we've been helping Canadians for more than 75 years to get the health and travel insurance they want and need. The same pioneering spirit that started our story is what drives us to do things differently today. Insurance, honestly, is our promise, and it's what we do at GMS. We care about our customers, our community and each other. As a non-profit organization, we're proud to reinvest our profits into the health of the communities we serve and that have supported us since 1949.
We want our employees to feel good about coming to work and being in a workplace that promotes flexibility, growth and a healthy work-life balance. If you'd like to be part of a team that truly takes care of our customers, our communities, and each other, this could be your chance.
Here's the role
The Data Systems Analyst (SQLDatabase Development) supports and enhances the organization's data environment through advanced SQL development, cross system data analysis, and close collaboration with development and analytics teams. The role is responsible for designing and optimizing database objects, ensuring reliable access to data, and supporting application teams that work with both structured and unstructured data.
Position Responsibilities
- Perform advanced TSQL querying, data discovery, performance tuning, and validation across transactional, warehouse, and legacy systems.
- Develop adhoc data queries and build custom SQL reports to meet business needs quickly; organize and promote these reporting assets to support analytics and decision
- Manage and optimize database schemas and structures across environments, including consolidation, cleanup, and maintenance for transactional and datawarehouse databases.
- Collaborate with development and DevOps teams to promote data structures via repositories, integrate database changes into CI/CD pipelines, and support data migrations and integrations (data mapping, data modeling, cleansing, ETL execution, and validation).
- Support application and legacy teams by designing and maintaining database objects (tables, views, procedures), implementing schema changes, processing structured/unstructured data, and handling BAU troubleshooting.
- Perform targeted data mapping and analysis for migrations and integrations as needed.
- Enable reporting and analytics by providing data access and integrating sources using SSRS, Power BI, SSIS, and Azure Data Factory.
- Maintain accurate documentation of database structures, processes, and operational procedures.
- Maintain an understanding of ETL workflows and reporting best practices.
Competencies
-Problem Solving: Ability to notice small details where others may miss for the purpose of analysis; quickly consider solutions and alternatives to determine a course of action. -**Results Orientated:**Focuses on desired outcomes, sets high expectations and pushes towards attaining milestones; looks for opportunities, and consistently moves to action. -**Quality Orientation:**Sets high expectations for self; ensures accurate delivery of work across the team; conducts extensive discussions with peers, business units and external business partners to ensure assumptions are complete. -**Information Seeking:**Driven by an underlining curiosity to know more about things, people, or issues; asks questions to get at the root cause of a situation or problem and understand environmental context.
EducationExperience
- Bachelor's degree, certificate or diploma in Computer Science, Information Technology, or related field.
- Minimum 5 years of experience in database development.
- Strong knowledge of relational database systems on Microsoft SQL (On-premise and Azure)
- Basic experience or familiarity with SSRS, Power BI, SSIS, Azure Data Factory for reporting and data integration tasks.
- Experience with schema management, performance tuning, and security best practices including relational and dimensional data modeling.
- Familiarity with DevOps principles and CI/CD pipelines.
When you become a GMSer, you can expect:
- Competitive salary, bonus opportunities and a comprehensive benefit package.
- Personal and professional development initiatives.
- Social events, volunteer opportunities, and a whole lot of fun.
- Free coffee - yes, really! And if tea is more of your vibe, we've got that covered too!
Are we a fit?
**If you think so, please apply by Monday March 23, 2026.**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.
Similar jobs you might like
Data Systems Analyst (SQL & Database Development) - 12 month term
Top Benefits
About the role
At GMS, we've been helping Canadians for more than 75 years to get the health and travel insurance they want and need. The same pioneering spirit that started our story is what drives us to do things differently today. Insurance, honestly, is our promise, and it's what we do at GMS. We care about our customers, our community and each other. As a non-profit organization, we're proud to reinvest our profits into the health of the communities we serve and that have supported us since 1949.
We want our employees to feel good about coming to work and being in a workplace that promotes flexibility, growth and a healthy work-life balance. If you'd like to be part of a team that truly takes care of our customers, our communities, and each other, this could be your chance.
Here's the role
The Data Systems Analyst (SQLDatabase Development) supports and enhances the organization's data environment through advanced SQL development, cross system data analysis, and close collaboration with development and analytics teams. The role is responsible for designing and optimizing database objects, ensuring reliable access to data, and supporting application teams that work with both structured and unstructured data.
Position Responsibilities
- Perform advanced TSQL querying, data discovery, performance tuning, and validation across transactional, warehouse, and legacy systems.
- Develop adhoc data queries and build custom SQL reports to meet business needs quickly; organize and promote these reporting assets to support analytics and decision
- Manage and optimize database schemas and structures across environments, including consolidation, cleanup, and maintenance for transactional and datawarehouse databases.
- Collaborate with development and DevOps teams to promote data structures via repositories, integrate database changes into CI/CD pipelines, and support data migrations and integrations (data mapping, data modeling, cleansing, ETL execution, and validation).
- Support application and legacy teams by designing and maintaining database objects (tables, views, procedures), implementing schema changes, processing structured/unstructured data, and handling BAU troubleshooting.
- Perform targeted data mapping and analysis for migrations and integrations as needed.
- Enable reporting and analytics by providing data access and integrating sources using SSRS, Power BI, SSIS, and Azure Data Factory.
- Maintain accurate documentation of database structures, processes, and operational procedures.
- Maintain an understanding of ETL workflows and reporting best practices.
Competencies
-Problem Solving: Ability to notice small details where others may miss for the purpose of analysis; quickly consider solutions and alternatives to determine a course of action. -**Results Orientated:**Focuses on desired outcomes, sets high expectations and pushes towards attaining milestones; looks for opportunities, and consistently moves to action. -**Quality Orientation:**Sets high expectations for self; ensures accurate delivery of work across the team; conducts extensive discussions with peers, business units and external business partners to ensure assumptions are complete. -**Information Seeking:**Driven by an underlining curiosity to know more about things, people, or issues; asks questions to get at the root cause of a situation or problem and understand environmental context.
EducationExperience
- Bachelor's degree, certificate or diploma in Computer Science, Information Technology, or related field.
- Minimum 5 years of experience in database development.
- Strong knowledge of relational database systems on Microsoft SQL (On-premise and Azure)
- Basic experience or familiarity with SSRS, Power BI, SSIS, Azure Data Factory for reporting and data integration tasks.
- Experience with schema management, performance tuning, and security best practices including relational and dimensional data modeling.
- Familiarity with DevOps principles and CI/CD pipelines.
When you become a GMSer, you can expect:
- Competitive salary, bonus opportunities and a comprehensive benefit package.
- Personal and professional development initiatives.
- Social events, volunteer opportunities, and a whole lot of fun.
- Free coffee - yes, really! And if tea is more of your vibe, we've got that covered too!
Are we a fit?
**If you think so, please apply by Monday March 23, 2026.**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.