SQL Azure Senior Data Engineer

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 | ***