Назад
Company hidden
1 день назад

Senior Data Engineer (SQL)

135 000 - 150 000CAD
Формат работы
hybrid
Тип работы
fulltime
Грейд
senior
Английский
b2
Страна
Canada
Вакансия из списка Hirify.GlobalВакансия из Hirify Global, списка международных tech-компаний
Для мэтча и отклика нужен Plus

Мэтч & Сопровод

Для мэтча с этой вакансией нужен Plus

Описание вакансии

Текст:
/
TL;DR
Senior Data Engineer (SQL/Azure): Building and optimizing SQL and Python-based ETL/ELT pipelines, cloud-native data solutions, and scalable Lakehouse data products with an accent on Databricks administration, data quality, and database performance. Focus on migrating SQL Server workloads, implementing CI/CD and observability, and designing governed data platforms with Azure, PySpark, and Delta Lake.

Location: Toronto, Canada; hybrid work model with weekly in-office and remote days at the Toronto office on 390 Bay St.

Salary: CAD 135,000–150,000 per year, plus an annual company bonus.

Company

hirify.global is a global reinsurance company with more than 40,000 employees in over 50 locations, developing insurance and life-insurance solutions through data, technology, and risk management.

What you will do

  • Build and optimize SQL and Python-based ETL/ELT pipelines integrating data from multiple sources.
  • Deliver reliable, reusable datasets for applications, reporting, and analytics in collaboration with stakeholders, analysts, and software developers.
  • Develop SQL queries, stored procedures, data models, metadata, data lineage, documentation, and data-quality controls.
  • Implement CI/CD pipelines, testing frameworks, observability, governance, and compliance for data workflows.
  • Administer and evolve the enterprise Databricks platform, including workspace governance, cluster policies, security, cost optimization, monitoring, and operational support.
  • Design scalable Azure data solutions and Lakehouse data products using Azure Data Factory, Azure Storage, Azure Key Vault, Azure Monitor, Azure DevOps, Databricks, and Delta Lake.

Requirements

  • 8+ years of experience in data engineering, database development, software engineering, or a related technical field, including designing and supporting enterprise data solutions.
  • Advanced SQL skills, including complex queries, stored procedures, functions, and performance optimization.
  • Strong Python programming skills for data engineering, automation, and testing.
  • Hands-on experience with Azure Databricks, PySpark, Delta Lake, relational databases, data modeling, and ETL/ELT processes.
  • Experience designing, developing, and maintaining cloud-based data solutions with Microsoft Azure services.
  • Experience with SQL Server performance tuning, troubleshooting, optimization, and migration of SQL Server workloads to Databricks.
  • Knowledge of DevOps practices, Git, CI/CD pipelines, and Azure DevOps.
  • Strong analytical, problem-solving, communication, and collaboration skills, including explaining technical concepts to technical and non-technical stakeholders.

Nice to have

  • Strong proficiency with big data technologies such as Azure Databricks and Spark.
  • Technical leadership, mentoring, solution design leadership, or team leadership experience.
  • Databricks Certified Data Engineer Associate or Professional certification.

Culture & Benefits

  • Collaborative environment focused on continuous learning, development, innovation, and high performance.
  • Hybrid work environment combining weekly in-office and remote days.
  • Company-paid flexible health and dental benefits from the first day, plus Health Spending Account and Wellness Spending Account funds.
  • Immediate participation in a defined-contribution pension plan with automatic employer contributions and an optional company match.
  • Vacation, personal days, unplanned time, statutory holidays, company-wide early-closure half-days, and maternity, parental, and adoption leave top-up.
  • LinkedIn Learning, education assistance, professional-fee reimbursement, employee referrals, recognition, and rewards programs.

Hiring process

  • Applications are reviewed by the recruitment team; only candidates selected for an interview will be contacted.
  • Accommodations are available for qualified applicants with disabilities throughout the recruitment process.

Будьте осторожны

Если работодатель просит войти в их систему, используя iCloud/Google, прислать код/пароль, запустить код/ПО, не делайте этого. Это мошенники. Обязательно жмите «Пожаловаться» или пишите в поддержку. Подробнее в гайде →