Posted: May 9, 2025
This SQL Azure Senior Data Engineer works hybrid in our Calgary office. This position is required to work PST hours.
Required skills:
- Python - Strong proficiency, unit testing expertise and good knowledge of packages for data, like Pandas, SQLAlchemy and Alembic.
- SQL - strong proficiency in DDL and DML, including window function (ex.: lag), CTEs, sub-queries, joins, optimization, and performance profiling. Know how SQL behaves in different platforms, like Spark, PostgreSQL
- Spark - Pyspark, SparkSQL, Batch and Streaming processing, partitioning/liquid clustering, delta tables, parquet
- Databricks - Workflows/Jobs, Clusters, SQL Warehouse, Unity Catalog, Performance profiling, log analysis.
- Azure EventHubs or a similar streaming solution understand how to best consume data from streaming for aggregations and parallelization/scaling.
- PostgreSQL - Queries, indexes(different types of indexes), performance profiling, JSON columns.
- Data Modeling: Dimensional Modeling (and experience with this model being used in BI tools), Normal Forms.
- Containerization (ex.: Docker)
- Familiar with Azure data services
- DBT - models, seeds, multiple environments, parameters, macros, unit tests, data tests, incremental materialization, snapshots
- Infra as code/ CICD tools: Kubernetes, Argo, Cross Plane, Terraform or similar.
- Migrations - versioning for database, for example, Alembic (preferred), Flyway, Liquibase, etc.…
- SQL and NoSQL databases, and selecting the best fit for different use cases.
- Logging and being able to query logs using KQL(Azure) or similar.
Qualifications and experience:
- Computer Science degree or equivalent education and experience
- Professional experience with data ingestion, ETL, and ELT for structured and unstructured data.
- Strong proficiency in Python (especially data packages like pandas, NumPy) and SQL for analytics, database development, and data modelling
- Experience with DevOps and CICD for data.
- Experience working with one or more cloud platforms to implement data-intensive applications, Azure is preferred.
- Strong understanding of Agile methodologies and experience on an agile team
Responsibilities:
- Support, maintain, optimize and create ETL/ELT pipelines, both batch and streaming, in Databricks(PySpark, Databricks SQL), Python, SQL and/or DBT.
- Build, Design and Model data objects.
- Proficient in Dimensional Modeling and Database normalization (Normal Form)
- Write and perform tests for data flow
- Work with a team with different skill sets and roles (back and front-end developers, data scientists, business specialists, DevOps…) to deliver the best solution possible
- Collaborate with Platform teams to use the available infrastructure as efficiently as possible, including on the CICD deployment.
Life at Capgemini
Capgemini supports all aspects of your well-being throughout the changing stages of your life and career. For eligible employees, we offer:
- Collaborating with teams of creative, fun, and driven colleagues
- Flexible work options enabling time and location-based flexibility
- Company-provided home office equipment
- Virtual collaboration and productivity tools to enable hybrid teams
- Comprehensive benefits program (Health, Welfare, Retirement and Paid time off)
- Other perks and wellness benefits like discount programs, and gym/studio access.
- Paid Parental Leave and coaching, baby welcome gift, and family care/illness days
- Back-up childcare/elder care, childcare discounts, and subsidized virtual tutoring
- Tuition assistance and weekly hot skill development opportunities
- Experiential, high-impact learning series events
- Access to mental health resources and mindfulness programs
- Access to join Capgemini Employee Resource Groups around communities of interest
About Capgemini
Capgemini is a global business and technology transformation partner, helping organizations to accelerate their dual transition to a digital and sustainable world, while creating tangible impact for enterprises and society. It is a responsible and diverse group of 340,000 team members in more than 50 countries. With its strong over 55-year heritage, Capgemini is trusted by its clients to unlock the value of technology to address the entire breadth of their business needs. It delivers end-to-end services and solutions leveraging strengths from strategy and design to engineering, all fueled by its market leading capabilities in AI, cloud and data, combined with its deep industry expertise and partner ecosystem. The Group reported 2023 global revenues of €22.5 billion.
Get The Future You Want | ***
Read the full job description and apply online on the recuiter's web-site
Senior Java Developer
Posted: May 8, 2025
This is an exciting time for CGI, and we want you to be part of it.We are Canada's largest independent information technology services firm, and we are still growing! We are expanding in Atlantic Canada, and we need your skills, enthusiasm, and dedication as part of our team.We are seeking an
read more...
View Job Details
Environmental Project Manager
Location:
CA -
Alberta -
Alberta -
Hinton
Posted: May 9, 2025
The Project Manager is responsible for project management through the delivery of various projects within the Environmental Services Division. • Operating in a diverse and competitive environment, this position will manage projects from start to finish, ensuring safe, effective operations with
read more...
View Job Details
Environmental Project Manager
Posted: May 9, 2025
The Project Manager is responsible for project management through the delivery of various projects within the Environmental Services Division. • Operating in a diverse and competitive environment, this position will manage projects from start to finish, ensuring safe, effective operations with
read more...
View Job Details
Registered Nurse - ICU, ER, Surgical - Relocate to Vancouver Island, BC
Posted: May 9, 2025
Are you a Registered Nurse or a Specialized Registered Nurse looking to showcase your knowledge, skills, and abilities in a dynamic environment? We're hiring • Registered Nurses • in our • Surgical, Emergency • and • Critical Care • units across sites on Vancouver
read more...
View Job Details
AI Content Writer
Posted: May 9, 2025
DataAnnotation is committed to creating quality AI. Join our team to help train AI chatbots while gaining the flexibility of remote work and choosing your own schedule.We are looking for a • content writer • to join our team and teach AI chatbots. You will have conversations with chatbots
read more...
View Job Details
AI Content Writer
Posted: May 9, 2025
DataAnnotation is committed to creating quality AI. Join our team to help train AI chatbots while gaining the flexibility of remote work and choosing your own schedule.We are looking for a • content writer • to join our team and teach AI chatbots. You will have conversations with chatbots
read more...
View Job Details
Environmental Project Manager
Location:
CA -
Ontario -
Ontario -
Ottawa
Posted: May 9, 2025
The Project Manager is responsible for project management through the delivery of various projects within the Environmental Services Division. • Operating in a diverse and competitive environment, this position will manage projects from start to finish, ensuring safe, effective operations with
read more...
View Job Details
Environmental Project Manager
Posted: May 9, 2025
The Project Manager is responsible for project management through the delivery of various projects within the Environmental Services Division. • Operating in a diverse and competitive environment, this position will manage projects from start to finish, ensuring safe, effective operations with
read more...
View Job Details
Environmental Project Manager
Posted: May 9, 2025
The Project Manager is responsible for project management through the delivery of various projects within the Environmental Services Division. • Operating in a diverse and competitive environment, this position will manage projects from start to finish, ensuring safe, effective operations with
read more...
View Job Details
Quantitative Analyst - AI Trainer
Posted: May 9, 2025
We are looking for a • quantitative analyst • to join our team to train AI models. You will measure the progress of these AI chatbots, evaluate their logic, and solve problems to improve the quality of each model.In this role you will need to hold an expert level of
read more...
View Job Details
Registered Dental Hygienist
Posted: May 9, 2025
At Arrowsmith Dental Group in beautiful Parksville, BC, we pride ourselves on providing high-quality, compassionate dental care in a welcoming and supportive environment. • Our modern, aesthetically pleasing practice offers an inviting space where patients and team members alike feel
read more...
View Job Details
Environmental Project Manager
Posted: May 9, 2025
The Project Manager is responsible for project management through the delivery of various projects within the Environmental Services Division. • Operating in a diverse and competitive environment, this position will manage projects from start to finish, ensuring safe, effective operations with
read more...
View Job Details
Environmental Project Manager
Posted: May 9, 2025
The Project Manager is responsible for project management through the delivery of various projects within the Environmental Services Division. • Operating in a diverse and competitive environment, this position will manage projects from start to finish, ensuring safe, effective operations with
read more...
View Job Details
AI Content Writer
Posted: May 9, 2025
DataAnnotation is committed to creating quality AI. Join our team to help train AI chatbots while gaining the flexibility of remote work and choosing your own schedule.We are looking for a • content writer • to join our team and teach AI chatbots. You will have conversations with chatbots
read more...
View Job Details
AI Content Writer
Posted: May 9, 2025
DataAnnotation is committed to creating quality AI. Join our team to help train AI chatbots while gaining the flexibility of remote work and choosing your own schedule.We are looking for a • content writer • to join our team and teach AI chatbots. You will have conversations with chatbots
read more...
View Job Details
Quantitative Analyst - AI Trainer
Posted: May 9, 2025
We are looking for a • quantitative analyst • to join our team to train AI models. You will measure the progress of these AI chatbots, evaluate their logic, and solve problems to improve the quality of each model.In this role you will need to hold an expert level of
read more...
View Job Details
AI Content Writer
Posted: May 9, 2025
DataAnnotation is committed to creating quality AI. Join our team to help train AI chatbots while gaining the flexibility of remote work and choosing your own schedule.We are looking for a • content writer • to join our team and teach AI chatbots. You will have conversations with chatbots
read more...
View Job Details
Registered Nurse RN - Casual
Posted: May 8, 2025
*Location • : Piccadilly Care Centre • Address: • 821 - 10th Ave SW, Salmon Arm, BC, V1E 1T2 • Position Details: • Casual • Schedule: • Day (0700-1500), Eve (1500-2300), Night (2300-0700) • Compensation: • Starting at $41.42 per hour, based on experience
read more...
View Job Details
AI Content Writer
Posted: May 9, 2025
DataAnnotation is committed to creating quality AI. Join our team to help train AI chatbots while gaining the flexibility of remote work and choosing your own schedule.We are looking for a • content writer • to join our team and teach AI chatbots. You will have conversations with chatbots
read more...
View Job Details
AI Content Writer
Posted: May 9, 2025
DataAnnotation is committed to creating quality AI. Join our team to help train AI chatbots while gaining the flexibility of remote work and choosing your own schedule.We are looking for a • content writer • to join our team and teach AI chatbots. You will have conversations with chatbots
read more...
View Job Details
Registered Nurse - ICU, ER, Surgical - Relocate to Vancouver Island, BC
Posted: May 9, 2025
Are you a Registered Nurse or a Specialized Registered Nurse looking to showcase your knowledge, skills, and abilities in a dynamic environment? We're hiring • Registered Nurses • in our • Surgical, Emergency • and • Critical Care • units across sites on Vancouver
read more...
View Job Details
Registered Nurse RN - Casual
Posted: May 8, 2025
*Location • : Mountain Lake Seniors Community • Address: • 908 Eleventh Street, Nelson, BC, V1L 7A6 • Position Details: • Casual • Schedule: • Day (0700-1500), Eve (1500-2300), Night (2300-0700) • Compensation: • Starting at $41.42 per hour, based on
read more...
View Job Details
Registered Nurse RN - Evenings
Posted: May 8, 2025
*Location • : Mountain Lake Seniors Community • Address: • 908 Eleventh Street, Nelson, BC, V1L 7A6 • Position Details: • Permanent Part-Time • Schedule: • 4 on, 4 off (1500-2300) • Compensation: • Starting at $41.42 per hour, based on previous experience
read more...
View Job Details
Quantitative Analyst - AI Trainer
Posted: May 9, 2025
We are looking for a • quantitative analyst • to join our team to train AI models. You will measure the progress of these AI chatbots, evaluate their logic, and solve problems to improve the quality of each model.In this role you will need to hold an expert level of
read more...
View Job Details
AI Content Writer
Posted: May 9, 2025
DataAnnotation is committed to creating quality AI. Join our team to help train AI chatbots while gaining the flexibility of remote work and choosing your own schedule.We are looking for a • content writer • to join our team and teach AI chatbots. You will have conversations with chatbots
read more...
View Job Details
Speech Language Pathologist
Posted: May 9, 2025
*Horizon Health Network is currently recruiting Speech Language Pathologists to join our teams in the Miramichi, Saint John, and the Upper River Valley areas. • Horizon Health Network is the largest regional health authority - and one of the largest employers - in New Brunswick, and the
read more...
View Job Details
Registered Dental Hygienist - Landmark Dental
Posted: May 9, 2025
About Us: • Located in the heart of Kelowna on vibrant Dickson Avenue, Landmark Dental Centre proudly serves our community with exceptional dental care. • Under the leadership of Dr. • Brent Corlazzoli, our passionate team of dental professionals is redefining what it means to provide
read more...
View Job Details