Data Engineer

3 weeks ago

Regina, Canada Group Medical Services Full time

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 Engineer is responsible for building and maintaining data integration services in GMS's data platform. This role will also be heavily involved in developing database architectures and data models that are utilized in GMS's information management services. This role will apply database best practices to automate data flow processes and support designing a scalable and reliable data management platform. To be successful, the Data Engineer will be conducting research and documenting data requirements that are leveraged in building data collection processes from various sources such as Azure Storage services and SQL databases. The Data Engineer plays a key role in developing and implementing data administration and governance policies and standards, and data modeling essentials for GMS's Extract-Transform-Load (ETL) process. Furthermore, this role is responsible for writing SQL scripts, building stored procedures and triggers and operating database management systems.

Position Responsibilities

•Research and document data requirements and data collection processes.
•Collect and document GMS's user requirements for data storage services.
•Develop and implement data administration policy, standards and data models that need to be applied to ETL process.
•Apply best practices to data cleansing and validation steps in data pipelines.
•Collect data from different sources such as GMS SQL databases.
•Conduct research and provide advice to other information systems professionals and business SMEs regarding the collection, availability, security, and suitability of GMS data.
•Support designing and implementing data integration services between GMS's core Cloud infrastructure and third-party vendors.
•Write scripts related to stored procedures and triggers in GMS's Cloud SQL Database.
•Develop database architecture for information systems projects.
•Modify GMS's data models and database management systems on Azure to improve efficiency.
•Identify and implement internal process improvements such as automating manual data processes and optimizing data delivery.
•Export data from database management systems to perform data mining analysis.
•Collaborate with the Data team to build strategies around data management and lifecycle.
•Build, and test data pipelines and ETL processes from a wide variety of data sources including structured, semi-structured and unstructured data, using Azure Data tools such as Azure Data Factory, Azure SQL, Microsoft Fabric and more.
•Maintain GMS's data pipelines and expand them according to the new requirements due to business growth.
•Research and explore ways to enhance data quality, reliability, and efficiency.
•Identify and evaluate methods and technology solutions to improve data flows.
•Work with business stakeholders to assist with data-related technical issues and support their data infrastructure needs.

Competencies

•Impact and Influence: Uses active listening skills to understand a perspective and opinion; respectfully considers a different perspective; shares opinions and thoughts openly regardless of a shared or counter opinion.
•Quality Orientation: Completes tasks with a high level of accuracy; routinely checks inputs, outputs, tasks, and processes to ensure they are error free.
•Critical Thinking: Uses data and experience to understand and develop solutions to a range of business problems; validates inputs, assumptions, and outputs for reasonableness; sees connections between actions and their consequences.
•Problem Solving: Actively explores and analyzes options and solutions to make effective customer and business decisions; considers causal relationships and impacts of risk decisions within area of knowledge and expertise.

Education & Experience

•Post-secondary education in Computer Science, Software Engineering, Statistics, or equivalent combination of education and experience.
•3+ years' experience of developing and maintaining ETL and data pipelines.
•Highly proficient in SQL, Azure Data Factory, and Database Management Systems.
•Proficient in working with structured, semi-structured and unstructured data.
•Advanced experience working with relational databases as well as familiarity with non-relational databases.
•A successful history of extracting, manipulating, processing, and analyzing data from multiple disconnected datasets.
•Experience performing root cause analysis on data processes and ETLs to answer specific business questions, troubleshoot issues and identify opportunities for improvement.
•Experience with Azure data storage and processing services.


Are we a fit?
If you think so, please apply by November 20, 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.


  • Data Engineer

    1 month ago

    Regina, Saskatchewan, Canada BQ INTERNATIONAL LTD. Full time

    Data Engineer Job DescriptionWe are seeking a highly skilled Data Engineer to join our team at BQ INTERNATIONAL LTD. The ideal candidate will have a strong background in data management principles, including ETL, data design, architecture, management, modeling, quality, and analytics.The successful Data Engineer will possess a broad and solid understanding...

  • Data Engineering Specialist

    2 weeks ago

    Regina, Saskatchewan, Canada Group Medical Services Full time

    Job DescriptionAt Group Medical Services, we're dedicated to providing Canadians with the health and travel insurance they need. As a pioneer in our field, we strive to do things differently today, just as we did when we started over 75 years ago.We want our employees to feel good about coming to work and being in a workplace that promotes flexibility,...

  • Data Engineer: Design and Develop

    3 weeks ago

    Regina, Saskatchewan, Canada Group Medical Services Full time

    About the RoleWe are seeking a highly skilled Data Engineer to join our team at Group Medical Services. As a Data Engineer, you will play a key role in designing, developing, and maintaining our data platform, ensuring data quality, integrity, and security.Key ResponsibilitiesDesign and develop data integration services, database architectures, and data...

  • Senior Data Engineer

    4 weeks ago

    Regina, Saskatchewan, Canada BQ INTERNATIONAL LTD. Full time

    Job Description:The ideal candidate will have a strong background in data management principles, including data design, architecture, management, modeling, quality, and analytics. They will be responsible for monitoring and addressing database issues, ensuring compliance with company policies and external regulations.Key Responsibilities:Develop and...

  • Data Engineer

    2 months ago

    Regina, Canada BQ INTERNATIONAL LTD. Full time

    In order to be considered, the Data Engineer resource MUST have a minimum of 5 years of recent (in last 7 years) experience in modern data management principles such as ETL, practical data design, architecture, management, modelling, quality, and analytics. The successful candidate will demonstrate a broad and solid understanding of these...

  • BI / BIG DATA : Data Engineer - Sénior (IT)

    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,...

  • Senior Data Analyst

    4 weeks ago

    Regina, Saskatchewan, Canada Equest Full time

    Key ResponsibilitiesThe Senior Data Analyst will join our team near Regina, Saskatchewan, for a 4- or 8-month term. As part of the Operations group, they will work on data engineering and analysis projects to optimize mill processes and enhance operational understanding.Data Gathering and Visualization: Develop and implement tools for data gathering and...

  • Data Analyst

    20 hours ago

    Regina, Canada InSync Full time

    We are looking for a **Data Analyst** for a **12-month contract position, with possible extensions** in** Regina, Saskatchewan.** **Must be legally entitled to work in Canada.** **Hybrid schedule, at least 3 days in the office. 8 hours a day, 40 hours a week. It is NOT a remote role.** **Role Description** **Responsibilities** - Create and execute...

  • Senior Data Solutions Architect

    2 days ago

    Regina, Saskatchewan, Canada BQ INTERNATIONAL LTD. Full time

    Job Description">We are seeking an experienced Data Engineer to join our team at BQ International Ltd. as a key member in designing, developing, and maintaining large-scale data systems.Responsibilities:Design and implement robust data pipelines using SQL Server and SSIS;Create and maintain ETL processes to ensure accurate and timely data...

  • AWS Data Architect

    1 month ago

    Regina, Saskatchewan, Canada BQ INTERNATIONAL LTD. Full time

    Job Title: Data ArchitectSaskEnergy'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...

  • AWS 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...

  • Highly Skilled Data Solutions Specialist

    1 week ago

    Regina, Saskatchewan, Canada BQ INTERNATIONAL LTD. Full time

    We are looking for a skilled professional to fill the role of Data Engineer at BQ International Ltd. This is a highly sought-after position that requires strong technical expertise in data management principles, including ETL, data design, architecture, management, modeling, quality, and analytics.The successful candidate will have a solid understanding of...

  • Platform Engineer

    3 weeks ago

    Regina, Canada S I Systems Full time

    Platform Engineer (GCP)Job Type: ContractPositions to fill: 1Job End Date: Mar 31, 2025Pay Rate: Hourly: $83Job ID: 141351Our client is looking for a Sr. Platform Engineer (GCP) to assess our current monitoring and alerting capabilities, design and implement enhancements for a Financial client.Overview:You are a skilled and experienced Google Cloud Platform...

  • Analytical Chemist with Data Science

    3 months ago

    Regina, Canada Ground Truth Agriculture Inc. Full time

    Ground Truth Ag is an exciting, young, agtech company building products that generate realizable value using real-time grain quality data. We are adding to our multi-disciplinary team of scientists, engineers, and agriculture experts to bring our products to market. If you’re a talented individual in your field that can communicate with people outside your...

  • Engineering Assistant II

    2 weeks ago

    Regina, Saskatchewan, Canada City of Regina Full time

    Job Summary:This is a term position for up to 4 months. The City of Regina's Infrastructure Delivery branch is seeking a qualified candidate to perform technical and business support related to data base management, asset management, construction, locates, preservation, and operations within sewer, water, and waste infrastructure.Key...

  • Data Analytics Co-op Student

    4 weeks ago

    Regina, Canada EVRAZ North America Full time

    Job DescriptionJob DescriptionAt EVRAZ, our strength starts with our people! As a team we collaborate to solve problems, contribute ideas and challenge each other to ensure growth and ultimately success for the business and our employees.The Data Analytics Co-op Student will join the EVRAZ NA Steel Operations team near Regina, Saskatchewan, for a 4- or...

  • Electrical Engineer

    1 month ago

    Regina, Canada Brandt Full time

    Brandt is currently looking for an Electrical Engineer in our Regina, Saskatchewan location. This position is responsible for the design and drafting of Electrical Engineering works, along with preparing of reports, estimates, site visit inspections, and project contract administration. Duties & Responsibilities Focus on building design. Responsible for the...

  • Data Architect

    1 week ago

    Regina, Saskatchewan, Canada BQ INTERNATIONAL LTD. Full time

    Job DescriptionBQ International Ltd. is seeking an experienced Data Architect to lead our analytics team in Regina, Saskatchewan. The ideal candidate will have a strong background in data management principles, architecture, and governance.Key ResponsibilitiesDevelop strategies and roadmaps for the Enterprise Analytics teamDesign and implement reference...

  • Grain Data Collector

    3 months ago

    Regina, Canada Ground Truth Agriculture Inc. Full time

    Ground Truth Ag is an exciting, young, agtech company building products that generate realizable value using real-time grain quality data. We are adding to our multi-disciplinary team of scientists, engineers, and agriculture experts to continue building out our solutions. If you’re a talented individual in your field that can communicate with people...

  • Sr. Data Architect

    3 weeks ago

    Regina, Canada undisclosed 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,...